[SOLVED] ADMIN area disappeared !

[Athena]

Hello,

I use OTRS 3.3.3 running on a W2K8 server, using MySQL and IIS.
Everything was working fine till yesterday.

No account (even root@localhost) can see the ADMIN area.
When trying to access it via a direct link (http://myurl.com/index.pl?Action=Admin; ... xxxxxxxxxx), I receive this error message : "Message: No Permission to use this frontend module!".

I tryed to reinstall an old backup of the DB (from a date where this area was reachable) : no effect.
I tryed to reinstall an old backup of the OTRS modules (from a date where this area was reachable) : no effect.
I also restored the access rights in the DB (UPDATE `otrs`.`group_user` SET `permission_key` = 'rw' WHERE `group_user`.`user_id` =1 AND `group_user`.`group_id` =2 LIMIT 1;) : no effect.

I checked in the DB : all users are still defined, and assigned to correct groups (including group 2).

What could be wrong ?

Thanks in advance for your help.

[jojo]

as nothing happens without a change, what did you do before?

[Athena]

I received a clue from an admin user.
Yesterday, he did a cleanup of the existing groups.
And... he invalidated the "admin" group.

How is it possible to undo this invalidation ?

[Athena]

I found the table associating the groups to the valid_id.
After an direct update in MySQL, the admin area is back !

However, it was not immediately available, even after a restart of MySQL and IIS.
Is there any cache effect in the access rights ?

[RStraub]

Yup there is a cache though I do not know exactly what it caches. To properly purge it, there is a script in bin/otrs.DeleteCache.pl
As far as I know this is to be used if you change anything manually on the files. If you change somthing via webinterface, the cache is cleared implicitly.