Locked out of JIRA

Looking for some help here, we were in the process of configuring our Active Directory setup and I moved Active Directory up above the internal user directory. Once I clicked to another screen I was locked out of the system and have been ever since.

There is a duplicating user with the same username in the directory in higher position. Currently, JIRA does not support 'shadowed' users. This is a known limitation tracked in JRA-23861 - An admin can lock themselves out of JIRA by changing the order of the User Directories.

The resolution is as follows:

Ask for assistance another administrator and ask them to revert the ordering modification.

Temporally disable the directory in the higher position with help of SQL.

Ensure that you have valid backup of your data that could be used for the restore, if something goes wrong.

The problem is both administrators in the Jira directory are both also users in the Group in AD but cannot login to Jira at all. We are currently using the h2 database and my next step was going to be to migrate the database off to an SQL. I was able to connect to the h2 database but the commands would not work because it was telling me that it was 'read only'.

Any thoughts?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

If the database is teling you it is read only, is JIRA possibly still up? If so, please shut down JIRA, run the SQL recommended by Branden, and start JIRA again.

If you continue to be unable to write to the H2 database, please consider installing a new instance of JIRA, with the SQL database you are moving to, then importing the XML backup from the <jira_home>/export directory of your existing instance. This back-up runs automatically unless it has been disabled on your instance.

I look forward to hearing how it goes.

Thanks,

Ann

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Ann I did a re-install of Jira but need some assistance with the restore. I have the old Atlassian directory (and all folders) along with a backup file but when I put that into the File Name area in the Restore JIRA data from Backup section I get an error.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.