By rstoeber on

Not sure what's going on, but I can't log in anymore as the administrator or any other user. I've done several other upgrades over the past year and never had the problem before.

I logged in as the admin user. Then I installed 4.7.6 in a new directory and copied my settings and theme files. I use several extra modules which are all in modules/contrib/ so I copied that directory in too. Then I ran the update.php script which worked, but didn't seem to do any database updates.

After that I browsed around a little, then logged out. But after that I can't log in again.

Putting in a bad user name and/or password tells me that's not a valid account. Putting in a good user id and password doesn't display any error, it simply clears the form and redisplays the home page as if I did get logged in but it didn't give me the admin menu.

I'm really stuck now and not even sure where to look for a problem. Any ideas appreciated.

⋅ Categories: Drupal 4.7.x

Comments

vm’s picture

vm commented

clear your browser cache, clear the cache table in the database and report back.

rstoeber’s picture

rstoeber commented

I see a table in the database called "cache" which contains a bunch of data. Do you mean I should delete all rows in that table?

vm’s picture

vm commented

after selecting the cache table in the left pane of phpmyadmin click on empty at the top of the right pane you will be presented with a JS pop up, are you sure you want to truncuate the cache table, click yes.

rstoeber’s picture

rstoeber commented

Couldn't wait for an answer and since I have a database backup I just went ahead. Deleted all 29 rows that were in the db table called cache. Then I cleared browser cache, cookies, history, etc.

No change. Same problem - still can't log in.

Even tried a different browser just in case. I normally use Firefox, but I just tried it with Internet Explorer 7 and get the same problem. With a good user id/password combination the screen clears and redisplays with the login form blanked.

rstoeber’s picture

rstoeber commented

Here's a couple more things that might be interesting.

To try eliminating my extra modules as a cause of the problem I renamed the modules/contrib directory, so they basically don't exist. Cleared the cache table and my browser cache again. I can see from the home page that the extra modules are no longer working. But I still can't log in. Same exact problem so it must be something with the base installation.

Also, I was looking at the database, and in the users table is a field called login. Assuming this is used to track the last time someone logged in I found my record (uid = 1) and that field had the number 1170526384. Then I tried to log in, which still didn't work, but that number changed to 1170527836.

I assume that bigger number means a later time, so some part of the system thinks I actually logged in. That would also explain why I'm not getting error messages.

vm’s picture

vm commented

just moving the modules folder wont shut off the modules. they are still enabled as far as the database is concerned. you would have to gointo the system table and sift the enabled modules (1) to (0) for them to be disabled.

your apache error logs show ?

Couldn't hurt to truncuate (clear) the sessions table.

rstoeber’s picture

rstoeber commented

Nothing special in the apache logs, just normal page/image requests. No errors.

I cleared the session table and the cache table again. Also cleared the browser cache. Also, restared apache for good measure.

Still having the same problem.

rstoeber’s picture

rstoeber commented

Trying to follow the log in process to see what's breaking. I found a function called user_load in the user.module. It looks like that function loads an array with all the user's information IF the user is successfully logged in.

I put a var_dump($user) in there at the very end, just before the return statement. The array is clearly populated with my information. So at that point at least the system knows I am logged in as a valid user.

But somewhere after that the system thinks I'm an Anonymous user again.

vm’s picture

vm commented

you can clear the sessions table. This will log everyone out, shut down all sessions.

double check your settings.php as well.

greg_y’s picture

greg_y commented

Upgraded from 4.7.3 (I think) to 4.7.6. Can't log in (and some of my homepage Views blocks aren't linking to correct nodes, which is probably a different problem). After the upgrade I was still logged in as user 1 and all was fine. When I logged out to check if there were any problems for anonymous users, I wasn't able to log back in -- as described above, I am just presented with the homepage presented to anonymous users.

Have cleared browser cache (and tried 2 different browsers) and have cleared the MySQL cache and sessions tables, all with no effect. Will advise if I find out more.

Also, a newly created user can't log in.

Update: I reverted to my saved 4.7.3 (?) installation (not the database, just the program files -- which i know could be a problem). Can log in again. Received a MySQL error about not being able to access the accesslog table; fixed with SQL command "repair table accesslog."

vm’s picture

vm commented

Those having login issues, chiming in here : http://drupal.org/node/115889 so that the devs can further investigate this problem. testing results are needed to help extinguish this elusive bug.