How to Determine The Order of the Directories for Crowd in the Database?
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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
Summary
To determine the order of the User Directories (external user management) when Crowd admin user cannot login with the correct credentials. This is extremely useful for recovering administrator rights from the Crowd Internal Directory - Restoring Passwords To Recover Admin User Rights via Database with directories reordering.
Solution
Execute the following SQL query against the Crowd database via database client.
1
2
3
4
5
SELECT m.id, m.application_id, a.application_name, m.directory_id, m.allow_all, m.list_index, d.directory_name, d.directory_type
FROM cwd_app_dir_mapping m
JOIN cwd_directory d ON m.directory_id = d.id
JOIN cwd_application a ON m.application_id = a.id
WHERE a.application_type = 'CROWD';ℹ️Recover Administrator Rights: Make sure that the list_index for Crowd Internal Directory is 0 and the remaining directories are in ascending order (1, 2, 3, ...).
Priority |
|
|---|---|
1st |
|
2nd |
|
3rd |
|
Was this helpful?