Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
Im Locked out of textpattern !!!!
Hi There,
Ive got a site i made with textpattern a year ago… now the guys has come back saying he has lost his log in… and then i realised that mine doesnt work either ! I cant figure it out… it is quite an old version of textpattern (just over a year), I cant find what version anywhere in the site files.
Ive tried the method explianed at textbook.net, by using that MySql string etc… but it doesnt work – it seams to put an * at the beginning of the password, and its all uppercase. I then tried the new “passw0rd” as explianed too… but mysql keeps chopping off the last few characters. The servers are running 4.1.13 if that helps…
Does anyone have any idea whats going on ?? Im locked out !! The site is working fine: http://www.centerawareness.com/
If you have any idea please help !
Matt
Dont worry… The flash site is being re-developed with txp !
Offline
#2 2005-12-13 00:14:33
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Offline
Re: Im Locked out of textpattern !!!!
Mate, ive seriously tried it 4 times, on different computers too… but it DIDNT work.
I think the server config has changed since being locked out…. could that have anything to do with it ? This is a huge problem, because I cant afford to loose all the data in the database. Would updating textpattern help ? As i said, it is a version thats just over a year old.
Matt
Dont worry… The flash site is being re-developed with txp !
Offline
#4 2005-12-13 21:00:22
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: Im Locked out of textpattern !!!!
it seams to put an * at the beginning of the password, and its all uppercase. I then tried the new “passw0rd” as explianed too… but mysql keeps chopping off the last few characters.
I’m not sure what you mean by this. Are you logging in with the password you chose (“pass” in the FAQ example), or trying to use the encrypted mysql value?
As long as you can log in to mysql/phpmyadmin, the server settings shouldn’t have an affect.
Alex
Offline
Re: Im Locked out of textpattern !!!!
Its strange, here is the sql query im running:
update txp_users set pass=password(lower(‘openup’)) where name=‘adminwebbous’;
and here is the password that is being generated…. it doesnt look right to me ?
*903BBBC3C6E9677A7
And i still cant log in !!! I am totally sure… ive seriously tried about 15 times… no luck.
I even went as far as installing a local version, and taking the password from the DB and inserting it into the broken one to no avail.
??????? im totally stumped. :-(
(no, im not trying login using the encrypted mysql value either ;-)
Dont worry… The flash site is being re-developed with txp !
Offline
#6 2005-12-13 23:04:42
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: Im Locked out of textpattern !!!!
Are you sure the ‘adminwebbous’ user exists? Does mysql/phpmyadmin tell you that 1 row was updated? And you’re logging in with username ‘adminwebbous’ and password ‘openup’?
Alex
Offline
Re: Im Locked out of textpattern !!!!
sure am mate – “adminwebbous” is me – i created the site with this user – i can also see it there when i browse the table txp_users.
Yep:
Affected rows: 1 (Query took 0.0006 sec)
SQL-query:
UPDATE txp_users SET pass = password( lower( ‘openup’ ) ) WHERE name = ‘adminwebbous’
right after i did that – i went and copied what it wrote in the password field: *903BBBC3C6E9677A7 <— this dont look right to me…. am i wrong ?
I am 120% Sure im logging in with the correct username and password too.
Dont worry… The flash site is being re-developed with txp !
Offline
Re: Im Locked out of textpattern !!!!
> mattwebb wrote:
> right after i did that – i went and copied what it wrote in the password field: *903BBBC3C6E9677A7 <— this dont look right to me…. am i wrong ?
You’re right. That’s a bad hash. Your password column is apparently set to the old varchar(18) instead of varchar(128), so the password hash is being truncated to 18 characters.
And the old versions of Txp don’t test both password() and old_password(), so you’ll probably have to alter the table to make password a varchar(128).
Offline
Re: Im Locked out of textpattern !!!!
Wicked… Doesnt sound too hard, but I dont wanna screw it all up… would you mind telling me how you do that ?
Dont worry… The flash site is being re-developed with txp !
Offline
Re: Im Locked out of textpattern !!!!
maybe this movie helps
Offline
Re: Im Locked out of textpattern !!!!
> mattwebb wrote:
> Wicked… Doesnt sound too hard, but I dont wanna screw it all up… would you mind telling me how you do that ?
I would’ve told you before, but at the time I couldn’t remember the syntax, which is this:
<code>ALTER TABLE txp_users CHANGE pass pass varchar(128)</code>
Then, reset your password one more time, and you should be golden.
Offline
Re: Im Locked out of textpattern !!!!
WOO HOOOO ! Im in, thanks everybody for all your help, it saved my live ! :-)
Matt
Dont worry… The flash site is being re-developed with txp !
Offline
Pages: 1