Forums / Install & configuration / Admin and users cannot login

Admin and users cannot login

Author Message

Derrick Oltmann

Thursday 11 October 2007 12:46:25 pm

When trying to login to the admin interface, I would be sent back to the same login screen, with no errors. I manually changed my password by updating hash in the password_hash field in ezUser table using the following format username\npassword.

Now It is telling me that it does not recognize my username/password.

It does this for all users, and new users cannot activate accounts or login as well...

Nothing was changed (on my part) between when I was logged in and when it wanted me to relog, and could not.

Any Ideas?

*Edit*
Trying to login to the admin site with a normal user will produce an "Access Denied" message, but admin is unable to login. Although users will authenticate on main page, it will not actually log them in, as where the admin account will not not authenticate.

Betsy Gamrat

Thursday 11 October 2007 4:20:29 pm

I would check the database settings in site.ini.append.php for all siteaccesses.

Then, clear the caches.

To recover your password, use example.com/user/forgotpassword - and enter your email address.

Damien Pobel

Friday 12 October 2007 2:45:12 am

Hi Derrick,

I had a problem like that. It was because of a database corruption. This corruption was due to the ezsession table that keeps on growing with the default Debian (and Ubuntu...) configuration of session handler in PHP.
See http://issues.ez.no/10431

Damien
Planet eZ Publish.fr : http://www.planet-ezpublish.fr
Certification : http://auth.ez.no/certification/verify/372448
Publications about eZ Publish : http://pwet.fr/tags/keywords/weblog/ez_publish

Emil Lazaro

Saturday 13 October 2007 11:11:31 pm

Hi, I have the same problem on my local Windows install of 3.10
How do I clear the cache, when I cannot log in as admin?

I also noticed when I printed out the current session content that there is a user logged in, the one that comes with the sample site install (user: anonymous, e-mail: nospam@ez.no). I assume that's because the demo package has been created while this user was logged in, so this remained int the cache files.

Can I just manually delete the files in var/cache?

Ousmane Ba

Saturday 03 November 2007 9:03:35 pm

It's my first week here among you guys and hope to be able to contribute soon.
I am learning by making every possible mistake.
Yesterday I experienced the same problem. Turned on debugging and also noticed a select on the ezsession table I made a back up and then truncated the table and it fixed it.
I guess deleting entries specific to your user id should work.

Note there is a cronjobs script in contributions that clears up sessions. I am taking a look at it.

Ousmane Ba

Betsy Gamrat

Wednesday 09 January 2008 3:32:21 pm

Other things to try:

Check the memory limit in php.ini
Run the cronjob (does some clean up)