[rt-devel] Retrieving the encrypted data from MYSQL

Rich Lafferty rich+rt at lafferty.ca
Sat Aug 3 12:39:31 EDT 2002

On Sat, Aug 03, 2002 at 01:07:48PM +0530, Jay <jayps at addr.com> wrote:
> hello friends,
> I am Jayakumar from Bangalore, India.
> This is something related to RT and Mysql. 
> I have configured the RT system at my place. The database is Mysql.
> The passwords are encrypted in the user table. 
> I need to know the password of a user for 
> 1)who has missed his password 
> 2)to use the same databse for another application
> Please help me in retriving the password from the database

You can't. It's not encrypted, it's a one-way hash. You'll have to reset
his password via WebRT or rtadmin (as root).

This question really belongs on rt-users, by the way.



Rich Lafferty --------------+-----------------------------------------------
 Ottawa, Ontario, Canada    |  Save the Pacific Northwest Tree Octopus!
 http://www.lafferty.ca/    |    http://zapatopi.net/treeoctopus.html
rich at lafferty.ca -----------+-----------------------------------------------

More information about the Rt-devel mailing list