How to change the preferred order of User Directores in Bamboo Data Center via the database

Summary

When migrating Bamboo from one environment to another it may sometimes be necessary to change the preferred order of user directories directly via the database.

Environment

The solution has been validated in Bamboo 8.1 but may be applicable to other versions.

Solution

Considerations

• The directory preference is specified in the list_index column of the cwd_app_dir_mapping table in the Bamboo directory.

• The database uses a numerical value to indicate preference with the lower numbers (starting at 0) being the higher preference. 

• The cwd_app_dir_mapping table uses the directory_id as the primary key to identify the directories. 

• You can associate the directory_id  to a directory name by getting the directory_id and directory_name columns from the cwd_directory table.

• Once you have the directory_id  values you can update the list_index for those directories, making the new primary's list_index value 0, and adjusting the values of other directories accordingly.

Step-by-step

1. Run this SQL query to list directory IDs and names:

   1 SELECT id, directory_name FROM cwd_directory;

2. Identify the ID of the new primary directory ($newPrimary).

3. Run this query to set it as primary, replacing $newPrimary with the ID of the directory: 

   1 UPDATE cwd_app_dir_mapping SET list_index = 0 WHERE directory_id = $newPrimary;

4. Identify the ID of the old primary directory that will now be the secondary directory ($newSecondary).

5. Run this query to set it as secondary, replacing $newSecondary with the ID of the directory: 

   1 UPDATE cwd_app_dir_mapping SET list_index = 1 WHERE directory_id = $newSecondary;

6. Run this query to confirm the changes: 

   1 SELECT * FROM cwd_app_dir_mapping;

7. Commit the changes.

This process updates the directory priorities in your Bamboo setup. Upon restarting the app, they should take effect for login.