2015-01-23 12:28 GMT+01:00 Mark Howells <[email protected]>: > I'm sure I'm just being a bit dim here, but I have a list of users in > a mysql DB that I need to synchronise into a single LDAP group. ( > cn=mygroup ) > > I'm confused about the SQL queries I need to construct for List, > Object and Clean in this scenario. I'd assumed that I could just > return a column of names, use script to transform that to a comma > seperated list and set the member attribute of cn=mygroup to that > value. But what would each of the queries be expected to return. It > seems to me like all of the would need to return the same thing (a > column of names) but when I try that lsc (quite correctly) complains > that the getObject call returns thousands of entries rather than one. > > I have managed to achieve what I want by repeatedly adding a a single > member attribute, but it feels very inefficient to do so when the > attribute could be populated with a single call to the DB >
Hi Mark, don't know if we can do that with the database source service. Maybe you should try to use the executable plugin: http://lsc-project.org/wiki/documentation/plugins/executable Clément. _______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-users mailing list [email protected] http://lists.lsc-project.org/listinfo/lsc-users
