Issue #443 has been updated by Clément OUDOT.
Here is a complete log of what is happening on postgresql: <pre> 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: SET extra_float_digits = 3 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: SET extra_float_digits = 3 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: SET extra_float_digits = 3 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: SET extra_float_digits = 3 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: SET extra_float_digits = 3 2012-04-25 12:18:35 CEST LOG: execute S_1: BEGIN 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: Select 'inetOrgPerson' objectClass, pers.id, TRIM(pers.uid) as uid, TRIM(pers.sn) as sn, TRIM(pers.givenname) as givenName, TRIM(pers.cn) as cn, TRIM(pers.mail) as mail, TRIM(pers.address) as address, TRIM(pers.telephonenumber) as telephoneNumber FROM inetorgperson pers WHERE pers.mail = $1 2012-04-25 12:18:35 CEST DETAIL: parameters: $1 = '[email protected]' 2012-04-25 12:18:35 CEST LOG: execute S_1: BEGIN 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: Select 'inetOrgPerson' objectClass, pers.id, TRIM(pers.uid) as uid, TRIM(pers.sn) as sn, TRIM(pers.givenname) as givenName, TRIM(pers.cn) as cn, TRIM(pers.mail) as mail, TRIM(pers.address) as address, TRIM(pers.telephonenumber) as telephoneNumber FROM inetorgperson pers WHERE pers.mail = $1 2012-04-25 12:18:35 CEST DETAIL: parameters: $1 = '[email protected]' 2012-04-25 12:18:35 CEST LOG: execute S_1: BEGIN 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: Select 'inetOrgPerson' objectClass, pers.id, TRIM(pers.uid) as uid, TRIM(pers.sn) as sn, TRIM(pers.givenname) as givenName, TRIM(pers.cn) as cn, TRIM(pers.mail) as mail, TRIM(pers.address) as address, TRIM(pers.telephonenumber) as telephoneNumber FROM inetorgperson pers WHERE pers.mail = $1 2012-04-25 12:18:35 CEST DETAIL: parameters: $1 = '[email protected]' 2012-04-25 12:18:35 CEST LOG: execute S_1: BEGIN 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: Select 'inetOrgPerson' objectClass, pers.id, TRIM(pers.uid) as uid, TRIM(pers.sn) as sn, TRIM(pers.givenname) as givenName, TRIM(pers.cn) as cn, TRIM(pers.mail) as mail, TRIM(pers.address) as address, TRIM(pers.telephonenumber) as telephoneNumber FROM inetorgperson pers WHERE pers.mail = $1 2012-04-25 12:18:35 CEST DETAIL: parameters: $1 = '[email protected]' 2012-04-25 12:18:35 CEST LOG: execute S_1: BEGIN 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: Select 'inetOrgPerson' objectClass, pers.id, TRIM(pers.uid) as uid, TRIM(pers.sn) as sn, TRIM(pers.givenname) as givenName, TRIM(pers.cn) as cn, TRIM(pers.mail) as mail, TRIM(pers.address) as address, TRIM(pers.telephonenumber) as telephoneNumber FROM inetorgperson pers WHERE pers.mail = $1 2012-04-25 12:18:35 CEST DETAIL: parameters: $1 = '[email protected]' 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: SELECT typname FROM pg_catalog.pg_type WHERE oid = $1 2012-04-25 12:18:35 CEST DETAIL: parameters: $1 = '705' 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: SELECT typinput='array_in'::regproc, typtype FROM pg_catalog.pg_type WHERE typname = $1 2012-04-25 12:18:35 CEST DETAIL: parameters: $1 = 'unknown' 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: SELECT typname FROM pg_catalog.pg_type WHERE oid = $1 2012-04-25 12:18:35 CEST DETAIL: parameters: $1 = '705' 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: SELECT typinput='array_in'::regproc, typtype FROM pg_catalog.pg_type WHERE typname = $1 2012-04-25 12:18:35 CEST DETAIL: parameters: $1 = 'unknown' 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: SELECT typname FROM pg_catalog.pg_type WHERE oid = $1 2012-04-25 12:18:35 CEST DETAIL: parameters: $1 = '705' 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: SELECT typinput='array_in'::regproc, typtype FROM pg_catalog.pg_type WHERE typname = $1 2012-04-25 12:18:35 CEST DETAIL: parameters: $1 = 'unknown' 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: SELECT typname FROM pg_catalog.pg_type WHERE oid = $1 2012-04-25 12:18:35 CEST DETAIL: parameters: $1 = '705' 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: SELECT typinput='array_in'::regproc, typtype FROM pg_catalog.pg_type WHERE typname = $1 2012-04-25 12:18:35 CEST DETAIL: parameters: $1 = 'unknown' 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: SELECT typname FROM pg_catalog.pg_type WHERE oid = $1 2012-04-25 12:18:35 CEST DETAIL: parameters: $1 = '705' 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: SELECT typinput='array_in'::regproc, typtype FROM pg_catalog.pg_type WHERE typname = $1 2012-04-25 12:18:35 CEST DETAIL: parameters: $1 = 'unknown' 2012-04-25 12:18:35 CEST LOG: execute S_2: ROLLBACK 2012-04-25 12:18:35 CEST LOG: execute S_2: ROLLBACK 2012-04-25 12:18:35 CEST LOG: execute S_2: ROLLBACK 2012-04-25 12:18:35 CEST LOG: execute S_2: ROLLBACK 2012-04-25 12:18:35 CEST LOG: execute S_2: ROLLBACK 2012-04-25 12:18:35 CEST LOG: execute S_1: BEGIN 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: Select 'inetOrgPerson' objectClass, pers.id, TRIM(pers.uid) as uid, TRIM(pers.sn) as sn, TRIM(pers.givenname) as givenName, TRIM(pers.cn) as cn, TRIM(pers.mail) as mail, TRIM(pers.address) as address, TRIM(pers.telephonenumber) as telephoneNumber FROM inetorgperson pers WHERE pers.mail = $1 2012-04-25 12:18:35 CEST DETAIL: parameters: $1 = '[email protected]' 2012-04-25 12:18:35 CEST LOG: execute S_1: BEGIN 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: Select 'inetOrgPerson' objectClass, pers.id, TRIM(pers.uid) as uid, TRIM(pers.sn) as sn, TRIM(pers.givenname) as givenName, TRIM(pers.cn) as cn, TRIM(pers.mail) as mail, TRIM(pers.address) as address, TRIM(pers.telephonenumber) as telephoneNumber FROM inetorgperson pers WHERE pers.mail = $1 2012-04-25 12:18:35 CEST DETAIL: parameters: $1 = '[email protected]' 2012-04-25 12:18:35 CEST LOG: execute S_2: ROLLBACK 2012-04-25 12:18:35 CEST LOG: execute S_2: ROLLBACK 2012-04-25 12:18:35 CEST LOG: execute S_1: BEGIN 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: SELECT pers."mail" AS mail FROM inetorgperson pers 2012-04-25 12:18:35 CEST LOG: execute S_2: ROLLBACK 2012-04-25 12:18:35 CEST LOG: execute S_1: BEGIN 2012-04-25 12:18:35 CEST LOG: execute <unnamed>: DELETE FROM inetorgperson WHERE mail = $1 2012-04-25 12:18:35 CEST DETAIL: parameters: $1 = NULL 2012-04-25 12:18:35 CEST LOG: execute S_3: COMMIT 2012-04-25 12:18:35 CEST LOG: unexpected EOF on client connection 2012-04-25 12:18:35 CEST LOG: unexpected EOF on client connection 2012-04-25 12:18:35 CEST LOG: unexpected EOF on client connection 2012-04-25 12:18:35 CEST LOG: unexpected EOF on client connection 2012-04-25 12:18:35 CEST LOG: unexpected EOF on client connection </pre> ---------------------------------------- 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
