After going through the install procedure, I am unable to login as admin. The database connection appears to work since admin shows up in the member list. I have verified that the hashed password in mysql is equal to $salt . MD5($salt . $password).
Where else should I look for the problem? How can I get better debugging info in order to determine where the authentication is failing?
Posts: 3
I found the debug option in config.php. 'admin' has a userID of 5 according to mysql, however I notice that the bottom SQL is asking about userID = '4', and 'guest' is not in groupID = '2'. Any tips?
Posts: 7994
That's odd. I notice that in your debug output it appears to be using the "google" session which is very strange; that should only be used by the googlebot! I'm not sure what bearing that may have on the current problem, though.
I'd start by putting some debug code in and around line 55 of modules/core/UserLogin.inc, something like this:
printf("<pre>%s</pre>", print_r($user, 1));
That should help us to figure out if it's loading the right user or not. You sound like you know what you're doing, so if you start fiddling around with putting print statements in that code you should be able to figure out whether it succeeds in authenticating you as the admin user at that point. Let me know how it goes, and I'll give further guidance.
Posts: 3
I deleted everything and started over. This time it worked.
About the google thing -- there are a few websites that allow googlebot to index their pages, but regular people have to pay for access to the articles. So, I've changed my browser's User-Agent header.