Issue #443 has been updated by Clément OUDOT.
Clément OUDOT wrote: > * The LDAP base DN is wrong, we should have ou=Sample instead of ou=People (I > will correct this) > * The LDAP is empty by default, we must run the HSQLDB sample first to get > data in the LDAP directory > * The uid column is mandatory, but not imported in the LDAP directory with > the HSQLDB sample (I will correct this) All this is now fixed. > * Then the creation of data is done in postgresql, but modifications and > delete do not work, I do not have investigate for now In pgsql logs I see: <pre> 2012-04-25 11:02:32 CEST LOG: unexpected EOF on client connection 2012-04-25 11:02:32 CEST LOG: unexpected EOF on client connection 2012-04-25 11:02:32 CEST LOG: unexpected EOF on client connection 2012-04-25 11:02:32 CEST LOG: unexpected EOF on client connection 2012-04-25 11:02:32 CEST LOG: unexpected EOF on client connection </pre> Seems LSC do not close connections properly (see http://postgresql.1045698.n5.nabble.com/LOG-unexpected-EOF-on-client-connection-td3204658.html), but I don't know if this is the cause. For delete, I have this log in LSC: <pre> avr. 25 11:02:31 - INFO - # Removing object [email protected] for People dn: [email protected] changetype: delete avr. 25 11:02:31 - INFO - All entries: 8, to modify entries: 1, successfully modified entries: 1, errors: 0 </pre> LSC says it is deleted but it's not. And for modification, LSC does not see it, but the sn of an entry in my source is different that the sn in the destination... ---------------------------------------- Bug #443: PostGreSQL sample does not work http://tools.lsc-project.org/issues/443 Author: Clément OUDOT Status: Feedback Priority: Normal Assigned to: Clément OUDOT Category: Sample Target version: 2.0 Problem in version: 2.0 I try to lancun the postgresql sample. The PG database is initiated (see #442), and the lsc.xml is corrected to use the new clean request nam for ldapSourceService (see r1676). I started the embedded OpenDJ server, and populate it trough the hsqldb sample. I try then the launch the postgresql sample that should synchronize entries from OpenDJ to postgresql. First, the user branch DN is wrong in the configuration, I replaced it by: <pre> <baseDn>ou=Sample,dc=lsc-project,dc=org</baseDn> </pre> Then, when launching the sample: <pre> clement@ader:~/Programmes/lsc-2.0-SNAPSHOT$ bin/lsc -f sample/postgresql/etc/ -s all avr. 18 15:41:52 - DEBUG - Loading XML configuration from: /home/clement/Programmes/lsc-2.0-SNAPSHOT/sample/postgresql/etc/lsc.xml avr. 18 15:41:53 - INFO - Logging configuration successfully loaded from /home/clement/Programmes/lsc-2.0-SNAPSHOT/sample/postgresql/etc/logback.xml avr. 18 15:41:53 - INFO - LSC configuration successfully loaded from /home/clement/Programmes/lsc-2.0-SNAPSHOT/sample/postgresql/etc/ avr. 18 15:41:53 - DEBUG - Reading sql-map-config.xml from file:/home/clement/Programmes/lsc-2.0-SNAPSHOT/sample/postgresql/etc/sql-map-config.xml avr. 18 15:41:53 - INFO - Connecting to LDAP server ldap://127.0.0.1:33389/dc=lsc-project,dc=org as cn=Directory Manager avr. 18 15:41:53 - INFO - Starting sync for People avr. 18 15:41:53 - INFO - Starting sync for People avr. 18 15:41:53 - DEBUG - Synchronizing People for {[email protected]} avr. 18 15:41:53 - DEBUG - Synchronizing People for {[email protected]} avr. 18 15:41:53 - DEBUG - Synchronizing People for {[email protected]} avr. 18 15:41:53 - DEBUG - Synchronizing People for {[email protected]} avr. 18 15:41:53 - ERROR - Error while synchronizing ID {[email protected]}: java.lang.UnsupportedOperationException: This method should never be called - this is a software BUG ! avr. 18 15:41:53 - DEBUG - Synchronizing People for {[email protected]} avr. 18 15:41:53 - ERROR - Error while synchronizing ID {[email protected]}: java.lang.UnsupportedOperationException: This method should never be called - this is a software BUG ! avr. 18 15:41:53 - ERROR - Error while synchronizing ID {[email protected]}: java.lang.UnsupportedOperationException: This method should never be called - this is a software BUG ! avr. 18 15:41:53 - DEBUG - java.lang.UnsupportedOperationException: This method should never be called - this is a software BUG ! java.lang.UnsupportedOperationException: This method should never be called - this is a software BUG ! at org.lsc.service.SimpleJdbcDstService.getRequestNameForClean(SimpleJdbcDstService.java:134) ~[lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.service.AbstractJdbcService.getBean(AbstractJdbcService.java:196) ~[lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:668) [lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:633) [lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:604) [lsc-core-2.0-SNAPSHOT.jar:na] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_26] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_26] at java.lang.Thread.run(Thread.java:662) [na:1.6.0_26] avr. 18 15:41:53 - DEBUG - Synchronizing People for {[email protected]} avr. 18 15:41:53 - DEBUG - java.lang.UnsupportedOperationException: This method should never be called - this is a software BUG ! java.lang.UnsupportedOperationException: This method should never be called - this is a software BUG ! at org.lsc.service.SimpleJdbcDstService.getRequestNameForClean(SimpleJdbcDstService.java:134) ~[lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.service.AbstractJdbcService.getBean(AbstractJdbcService.java:196) ~[lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:668) [lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:633) [lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:604) [lsc-core-2.0-SNAPSHOT.jar:na] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_26] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_26] at java.lang.Thread.run(Thread.java:662) [na:1.6.0_26] avr. 18 15:41:53 - DEBUG - Synchronizing People for {[email protected]} avr. 18 15:41:53 - ERROR - Error while synchronizing ID {[email protected]}: java.lang.UnsupportedOperationException: This method should never be called - this is a software BUG ! avr. 18 15:41:53 - DEBUG - java.lang.UnsupportedOperationException: This method should never be called - this is a software BUG ! java.lang.UnsupportedOperationException: This method should never be called - this is a software BUG ! at org.lsc.service.SimpleJdbcDstService.getRequestNameForClean(SimpleJdbcDstService.java:134) ~[lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.service.AbstractJdbcService.getBean(AbstractJdbcService.java:196) ~[lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:668) [lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:633) [lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:604) [lsc-core-2.0-SNAPSHOT.jar:na] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_26] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_26] at java.lang.Thread.run(Thread.java:662) [na:1.6.0_26] avr. 18 15:41:53 - ERROR - Error while synchronizing ID {[email protected]}: java.lang.UnsupportedOperationException: This method should never be called - this is a software BUG ! avr. 18 15:41:53 - ERROR - Error while synchronizing ID {[email protected]}: java.lang.UnsupportedOperationException: This method should never be called - this is a software BUG ! avr. 18 15:41:53 - DEBUG - java.lang.UnsupportedOperationException: This method should never be called - this is a software BUG ! java.lang.UnsupportedOperationException: This method should never be called - this is a software BUG ! at org.lsc.service.SimpleJdbcDstService.getRequestNameForClean(SimpleJdbcDstService.java:134) ~[lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.service.AbstractJdbcService.getBean(AbstractJdbcService.java:196) ~[lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:668) [lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:633) [lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:604) [lsc-core-2.0-SNAPSHOT.jar:na] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_26] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_26] at java.lang.Thread.run(Thread.java:662) [na:1.6.0_26] avr. 18 15:41:53 - ERROR - Error while synchronizing ID {[email protected]}: java.lang.UnsupportedOperationException: This method should never be called - this is a software BUG ! avr. 18 15:41:53 - DEBUG - java.lang.UnsupportedOperationException: This method should never be called - this is a software BUG ! java.lang.UnsupportedOperationException: This method should never be called - this is a software BUG ! at org.lsc.service.SimpleJdbcDstService.getRequestNameForClean(SimpleJdbcDstService.java:134) ~[lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.service.AbstractJdbcService.getBean(AbstractJdbcService.java:196) ~[lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:668) [lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:633) [lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:604) [lsc-core-2.0-SNAPSHOT.jar:na] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_26] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_26] at java.lang.Thread.run(Thread.java:662) [na:1.6.0_26] avr. 18 15:41:53 - DEBUG - java.lang.UnsupportedOperationException: This method should never be called - this is a software BUG ! java.lang.UnsupportedOperationException: This method should never be called - this is a software BUG ! at org.lsc.service.SimpleJdbcDstService.getRequestNameForClean(SimpleJdbcDstService.java:134) ~[lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.service.AbstractJdbcService.getBean(AbstractJdbcService.java:196) ~[lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:668) [lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:633) [lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:604) [lsc-core-2.0-SNAPSHOT.jar:na] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_26] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_26] at java.lang.Thread.run(Thread.java:662) [na:1.6.0_26] avr. 18 15:41:53 - DEBUG - java.lang.UnsupportedOperationException: This method should never be called - this is a software BUG ! java.lang.UnsupportedOperationException: This method should never be called - this is a software BUG ! at org.lsc.service.SimpleJdbcDstService.getRequestNameForClean(SimpleJdbcDstService.java:134) ~[lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.service.AbstractJdbcService.getBean(AbstractJdbcService.java:196) ~[lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:668) [lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:633) [lsc-core-2.0-SNAPSHOT.jar:na] at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:604) [lsc-core-2.0-SNAPSHOT.jar:na] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_26] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_26] at java.lang.Thread.run(Thread.java:662) [na:1.6.0_26] avr. 18 15:41:53 - ERROR - All entries: 7, to modify entries: 0, modified entries: 0, errors: 7 </pre> Do you know why getRequestNameForClean is called? -- You have received this notification because you have either subscribed to it, or are involved in it. To change your notification preferences, please click here: http://tools.lsc-project.org/my/account
_______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-dev mailing list [email protected] http://lists.lsc-project.org/listinfo/lsc-dev
