Hi Pramod, At this time the JDBC destination service supports only single value per key. When several values are provided by the source (here the isMemberOf attribute), then LSC will take the first one.
Sorry, Regards, Sebastien 2015-07-27 9:11 GMT+02:00 Pramod <[email protected]>: > Dear Reader, > > I am using LSC 2.1.3 for synching users from LDAP to PostGreSQL database. > The users in LDAP have one or many roles assigned to them. I need to sync > users from LDAP belonging to only some specific roles. I am able to fetch > the roles of the users using the isMemberOf operational attribute which is > configured in lsc.xml. The problem is while synching only one role is > fetched by the tool in spite of a user belonging to multiple roles. All the > roles for the user is displayed in the log but somehow only the first role > is fetched and put as parameter in the SQL query which I am using to copy > the users to database. > > This is what gets printed in the log: > > isMemberOf: cn=UID_BO,ou=roles,dc=users,dc=in > isMemberOf: cn=SALES_AGENT,ou=roles,dc=users,dc=in > isMemberOf: cn=HOMESIS,ou=roles,dc=users,dc=in > > But only the first one gets picked at the time of synching with database > using SQL query. > > SELECT > usf_insert_user(#employeenumber#,#uid#,#sn#,#givenname#,#cn#,#mail#,#address#,#mobile#,#userpassword#,#isMemberOf#) > > According to the above result, the #isMemberOf# value in the above SQL is > cn=UID_BO,ou=roles,dc=users,dc=in. > I want all the roles to be passed as parameter to SQL which is not > happening currently. > > Need help urgently on this. > > I've attached lsc.xml and InetOrgPerson.xml for your reference. > > Thanks & Regards, > Pramod > > > > _______________________________________________________________ > Ldap Synchronization Connector (LSC) - http://lsc-project.org > > lsc-users mailing list > [email protected] > http://lists.lsc-project.org/listinfo/lsc-users >
_______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-users mailing list [email protected] http://lists.lsc-project.org/listinfo/lsc-users
