Admin area is not showing
Moderator: crythias
-
- Znuny newbie
- Posts: 17
- Joined: 16 Feb 2011, 12:17
- Znuny Version: 2.4
- Real Name: Ravi
- Company: Patni Telecom Systems
- Location: Hyderabad, India
- Contact:
Admin area is not showing
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.
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.
Many Thanks,
Ravi
Ravi
-
- Znuny newbie
- Posts: 17
- Joined: 16 Feb 2011, 12:17
- Znuny Version: 2.4
- Real Name: Ravi
- Company: Patni Telecom Systems
- Location: Hyderabad, India
- Contact:
Re: Admin area is not showing
I realize now that i have removed root user from the Admin filed...!!! can you please tell me how to get it back!!
Many Thanks,
Ravi
Ravi
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Admin area is not showing
Need more information. You removed the root user from what, specifically?
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
- Znuny newbie
- Posts: 17
- Joined: 16 Feb 2011, 12:17
- Znuny Version: 2.4
- Real Name: Ravi
- Company: Patni Telecom Systems
- Location: Hyderabad, India
- Contact:
Re: Admin area is not showing
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.
Plz let me know if you require more info.
Many Thanks,
Ravi
Ravi
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Admin area is not showing
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
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.
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;
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Admin area is not showing
also, this is why you should not be using root@localhost to do anything.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
- Znuny newbie
- Posts: 17
- Joined: 16 Feb 2011, 12:17
- Znuny Version: 2.4
- Real Name: Ravi
- Company: Patni Telecom Systems
- Location: Hyderabad, India
- Contact:
-
- Znuny newbie
- Posts: 3
- Joined: 20 Mar 2012, 13:07
- Znuny Version: 30101
- Real Name: Sven
- Location: Remseck, Germany
Re: Admin area is not showing
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.
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.
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Admin area is not showing
If you can manipulate it directly with MySQL workbench or PHPMyAdmin, try that.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
- Znuny newbie
- Posts: 4
- Joined: 14 Dec 2017, 12:16
- Znuny Version: 6PatchLvl2
- Real Name: Sergio Giganti
Re: Admin area is not showing
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
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