Admin area is not showing

[Ravikummary]

Urgent!!!!

I was tweeking OTRS a bit and suddenly i realize that Admin area is not showing, though i am logged in with the root login.

Please advise.

[Ravikummary]

I realize now that i have removed root user from the Admin filed...!!! can you please tell me how to get it back!!

[crythias]

Need more information. You removed the root user from what, specifically?

[Ravikummary]

In Admin area -> users <->groups, i clicked on the user (root@localhost (Admin OTRS)) then unchecked all the fileds, after which i could not see the Admin icon again!!

Plz let me know if you require more info.

[crythias]

And I'm assuming you have no other admin login person?


The groupid of admin is 2
The userid of root@localhost is 1

in mysql or phpmyadmin

Code: Select all

UPDATE  `otrs`.`group_user` SET  `permission_key` =  'rw' WHERE  `group_user`.`user_id` =1 AND  `group_user`.`group_id` =2 LIMIT 1;

strong disclaimer applies: using mysql to update tables and records outside of the interface of OTRS is not recommended and can result in data loss, hair loss, and sleepless nights. Don't go changing things without a backup and understanding what you're doing.

[crythias]

also, this is why you should not be using root@localhost to do anything.

[Ravikummary]

Yeah, got it back!!

Thanks alot crythias

[MagellanX]

Hello,

I know, this thread is not the newest, but while testing some stuff in our lab on OTRS it happened that the administrative rights for our root user are missing now.

I tried to restore the rights in mysql using the SQL code mentioned before, but after clicking enter I always get the reply

"Rows matched: 1 - Changed: 0 - Warnings:0"

I used the following:

UPDATE `otrs`.`group_user` SET `permission_key` = 'rw' WHERE `group_user`.`user_id` =1 AND `group_user`.`group_id` =2 LIMIT 1;

Has anyone an idea what went wrong?
I'm still missing the admin Tab with my root account.

[crythias]

If you can manipulate it directly with MySQL workbench or PHPMyAdmin, try that.

[sgiganti]

I'm sorry if I'm answering to an old thread (this is the first result after googling my issue).

I'm working with the latest version of OTRS.
My root lost admin permissions and I've tried to update the record, but nothing changed

How can I fix this?
Thank you in advance.

Sergio

[sgiganti]

I'm sorry (again), but I just found my answer.

viewtopic.php?f=62&t=36276

Thank you!