Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2011-07-03 15:33:20

geoff777
Plugin Author
From: Benarrabá Andalucía Spain
Registered: 2008-02-19
Posts: 282
Website

Admin Login Problem

Sorry to post this here but it is urgent and the Troubleshooting forum doesn’t get as many visitors …

Hi,

I can’t login to the admin side of one of my sites.

I’ve reset the password using phpmyadmin as instructed in the reference – using Password from the dropdown.

I get the login page then on entering my details I get a 500 server error message.

I then have to clear cookies to get the login page again … then the same thing happens.

The front end is working.

Anyone any ideas what could be happening?

Thanks


There are 10 types of people in the world: those who understand binary, and those who don’t.

Offline

#2 2011-07-03 16:05:08

CeBe
Plugin Author
From: Caen - Fr
Registered: 2010-06-25
Posts: 345
Website

Re: Admin Login Problem

Did you change your .htaccess recently ?

Offline

#3 2011-07-03 16:21:00

Dragondz
Moderator
From: Algérie
Registered: 2005-06-12
Posts: 1,549
Website GitHub Twitter

Re: Admin Login Problem

Hi

The password hash has changed since 4.4 and how have you reset your password using phpmyadmin?

Cheers

Offline

#4 2011-07-03 16:26:05

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,258
Website GitHub Mastodon Twitter

Re: Admin Login Problem

from the FAQ

With phpMyAdmin, or at the MySQL command prompt, run the following query: update txp_users set pass=password(lower('pass')) where name='user';
..where pass is the new password, and user is the login username.

is this what you did?


Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

Offline

#5 2011-07-03 16:34:36

wet
Developer Emeritus
From: Schoerfling, Austria
Registered: 2005-06-06
Posts: 3,376
Website GitHub Mastodon

Re: Admin Login Problem

Dragondz wrote:

The password hash has changed since 4.4 and how have you reset your password using phpmyadmin?

NB: The password reset instructions from previous versions are still valid in 4.4+

Offline

#6 2011-07-03 17:19:32

geoff777
Plugin Author
From: Benarrabá Andalucía Spain
Registered: 2008-02-19
Posts: 282
Website

Re: Admin Login Problem

Thanks for the replies.

No I haven’t changed my .htaccess file recently.

I changed my password by writing to the table.

I have since used the SQL command prompt and executed the query Colak suggested.

No luck.


There are 10 types of people in the world: those who understand binary, and those who don’t.

Offline

#7 2011-07-03 18:41:52

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 11,945
Website GitHub

Re: Admin Login Problem

Anything in the PHP error logs that might give us a clue? You can usually access these from your host’s cpanel or, depending on the severity of the problem, you may get an error_log file in your textpattern root, or /textpattern subfolder which you can download via your FTP client. Sometimes these give file names and line numbers of encountered errors and we can work back from there.

Last edited by Bloke (2011-07-03 18:42:39)


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#8 2011-07-03 19:58:59

geoff777
Plugin Author
From: Benarrabá Andalucía Spain
Registered: 2008-02-19
Posts: 282
Website

Re: Admin Login Problem

Hi Stef,

There is an error log file in the root but the last entry was June 2010 and was to do with mail.

No error log in the textpattern folder.


There are 10 types of people in the world: those who understand binary, and those who don’t.

Offline

#9 2011-07-04 08:37:20

Dragondz
Moderator
From: Algérie
Registered: 2005-06-12
Posts: 1,549
Website GitHub Twitter

Re: Admin Login Problem

wet a écrit:

Dragondz wrote:

The password hash has changed since 4.4 and how have you reset your password using phpmyadmin?

NB: The password reset instructions from previous versions are still valid in 4.4+

Sorry my mistake, i thinked that using phppass in txp has changed the manner that the password is stored in DB.

Offline

#10 2011-07-04 08:51:33

wet
Developer Emeritus
From: Schoerfling, Austria
Registered: 2005-06-06
Posts: 3,376
Website GitHub Mastodon

Re: Admin Login Problem

It has, but there’s a password upgrade path which also works for the “old” password recovery procedure.

Offline

#11 2011-07-04 09:52:57

Dragondz
Moderator
From: Algérie
Registered: 2005-06-12
Posts: 1,549
Website GitHub Twitter

Re: Admin Login Problem

wet a écrit:

It has, but there’s a password upgrade path which also works for the “old” password recovery procedure.

Thanks for the precision wet

Offline

#12 2011-07-04 12:24:29

geoff777
Plugin Author
From: Benarrabá Andalucía Spain
Registered: 2008-02-19
Posts: 282
Website

Re: Admin Login Problem

Hi,

I temporarily swapped databases with another txp install on the same server.
The site worked so I know the textpattern files 4.4.1 are not corrupted and it’s not a permissions problem.

I also tried changing the password on another txp site using the method given, it worked.
So I’m presuming that the password isn’t an issue on my problem site.

I think it may be possibly be a cookie problem but I’m not really sure.
I’ve looked at the cookie on the problem site and one that is working and they contain similar data.

Any one got a clue what may be causing this?

Thanks


There are 10 types of people in the world: those who understand binary, and those who don’t.

Offline

Board footer

Powered by FluxBB