Need to change authentication order via SQL commands

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

2 answers

0 votes
Ann Worley Atlassian Team Jun 02, 2017

The table you want is cwd_directory. 

Start with 

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.

Yes this worked for me.  Now the search order is Jira Internal Directory first, the Active Directory.

 

This worked for me and I am able to get into my Jira again.  Thanks.

0 votes

Have a look at https://confluence.atlassian.com/jira/retrieving-the-jira-administrator-192836.html

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.

Thanks Nic.  This was resolved by changing the authentication order above - but your link to manually create a local admin user would have been my backup plan.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Apr 22, 2018 in Jira Software

How-to setup a secured Jira Software 7.9.0 on Ubuntu 16.04.4 in less than 30 minutes

...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...

2,084 views 14 13
Read article

Atlassian User Groups

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!

Find my local user group

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

Groups near you