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

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

Postby deb1bhu » Mon May 09, 2011 9:43 am

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
deb1bhu
TestLink user
 
Posts: 7
Joined: Mon May 09, 2011 9:33 am

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

Postby fman » Mon May 09, 2011 5:54 pm

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
fman
Member of TestLink Community
 
Posts: 3012
Joined: Tue Nov 15, 2005 7:19 am

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

Postby deb1bhu » Tue May 10, 2011 8:01 am

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
deb1bhu
TestLink user
 
Posts: 7
Joined: Mon May 09, 2011 9:33 am

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

Postby Unhandled » Thu Jun 02, 2011 12:28 am

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  -
Unhandled
Advanced user
 
Posts: 67
Joined: Sun Jan 23, 2011 11:28 pm


Return to TestLink 1.8 (OBSOLETE => EOL)[LOCKED]



Who is online

Users browsing this forum: No registered users and 6 guests