By Suerte on

I have installed a new Drupal site, but the admin account gets 'access denied' when I click on any link, and I have to continually enter the user name and password to regain access. Looking at the 'sessions' table in mysql, the uid matching the session id in the cookie keeps getting set to '0' instead of '1'

Any educated guesses about this behavior appreciated.

Running winxp sp2, PHP5, mySQL 4.1

⋅ Categories: Drupal 4.7.x

Comments

CmdrGravy’s picture

CmdrGravy commented

I've had similar sorts of problems if I've forgotten to put the sites url in the settings file. It's at /sites/default/settings.php

I don't know if that will help but it's worth a look.

Suerte’s picture

Suerte commented

Thanks for the reply, but the $base_url in the settings file seems fine. . .

artem_sokolov’s picture

artem_sokolov commented

Try checking the domain of cookies set -- you may be logged to a domain with/without a www, and trying to access a page without/with it.
Another guess is to try repairing or cleaning cache and sessions tables.

I was also having some problems with logins, however, of different flavour, and the #7 patch in this issue helped.

Suerte’s picture

Suerte commented

Seems like the problem is definitely in the cookie/session management, but cleaning the cache and sessions table didn't work, and the default cookie domain for the host machine seems to be working okay.

For some reason, with every new page loaded, the uid in the sessions table is reset to 0. Even the very first record added to a clean sessions table at login shows a uid of 0. The only way I've been able to navigate the site is to manually reset the uid in the sessions table after every page load.

Aargh !

artem_sokolov’s picture

artem_sokolov commented

I also changed the sites/default/settings.php file and now the affected lines look like this:

/*ini_set('session.cache_limiter',    'none');*/
ini_set('session.cache_limiter',    'nocache');

It helped some of the users not to see outdated pages.

davemybes’s picture

davemybes commented

I started having a similar problem, but could still browse the site. Each page I went to, though, threw up an access denied warning in watchdog. By deleting the cookie for the PHPsessionid, then logging out and back in again, everything went back to normal.

______________________________________________________________________________________________________
Recent Drupal websites: http://mbacasecomp.com and http://hudsonhistoricalsociety.ca

______________________________________________________________________________________________________