AW: Deleted SuperUser privilege for Root

Hello Mark,

thanks a lot, but I killed my root-account in RT,
not on my linux-system … any ideas ?

Tom

| Try booting from CD, mount your file systems and edit your
| /etc/passwd file.
| Any account with UID 0 will have “root” privileges (it’s the
| UID, not the
| name which is important)
|
| Good luck
| Mark Collis
| Trinity College
|
| At 00:22 27/08/2003 +0200, you wrote:
| > Hello list,
| >
| > I made a big mistake …
| > I’ve deleted the ‘SuperUser’-privilege for root …
| > Any suggestions how to get it back?
| >
| > System: RT 3.0.5pre4
| > MySQL 3.23
| > Apache 1.3.26
| >
| > Any help would be very appreciated :slight_smile:
| >
| > thanks,
| > Tom

Hello Mark,

thanks a lot, but I killed my root-account in RT,
not on my linux-system … any ideas ?

You will have to fix it in the database, I guess.

update acl set rightname = ‘SuperUser’, rightscope = ‘System’, rightappliesto =
0 where principalid = (select id from users where name = ‘root’) and
principaltype = ‘User’;

looks ok to me for my Postgres based RT/2.0.15. YMMV. Test. Test. Test. Make a
copy of the DB and test some more.:slight_smile:

Binand

Hello list,

you’re my heros :slight_smile:
The system is productive, so an ‘initialize-database’
wasn’t possible … I compared the ACL-Table of a backup
from a few days ago and restored the deleted field …
Everythings works fine now again.

thanks a lot for your help,
Tom

| -----Ursprüngliche Nachricht-----
| Von: ODHIAMBO Washington [mailto:wash@wananchi.com]
| Gesendet: Mittwoch, 27. August 2003 09:48
| An: Knaupp, Thomas
| Betreff: Re: [rt-users] Deleted SuperUser privilege for Root
|
|
| * Knaupp, Thomas Thomas.Knaupp@schwarz.de [20030827 01:27]: wrote:
| > Hello list,
| >
| > I made a big mistake …
| > I’ve deleted the ‘SuperUser’-privilege for root …
| > Any suggestions how to get it back?
| >
| > System: RT 3.0.5pre4
| > MySQL 3.23
| > Apache 1.3.26
| >
| > Any help would be very appreciated :slight_smile:
|
|
| If it’s without tickets, you can simply redo make | initialize-database again.
| If it has tickets, then fix it in MySQL itself as was suggested.
|
|
|
|
| -Wash
|
| –
| Odhiambo Washington wash@wananchi.com “The box said ‘Requires
| Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,’
| Tel: +254 2 313985-9 +254 2 313922 so I installed FreeBSD.”
| GSM: +254 72 743223 +254 733 744121 This sig is McQ! :slight_smile:
|
|
| People will buy anything that’s one to a customer.