I ran rebuild permissions and after the site refreshed I had no access to any content. all admin account as well as the authenticated user have no access, I have no admin options or permissions. I have a site full of access denied pages.

www.rockharrisonville.com

Please help

Comments

shamik.dasgupta’s picture

Hi,

You can try to fix this directly at the backend db. The first task would be to gain control of the admin account (the UID for which is 1 by default during Drupal installation)

To directly reset your password, log into phpMyAdmin and execute the following mySQL statement:

UPDATE users SET pass = md5('newpassword') WHERE uid = 1;

Enter your new password in the md5 function - it will automatically be converted via a one-way hash (this is why we can't retrieve your old password - the decryption is a one-way process). Note that for earlier versions of Drupal you may need to use SET password, instead of SET pass.

This will effectively reset the Drupal admin password for user 1. Note that you can use this to reset the password of any user, although this is typically unnecessary as you should be able to simply log in as admin user (user 1), under which you have the ability to reset any user's password.

Let me know how it goes.

regards,
Shamik

dpearcefl’s picture

Priority: Critical » Normal
Status: Active » Postponed (maintainer needs more info)

Sounds like you have a fix. Do you?

dpearcefl’s picture

Priority: Normal » Critical
Status: Postponed (maintainer needs more info) » Active
8tropos’s picture

Assigned: Unassigned » 8tropos

I tried the above fix. It executed the statement correctly, but did not resolve the issue. I'm stil being locked out.

This is a major problem. I'm not able to administer my customer's site. Please help!

dpearcefl’s picture

Assigned: 8tropos » Unassigned

Your title for this issue is confusing: "All user accounts are denied access to every page"

If this is true, how is the site being updated? I see current content and events. Perhaps a current description of the issue is in order?

BTW: You only assign yourself to the issue if you are fixing the issue to yourself. Since you are asking for help, you can't be fixing the issue yourself.

mdupont’s picture

Check the "users" table in your DB. Do you have "anonymous" user with uid = 0? Do you have a user with uid = 1 (super-admin user)? Many problems can be caused by not having the anonymous user at uid 0.

dpearcefl’s picture

Priority: Critical » Normal
Status: Active » Fixed

Since we haven't heard from the original poster (mikebru10) and since his website appears to be operational, we can assume this issue is fixed for him.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

emerygjr’s picture

We were using the path_access module and the anonymous user (1) in the path_access table was set to (0) which mane anonymous users unable to access the login form (which is a bit of a catch-22).

Log into the database directly, find the path_access table and change that 0 to a 1 for the appropriate role id (1) and you should be set.

Or run
update path_access set visibility = 1 where rid= 1

jasnpast’s picture

I have a somewhat-similar problem to the above. Our site does not yet allow users to create accounts, so there are only three total users. Anonymous users see an "Access Denied/You are not authorized to access this page." message for the Home page, primary links do not expand, only links to other web sites work.

I am able to log-in as /q?=user (which is the admin account), I have checked in the DB to make certain that anonymous user UID = "0", and I tried "update path_access set visibility = 1 where rid= 1" in phpMyAdmin, but path_access doesn't exist in my databases.

I have done very little with the capabilities of this Drupal 6.x website, mostly because I'm a newbie to Drupal and very cautious. I have CiviCRM installed on the site, but I am only just beginning to add payment-processors to the site (not yet fully configured) to prepare for credit-card processing.