目的

You might want to disable incremental synchronization in Confluence for an external directory. Sometimes having the Crowd SSO authenticator enabled or not having an internal administrator in place can complicate things, so this can be done through the database.

ソリューション

• Shutdown Confluence and backup your database before making any of these changes.

• Run the following to find the name of the external directory for which you want to disable incremental syncs:

  SELECT directory_name 
  FROM cwd_directory
  WHERE directory_type != 'INTERNAL'

• データベースの変更を行う場合は必ず事前にバックアップを取得してください。可能な場合は、まずステージング サーバーで SQL コマンドの変更、挿入、更新、または削除を行うようにします。

• Run the following to disable the incremental synchronization:

  update cwd_directory_attribute 
  set attribute_value = 'false'
  where attribute_name = 'crowd.sync.incremental.enabled' 
  and directory_id = (select id 
  			from cwd_directory
  			where directory_name = 'YOUR_DIRECTORY_NAME'); 

• Confluence を再起動します。

• Trigger another synchronization through Confluence Admin -> General configuration -> User directories -> Your directory -> Synchronize