nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need to change authentication order via SQL commands

Christopher Reitci

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

Accepted answers

AnnWorley

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.

All comments

AnnWorley

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.

Nic Brough -Adaptavist-

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.

David Martin_z57k1k

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

Christopher Reitci

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

Christopher Reitci

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-software