How to alter a Directory's Synchronisation Interval

[Peter Binney]

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

How do I do this, please?

[C_ Faysal · Accepted solution]

yes according to narens post...

open your ldap directory config and check for

[Peter Binney]

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:

[C_ Faysal]

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

[Peter Binney]

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.

[C_ Faysal]

can you run this statement locally on your DB?

select id,directory_name from cwd_directory;

this should list your two directories.

run

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

[C_ Faysal]

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

[Peter Binney]

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).

[Naren]

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!