[Solved] How to remove hundreds of users

[stef44]

Bonjour,

I'm doing some LDAP import tests and I would like to reset my user repository.
I can follow this tutorial http://www.alfresco.com/help/34/community/all/tasks/adminconsole-user-delete.html but I have hundred of users …

I know users are created in alf_authority table but I assume this table is linked to another table. So I can't delete all users from this table (foreign key can't be null).

So my question is :
Is there a procedure to reset the user repository ou a sql script to remove all users from share ?

Thanks a lot.

Stephane

[stef44]

Hello,
I've succeeded doing it using http://wiki.alfresco.com/wiki/The_Synchronization_Subsystem. But i can't resynchronize anymore.

In the log, there is no error :

12:37:25,632 User:System INFO  [security.sync.ChainingUserRegistrySynchronizer] Synchronizing users and groups with user registry 'ldap1'
12:37:25,647 User:System INFO  [security.sync.ChainingUserRegistrySynchronizer] Retrieving groups changed since 19 avr. 2011 09:34:06 from user registry 'ldap1'
12:37:25,694 User:System INFO  [security.sync.ChainingUserRegistrySynchronizer] ldap1 Group Analysis: Commencing batch of 0 entries
12:37:25,710 User:System INFO  [security.sync.ChainingUserRegistrySynchronizer] ldap1 Group Analysis: Completed batch of 0 entries
12:37:25,710 User:System INFO  [security.sync.ChainingUserRegistrySynchronizer] Retrieving users changed since 19 avr. 2011 11:31:48 from user registry 'ldap1'
12:37:25,741 User:System INFO  [security.sync.ChainingUserRegistrySynchronizer] ldap1 User Creation and Association: Commencing batch of 0 entries
12:37:25,741 User:System INFO  [security.sync.ChainingUserRegistrySynchronizer] ldap1 User Creation and Association: Completed batch of 0 entries
12:37:25,881 User:System INFO  [security.sync.ChainingUserRegistrySynchronizer] Finished synchronizing users and groups with user registry 'ldap1'
12:37:25,881 User:System INFO  [security.sync.ChainingUserRegistrySynchronizer] 0 user(s) and 0 group(s) processed
‍‍‍‍‍‍‍‍‍‍

The system keeps in mind the last synchronization time and date and no user is loaded.

Stephane

[stef44]

Hello,

Some good news.
I think I've misundestood the way the Differential With Deletions Synchronization Mode works.
During my tests, I was changing the query to load differents kinds of users (all users or users with a king of accountControl, …).
So, I thought Alfresco loaded "new" users even if their modifyTimestamp attribute was older than the last synchronization. But Alfresco compares the timestamp first.

So, for my tests, I think I have to use the full synchronization mode.

Regards.

Stephane