By lwatcdr on

I just installed 4.6.6 and I can not log on !
I created a user called admin and they tried to log on with the password given and nothing!
It will not let me log on. I even tried to get a new password sent and that didn't work. It sent the new password just fine but the password wouldn't allow me to log in.
I checked the watchdog table and see this "Session opened for admin"
which looks good to me but then when I try and go to administration I get this
"access denied admin denied access. 1 view"
Any ideas what the heck is going on?

Thanks

Comments

jaylu’s picture

jaylu commented

1. Make sure your browser allows cookie
2. Try to clear all saved cookies

I had the same problem. Clearing cookies solved it. Later on I turned off the cookie permission in my browser and I couldn't login anymore. I guess the login process depends on saved cookies.

harry slaughter’s picture

harry slaughter
Location Omaha NE USA
commented

remove all users from database **except user 0**

in your favorite sql client:

delete from mydrupaldatabase.users where uid > 0;

of course, be careful, make sure you delete from appropriate DB.

then you will be able to create a new account when you go back to your site's front page.

--
Drupal tips, tricks and services
http://devbee.com/ - Effective Drupal

--
Devbee - http://devbee.net/

lwatcdr’s picture

lwatcdr commented

Did that and when I made the new user it gave it a uid of 3. But it still wouldn't let me log in.
I wonder if the hash is some how wrong, the persmisons of the files are wrong. Or I did something wrong during the install.
Any suggestions on where else to look? It is driving me nuts since I have installed drupal three of four times before without any issues like this. Before it just seemed to work.

heine’s picture

heine commented

Did that and when I made the new user it gave it a uid of 3

emphasis added.

I strongly suspect the account with the username 'admin' was uid 2, not uid 1; and it's all about userid, not the username.

To find the name of uid 1, execute the query:

SELECT `name` from `users` where `uid` = 1

To set a new password, execute the query

update `users` set `pass`=MD5('newpwd') where `uid`=1;

--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.

harry slaughter’s picture

harry slaughter
Location Omaha NE USA
commented

i missed a step :(

after you remove uids greater than 0, you have to reset the users table "sequence", else, as you've seen, your next UID will not be 1 but the value of (sequences.users_uid + 1).

if you've deleted all users greater than uid 1, you can safely run the following:

DELETE 
FROM YOURDBNAME.sequences 
WHERE name = 'users_uid'

Then when you next log in to your site, you'll be allowed to create that initial user again (who will have uid 1, and will have admin/root privelages on the site). Go to your site's homepage and click on 'create new account'.

--
Drupal tips, tricks and services
http://devbee.com/ - Effective Drupal

--
Devbee - http://devbee.net/

drlingo’s picture

drlingo commented

As you suggest I deleted the users from the db and went back tried to create a new account. After submitting I recieve thhis error.

Forbidden 403

You don't have permission to access /ispeak/articlesd//9:21 PM 4/10/2006/ on this server.

Is this a permission problem with the dir.?

drlingo’s picture

drlingo commented

Finally, after following along I can now get past the login but now I cannot access the admin in order to config the install. How can I se the permissions to do this?

I have lost the images now I have only plain text at the login page what has happened?

Thank you

Paul

drlingo’s picture

drlingo commented

After following this thread I was able to workaround the login issue by following the helpful tips here. Remember, after uou have followed the directions you need to go back to your db and make sure the userid is set for 1 Only the first user will have access to the admin in order for you to confid drupal.

Now, i need to figure out why I am seeing plain text only in the admin section? Any hints?

Paul

jfine’s picture

jfine commented

I'm experencing the exact same problem. I've installed 4.6.6 and can not log in with the credentials supplied. I tried resetting my password for the account, looked at the database (users table) and it looks fine, cleared my cookies, no luck. From a trouble shooting perspecitve I've found that if I enter valid credentials it simply redirects me back to the login page with blank fields, if I enter my password incorrectly it prompts with "Sorry. Unrecognized username or password." as expected.

jfine’s picture

jfine commented

I think I figured out what the problem is. The server I was attempting to install on is using a backpatched PHP 4.3.2, I see that the required version is 4.3.3.