AnsweredAssumed Answered

Timezone issue with LDAP Differential Sync

Question asked by warren.mcdonald on Nov 11, 2010
Latest reply on Mar 12, 2013 by bopolissimus
Hello everyone,

we have uncovered an interesting problem with LDAP Sync in Differential mode.

In a nutshell, our Alfresco application sees the last Sync datetime in local time but the LDAP server modifyTimestamp value is always in UTC, which is pretty standard.

This may not be so much of a problem for sites west of UK to the Cook Islands but for those in front of UTC by 10 hours it poses an interesting challenge. This especially frustrating when trying to do frequently scheduled sync runs. Nothing is returned from the LDAP server as the timestamp sent in the query is always later than the UTC timestamps. 

I am not a Java environment expert, but it seems we would have to either set the whole server to be running on UTC or somehow set the timezone in JVM to accommodate the timezone offset. Either way would likely change all logging output and cron jobs in alfresco to be in UTC. Which we don't want either 

I have searched extensively for similar problems but found no relevant solutions. Hopefully I am just missing something very basic and will be happy to be enlightened. 

Thanks in advance