Admin Password changed, can't login, how to recover

1.8 related questions and discussions.
Please upgrade to LATEST 1.9.x.
No more fixes for 1.8.

Moderators: Amaradana, TurboPT, TL Developers

Locked
deb1bhu
TestLink user
Posts: 7
Joined: Mon May 09, 2011 9:33 am

Admin Password changed, can't login, how to recover

Post by deb1bhu »

Hi, I wanted to change the admin password in testlink, so in testlink database I executed the query
"update users set password="password123" where login="admin";"

after I executed the query, Rows matched:1 Changed: 1; Warnings:0;

But I am unable to login in testlinkusing the login name as "admin" and using the new password, "password123", even I am unbale to login using the default password "admin", which I eventually changed. :!:

Can anybody help me out to resolve the issue?

Thanks
Deb
fman
Member of TestLink Community
Posts: 3123
Joined: Tue Nov 15, 2005 7:19 am

Re: Admin Password changed, can't login, how to recover

Post by fman »

no serious system stores password on plain text.
you have to use testlink to change password for any user instead of using this kind of wrong shortcuts
deb1bhu
TestLink user
Posts: 7
Joined: Mon May 09, 2011 9:33 am

Re: Admin Password changed, can't login, how to recover

Post by deb1bhu »

OK thanks fman, but tell me if I change the admin password using mysql database "testlink", then why not it is reflecting in the database? it should reflect, over there, according to my knowledge. testlink using md5 encrytion technique for hashing.

Just I asked as i don't have enough knowledge in testlink. Also if you guide me of how to change the admin password niotestlink, I would be happy.

Thanks

deb
Unhandled
Advanced user
Posts: 67
Joined: Sun Jan 23, 2011 11:28 pm

Re: Admin Password changed, can't login, how to recover

Post by Unhandled »

As fman points out, the clear text password is not stored in database. The MD5 digest of the password is stored in the database.

So for example to fix your admin password to be the word "apple", update the password in the database to be "1f3870be274f6c49b3e31a0c6728957f"

Code: Select all

# echo -n "apple" | md5sum
1f3870be274f6c49b3e31a0c6728957f  -
Locked