<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=562382622-29072003><FONT face=Arial color=#0000ff size=2>Jeff
</FONT></SPAN></DIV>
<DIV><SPAN class=562382622-29072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=562382622-29072003><FONT face=Arial color=#0000ff size=2>Thanks
for the reply .</FONT></SPAN></DIV>
<DIV><SPAN class=562382622-29072003><FONT face=Arial color=#0000ff size=2>I
tried to set the password with the MD5 option , it is still not working . Infact
I noticed </FONT></SPAN></DIV>
<DIV><SPAN class=562382622-29072003><FONT face=Arial color=#0000ff size=2>with
MD5 it is setting the pasword whose length ( in envcrypted format) is
too long , longer then the reqular user . </FONT></SPAN><SPAN
class=562382622-29072003><FONT face=Arial color=#0000ff size=2>Do I need to use
someother encryption formation to change the password in
RT3.0.4</FONT></SPAN></DIV>
<DIV><SPAN class=562382622-29072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=562382622-29072003><FONT face=Arial color=#0000ff size=2>Here
is the data from the Users table </FONT></SPAN></DIV>
<DIV><SPAN class=562382622-29072003></SPAN> </DIV>
<DIV><SPAN class=562382622-29072003><FONT face=Arial color=#0000ff size=2>|
root | 5f4dcc3b5aa765d61d8327deb882cf99
|<BR>| test |
dDBr7H7iUYUA6VzlLPolkA
|<BR>| test1 |
gZrvD5/q9BCeqAvcs9SFMA
|<BR>|<BR></FONT></SPAN></DIV>
<DIV><SPAN class=562382622-29072003><FONT face=Arial color=#0000ff size=2>Thanks
</FONT></SPAN></DIV>
<DIV><SPAN class=562382622-29072003><FONT face=Arial color=#0000ff
size=2>Jitender</FONT></SPAN></DIV>
<DIV><SPAN class=562382622-29072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=562382622-29072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Hodge, Jeff F (ECIII) [mailto:Jeff.Hodge@yuma.army.mil] <BR><B>Sent:</B> Tuesday, July 29, 2003 6:13
PM<BR><B>To:</B> Kataria, Jitender .; rt-devel@lists.fsck.com<BR><B>Cc:</B> rt-users@lists.fsck.com<BR><B>Subject:</B> RE: [rt-users] Restore root password
for rt3.0<BR><BR></FONT></DIV>
<DIV><SPAN class=546110822-29072003><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV><SPAN class=546110822-29072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=546110822-29072003><FONT face=Arial color=#0000ff
size=2>Something like:</FONT></SPAN></DIV>
<DIV><SPAN class=546110822-29072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=546110822-29072003><FONT face=Arial color=#0000ff size=2>UPDATE
rt3.user set password = MD5('password') WHERE username=
'root';</FONT></SPAN></DIV>
<DIV><SPAN class=546110822-29072003></SPAN> </DIV>
<DIV><SPAN class=546110822-29072003><FONT face=Arial color=#0000ff
size=2>...then change he password afterwords</FONT> </SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Kataria, Jitender . [mailto:Jitender.Kataria@us.ngrid.com]<BR><B>Sent:</B> Tuesday, July 29, 2003
1:41 PM<BR><B>To:</B> rt-devel@lists.fsck.com<BR><B>Cc:</B>
rt-users@lists.fsck.com<BR><B>Subject:</B> [rt-users] Restore root password
for rt3.0<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>Hi </FONT></P>
<P><FONT face=Arial size=2>By mistake I modified the root password in
Users table of rt schema .</FONT> <BR><FONT face=Arial size=2>Now I cannot
login to rt with root account ( which is the only account whic has all the
privileges)</FONT> <BR><FONT face=Arial size=2>How can I restore this Id</FONT> </P>
<P><FONT face=Arial size=2>Thanks in advance</FONT> </P>
<P><FONT face=Arial size=2>Jitender</FONT> </P><FONT size=3><BR><BR>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.<BR></BLOCKQUOTE></FONT><FONT SIZE=3><BR>
<BR>
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.<BR>
</FONT>
</BODY></HTML>