no admin user

Moderator: crythias

Locked
brandocomando
Znuny newbie
Posts: 10
Joined: 13 Apr 2013, 00:09
Znuny Version: 3.2.5-01.noarch

no admin user

Post by brandocomando »

Hey all,
I have my otrs using Ldap authentication, but I can no longer log in as root@localhost, and therefor do not have any admin users.

I know I can take off the ldap go in and add a root user, but I was wondering if there was an easier way to do it.

I was attempting to give a user admin rights by editing the mysql database, but editing the group_user table doesnt seem to do that trick and I cant find where else it would store that info. has anyone tried this?

-Brandon
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: no admin user

Post by crythias »

Show your config.pm?
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
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: no admin user

Post by jojo »

switch off LDAP, login as root@localhost, assign another user to admin permissions, log out, switch on LDAP
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
brandocomando
Znuny newbie
Posts: 10
Joined: 13 Apr 2013, 00:09
Znuny Version: 3.2.5-01.noarch

Re: no admin user

Post by brandocomando »

jojo wrote:switch off LDAP, login as root@localhost, assign another user to admin permissions, log out, switch on LDAP
right, that works. but my goal is to be able to do this all in one pass with the command line.

I think I did it once using changes done to the mysql database, but it cached the old permissions for a really long time, trying again from scratch with this today and am going to see if it eventually updates.
brandocomando
Znuny newbie
Posts: 10
Joined: 13 Apr 2013, 00:09
Znuny Version: 3.2.5-01.noarch

Re: no admin user

Post by brandocomando »

yep after 6+ hours my user gained admin rights after making changes to the group_user table.

anyone know a way to speed this up? tried restarting httpd, mysql, otrs, rebooting and clearing browser cache.

it seems to be caching somewhere
brandocomando
Znuny newbie
Posts: 10
Joined: 13 Apr 2013, 00:09
Znuny Version: 3.2.5-01.noarch

Re: no admin user

Post by brandocomando »

nevermind I was making it much more compicated than it needed to be. i found the AddUser2Group.pl
Locked