Hello, First a note to Kiggs: After getting this response, the mailing list server yesterday jammed to submit all further mails I sent regarding this subject. I would send them, but they wouldn't appear(and still have not appeared). It should have heard the names I called it but all the same look into it please. To the rest, the solution to this problem rotated around this submission below. However, the user you swap passwords with as indicated below must already be priviliged otherwise you will go round in circles. Thank you all.
> On Thu, Mar 04, 2004 at 07:33:07PM +0300, Lule George William wrote: > > > > > > > > Not sure, but I do know it comes with a default root user, if you are > > using > > > Best Practical's RT, of course. If you haven't yet changed the > > password, you > > > could try that one, unless this is the administrative user you were > > talking > > > about :). > > > > Unfortunately it is the one. Does that mean that I am down the drain? > > Meanwhile I have been trying to search for where RT stores its > > passwords i.e RT's equivalent of /etc/shadow but I have failed so far. > > Do you have an idea where RT stores its internal passwords, the form > > (encrypted or not, and what encryption). > > > > > > > > > > > > > By the way, as I was clutching at the straws, I remembered that as I > > > > did the installation, I created some two RT users who still have the > > > > administrative rights but whose password I have forgotten. Would > > this > > > > be of any help. > > > > Assuming you are using RT from Best Practical: > What version of RT are you using? RT3 had major revisions from the RT2 version. > Do you have connectivity to the database you use for RT? > Can you get a dump of the database? > If so, try doing this: > Obtain a dump of your database as a backup. > Access your databae from the command line > > View the values in the Users table.You should see entries for RT_System,root,Nobody. > By design RT_System and nobody are password-less.This is the tricky part.Assuming you also have a user lule also in the database, you can get the > string that matches his password, and change the password entry in the database to that string.You can then login to RT with the same password as lule. > > > mysql> select id,Name,Password from Users where Name = 'root' or Name = 'lule'; > +-----+------+------------------------+ > | id | Name | Password | > +-----+------+------------------------+ > | 281 | lule | toDCa0670IcQTCDMoYmvWQ | > | 12 | root | X03MO1qnZdYdgyfeuILPmQ | > +-----+------+------------------------+ > > mysql> update Users set Password = 'toDCa0670IcQTCDMoYmvWQ' where Name = 'root'; > > Now go the login and use the password lule uses. > K > > > --------------------------------------------- > This service is hosted on the Infocom network > http://www.infocom.co.ug > > ************************************************************************ Lule George William (Mr) Network and Systems Administrator Uganda Martyrs University, Nkozi P.O. Box 5498 Kampala Uganda --------------------------------------------- This service is hosted on the Infocom network http://www.infocom.co.ug
