How to stop the user directory synchronization forcefully?

Question

* My confluence is tied to AD and my full synchronization runs in an infinite loop.

* I've disabled the user directory and restarted the node, but it is still running the synchronization.

sudarshana ramesh jayawardana amadoru · Answer

* Also, you can do it from the database end by disabling the "Incremental Synchronization".

* This involves updating the "cwd_directory_attribute" table to set "crowd.sync.incremental.enabled" to false for the directory you wish to disable incremental syncs.
Also, ensure to back up your database before making these changes.

Here's the SQL command for that:

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');

* Once you update the database, restart Confluence and trigger another synchronization through Confluence Admin -> General configuration -> User directories -> Your directory -> Synchronize.

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

Humashankar VJ · Answer

That's a great try - It's a learning for me as well - Thanks for sharing !!

sudarshana ramesh jayawardana amadoru · Answer

Hi @Humashankar VJ

unfortunately, I don't have the control of AD side. So the only way to stop from Confluence end.

Somehow I figured out a way to stop the process from the UI level by modifying the 'Schema Settings' in the Confluence Admin > User Directories section. Enter dummy values for 'Additional User DN' and 'Additional Group DN' to prevent Confluence from successfully syncing with the LDAP directory on startup.

Source: https://jira.atlassian.com/browse/CONFSERVER-22326