Textpattern CMS

#1 2006-04-22 01:20:42

rollo

New Member

Registered: 2006-04-22

Posts: 6

Can't login, nothing changed

I go to log in to my Textpattern installation and get this:

“Could not log in with that name/password”

The username and password are definitely correct. The software is hosted remotely and hasn’t been touched. The only thing that has changed is my web browser, because I have a new computer.

I have tried the tricks for resetting the password (http://textpattern.org/tips/196/password-reset-in-mysql-database) and changing the language setting (http://forum.textdrive.com/viewtopic.php?id=3880). No use.

Anyone know what to try next?

Thanks!

#2 2006-04-22 03:48:38

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

Re: Can't login, nothing changed

Have you modified your install in any way?

#3 2006-04-22 07:35:15

-P-

Member

From: Finland

Registered: 2005-09-10

Posts: 211

Re: Can't login, nothing changed

Which browser are you using? I have run into logging problems few times with IE. Also I´d recommend adding your site installation domain to trusted sites in your firewall program and checking that sending cookies and referrers are both allowed.

---

shenerd

#4 2006-04-22 11:43:23

rollo

New Member

Registered: 2006-04-22

Posts: 6

Re: Can't login, nothing changed

Using the latest Firefox. Firewall makes no difference on or off. Cookies allowed, cleared and reset. No difference.

But I solved it! Using the third suggested trick at http://textpattern.org/tips/196/password-reset-in-mysql-database , a MySQL query which I would swear I had already tried unsuccessfully:

UPDATE PFXtxp_users SET pass = password(‘NEW_PASSWORD’) WHERE user_id = ‘USER_ID_OF_USER’

“where PFX is the prefix you set in your TXP config (make sure you wrap the whole thing in backticks, though not doing so probably won’t have an effect), NEW_PASSWORD is the new password you want, wrapped in single quotes. USER_ID_OF_USER is the user_id of the user whose password you want to reset.”

I also changed character encoding in Firefox to UTF-8 and in MySQL to utf8_general_ci . This could have been what did it.

Either that, or I had in fact changed the password and then forgotten! In which case I really am losing it…

Thanks guys, I really appreciate the pointers.

Last edited by rollo (2006-04-22 11:44:18)