How to change the preferred order of User Directores in Bamboo Data Center via the database
プラットフォームについて: Data Center - この記事は、Data Center プラットフォームのアトラシアン製品に適用されます。
このナレッジベース記事は製品の Data Center バージョン用に作成されています。Data Center 固有ではない機能の Data Center ナレッジベースは、製品のサーバー バージョンでも動作する可能性はありますが、テストは行われていません。サーバー*製品のサポートは 2024 年 2 月 15 日に終了しました。サーバー製品を利用している場合は、アトラシアンのサーバー製品のサポート終了のお知らせページにて移行オプションをご確認ください。
*Fisheye および Crucible は除く
要約
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.
環境
The solution has been validated in Bamboo 8.1 but may be applicable to other versions.
ソリューション
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.
- Before taking any action on the database you'll want to be sure to create a backup of your Bamboo environment.
- Be sure that no value for the list_index column is duplicated to prevent directory conflicts.
- You will need to stop Bamboo prior to making any modification to the database, and restart Bamboo once the changes are complete.
Step-by-step
Run this SQL query to list directory IDs and names:
SELECT id, directory_name FROM cwd_directory;- Identify the ID of the new primary directory (
$newPrimary). Run this query to set it as primary, replacing
$newPrimarywith the ID of the directory:UPDATE cwd_app_dir_mapping SET list_index = 0 WHERE directory_id = $newPrimary;Identify the ID of the old primary directory that will now be the secondary directory (
$newSecondary).Run this query to set it as secondary, replacing
$newSecondarywith the ID of the directory:UPDATE cwd_app_dir_mapping SET list_index = 1 WHERE directory_id = $newSecondary;Run this query to confirm the changes:
SELECT * FROM cwd_app_dir_mapping;- 変更をコミットする。
This process updates the directory priorities in your Bamboo setup. Upon restarting the app, they should take effect for login.