topic Re: Sync deletes existing users in Alfresco Archive

Sync deletes existing users

jriker1 — Tue, 15 Jun 2010 13:51:14 GMT

What do I need to do since moving to 3.3g from 3.2 to get sync to stop deleting and recreating the accounts the first time it runs? I have to keep restoring my DB each test I do as it deletes everyone and adds them again. Below is an example:13:35:00,154 Userystem INFO [security.sync.ChainingUs

Re: Sync deletes existing users

mikeh — Tue, 15 Jun 2010 13:57:13 GMT

Please see http://forums.alfresco.com/en/viewtopic.php?f=9&t=20864&p=68422#p68422

Thanks,
Mike

Re: Sync deletes existing users

jriker1 — Tue, 15 Jun 2010 14:19:58 GMT

Please see http://forums.alfresco.com/en/viewtopic.php?f=9&t=20864&p=68422#p68422

Thanks,
Mike

Thanks Mike. So what am I missing? Looks like this was just "fixed" in a prior build. All my users are wiped and their associations to rooms gone. That talked about rezoning people that already existed so would tell me that they would not physically be deleted.

Thanks.

JR

Re: Sync deletes existing users

mikeh — Tue, 15 Jun 2010 14:44:26 GMT

I think the fix would have only made it to 3.2r so that might be your issue here.

Thanks,
Mike

Re: Sync deletes existing users

jriker1 — Tue, 15 Jun 2010 14:49:54 GMT

I think the fix would have only made it to 3.2r so that might be your issue here.

Thanks,
Mike

Soooo. You are saying that fixes implemented into the system would be somehow abandoned or branched from earlier builds to create 3.3 and the fix wasn't brought over? Thought the fix was specifically for 3.2 people trying to go to 3.3. Not sure about g but still. If that's the odd case, anyway to identify what was done to fix this previously?

Or perhaps find out what rev in SVN Alfresco 3.2 build 79 is where it was originally implemented and try and find what it did different.

Or get David Ward into this who seemed to code that fix in the first place.

Note that if this fix ever did work, the sync code is heavily changed since the jira reference says and the user zoning info still seems to be in there.

Is there perhaps something I can define in the database directly to make the system accept the existing users and not delete them?

Also looks like most of the custom code installed to fix the problem before does exist in the current build with some changes to support groups where the original fix looked to only maintain old users. So issue still outstanding I guess.

JR

Re: Sync deletes existing users

jriker1 — Fri, 18 Jun 2010 16:56:45 GMT

So any ideas what's actually going on here or what needs to be done? Sounds like for now 3.3 and 3.3g were meant for fresh installs only currently as no one is going to tollerate having bunches of users deleted and readded.

Thanks.

JR

Re: Sync deletes existing users

dward — Wed, 30 Jun 2010 11:30:31 GMT

We meet again jriker!

I'm afraid what we are seeing is due to the knock on effect of the fix to https://issues.alfresco.com/jira/browse/ETHREEOH-4008, where Alfresco started correctly honouring the case of UIDs returned by the LDAP server instead of lower casing them, and a new regression concerning user name case sensitivity. Despite LDAP sync trying to update the UIDs to match the case they occur in the LDAP server, this is blocked by the PersonService and what actually happens is that it ends up deleting all the original users!

See bug https://issues.alfresco.com/jira/browse/ALF-3604

We hope we now have a full understanding of the issue and have created new unit tests to ensure this will not be a problem in the future. I have attached a source patch for HEAD revision 20754 to the issue and will promptly merge it in to HEAD and the next Enterprise service pack.