On my Jira Test system I have just added the LDAP authentication connectivity. I then changed the order of authentication to look at LDAP first. Problem is I just locked myself out and I don't know of a local admin ID I can use (the original installers did not keep that info around).
Rather than re-installing the software over again I want to go into the SQL db and change the authentication order to where JIRA Internal Directory is first, then restart Jira.
What SQL commands can I use to do this?
I am using Jira v7.1.9
The table you want is cwd_directory.
select * from cwd_directory;
Note the id column for the LDAP and JIRA Internal directories (check the directory_name column)
The id for LDAP is probably 0, set it to a temporary value, like 2, to free up 0 for your Internal Directory:
update cwd_directory set directory_position = 2 where id = <LDAP id from previous query>;
Then use a similar update statement to change the Internal directory position to 0. Afterward, change the temporary 2 to 1 so the directory_position column is 0 and 1.
A lot of it is about changing passwords and groups etc, but there's also instructions on changing the order and enabling different directories in there.
...PermissionsStartOnly=true User=www-data Group=www-data ExecStart=/opt/jira/bin/startup.sh ExecStop=/opt/jira/bin/shutdown.sh TimeoutStartSec=120 TimeoutStopSec=600 PrivateTmp=true [Install] WantedBy...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG