Thanks Petar for your much needed reply,
On 1/22/07, Petar Kazakov <[EMAIL PROTECTED]> wrote:
You need to do the following
Find out you admin group ID
Find the ID for some user (like admin, [EMAIL PROTECTED] 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
This is what I have already verified. Is there a setting that
specifies the admin group or is it always assumed to be Admin (id=2).
And are there any settings on the module.
Philip
Peter
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Philip Mark Donaghy
Sent: Monday, January 22, 2007 2:47 PM
To: [email protected]
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/
_______________________________________________
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/
--
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/
