Hi Xavier, Can you pastebin the complete log file which may be located in /tmp/lsc.log ? I suggest you modify the following lines in the logback.xml configuration :
In the '<appender name="LSC" ...' node : from : <filter class="ch.qos.logback.classic.filter.ThresholdFilter"><level>INFO</level></filter> to : <filter class="ch.qos.logback.classic.filter.ThresholdFilter"><level>DEBUG</level></filter> Near the end of the file : from : <root level="WARN"> to : <root level="DEBUG"> Regards, 2011/8/19 Xavier Montagutelli <[email protected]> > 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 > -- Sebastien BAHLOUL IAM / Security specialist Ldap Synchronization Connector : http://lsc-project.org Blog : http://sbahloul.wordpress.com/
_______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-users mailing list [email protected] http://lists.lsc-project.org/listinfo/lsc-users
