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

This widget could not be displayed.

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.

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

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

This widget could not be displayed.

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
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in Teamwork

What teamwork quotes inspire you?

Hey everyone! My name is Natalie and I'm an editor of the Atlassian Blog and I've got a question for you: What's your favorite quote about teamwork?  We've compiled a list here, along with...

141 views 16 7
Join discussion

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