On Thursday, April 29, 2004 1:32 PM
Nic Laschinger
I have just set up my first otrs system, so bear with me. I have logged with root for the first time, and I have no Admin-Area or Stats, it seems as if I have only the privileges of a normal user. I am running a standard SuSE 9 box, nothing special there.
If you've got another admin user, use this one to re-assign 'root@localhost' to the 'admin' group. If 'root@localhost' was the one and only admin it's time for hacking: Use a tool like phpMyAdmin or similar to have a look in the table 'group_user'. Find the row for the offending user, the user_id is most likely to be 1. The wanted group_id maps from table 'groups', 'admin' is '2'. You need a permission_key of 'rw' with a permission_value of '1' here. If the table structure doesn't match the mentioned fields, you may want to execute these SQL commands on the OTRS database carefully and one-by-one: ALTER TABLE group_user ADD permission_value SMALLINT; UPDATE group_user SET permission_key = 'ro', permission_value = 1 WHERE permission_read = 1; UPDATE group_user SET permission_key = 'rw', permission_value = 1 WHERE permission_write = 1; UPDATE group_user SET permission_key = 'rw', permission_value = 1 WHERE permission_write = 0 and permission_read = 0; DELETE FROM group_user WHERE permission_value IS NULL; ALTER TABLE group_user ALTER permission_value SET NOT NULL; ALTER TABLE group_user DROP permission_read; ALTER TABLE group_user DROP permission_write; Please be cautious and have a complete backup at hands. No warranties appliable. hth, Robert Kehl -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Tel. +49 (0)6172 4832388