I got the sync to work but it is deleting existing users , I believe
because of an error in InetOrgPerson.xml I have attached file.
Thanks
Mike
Jul 30 10:44:54 - WARN - Error while looking for a specific entry with
id=kaiyahharger06 (com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in
file:///etc/lsc/sql-map-config.d/InetOrgPerson.xml.
--- The error occurred while executing query.
--- Check the Select 'inetOrgPerson' objectClass, pers."UID" AS
uid, pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN"
AS cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Unexpected token AS, requires FROM in
statement [ Select 'inetOrgPerson' objectClass, pers."UID" AS uid,
pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN" AS
cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? ])
Jul 30 10:44:54 - ERROR - Error while synchronizing ID {uid=noahhardin77}:
org.lsc.exception.LscServiceException: javax.naming.CommunicationException:
--- The error occurred in
file:///etc/lsc/sql-map-config.d/InetOrgPerson.xml.
--- The error occurred while executing query.
--- Check the Select 'inetOrgPerson' objectClass, pers."UID" AS
uid, pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN"
AS cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Unexpected token AS, requires FROM in
statement [ Select 'inetOrgPerson' objectClass, pers."UID" AS uid,
pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN" AS
cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? ]
Jul 30 10:44:54 - ERROR - Error while synchronizing ID {uid=emmahardman38}:
org.lsc.exception.LscServiceException: javax.naming.CommunicationException:
--- The error occurred in
file:///etc/lsc/sql-map-config.d/InetOrgPerson.xml.
--- The error occurred while executing query.
--- Check the Select 'inetOrgPerson' objectClass, pers."UID" AS
uid, pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN"
AS cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Unexpected token AS, requires FROM in
statement [ Select 'inetOrgPerson' objectClass, pers."UID" AS uid,
pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN" AS
cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? ]
Jul 30 10:44:55 - ERROR - Error while synchronizing ID
{uid=kaiyahharger06}: org.lsc.exception.LscServiceException:
javax.naming.CommunicationException:
--- The error occurred in
file:///etc/lsc/sql-map-config.d/InetOrgPerson.xml.
--- The error occurred while executing query.
--- Check the Select 'inetOrgPerson' objectClass, pers."UID" AS
uid, pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN"
AS cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Unexpected token AS, requires FROM in
statement [ Select 'inetOrgPerson' objectClass, pers."UID" AS uid,
pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN" AS
cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? ]
Jul 30 10:44:54 - WARN - Error while looking for a specific entry with
id=hunterharmon98 (com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in
file:///etc/lsc/sql-map-config.d/InetOrgPerson.xml.
--- The error occurred while executing query.
--- Check the Select 'inetOrgPerson' objectClass, pers."UID" AS
uid, pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN"
AS cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Unexpected token AS, requires FROM in
statement [ Select 'inetOrgPerson' objectClass, pers."UID" AS uid,
pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN" AS
cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? ])
Jul 30 10:44:54 - WARN - Error while looking for a specific entry with
id=emilyharper30 (com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in
file:///etc/lsc/sql-map-config.d/InetOrgPerson.xml.
--- The error occurred while executing query.
--- Check the Select 'inetOrgPerson' objectClass, pers."UID" AS
uid, pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN"
AS cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Unexpected token AS, requires FROM in
statement [ Select 'inetOrgPerson' objectClass, pers."UID" AS uid,
pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN" AS
cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? ])
Jul 30 10:44:55 - ERROR - Error while synchronizing ID {uid=emilyharper30}:
org.lsc.exception.LscServiceException: javax.naming.CommunicationException:
--- The error occurred in
file:///etc/lsc/sql-map-config.d/InetOrgPerson.xml.
--- The error occurred while executing query.
--- Check the Select 'inetOrgPerson' objectClass, pers."UID" AS
uid, pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN"
AS cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Unexpected token AS, requires FROM in
statement [ Select 'inetOrgPerson' objectClass, pers."UID" AS uid,
pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN" AS
cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? ]
Jul 30 10:44:55 - ERROR - Error while synchronizing ID
{uid=hunterharmon98}: org.lsc.exception.LscServiceException:
javax.naming.CommunicationException:
--- The error occurred in
file:///etc/lsc/sql-map-config.d/InetOrgPerson.xml.
--- The error occurred while executing query.
--- Check the Select 'inetOrgPerson' objectClass, pers."UID" AS
uid, pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN"
AS cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Unexpected token AS, requires FROM in
statement [ Select 'inetOrgPerson' objectClass, pers."UID" AS uid,
pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN" AS
cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? ]
Jul 30 10:44:55 - WARN - Error while looking for a specific entry with
id=jamesharper13 (com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in
file:///etc/lsc/sql-map-config.d/InetOrgPerson.xml.
--- The error occurred while executing query.
--- Check the Select 'inetOrgPerson' objectClass, pers."UID" AS
uid, pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN"
AS cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Unexpected token AS, requires FROM in
statement [ Select 'inetOrgPerson' objectClass, pers."UID" AS uid,
pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN" AS
cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? ])
Jul 30 10:44:55 - ERROR - Error while synchronizing ID {uid=jamesharper13}:
org.lsc.exception.LscServiceException: javax.naming.CommunicationException:
--- The error occurred in
file:///etc/lsc/sql-map-config.d/InetOrgPerson.xml.
--- The error occurred while executing query.
--- Check the Select 'inetOrgPerson' objectClass, pers."UID" AS
uid, pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN"
AS cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Unexpected token AS, requires FROM in
statement [ Select 'inetOrgPerson' objectClass, pers."UID" AS uid,
pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN" AS
cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? ]
Jul 30 10:44:55 - WARN - Error while looking for a specific entry with
id=valerieharper96 (com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in
file:///etc/lsc/sql-map-config.d/InetOrgPerson.xml.
--- The error occurred while executing query.
--- Check the Select 'inetOrgPerson' objectClass, pers."UID" AS
uid, pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN"
AS cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Unexpected token AS, requires FROM in
statement [ Select 'inetOrgPerson' objectClass, pers."UID" AS uid,
pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN" AS
cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? ])
Jul 30 10:44:55 - ERROR - Error while synchronizing ID
{uid=valerieharper96}: org.lsc.exception.LscServiceException:
javax.naming.CommunicationException:
--- The error occurred in
file:///etc/lsc/sql-map-config.d/InetOrgPerson.xml.
--- The error occurred while executing query.
--- Check the Select 'inetOrgPerson' objectClass, pers."UID" AS
uid, pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN"
AS cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Unexpected token AS, requires FROM in
statement [ Select 'inetOrgPerson' objectClass, pers."UID" AS uid,
pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN" AS
cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? ]
Jul 30 10:44:55 - WARN - Error while looking for a specific entry with
id=toddharper35 (com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in
file:///etc/lsc/sql-map-config.d/InetOrgPerson.xml.
--- The error occurred while executing query.
--- Check the Select 'inetOrgPerson' objectClass, pers."UID" AS
uid, pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN"
AS cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
pers "DN" AS dn, FROM csvdata pers WHERE pers."MAIL" LIKE ? .
--- Check the SQL Statement (preparation failed).
--- Cause: java.sql.SQLException: Unexpected token AS, requires FROM in
statement [ Select 'inetOrgPerson' objectClass, pers."UID" AS uid,
pers."SN" AS sn, pers."DISPLAYNAME" AS displayname, pers."CN" AS
cn, pers."MAIL" AS mail, pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber, pers."USERPASSWORD" AS
userpassword, pers "DESCRIPTION" AS description,
<?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
'inetOrgPerson' objectClass,
pers."UID" AS uid,
pers."SN" AS sn,
pers."DISPLAYNAME" AS displayname,
pers."CN" AS cn,
pers."MAIL" AS mail,
pers."EMPLOYEETYPE" AS employeetype,
pers."EMPLOYEENUMBER" AS employeenumber,
pers."USERPASSWORD" AS userpassword,
pers "DESCRIPTION" AS description,
pers "DN" AS dn,
FROM csvdata pers
WHERE pers."MAIL" LIKE #mail#
</select>
<select id="checkPersonForClean" resultClass="java.util.HashMap" parameterClass="java.util.Map">
Select
pers."UID" AS UID
FROM csvdata pers
WHERE pers."MAIL" LIKE #mail#
</select>
<select id="getInetOrgPersonList" resultClass="java.util.HashMap">
SELECT pers."UID" AS uid
FROM csvdata pers
</select>
</sqlMap>
_______________________________________________________________
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
