Hello list, I try to configure LSC 1.2.1 to synchronise a LDAP directory from a MySQL source. Very simply, with one attribute only stored in a MySQL table ...
# ../bin/lsc -f . -s MyTask août 19 12:48:00 - INFO - Starting sync for MyTask août 19 12:48:00 - ERROR - Error while launching task "MyTask". Please check your configuration! (java.lang.ExceptionInInitializerError) I don't know where to start with this message .... Any help would be appreciated. 1/ I installed mysql-connector-java-5.1.17-bin.jar under the lib/ directory 2/ lsc.properties : src.database.driver = com.mysql.jdbc.Driver src.database.url = jdbc:mysql://mysql-host.univ.edu/db_name src.database.username = USER src.database.password = PASS dst.java.naming.provider.url = ldap://ldap.univ.edu/dc=univ,dc=edu dst.java.naming.security.authentication = simple dst.java.naming.security.principal = cn=admin,dc=univ,dc=edu dst.java.naming.security.credentials = LDAP_PASSWORD dst.java.naming.referral = ignore dst.java.naming.ldap.derefAliases = never dst.java.naming.factory.initial = com.sun.jndi.ldap.LdapCtxFactory dst.java.naming.ldap.version = 3 lsc.tasks = MyTask lsc.tasks.MyTask.srcService = org.lsc.service.SimpleJdbcSrcService lsc.tasks.MyTask.srcService.requestNameForList = getAllAliases lsc.tasks.MyTask.srcService.requestNameForObject = getAliasRecord lsc.tasks.MyTask.dstService = org.lsc.jndi.SimpleJndiDstService lsc.tasks.MyTask.dstService.baseDn = ou=Aliases lsc.tasks.MyTask.dstService.filterAll = (mail=*) lsc.tasks.MyTask.dstService.pivotAttrs = mail lsc.tasks.MyTask.dstService.filterId = (mail={mail})) lsc.tasks.MyTask.dstService.attrs = objectClass mail lsc.tasks.MyTask.bean = org.lsc.beans.SimpleBean lsc.tasks.MyTask.dn = "mail=" + srcBean.getAttributeValueById("mail") + ",ou=Aliases" dn.real_root = dc=univ,dc=edu lsc.syncoptions.MyTask = org.lsc.beans.syncoptions.PropertiesBasedSyncOptions lsc.syncoptions.MyTask.default.action = F lsc.syncoptions.MyTask.objectClass.create_value = "inetOrgPerson" lsc.syncoptions.MyTask.mail.force_value = srcBean.getAttributeValuesById("mail") 3/ sql-map-config.xml : <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-config-2.dtd";> <sqlMapConfig> <transactionManager type="JDBC"> <dataSource type="SIMPLE"> <property value="${driver}" name="JDBC.Driver" /> <property value="${url}" name="JDBC.ConnectionURL" /> <property value="${username}" name="JDBC.Username"/> <property value="${password}" name="JDBC.Password"/> <property value="15" name="Pool.MaximumActiveConnections"/> <property value="15" name="Pool.MaximumIdleConnections"/> <property value="1000" name="Pool.MaximumWait"/> </dataSource> </transactionManager> <sqlMap url="file://${lsc.config}/sql-map-config.d/InetOrgPerson.xml"/> </sqlMapConfig> 4/ 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="getAllAliases" resultClass="java.util.HashMap"> SELECT alias FROM aliases_domain </select> <select id="getAliasRecord" resultMap="java.util.HashMap" parameterClass="java.util.Map"> SELECT alias as mail FROM aliases_domain WHERE alias = #alias# </select> </sqlMap> -- Xavier Montagutelli Tel : +33 (0)5 55 45 77 20 Service Commun Informatique Fax : +33 (0)5 55 45 75 95 Universite de Limoges 123, avenue Albert Thomas 87060 Limoges cedex _______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-users mailing list [email protected] http://lists.lsc-project.org/listinfo/lsc-users
