By rich_lang on

Hi,

I performed some updates about a month ago, including upgrading to Drupal 6.20. Everything seemed to be fine. I have gone to the site today to perform this months maintenance, and cannot login.

I can get to the login form, and login using the correct details. It recognises that I login as admin, as it takes me to the page /users/administrator, but that page says access denied. I cannot get access to any admin pages, and if I login as a standard user, they too are unable to access their profile page.

I have cleared the sessions table as suggested in some forum topics.

Does anyone have any ideas? It is absolutely crucial that I am able to get back into this website.

Thanks in advance
Rich

⋅ Categories: Drupal 6.x

Comments

jscoble’s picture

jscoble commented

Is the user you are using user 1, i.e. the user that was created when Drupal was originally created or is it a different user that was created after installation and given a role with the necessary permissions to be an admin?

ishmael-sanchez’s picture

ishmael-sanchez commented

I think Joel is right, it sounds like you aren't actually using the user 1 login but another login with some admin rights. If you have access to your database you can check the user table and verify the username and email address of user 1 (uid will be one) and reset the password (add text then select MD5). Or once you find out the email address you can use that to reset the password.

rich_lang’s picture

rich_lang commented

Hi,

I have checked the users table, and I am trying to login with the original admin account when Drupal was setup, with the uid of 1. I have reset the password, but it makes no difference.

It's not just the admin account I am experiencing this problem with, I also get access denied when I try and login with any other user, with any role.

rich_lang’s picture

rich_lang commented

An update on this issue...

I decided to roll back to the previous version of Drupal 6.16, restored the db and files, and everything is working again.

Tried upgrading again, but encountered the same issue. This happened when I tried to upgrade from 6.16 to 6.20 and also from 6.16 to 6.17.

It got into a bit of a mess being stuck in maintenance mode, and then denying access to the update.php page. I have rolled back and will stick with 6.16 for now.

Could this be an issue with the settings.php file? or .htaccess files? Just guessing...

AviadG’s picture

AviadG commented

subscribing

dcarr’s picture

dcarr commented

I also having the same problem with accessing the user 1 when I logged in. I tried resetting the password. I get the email to my admin account and use the 1-time login, but after I supposedly log in, it takes me to an Access Denied page.

I've tried manually changing the password in the DB, but this doesn't seem to be the issue. I've also tried it in multiple browsers with cleared caches.

I also tried the $update_free_access = FALSE; and $cookie_domain in the settings.php file

I'm using Drupal 6, but its been so long since I've been on my clients site, I'm not sure what version exactly.

Anyone have any insight on this. I do not want to have to delete everything and start over.

I noticed that there are many spammed user accounts that have been added to the user table. Would that have any affect? I can manually delete all those dummy records in the user table, but would that have repercussions elsewhere on the site?