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

[Jesse Vincent]

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
>