How to disable incremental synchronization for an external directory through the database


アトラシアン コミュニティをご利用ください。


The content on this page relates to direct database modifications which are not supported. Consequently, Atlassian Support cannot guarantee providing any support for it. Please be aware that this material is provided for your information only and using it is done so at your own risk. See our page on configuring user directories for reference on how to configure this through the UI.


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


最終更新日 2018 年 11 月 2 日


Powered by Confluence and Scroll Viewport.