[rt-users] Re: locking the keys up in your car. (RT lockup)

[Lule George William]

Thanks all for the effort. I based on the ideas from the mailing list 
and sorted out the mess.
When I was doing my initial installation, I made a test user with 
priviledges but forgot about him/her altogether and he remained 
floating around in the d/base. I remembered him today but couldn't 
recall the password, so what I did was to go to the sql d/base, update 
it with the encrypted version of my password which I am sure of and 
viola! I could log in with his ID!!!
Of course you know what I did the moment I saw the blessed admin 
screeen!!
Thanks once again.

> In RT3, the "Privileged" group is just that, a group in RT.
> 
> one option would be to manually grant some other user the SuperUser  
> right by adding a row to the database and let them log in as the  
> superuser.
> 
> 
> On Mar 4, 2004, at 4:44 PM, William George wrote:
> 
> > Jesse,
> >
> >   can you help this guy out? He locked himself out.  My copy of RT3 
is  
> > (incorrectly) running Postgres. Is this a value on the Principals  
> > table?
> >
> > Regards,
> >
> > Bill
> >
> > -----Original Message-----
> > From: Lule George William [mailto:glule at umu.ac.ug]
> > Sent: Thursday, March 04, 2004 3:35 PM
> > To: William George
> > Subject: RE: locking the keys up in your car. (RT lockup)
> >
> >
> > There goes my last straw I could clutch at. All the same thanks for
> > your help and say a small prayer for my soul. It will need it by the
> > time the ICT committee is through with me tommorrow. Goodnight!!
> >
> >>
> >> Drat. He changed this in version 3.0.
> >>
> >> My version 3.0 is in postgres so I can't help.
> >>
> >> Sorry.
> >> -----Original Message-----
> >> From: Lule George William [mailto:glule at umu.ac.ug]
> >> Sent: Thursday, March 04, 2004 3:02 PM
> >> To: William George
> >> Subject: Re: locking the keys up in your car. (RT lockup)
> >>
> >>
> >>
> >>
> >>> This is a multi-part message in MIME format.
> >>>
> >>>
> >>> Because you name is so similar I'm going to help out.
> >>>
> >>>> From your config.pm file of RT, grab the username and password
> > (and
> >> IP address as well) for your database. If your using mysql:
> >>>
> >>> mysql -uusername_name -ppassword
> >>>
> >>> select id from Users where name="your login name here";
> >>>
> >>> update Users set privileged=1 where id=value from above select;
> >>>
> >>> Let me know if you need more help.
> >>>
> >>
> >> Thanks abunch namesake. You can't know how much this means to me.
> >> However when I run the above update statement after getting my id, 
I
> >> get the error
> >> ERROR 1054: Unknown column 'privileged' in 'field list'
> >> What should I do next?
> >>
> >> George
> >>
> >>> Regards,
> >>>
> >>> William George
> >>>
> >>>
> >>>
> >>
> >>
> > 
*********************************************************************** 
> > *
> >> Lule George William (Mr)
> >> Network and Systems Administrator
> >> Uganda Martyrs University, Nkozi
> >> P.O. Box 5498 Kampala
> >> Uganda
> >>
> >>
> >
> > 
*********************************************************************** 
> > *
> > Lule George William (Mr)
> > Network and Systems Administrator
> > Uganda Martyrs University, Nkozi
> > P.O. Box 5498 Kampala
> > Uganda
> >
> 
> 

************************************************************************
Lule George William (Mr)
Network and Systems Administrator
Uganda Martyrs University, Nkozi
P.O. Box 5498 Kampala
Uganda