Page 1 of 1

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

PostPosted: Mon May 09, 2011 9:43 am
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

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

PostPosted: Mon May 09, 2011 5:54 pm
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

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

PostPosted: Tue May 10, 2011 8:01 am
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

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

PostPosted: Thu Jun 02, 2011 12:28 am
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  -