Locking the keys up in your car. (RT lockup)

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@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@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

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.

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@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@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