Cant log in

Yeah, this has been ongoing for as long as I have been using Drupal. There is a long thread about this here:

http://drupal.org/node/6696

A developer had commented that without specific ways to reproduce the error there was nothing they could do, even though a fair number of people have the issue. It just "happens" when logging in. Hope this gets resolved in future versions :)

I've tried many times these days still get "Access denied" page each time.

The symptoms is :
Install drupal successfully, when I create the first account and just after click to submit and get the "access deny" page even though I got email later with the user name and password inside.
I only have windows XP firewalls and tried turn it and other anti-virus software off, no luck.
I tried other methods from this forum but still not work.

I've tried on the following combinations:
One combination:
Windows2000ProSP4
PHP5.0.5
Apache 2.0.54
Mysql 4.1.15
PHPMyAdmin 2.6.4
I've tried each available version of Drupal(4.6, 4.7, 5.0Rc). but no luck at all.

another combination:
WindowsXPpro
PHP5.2.0
Apache 2.2.3
Mysql 5.0.27
PHPMyAdmin 2.7.0
I've also tried each available version of Drupal(4.6, 4.7, 5.0Rc). but no luck at all.

now since each version of Drupal not work so I decide just stick with the 5.0 rc version.
went through all the solutions provided from this forum but just not work.

Anybody please help. what should I do? Many thanks

Deathgod,

For this.... "Symptom: I cant log in even though I entered the correct username and password. It just reloads the page with the log in, and also shows that I am logged in my member's online block.

Solution: In user.module, comment out
sess_regenerate();
return 'user/'. $user->uid;"

I thank you profusely.
Tonight I did a fantastico install of a test version of Drupal 5.1. I operate a 4.7.5 Drupal site that had been working fine. I got the 5.1 site to work for purposes of getting familiar with 5.1 as a do planning for major revision of site. HOWEVER, when I left 5.1 and went back to use working site, I could NOT login for the life of me. Using Firefox I could not enter with any of my test identities either. And could not even get in using UID 1. Finally I was able to get in via UID 1 on Internet Explorer and the log showed that I had "successfuly" logged on numerous times.

I then used your SOLUTION! BINGO it worked. I was able to log in just fine. I tried breaking it, I could not. Each time it took, even when I closed Firefox and started up again, when I logged out, etc. It took each time on the first time.
Thanks. Now I will see if it resolves the other annoying little Drupal quirk, ie, logging in but having to do it a second time so that it "takes."

FYI, for yucks, and to do the math on this problem that seems to be plaguing a lot of folks, I reinstalled Drupal 5.1 in another folder again. I used the same login and password as the other installation AND the same login and password I use for the working site. I logged into the new site. I logged out of the working site and tried to log in again; it would NOT let me log in to the working site. I closed the 5.1 location; I was able to log in without problem.

So I wonder if there is another issue, ie password recall or incompatibility (computer brain warp) when there is more than one site using drupal with same user login name and password on the same server?

I don't know. What I do know is that your solution bailed me. Thanks.

geoff gevalt
http://www.youngwritersproject.org

I am eager to know how to solve this problem

I have a problem with this issue as well.

I am a recent convert to Drupal and have now built several sites, using it. The latest I have set up and spent a few hours configuring and now I am completely unable to log back in, entirely negating all the work I have done :(

I was extremely happy with Drupal prior to this, but it seems to be a big problem.

I think I've observed the same problem today. Strangely enough, it appeared from nowhere.
I have RHEL3 with manually installed php 4.3.2, and I've upgraded to Drupal 5.1 about a month ago. Everything went fine, users could happily log in and out.
About a day or two ago another admin of the site has updated mysql to version 5. He might have upgraded some other packages at the same time, but as far as I understood nothing except mysql was really affected.
What is sure is that none of the drupal files was touched.

Nonetheless, I found out today that Drupal refuses to log me in. After some live-http-headering I discovered that although Drupal authenticated me correctly, it refused to let the browser know of the changed session id in the PHPSESSID cookie.

This lead me inside the sess_regenerate (that's where the session id is being changed), where I ended up changing the code

  if (isset($_COOKIE[session_name()])) {
     setcookie(session_name(), '', time() - 42000, '/');
  }
  
  session_regenerate_id();

with

  session_regenerate_id();
  setcookie(session_name(), session_id(), time() + 36000, '/');

and it seemed to fix the problem.
I'm not really sure whether I did the right thing, the solution where you just switch the regeneration of the session id off seems quite reasonable too, but I'm just sharing the experience in the hope it provides additional clues to someone.

I have three websites running on the same server.. All are Drupal 5.1. They run in seperte directories.. All seperate installations..

Now one of them has this problem out of the blue.. I login but is just treats me as an anonymous user.. I can't login.. I create new password and login through the onetime login but I still can't access anything..

Is there a solution to this??? I Tried the above techniques and it just doesn't work.. I can't login!

After using my Drupal site for about a month, mostly from firefox, I began having this issue. Thankfully, I was able to login fine from IE, but that just made me realize that it wasn't a login & password problem. As mentioned above, the site's log shows multiple successful logins but the front page keeps looping back to the login prompt. Going directly to http://site.com/?q=user/1 simply gives an access denied error, so I don't think I'm completely logging in.

I tried two of the solutions:

1. http://drupal.org/node/6696 (didn't help)
which tells you to add a line to index.php

2. The patch in this thread (this worked for me)
commenting out two lines in user.module:

//sess_regenerate();
//return 'user/'. $user->uid;

I also deleted the site cookie many times and flushed the cache while trying different solutions. Good luck to everyone else and I hope we're not blowing open a security gap. D:

Also, the site doesn't seem to be setting cookies (at least in firefox) anymore.

I can't log in either. These were my steps. I took out the Adsense Id beside my profile.. Then the next page displayed was the front page, but I was logged off... Then I tried to log on.. It doesnt recogzize my Name nor my Email when trying to recover my password.. Nothing happens... ARRRRGGUHHH... Alot of these PHP programs are doing this... What is with this.. I know its free, but by all means, I spent alot of time on this setting it up, and now Im hoping atleast to wait a day so I can log in again... I got rid of WORD PRESS cause it was doing it alot to me.. Now This one.. But seriously This program was better than all the ones I have used... BIG respects to this Software, but please fix this problem... Its the only fall back... Thank You Alex.

deathgod's solution worked for me.

I had problem with not being able to log in after fresh installation of Drupal 5.2 (I had no problem with 4.7.7).

My host's settings:

PHP built On: Windows NT SERVER4 5.0 build 2195
Database Version: 4.0.27-standard
PHP Version: 4.3.6
Web Server: Microsoft-IIS/5.0

Problem:
Unable to log in after fresh installation of Drupal 5.2. You're getting back to login page with no error message at all. Tried many other solutions but none of them actually worked until i tried this one.

Thanks again!

This problem has persisted and is still present in Drupal 6. I've tried all suggestions listed here, and this one solved it:

In /modules/user/user.module, in the function user_login_submit(), roughly around line 975, comment out this line:
sess_regenerate();

So that it reads:
//sess_regenerate();

Don't comment out the line below, it returns the ID of the logged in user, which is fine.

This was tested on IIS/5.0 on Windows NT.

A better solution though, would be to ditch IIS and go with the most widely used HTTP server, Apache.

This is a trick to get rid of this annoying bug.
1. Go to yoursite.com/user/logout
2. Login :)

And that is.

$signature = '
(3 John 1:2)
Dear friend, I pray that you may enjoy good health and that all may go well with you, even as your soul is getting along well.';

echo $signature;

Looking at the tables in my database with phpMyAdmin, I see two tables listed as 'in use', 'sessions' and 'search_index'.

I see all the tables, other than those two, listed as 'utf8_general_ci', but the summary line at the bottom of the page says 'latin1_swedish_ci'. Go figure.

When I check the information on the two tables listed as 'in use' I get this message:
#145 - Table './drupal/
' is marked as crashed and should be repaired

I ran the repairs on the tables one at a time, and did a full export as backup before I did it, but that seems to have solved the problem... for now ;-)

I'll get back to you, if it fails again. Either way, running with a crashed table probably isn't a good idea.

Carey
====================================
I'm willing to put up with you, if you're willing to put up with me.

I had this problem under Drupal 6 and tried everything listed without success, then deleted the php.ini file that I had created in /public_html/. This fixed my problem. I have not tried to figure out which part of php.ini was causing the problem, as I don't need it, anyhow. Hope this information saves someone the frustration that this problem caused me.

I have noticed a whole thread of posts on this, but none seem to help : http://drupal.org/node/105114 This has only happened in the past 48 hours or so, so if might be some upgrade at their end.

It may well be a the server end, they have had a look, but they don't support 3rd party software :(

The server is running Apache version 1.3.41 (Unix) PHP version 5.2.5
MySQL version 4.1.22-standard

I try to log in

mysite.com/user/

it won't accept my p/w do I ask for a new temp p/w, which I log in with, and put in a new p/w. But then it doesn't accept that and I am locked out.

the posts mentioned commenting out

Solution: In user.module, comment out
sess_regenerate();
return 'user/'. $user->uid;

so that it looks like

//sess_regenerate();
//return 'user/'. $user->uid;

but this code is not in my version of user.module.

Another post, way down the list suggested to delete php.ini. I don't believe I have a php.ini file to delete (where would it be??) as the last person on this commented.

Does anyone have any ideas about how to get in. Obviously the next step is to upgrade to 6.1, but I can't do that properly (uninstalling extra modules etc), until I can get in.

I am rather desparate, as I need to update content!!