root@localhost does not have access to administrative functions

When I log into OTRS 1.1.3 as root@localhost I have no access to the administrative functions. I have looked in the MySQL database, but as I am no expert I am hopeful that someone can point me in the right direction for fixing this dilemma (short of deleting the database..hopefully). Steve _________________________________________________ Steve Gold Network Administrator WBFS-UPN33, WTVX-UPN34 & WFOR-CBS4

root@localhost does not have access to administrative functionsSteve, Run this query in MySQL: select * from group_user where user_id = 1 and group_id = 1; If you don't get any results, then the problem is that the root user has somehow been removed from the admin group in OTRS. You should be able to insert the record pretty easily. If there is a record returned, then make sure that permission_read and permission_write are both set to 1. Hope this helps! -- Chris Salter -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org]On Behalf Of Gold, Steven T Sent: November 18, 2003 9:40 AM To: 'otrs@otrs.org' Subject: [otrs] root@localhost does not have access to administrativefunctions When I log into OTRS 1.1.3 as root@localhost I have no access to the administrative functions. I have looked in the MySQL database, but as I am no expert I am hopeful that someone can point me in the right direction for fixing this dilemma (short of deleting the database..hopefully). Steve _________________________________________________ Steve Gold Network Administrator WBFS-UPN33, WTVX-UPN34 & WFOR-CBS4

On Tuesday, November 18, 2003 3:40 PM
Gold, Steven T
When I log into OTRS 1.1.3 as root@localhost I have no access to the administrative functions. I have looked in the MySQL database, but as I am no expert I am hopeful that someone can point me in the right direction for fixing this dilemma (short of deleting the database..hopefully).
It might be you revoked root from the 'admin' group. If you got another user in the 'admin' group, you may use this one to re-add root there. hth, Robert Kehl -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Tel. +49 (0)6172 4832388
participants (3)
-
Chris Salter
-
Gold, Steven T
-
Robert Kehl