THAT STUPID COOKIE ISSUE - [scary kookie enabled thing]

[Simon]

ARRGH.
I know it's probably been said a million times but ...

Login Failed

* You must have cookies enabled in your browser

--- I can't login for the life of me!

Browser Says that cookies is enabled -

Can't even login when I reset my password.

Was working fine before... but now Nobody can log in.

Normally would try to fix it myself but after going through all this permissions mumbo with iPowerWeb I'm getting toasty.

[pedroa]

Can you see the gacl_aro table and the users table?
How many records in them? and what is your password hash? reseted it? how?
Things working and suddendly not working is not a normal behavior, so this can be an out of dP realm issue.

Pedro A.

[Karen]

ARRGH.
I know it's probably been said a million times but ...

Login Failed

* You must have cookies enabled in your browser

--- I can't login for the life of me!



The cookie message on the login page is by way of information only. See:

http://www.dotproject.net/vbulletin/showthread.php?t=2134

Also you haven't said who you can't login as - if it's a new user account - have you added a role?

[NaX]

Could be a sessions problem check out this thread

http://www.dotproject.net/vbulletin/showthread.php?p=15221#post15221

[Simon]

FIRST OF ALL...

I want to thank everyone for the response!

One thing I always learnt -
Be thankful for help and help the thankful.
heh. :grin:
Or something like that.


USERS -

Field Type Attributes Null Default Extra Action
user_id int(11) No auto_increment
user_contact int(11) No 0
user_username varchar(255) No
user_password varchar(32) No
user_parent int(11) No 0
user_type tinyint(3) No 0
user_company int(11) Yes 0
user_department int(11) Yes 0
user_owner int(11) No 0
user_signature text Yes NULL
Check All / Uncheck All With selected:



--------------------------------------------------------------------------------
Print view Propose table structure

Add field(s) At End of Table At Beginning of Table After user_id user_contact user_username user_password user_parent user_type user_company user_department user_owner user_signature

--------------------------------------------------------------------------------
Indexes:
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 6 user_id
idx_uid INDEX 6 user_username
idx_pwd INDEX 6 user_password
idx_user_parent INDEX 3 user_parent
Create an index on columns
Space usage:
Type Usage
Data 408 Bytes
Index 6,144 Bytes
Overhead 56 Bytes
Effective 6,496 Bytes
Total 6,552 Bytes
Optimize table
Row Statistics:
Statements Value
Format dynamic
Rows 6
Row length ø 58
Row size ø 1,092 Bytes
Next Autoindex 8
Creation Sep 28, 2005 at 02:09 PM
Last update Oct 06, 2005 at 12:04 PM

GACL_ACL



Field Type Attributes Null Default Extra Action
id int(11) No 0
section_value varchar(80) No system
allow int(11) No 0
enabled int(11) No 0
return_value longtext Yes NULL
note longtext Yes NULL
updated_date int(11) No 0
Check All / Uncheck All With selected:



--------------------------------------------------------------------------------
Print view Propose table structure

Add field(s) At End of Table At Beginning of Table After id section_value allow enabled return_value note updated_date

--------------------------------------------------------------------------------
Indexes:
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 6 id
gacl_enabled_acl INDEX 1 enabled
gacl_section_value_acl INDEX 1 section_value
gacl_updated_date_acl INDEX 1 updated_date
Create an index on columns
Space usage:
Type Usage
Data 168 Bytes
Index 5,120 Bytes
Total 5,288 Bytes
Row Statistics:
Statements Value
Format dynamic
Rows 6
Row length ø 28
Row size ø 881 Bytes
Creation Sep 28, 2005 at 02:22 PM
Last update Sep 29, 2005 at 06:54 PM
Last check Sep 29, 2005 at 06:54 PM

USER_ROLES



Field Type Attributes Null Default Extra Action
user_id int(10) UNSIGNED No 0
role_id int(10) UNSIGNED No 0
Check All / Uncheck All With selected:




:(

Of course we can see above mentioned issues already.
But something weird is going on also...

I got some multiple write db thing going on thats got my sql all funkadelic.

Interesting... and yet not too good.



Well. I havent been able to complete my journey on this yet but I will and hope to get it all straightened out.

Thanks!

[Simon]

When in doubt backtrack it out.

O.K. so this may not be ANY use to someone else but you'll love it anyway ...

I guess apparently the deal is I had to Call and ask for create temp table permissions...

Which apparently I got ...

but when I just called I found out ...

Someone gave me too many permissions!!
I was seeing everyone else's db on the server! yowee.

sqlgiffer (http://mmsgov.com/sqlgiffer.gif)


heh. You gotta love it. I still like these guys though. They've been great for the most part.

However... now I still gotta deal with my own permission problems.

[caseydk]

No, you don't have any permissions except for View the database names. See how none of them have tables... highly unlikely.