You need to do the following Find out you admin group ID Find the ID for some user (like admin, root@localhost or what so ever is call you admin user) Execute next command update group_user set permission_value="1" where user_id="x" and group_id="y"; this will give your user RW access to that group and you should be able to have access to you admin section Peter -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Philip Mark Donaghy Sent: Monday, January 22, 2007 2:47 PM To: otrs@otrs.org Subject: [otrs] Help - A rogue administrator locked everyone out Hi, I am trying to restore admin access to the system users who were locked out by a rogue administrator. Unfortunately this kind of thing can happen. I have access to the mysql data and I am using otrs 2.0.4.
From what I can see the column valid_id in the group Admin (id = 2) should be set to 1.
And then the table group_user requires a certain number of permissions. The user administrator has the permission_key rw set with the permission_value 1. Yet this user does not have an admin link. If I login it as administrator and go directly to the link http://localhost/otrs/index.pl?Action=AdminGroup The error I have is "No permission". Please Help, Philip -- Philip Donaghy donaghy.blogspot.com del.icio.us/donaghy/philip Skype: philipmarkdonaghy Office: +33 5 56 60 88 02 Mobile: +33 6 20 83 22 62 _______________________________________________ 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 orr consulting for your OTRS system? => http://www.otrs.com/