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
no admin user
Moderator: crythias
-
- Znuny newbie
- Posts: 10
- Joined: 13 Apr 2013, 00:09
- Znuny Version: 3.2.5-01.noarch
-
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: no admin user
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
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
Re: no admin user
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny newbie
- Posts: 10
- Joined: 13 Apr 2013, 00:09
- Znuny Version: 3.2.5-01.noarch
Re: no admin user
right, that works. but my goal is to be able to do this all in one pass with the command line.jojo wrote:switch off LDAP, login as root@localhost, assign another user to admin permissions, log out, switch on LDAP
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.
-
- Znuny newbie
- Posts: 10
- Joined: 13 Apr 2013, 00:09
- Znuny Version: 3.2.5-01.noarch
Re: no admin user
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
anyone know a way to speed this up? tried restarting httpd, mysql, otrs, rebooting and clearing browser cache.
it seems to be caching somewhere
-
- Znuny newbie
- Posts: 10
- Joined: 13 Apr 2013, 00:09
- Znuny Version: 3.2.5-01.noarch
Re: no admin user
nevermind I was making it much more compicated than it needed to be. i found the AddUser2Group.pl