Le 17/05/2017 à 21:13, Billy Baker a écrit :
Hi LSC Users,
Hello Billy
Our organization keeps all personnel information in a database. The LDAP directory is a copy of that information. We have used custom scripts to manage the synchronization before, but now we wish to use LSC to help us manage this. I have configured LSC to import our user objects. But I am having a hard time trying to getting LSC to use a SQL Qry as the members list for the LDAP Destination. Using the Sample SQL Map InetOrgPerson.xml for the user import. ... For Synchronous run, the above configuration works somewhat. But it only adds users, it tries to add all users, even though they are in the group already, with the same DN. I think the getOneFilter is for this purpose of checking, or I'm missing something. If the username is in the member list, then it should not try to add the member attribute to the group. Could you please clarify if I am using LSC correctly in this purpose? I feel I'm missing something. We have one dozen or so groups that we need to update in this manner on a regular basis, and would like only to make changes to the groupOfNames object if necessary. My next question is Asynchronous mode, and I suppose it applies to the User objects as well. How do I write a query for <requestNameForClean> to return the name of the next member? I would like LSC to fetch the userlist and compare that list itself, having to provide a FILO List script seperate of LSC seems redundant for what I'm working with.
First of all, LSC is made to sync same kind of objects between source and destination, for example users to users, groups to groups. It's quite difficult to sync users to groups as LSC work with a pivot attribute that is used to match entries in source and destination.
See https://lsc-project.org/documentation/latest/basics for some explanation on this
In your case, you need to create a SQL query that will return groups with a member list. LSC will the convert them trough datasets in LDAP groups.
-- Clément OUDOT Consultant en logiciels libres, Expert infrastructure et sécurité Savoir-faire Linux 137 boulevard de Magenta - 75010 PARIS Blog: http://sflx.ca/coudot _______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-users mailing list [email protected] https://lists.lsc-project.org/cgi-bin/mailman/listinfo/lsc-users
