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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs