On Thursday, April 29, 2004 1:32 PM
Nic Laschinger <[EMAIL PROTECTED]> wrote:
>> 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
'[EMAIL PROTECTED]' to the 'admin' group.
If '[EMAIL PROTECTED]' 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
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support oder Consulting für Ihr OTRS System?
=> http://www.otrs.de/
