Unable to login JIRA after Restoring from Backup

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.

Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Except Fisheye and Crucible

Problem

After restoring JIRA into a new instance user is unable to login

The following appears in the atlassian-jira.log

2015-09-30 23:11:58,628 http-bio-8617-exec-20 ERROR anonymous 1389x36x1 - 127.0.0.1 /rest/gadget/1.0/login [crowd.manager.application.ApplicationServiceGeneric] Directory 'Delegated LDAP Authentication in BASF' is not functional during authentication of 'XXXXXX'. Skipped.

Cause

The JIRA Internal Directory's order is not configured as the first or on top. Therefore , JIRA is looking for the user from the external directory

Resolution

Manually manipulate the database to re-order JIRA internal directory to be on top by running this SQL Queries :

  1. Run this query to check the correct Directory IDs

    select id,directory_name,directory_position from cwd_directory;
  2. If the JIRA Internal Directory's id is 1 ( default ) , run this query to change the directory_position to 0 ( first )

    update cwd_directory set directory_position=0 where id=1
  3. Check to see if there are any other directories using the directory_position=0

    select id,directory_name,directory_position from cwd_directory where directory_position=0;
  4. If there are, any other ID besides the JIRA Internal Directory having the directory_position= 0, then update it to another number using step 2 but replacing id=1 with the appropriate id.


Managing 500+ users across Atlassian products?
Find out how easy, scalable and effective it can be with Crowd!
See centralized user management.
Last modified on Jan 14, 2019

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.