How to alter a Directory's Synchronisation Interval

I have an LDAP directory created and want to alter its Synchronisation Interval.

How do I do this, please?

2 answers

1 accepted

0 votes
Accepted answer

yes according to narens post...

open your ldap directory config and check for

Thanks - but the Directory is the only one used for authentication (we use Digital Certificates), so my problem is that I can't get to that screen:

oh i see...can you log in as admin from internal directory?

No. I can only login via the LDAP. I am an administrator.

OK its an odd situation, but it's a real nuisance.

I could stop the instance and reconfigure it to non-LDAP authentication (when it would use the Internal Directory) but that's a pain.

I guess this is just another weakness with Confluence's new (to us) directory model.

can you run this statement locally on your DB?

select id,directory_name from cwd_directory;

this should list your two directories.


select attribute_value from cwd_directory_attribute where directory_id = '<ID_from_your_LDAP_dir>' AND attribute_name = 'directory.cache.synchronise.interval';

this should show "60"

you could run an update query but please shut down confluence before and make a backup so just in case something breaks you can get back to the previous state

let me know if you need help building the query...

if you only got these two directories you could run this:

update cwd_directory_attribute set attribute_value="<new_value_here>" where directory_id = (select id from cwd_directory where directory_type NOT LIKE 'INTERNAL') AND attribute_name="directory.cache.synchronise.interval";

check if everything is ok:

select * from cwd_directory_attribute where directory_id = (select id from cwd_directory where directory_type NOT LIKE 'INTERNAL');

start confluence

Yes, the update works - many thanks.

Note: the values in the table are in seconds not minutes (as used in the UI).

I had set the interval to 240 minutes on installation which showed as 14400
So I updated in the table back to 3600 (1 hour).

The default synchronisation interval set is 60 minutes. You may be able to change this default interval under the User Directories configuration screen.

Hope it helps!

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Thursday in Agile

How Scrum works? It starts with training and education

To answer “How scrum works,” most of the teams I've worked with first addressed the question: “where to start?”  That question applies to both implementation and improvements on the Scrum framew...

220 views 3 7
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you