Problem with login (doesn't seem to 'take')

Is your browser set to deny cookies? That could be it. If something had gone wrong at the user login (invalid username/password) you would've gotten an error message about it.

Are you trying to login with the first account you created? This is the admin account by default and is identified with uid=1 in the users table.

Once you login with this account, go to Home » administer » accounts » Permissions and check the box for authenticated users for "Access Content"

--- www.harvesterchurch.org

I'm having the same problem, and it appears kwerle never found the solution, as the address he gave above now says it's powered by XOOPS.

I've been using Drupal for about two weeks, was able to sign in and out without difficulty. Now, any attempt to log in, simply returns you to the login page. Any attempt to create a new account, returns you to the account creation page, and does not actually create a new account.

I've had the same problem. I've messed with the database, reinstalled it several times, all so no avail. Any *valid* login just returns to the login page. An invalid login gives the usual error. Works the same with IE and Mozilla. I surely would like to have a clue about what to do now.

I think I'm having the exact same problem (I'm also not able to log on after a fresh installation). To me it looks like it's a problem with running Drupal with PHP as FastCGI on IIS. When I try to run Drupal with PHP as an ISAPI module it works fine. Can anyone figure out why it's behaving like this? I'm stumped.

FastCGI is used for instance when you install the EasyWindows Installer from http://phplens.com/phpeverywhere/node/view/12

cheers,
Otto

I've had this same problem, as it looks like a lot of people have had.

If you are using clean URLs, make sure you have mod_rewrite turned on in Apache. In Debian (>=sarge) under Apache 2, you must link mod_rewrite from /etc/apache2/mods-available to /etc/apache2/mods-enabled. Other versions of Apache 1.3/2.0 require you to have the line uncommented to load the module.

Jeremy - the linux web guy

On the "register" page, I can't even get my first account email sent off; it just blanks the fields and reloads the page. No error messages or anything. I set up an account at Drupal.org and was able to log in just fine. Maybe my problem is that stuff with Apache. How exactly do I go about changing those settings? (I use a hosting company, so the server isn't in my possession.)

The site is at `http://vokation.com` if you want to check it out. Feel free to try and set up the first account. But if it works, um, I'm gonna want the password. Please help! I'm itching to get rolling on my site.

Site works and logins works. One day I logout then try login back. And no more success - no error about bad username or password, site returns back to user/login page without any messages, user stil unlogged. And no any new strings in watchdog :\ - attempt not registered by site. Not only me can't entry - other users too, all from different browsers (FireFox, IE). Clean urls disabled, site placed under subdirectory of virtual domain, Drupal 4.5.1 installed.

--
Axel,
Russian Drupal Community

Just installed Drupal in my Mac, OS X 10.3.7 using Safari and FireFox (both accepting cookies) and I have the same problem. After creating the first user, I can't login and I don't get any errors.
If I use a wrong login, I do get the appropiate error msg.
Now what?

identical same problem:

Use valid user/passwd, kicked back to login page.
Use invalid user/passwd, kicked back to login page and saying Access denied.

It appears that the first case is passed the login check, for some reason, it cannot redirect to the correct page or the login info is not stored.

It doesn't work with both IE and FireFox. We can see there is a cookie there in FirFox. So it's not the cookie problem also.

BTW: I am using MySQL with UTF8 charset. Wondering if it's this problem.

WEIRD !

I have the exact same problem
Using the correct password for any account returns the same page.
Using wrong passwords returns page with the wrong username/password thing.

I'm on Windows XP SP2, Apache 2.0, the latest mySQL, PHP, and Drupal.

This has become so frustrating I'm ready to go back to Xoops.

for me it was browser related because i can login to my Drupal site or this Drupal site using Opera instead of Internet Explorer in this computer lab. however, using this IE i can login to other sites including gmail and wikipedia but not drupal. i wonder why is that - something for drupal to be fixed.

I was having this problem and I tried every solution listed in this discussion and the discussions in each of the duplicate bug reports. None of them worked for me. After a long process of tracing the program flow (PHP really needs a debugger), I found out what my problem was and I have a hack to fix it.

For reference, I am running drupal 4.7 on apache 1.3 under debian Linux 3.1 with MySQL5. This also means that I am using the mysqli api to connect to the database, and I have the database.mysqli.inc file I found in another discussion here.

My problem was that the sessions table was not being written to. The problem was that for some reason, the number of affected rows was coming up blank after a certain number of queries. I was echoing the all of this info to the screen from within the db_query function. What I did to fix this is a hack, but it works. I basically made drupal make a new database connection after every five queries.

in includes/database.inc, I changed:

to:

And:

to:

This could be yet another fix that only works for people with my particular flavour of the problem, but hopefully that's you and you will be able to paste this code in and move on instead of spending three solid days hacking at it like I did. If this doesn't work for you, make sure you try the other possible solutions listed in this thread, and in the other discussion

I installed Drupal 4.6.5 on my local Windoze box using the versions of Apache, PHP, and MySQL that are part of the "Sugar on Spike" stack from SugarCRM. The Drupal page comes up fine and prompts me to create the first account, which I do. It then displays a password for that user name (uid=1). When I go to log in with that user/password combination, I get the error message "Sorry. Unrecognized username or password. Have you forgotten your password." So I checked a bunch of things. I made sure that the localhost site would accept cookies. I turned off ZoneAlarm even though it shouldn't be an issue on a local machine. I looked at the users table in the MySQL database name to make sure that the uid=1 entry was there. I looked at the users_roles table to make sure that uid=1 was represented there. Everything good so far.

I browsed the watchdog table. Line 4 is the access denied entry mentioned above. Subsequent failed logins also. So I took matters into my own hands and wrote a SQL command to change my password in the users table following the suggestion of Jason@gut.sourceforge.net (see drupal.org/node/3884)

update users set pass=MD5('newpwd') where uid='1';

Now I'm able to log in and administer the site.

But it appears that drupal stores a different value in the database than the one displayed on the screen. My only guess is that this is a case of the OLD_PASSWORD problem with mySQL, but it would be helpful if someone took a look at this issue.

Tony

I have a number of Drupal sites running 4.6 with no problems. When I try to create a new site with 4.7 I get the login issue. Running on Windows 2000 with IIS PHP is 4.3.1 and mysql is 4.0.22. All my my established 4.6 sites are running fine, but any new 4.7 sites I try to add I get this login problem. I have tried all of the different suggestions here and elsewhere, but nothing is working.

Any other suggestions or any additonal information I can provide? Thanks!

Had the same problem running on Apache 2, PHP 5.0.4, Drupal 4.6.5 and 4.6.5, Fedora Core 4.

I tracked it down to the session_set_save_handler function in includes/session.inc failing. If this doesn't work, Drupal's session handlers don't work and it won't update the sessions table in the database so it thinks you're not logged in.

For this function to work, the PHP setting session.save_handler must be set to "user". Drupal tries to do this in the sites/default/settings.php file, but in my case it was failing and the following messages appeared in Apache's error log:

Basically, session.save_handler must be set before any session starts. However, the default PHP install had the line "session.auto_start = 1" in the php.ini file so PHP was automatially starting a session before Drupal had a chance to change the settings.

The fix was easy: change php.ini so that the line reads "session.auto_start = 0" and it Drupal now works!

It's be good if Drupal could detect this situation and handle it, or at least report a meaningful error.

I have tried all the listed solutions and still i can not login with IE (6 and 7) but i can with firefox. I think this problem is related to the hosting enviroment. I facing this issue with a linux box with CentOS 4.3. I have a secound box with linux CentOS 4.2 and it is working perfeclty !!

also this issue happen for 4.6 and 4.7 ?!

If you like to try visit:
http://www.freeq80.com

I'm encountering the same problem on a 4.6.6 fresh install on a Linux box server where and older install of 4.6.3 works smoothly.

Log in brings me back to the log in page without any obvious errors in Watchdog or Apache logs.

Hope this can be solved soon.

I had the same problem: login attempts simply returned me to the login screen, even though I was actually logged in. Even though the problem existed on one of my Windows computers, it worked fine on another identical computer on the same desk.

Based on suggestions in another thread (can't remember which one), the following solved my problem. Replaced my 4.6.6 modules/user.module file with the 4.6.5 version.

I'm not totally confident that this permanently solves the problem since the problem is so strange. It's definitely related to sessions and involves some combination of host/client elements. If someone smarter that me could look at user.module and determine what changed between 4.6.5 and 4.6.6, it might lead to a real solution. I'm not saying that 4.6.5 worked for all cases, but whatever changed between the two version relates to the problem.

As per another user's post, i deleted all cookies and the problem went away (for now).
I was noticing that, even though I couldn't get past the login screen, Drupal was reporting that I was among the logged-in users - so obviously there's some sort of session weirdness going on here.

Now if I could just figure out how to stop this from happening again...

Server: linux (freevps); Apache 2.0.46; PHP 4.3.2; mysql 3.23.58; Drupal 4.7 (had the same problem with the RC i was using)
Client: macOSX, Safari & Firefox

Tried again with 4.7.0. Tried all of the other things suggested since last time. Still running on IIS.

When I first hit the page, I get a new record in the sessions table. UID of 0 with a SessionID of 56 (shortened for space). Then I enter the username and password. Now there is a second record in the sessions table with a UID of 2 and a SID of 44. But when I look at the cookie on my computer, it is for a PHPSESSID of 56...

Is that the source of all these problems? The cookie left on my computer connects me as a user 0? Any other thoughts on a fix?

Thanks!

I wonder, if developers look through the hottest topics, at least sometimes :)

Clearing cookies was the problem for me since it worked in Firefox but not IE.

I think this issue http://drupal.org/node/60584 may have something to do with it.

Rob
------------------
Some of my Drupal sites:
Quotes | MySpace Layouts

Ok, EUREKA !!! :D

I applied this recomended solution and it worked for me I think is not the best solution but it works. So I am going to use it until I find a better one. For the fix, you have to modify the user.module in your module files and comment the next three lines:

FROM this:

$old_session_id = session_id();
session_regenerate_id();
db_query("UPDATE {sessions} SET sid = '%s' WHERE sid = '%s'", session_id(), $old_session_id);

TO this:

//$old_session_id = session_id();
//session_regenerate_id();
//db_query("UPDATE {sessions} SET sid = '%s' WHERE sid = '%s'", session_id(), $old_session_id);

And That´s it

I am Using:
DRUPAL 4.7
APACHE
PHP 4.3

I was just able to reproduce this in IE. I logged in at http://agencysolutions.us/user. The significance of that is the $base_url in the settings.php file is set to be http://www.agencysolutions.us, so the site redirected to www.agencysolutions.com. IE recorded the cookie as deekayen@agencysolutions[1].txt.

<