How to recreate the Confluence Internal User Directories
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
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.
*Fisheye および Crucible は除く
目的
In case the internal user directories is accidently deleted, you can follow the steps below to recreate the internal user directory.
ソリューション
データベースの変更を行う場合は必ず事前にバックアップを取得してください。可能な場合は、まずステージング サーバーで SQL コマンドの変更、挿入、更新、または削除を行うようにします。
Here's the list of steps that you will need to take to recreate the internal directory and user in Confluence:
- Remember to backup your Confluence database dump before running any of the queries below.
- Confluence を終了します。
Run these queries to recreate the directory:
INSERT INTO cwd_directory (id,directory_name,lower_directory_name,created_date,updated_date,active,description,impl_class,lower_impl_class,directory_type) VALUES (327681,'Confluence Internal Directory','confluence internal directory','2015-02-08 15:02:53','2015-02-08 15:02:53','T','Confluence default internal directory','com.atlassian.crowd.directory.InternalDirectory','com.atlassian.crowd.directory.internaldirectory','INTERNAL'); INSERT INTO cwd_directory_operation (directory_id,operation_type) VALUES (327681,'CREATE_GROUP'), (327681,'CREATE_ROLE'), (327681,'CREATE_USER'), (327681,'DELETE_GROUP'), (327681,'DELETE_ROLE'), (327681,'DELETE_USER'), (327681,'UPDATE_GROUP'), (327681,'UPDATE_GROUP_ATTRIBUTE'), (327681,'UPDATE_ROLE'), (327681,'UPDATE_ROLE_ATTRIBUTE'), (327681,'UPDATE_USER'), (327681,'UPDATE_USER_ATTRIBUTE'); INSERT INTO cwd_directory_attribute (directory_id,attribute_value,attribute_name) VALUES (327681,'atlassian-security','user_encryption_method'); INSERT INTO cwd_app_dir_mapping (id,application_id,directory_id,allow_all,list_index) VALUES (360449,294913,327681,'T',0); INSERT INTO cwd_app_dir_operation (app_dir_mapping_id,operation_type) VALUES (360449,'CREATE_GROUP'), (360449,'CREATE_ROLE'), (360449,'CREATE_USER'), (360449,'DELETE_GROUP'), (360449,'DELETE_ROLE'), (360449,'DELETE_USER'), (360449,'UPDATE_GROUP'), (360449,'UPDATE_GROUP_ATTRIBUTE'), (360449,'UPDATE_ROLE'), (360449,'UPDATE_ROLE_ATTRIBUTE'), (360449,'UPDATE_USER'), (360449,'UPDATE_USER_ATTRIBUTE');Follow this documentation to Restore Passwords To Recover Admin User Right to recreate the administrator user.