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 knowlege base article titled Administrator Cannot Login After Reordering User Directories.
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:
List all currently defined directories:
select id, directory_name, active from cwd_directory; ID DIRECTORY_NAME ACTIVE ----- ----------------------- ------ 10102 AD win2k8 1 1 JIRA Internal Directory 1 10106 Active Directory server 1 3 row(s) in 0 ms
Disable the conflicting directory. In our example we will disable directory with ID 10102:
update cwd_directory set active=0 where id=10102
Hopefully that helps.
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'.
Branden is not available now but I would like to help. Are you using the instructions Accessing JIRA's H2 embedded database?
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.
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot