[rt-users] Restore root password for rt3.0

[Kataria, Jitender .]

Jeff 
 
Thanks for the reply .
I tried to set the password with the MD5 option , it is still not
working . Infact I noticed 
with MD5 it is setting the pasword whose  length ( in envcrypted format)
is too long , longer then the reqular user . Do I need to use someother
encryption formation to change the password in RT3.0.4
 
Here is  the data  from the Users table 
 
| root      | 5f4dcc3b5aa765d61d8327deb882cf99 |
| test      | dDBr7H7iUYUA6VzlLPolkA           |
| test1     | gZrvD5/q9BCeqAvcs9SFMA           |
|

Thanks 
Jitender
 
 
-----Original Message-----
From: Hodge, Jeff F (ECIII) [mailto:Jeff.Hodge at yuma.army.mil] 
Sent: Tuesday, July 29, 2003 6:13 PM
To: Kataria, Jitender .; rt-devel at lists.fsck.com
Cc: rt-users at lists.fsck.com
Subject: RE: [rt-users] Restore root password for rt3.0


Your root Mysql (or whatever DB) account should log you into the
database and then open the users table within the rt3 DB and frind the
root user for RT.  Then update the user password for the root RT user.
Make sure you use MD5() to encrypt the password in your update
statement.
 
Something like:
 
UPDATE rt3.user set password = MD5('password') WHERE username= 'root';
 
...then change he password afterwords 

	-----Original Message-----
	From: Kataria, Jitender . [mailto:Jitender.Kataria at us.ngrid.com]
	Sent: Tuesday, July 29, 2003 1:41 PM
	To: rt-devel at lists.fsck.com
	Cc: rt-users at lists.fsck.com
	Subject: [rt-users] Restore root password for rt3.0
	
	

	Hi 

	By mistake  I modified the root password in Users table of rt
schema . 
	Now I cannot login to rt with root account ( which is the only
account whic has all the privileges) 
	How can I restore this Id 

	Thanks in advance 

	Jitender 

	
	
	This e-mail and any files transmitted with it, are confidential
to National Grid and are intended solely for the use of the individual
or entity to whom they are addressed. If you have received this e-mail
in error, please contact the National Grid USA Enterprise Support Center
on 508-389-3375 or 315-428-6360.
	



This e-mail and any files transmitted with it, are confidential to National Grid and are intended solely for the use of the individual or entity to whom they are addressed.  If you have received this e-mail in error, please contact the National Grid USA Enterprise Support Center on 508-389-3375 or 315-428-6360.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20030729/95a36637/attachment.htm>