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 Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

857 views 5 18
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot