2015-01-19 10:19 GMT+01:00 <[email protected]>: > > Hi Clement, > > > > I have done as per your suggestion but still it gives below error. > > > > Jan 19 14:46:12 - INFO - Starting sync for adGroup > > Jan 19 14:46:13 - ERROR - Error while adding entry > cn=demogrp1,dc=testrjil,dc=net in directory > :javax.naming.NameAlreadyBoundException: [LDAP: error code 68 - 00000526: > UpdErr: DSID-031A119B, problem 6005 (ENTRY_EXISTS), data 0 > > ]; remaining name 'cn=demogrp1' > > Jan 19 14:46:13 - ERROR - Error while synchronizing ID > cn=demogrp1,dc=testrjil,dc=net: java.lang.Exception: Technical problem > while applying modifications to the destination > > # Mon Jan 19 14:46:13 IST 2015 > > dn: cn=demogrp1,dc=testrjil,dc=net > > changetype: add > > sAMAccountName: demotestgrp1 > > objectClass: group > > objectClass: top > > > > Jan 19 14:46:13 - ERROR - Error while adding entry > cn=sqlgrp,dc=testrjil,dc=net in directory > :javax.naming.NameAlreadyBoundException: [LDAP: error code 68 - 00000526: > UpdErr: DSID-031A119B, problem 6005 (ENTRY_EXISTS), data 0 > > ]; remaining name 'cn=sqlgrp' > > Jan 19 14:46:13 - ERROR - Error while synchronizing ID > cn=sqlgrp,dc=testrjil,dc=net: java.lang.Exception: Technical problem while > applying modifications to the destination > > # Mon Jan 19 14:46:13 IST 2015 > > dn: cn=sqlgrp,dc=testrjil,dc=net > > changetype: add > > sAMAccountName: sqltestgrp > > objectClass: group > > objectClass: top > > > > Jan 19 14:46:13 - ERROR - All entries: 2, to modify entries: 2, > successfully modified entries: 0, errors: 2 > > Jan 19 14:46:13 - INFO - Starting clean for adGroup > > Jan 19 14:46:13 - ERROR - Empty or non existant destination (no IDs found) > > > > > > [root@hardik-test-vm lsc]# vim sql-map-config.d/InetOrgPerson.xml > > <?xml version="1.0" encoding="UTF-8" standalone="no"?> > > <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" " > http://www.ibatis.com/dtd/sql-map-2.dtd";> > > > > <sqlMap namespace="InetOrgPerson"> > > > > <select id="getInetOrgPerson" resultClass="java.util.HashMap" > parameterClass="java.util.Map"> > > Select > > groupname,samaccountname > > FROM group_info > > WHERE groupname LIKE #groupname# > > > > </select> > > > > <select id="getInetOrgPersonClean" resultClass="java.util.HashMap" > parameterClass="java.util.Map"> > > Select > > groupname > > FROM group_info > > WHERE groupname LIKE #cn# > > </select> > > > > And lsc is having below configuration. > > > > <databaseSourceService> > > <name>databaseConnectionService</name> > > <connection reference="mySQL" /> > > <requestNameForList>getInetOrgPersonList</requestNameForList> > > <requestNameForObject>getInetOrgPerson</requestNameForObject> > > <requestNameForClean>getInetOrgPersonClean</requestNameForClean> > > </databaseSourceService> > > <ldapDestinationService> > > <name>testad-dst-service</name> > > <connection reference="testAD" /> > > <baseDn>dc=testrjil,dc=net</baseDn> > > <pivotAttributes> > > <string>cn</string> > > </pivotAttributes> > > <fetchedAttributes> > > <string>cn</string> > > <string>sAMAccountName</string> > > <string>objectClass</string> > > </fetchedAttributes> > > > <getAllFilter><![CDATA[(objectClass=inetOrgPerson)]]></getAllFilter> > > > <getOneFilter><![CDATA[(&(objectClass=inetOrgPerson)(cn={cn}))]]></getOneFilter> > > </ldapDestinationService> > > <propertiesBasedSyncOptions> > > <mainIdentifier>"cn=" + > srcBean.getDatasetFirstValueById("groupname") + > ",dc=testrjil,dc=net"</mainIdentifier> > > <defaultDelimiter>;</defaultDelimiter> > > <defaultPolicy>FORCE</defaultPolicy> > > > > Your help will be really appreciated. > >
You use the inetOrgPerson class in your LDAP filters, but you create "group" object, so they are not found by the filters. Replace inetOrgPerson byt group in getAllFilter and getOneFilter. Clément.
_______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-users mailing list [email protected] http://lists.lsc-project.org/listinfo/lsc-users
