Hi,
I am trying trying but unable to resolve the multiple records sync from mysql
to AD. Errors are as below:
Jan 16 17:43:50 - INFO - Starting sync for adGroup
Jan 16 17:43:50 - WARN - Error while looking for a specific entry with
id=demogrp1 (com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in
file://localhost/etc/lsc/sql-map-config.d/InetOrgPerson.xml.
--- The error occurred while applying a parameter map.
--- Check the getInetOrgPerson-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have
an error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near '"GROUPNAME" LIKE 'demogrp1''
at line 1)
Jan 16 17:43:50 - ERROR - Error while synchronizing ID {groupname=demogrp1}:
org.lsc.exception.LscServiceException: javax.naming.CommunicationException:
--- The error occurred in
file://localhost/etc/lsc/sql-map-config.d/InetOrgPerson.xml.
--- The error occurred while applying a parameter map.
--- Check the getInetOrgPerson-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have
an error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near '"GROUPNAME" LIKE 'demogrp1''
at line 1
Jan 16 17:43:50 - WARN - Error while looking for a specific entry with
id=sqlgrp (com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in
file://localhost/etc/lsc/sql-map-config.d/InetOrgPerson.xml.
--- The error occurred while applying a parameter map.
--- Check the getInetOrgPerson-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have
an error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near '"GROUPNAME" LIKE 'sqlgrp'' at
line 1)
Jan 16 17:43:50 - ERROR - Error while synchronizing ID {groupname=sqlgrp}:
org.lsc.exception.LscServiceException: javax.naming.CommunicationException:
--- The error occurred in
file://localhost/etc/lsc/sql-map-config.d/InetOrgPerson.xml.
--- The error occurred while applying a parameter map.
--- Check the getInetOrgPerson-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have
an error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near '"GROUPNAME" LIKE 'sqlgrp'' at
line 1
Jan 16 17:43:50 - ERROR - All entries: 2, to modify entries: 0, successfully
modified entries: 0, errors: 2
Jan 16 17:43:50 - INFO - Starting clean for adGroup
Jan 16 17:43:50 - ERROR - Empty or non existant destination (no IDs found)
cat 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 pers
WHERE pers."GROUPNAME" LIKE #groupname#
</select>
<select id="getInetOrgPersonClean" resultClass="java.util.HashMap"
parameterClass="java.util.Map">
Select
pers."GROUPNAME" AS groupname
FROM group_info pers
WHERE pers."GROUPNAME" LIKE #groupname#
</select>
<select id="getInetOrgPersonList" resultClass="java.util.HashMap">
SELECT groupname
FROM group_info
</select>
</sqlMap>
And LSC configuration as below:
<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={groupname}))]]></getOneFilter>
</ldapDestinationService>
<propertiesBasedSyncOptions>
<mainIdentifier>"cn=" + srcBean.getDatasetFirstValueById("groupname")
+ ",dc=testrjil,dc=net"</mainIdentifier>
<defaultDelimiter>;</defaultDelimiter>
<defaultPolicy>FORCE</defaultPolicy>
<dataset>
<name>objectClass</name>
Same had been worked for hsqldb but not working for mysql. Any idea?
Thanks & Regards,
Hardik
"Confidentiality Warning: This message and any attachments are intended only
for the use of the intended recipient(s).
are confidential and may be privileged. If you are not the intended recipient.
you are hereby notified that any
review. re-transmission. conversion to hard copy. copying. circulation or other
use of this message and any attachments is
strictly prohibited. If you are not the intended recipient. please notify the
sender immediately by return email.
and delete this message and any attachments from your system.
Virus Warning: Although the company has taken reasonable precautions to ensure
no viruses are present in this email.
The company cannot accept responsibility for any loss or damage arising from
the use of this email or attachment."
_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org
lsc-users mailing list
[email protected]
http://lists.lsc-project.org/listinfo/lsc-users
