0002260: SQL errors on funambol sync - SOGo | BTS

ID	Project	Category	View Status	Date Submitted	Last Update

0002260	Funambol SOGo Connector	Backend General	public	2013-03-02 11:30	2021-09-17 20:18

Reporter	Pegasus	Assigned To	francis
Priority	normal	Severity	major	Reproducibility	always
Status	closed	Resolution	won't fix

Summary	0002260: SQL errors on funambol sync
Description	When trying to sync contacts between a SyncML client via Funambol and SOGo in a multiple-domain SOGo configuration, table names are not set correctly in the SQL queries. (They're showing as 'null' and 'null_quick'.) My environment: SOGo, Postgres and Funambol all on one machine Debian Squeeze standard SOGo 2.0.4b install from Inverse.ca Debian repository multiple SOGo domains PostgreSQL 8.4 Funambol 10.0.3 from bundle, hacked (symlinked) to use Debian's postgresql-jdbc3-8.4.jar and json_simple-1.1.jar sogo-card sync source Officer set to SOGoOfficer.xml SOGo authenticating users in LDAP (which then does so against Kerberos via SASL) Testing with the built-in SyncML client on a Nokia Asha 303. (FWIW, Software version is V14.87 RM-763.)
Additional Information	I've attached the complete log conversation, but here are the interesting bits: When Funambol.sogo does this: [sogo-card] getAllSyncItemKeys() postgresql.log shows this: ERROR: relation "null_quick" does not exist at character 20 STATEMENT: SELECT c_name FROM null_quick WHERE c_component = 'vcard' When Funambol.sogo is doing "getSyncItemKeysFromTwin", postgres shows: ERROR: syntax error at or near "null" at character 39 STATEMENT: SELECT c_cn, c_mail, c_o, c_name FROM null When Funambol.sogo tries "getSyncItemFromId( { keyValue: 7 } )", I get: ERROR: current transaction is aborted, commands ignored until end of transaction block STATEMENT: SELECT c_name FROM null_quick WHERE c_name = $1 And finally, when Funambol.sogo shows: [sogo-card] Parsed contact: com.funambol.common.pim.contact.Contact@1dd1ed2 [sogo-card] c_name: 7 ...postgres shows: ERROR: syntax error at or near "null" at character 13 STATEMENT: INSERT INTO null (c_name, c_content, c_creationdate, c_lastmodified, c_version) VALUES ($1,$2,$3,$4,$5)
Tags	No tags attached.

2013-03-02 11:30	logs.txt (45,887 bytes) ==> /opt/Funambol/logs/ds-server/ds-server.log <== [2013-03-01 07:12:53,875] [funambol.handler] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] spappalardo/IMEI:358279049775438 logged in. [2013-03-01 07:12:53,879] [funambol.handler] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] moving to state: STATE_PKG1_RECEIVING [2013-03-01 07:12:53,926] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Source URI: sogo-card [2013-03-01 07:12:53,926] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Done! Internal item type: 1 (text/x-vcard) [2013-03-01 07:12:54,150] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Source URI: sogo-card [2013-03-01 07:12:54,150] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Done! Internal item type: 1 (text/x-vcard) [2013-03-01 07:12:54,182] [funambol.handler] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] moving to state: STATE_PKG3_RECEIVING [2013-03-01 07:12:54,264] [funambol.transport.http] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Request processed. [2013-03-01 07:12:55,398] [funambol.transport.http] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Handling incoming request [2013-03-01 07:12:55,399] [funambol.transport.http] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Request URL: https://collaboration.renegadetech.com:8443/funambol/ds/ [2013-03-01 07:12:55,399] [funambol.transport.http] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Requested sessionId: A2068746F45F65F67F5F819C9C1045B9 [2013-03-01 07:12:56,196] [funambol.engine] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Starting synchronization ... [2013-03-01 07:12:56,200] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] In beginSync()... [2013-03-01 07:12:56,208] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] Loading the JDBC driver for URL: jdbc:postgresql://localhost/sogo [2013-03-01 07:12:56,214] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] Context's user ID: spappalardo [2013-03-01 07:12:56,214] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] Context sync mode: 201 [2013-03-01 07:12:56,215] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] Context conflict resolution: 1 [2013-03-01 07:12:56,215] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] Context query: null [2013-03-01 07:12:56,234] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] Device's charset: UTF-8 [2013-03-01 07:12:56,235] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] Device's timezone: null [2013-03-01 07:12:56,235] [funambol.engine.strategy] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] Preparing slow synchronization [2013-03-01 07:12:56,236] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] getAllSyncItemKeys() ==> /var/log/postgresql/postgresql-8.4-main.log <== 2013-03-01 07:12:56 EST ERROR: relation "null_quick" does not exist at character 20 2013-03-01 07:12:56 EST STATEMENT: SELECT c_name FROM null_quick WHERE c_component = 'vcard' ==> /opt/Funambol/logs/ds-server/ds-server.log <== [2013-03-01 07:12:56,250] [funambol.sogo] [ERROR] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] Exception during getAllSyncItemKeys(): org.postgresql.util.PSQLException: ERROR: relation "null_quick" does not exist Position: 20 org.postgresql.util.PSQLException: ERROR: relation "null_quick" does not exist Position: 20 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252) at ca.inverse.sogo.engine.source.SOGoSyncSource.getAllSyncItemKeys(SOGoSyncSource.java:297) at com.funambol.server.engine.Sync4jStrategy.prepareSlowSync(Sync4jStrategy.java:275) at com.funambol.server.engine.Sync4jEngine.sync(Sync4jEngine.java:676) at com.funambol.server.session.SyncSessionHandler.processModifications(SyncSessionHandler.java:1655) at com.funambol.server.session.SyncSessionHandler.processSyncMessage(SyncSessionHandler.java:1499) at com.funambol.server.session.SyncSessionHandler.processInitSyncMapMessage(SyncSessionHandler.java:960) at com.funambol.server.session.SyncSessionHandler.processMessage(SyncSessionHandler.java:527) at com.funambol.server.engine.SyncAdapter.processInputMessage(SyncAdapter.java:491) at com.funambol.server.engine.SyncAdapter.processMessage(SyncAdapter.java:442) at com.funambol.server.engine.SyncAdapter.processWBXMLMessage(SyncAdapter.java:265) at com.funambol.transport.http.server.LocalSyncHolder.processWBXMLMessage(LocalSyncHolder.java:118) at com.funambol.transport.http.server.Sync4jServlet.doPost(Sync4jServlet.java:398) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.funambol.transport.http.server.LogContextFilter.doFilter(LogContextFilter.java:137) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.funambol.transport.http.server.SyncResponseTimeFilter.doFilter(SyncResponseTimeFilter.java:151) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Thread.java:636) [2013-03-01 07:12:56,255] [funambol.engine.strategy] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] Preparation completed (not last message in the package) [2013-03-01 07:12:56,255] [funambol.engine.strategy] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] Synchronizing... [2013-03-01 07:12:56,259] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] In commitSync()... [2013-03-01 07:12:56,272] [funambol.transport.http] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Request processed. [2013-03-01 07:12:57,261] [funambol.transport.http] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Handling incoming request [2013-03-01 07:12:57,261] [funambol.transport.http] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Request URL: https://collaboration.renegadetech.com:8443/funambol/ds/ [2013-03-01 07:12:57,261] [funambol.transport.http] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Requested sessionId: A2068746F45F65F67F5F819C9C1045B9 [2013-03-01 07:12:57,385] [funambol.engine] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Starting synchronization ... [2013-03-01 07:12:57,386] [funambol.engine.strategy] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] Preparing slow synchronization [2013-03-01 07:12:57,565] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] In getSyncItemKeysFromTwin: firtname = \|Nokia\| lastname = \|Test\| cn = \|Nokia Test\| [2013-03-01 07:12:57,565] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] In getSyncItemKeysFromTwin: cn = Nokia Test emails = [com.funambol.common.pim.contact.Email@cd5db952, com.funambol.common.pim.contact.Email@226516de, com.funambol.common.pim.contact.Email@3f94dee, com.funambol.common.pim.contact.Email@8a4643bd] o = ==> /var/log/postgresql/postgresql-8.4-main.log <== 2013-03-01 07:12:57 EST ERROR: syntax error at or near "null" at character 39 2013-03-01 07:12:57 EST STATEMENT: SELECT c_cn, c_mail, c_o, c_name FROM null ==> /opt/Funambol/logs/ds-server/ds-server.log <== [2013-03-01 07:12:57,566] [funambol.sogo] [ERROR] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] Exception occured in getSyncItemKeysFromTwin() - ERROR: syntax error at or near "null" Position: 39 org.postgresql.util.PSQLException: ERROR: syntax error at or near "null" Position: 39 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252) at ca.inverse.sogo.engine.source.SOGoSyncSource.getSyncItemKeysFromTwin(SOGoSyncSource.java:1205) at com.funambol.server.engine.Sync4jStrategy.fixMappedItems(Sync4jStrategy.java:1579) at com.funambol.server.engine.Sync4jStrategy.prepareSlowSync(Sync4jStrategy.java:325) at com.funambol.server.engine.Sync4jEngine.sync(Sync4jEngine.java:676) at com.funambol.server.session.SyncSessionHandler.processModifications(SyncSessionHandler.java:1655) at com.funambol.server.session.SyncSessionHandler.processSyncMessage(SyncSessionHandler.java:1499) at com.funambol.server.session.SyncSessionHandler.processInitSyncMapMessage(SyncSessionHandler.java:960) at com.funambol.server.session.SyncSessionHandler.processMessage(SyncSessionHandler.java:527) at com.funambol.server.engine.SyncAdapter.processInputMessage(SyncAdapter.java:491) at com.funambol.server.engine.SyncAdapter.processMessage(SyncAdapter.java:442) at com.funambol.server.engine.SyncAdapter.processWBXMLMessage(SyncAdapter.java:265) at com.funambol.transport.http.server.LocalSyncHolder.processWBXMLMessage(LocalSyncHolder.java:118) at com.funambol.transport.http.server.Sync4jServlet.doPost(Sync4jServlet.java:398) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.funambol.transport.http.server.LogContextFilter.doFilter(LogContextFilter.java:137) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.funambol.transport.http.server.SyncResponseTimeFilter.doFilter(SyncResponseTimeFilter.java:151) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Thread.java:636) [2013-03-01 07:12:57,568] [funambol.engine.strategy] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] Preparation completed (last message in the package) [2013-03-01 07:12:57,568] [funambol.engine.strategy] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] Synchronizing... [2013-03-01 07:12:57,569] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] addSyncItem(7) [2013-03-01 07:12:57,569] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] addSyncItem - type: text/x-vcard [2013-03-01 07:12:57,569] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] getSyncItemFromId( { keyValue: 7 } ) ==> /var/log/postgresql/postgresql-8.4-main.log <== 2013-03-01 07:12:57 EST ERROR: current transaction is aborted, commands ignored until end of transaction block 2013-03-01 07:12:57 EST STATEMENT: SELECT c_name FROM null_quick WHERE c_name = $1 ==> /opt/Funambol/logs/ds-server/ds-server.log <== [2013-03-01 07:12:57,572] [funambol.sogo] [ERROR] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] Exception during getSyncItemFromId(): org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271) at ca.inverse.sogo.engine.source.SOGoSyncSource.getSyncItemFromId(SOGoSyncSource.java:565) at ca.inverse.sogo.engine.source.SOGoSyncSource.addSyncItem(SOGoSyncSource.java:963) at com.funambol.server.engine.Sync4jStrategy.execNewOperation(Sync4jStrategy.java:2636) at com.funambol.server.engine.Sync4jStrategy.execSyncOperation(Sync4jStrategy.java:1456) at com.funambol.server.engine.Sync4jStrategy.sync(Sync4jStrategy.java:990) at com.funambol.server.engine.Sync4jEngine.sync(Sync4jEngine.java:692) at com.funambol.server.session.SyncSessionHandler.processModifications(SyncSessionHandler.java:1655) at com.funambol.server.session.SyncSessionHandler.processSyncMessage(SyncSessionHandler.java:1499) at com.funambol.server.session.SyncSessionHandler.processInitSyncMapMessage(SyncSessionHandler.java:960) at com.funambol.server.session.SyncSessionHandler.processMessage(SyncSessionHandler.java:527) at com.funambol.server.engine.SyncAdapter.processInputMessage(SyncAdapter.java:491) at com.funambol.server.engine.SyncAdapter.processMessage(SyncAdapter.java:442) at com.funambol.server.engine.SyncAdapter.processWBXMLMessage(SyncAdapter.java:265) at com.funambol.transport.http.server.LocalSyncHolder.processWBXMLMessage(LocalSyncHolder.java:118) at com.funambol.transport.http.server.Sync4jServlet.doPost(Sync4jServlet.java:398) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.funambol.transport.http.server.LogContextFilter.doFilter(LogContextFilter.java:137) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.funambol.transport.http.server.SyncResponseTimeFilter.doFilter(SyncResponseTimeFilter.java:151) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Thread.java:636) [2013-03-01 07:12:57,573] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] addSyncItem - content: BEGIN:VCARD VERSION:2.1 N;CHARSET=UTF-8;ENCODING=8BIT:Test;Nokia TEL;PREF;VOICE;ENCODING=8BIT:1111 TEL;CELL;VOICE;ENCODING=8BIT:2222 EMAIL;CHARSET=UTF-8;ENCODING=8BIT:email@there.com PHOTO;ENCODING=BASE64;TYPE=JPEG:/9j/4AAQSkZJRgABAgAAAQABAAD/2wBDAAYEBQYFBAY GBQYHBwYIChAKCgkJChQODwwQFxQYGBcUFhYaHSYfGhskHBYWICwgJCYoKioqGR8uMC4oMCYoK ij/2wBDAQcHBwoIChMKChMoGhYaKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg oKCgoKCgoKCgoKCgoKCj/wAARCAFAAPADASIAAhEBAxEB/90ABAAP/8QAHwAAAQUBAQEBAQEAA AAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJ xFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZW mNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMX Gx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAA AECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEK RobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ 2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMn K0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD5yFPFNFPFUYiipBTBT xWiGPFPWoxUgqiRT1FbOjnF7B/vVjN2rV0s4uoD/tCtYGcjqbscVHY/62rF4PlqpaH96K7oHP0 O78On+VfR3w8bf4QsD/v/APobV81+H2+f8K+ifhbJu8JQr/zzkkH65/rWWN/hiwn8Q66iiivJP UCiiigDlviD/wAg+0P/AE2/9lNdQv3RXLfEX/kFWn/Xx/7I1dRFzEn0rpqfwYfMwp/xZjqKKK5 jcKKKKAENeVfGA/6baj0i/qf8K9UNeSfGFv8AiZQ/9cV/m9dWE/io5cU/cZ5ZdH5qtaX98Vn3D fPV/Szz+FeseWe8fDVceEbU/wB55T/5EauqrnvAieX4T04eqFvzJNdBXjVdZs9GlpFC0lFJWZo f/9D54MTDtSdKsR3CHv8AnQ43n5a0MSEA1IqMe1N+cd6RXf8AiP5VaEWBC1PEbelRJItTo3+1V iGuOKuWrbSp9KanPofrVhY/9n8q0SIZ2N59ysuBsTCnjU1lj2ujKagjOZflrqiYHbeH3/eLX0N 8JHz4fuR6XTf+grXzdoEuLhBX0N8HZN2hXf8A18f+yrRidabMaT5aqPRKKYDTs14569xaKTNJm gLnL/EU/wDEntv+vgf+gNXR2bZtIT/sCuY+JDY0GM/9N1/k1benXCLpFnJI4VTChyfpXU1elE5 VO1SRp5ozWNNr9hH/AMtd3+6KqDxTa55jlqFhqj6Gn1iJ0maTNYsniGxVsCTd7igeIbDjMuPwp ewqdg9vE1zXkHxlbGrQj/p3X+b13dx4qtEciNHcevSvKfijq39oahFJt24hC4/Fv8a68NRnGV2 ceJqKUbHn87/PWlpDfN+FYU8vNaGkz7d2fSu85D6a8JDHhjSh/wBO0f8A6DWvWR4VP/FM6T/16 Rf+gitQuB1NeK9T0Nh9JmqE+r6db/6+/tYz6NKKyNT8Y6RaQkx3ccr+i1SpSfQTqI//0fmYb6c JZV7UwfWngn1qjMnS9lFTLfL/ABx1VDN61KGPtVklkXEDeoqRSh+61VBg/wAC09Qv9yrEaETOK 6vw/pVzqlvI9sI2dP4C2Ca42PA6bhWrp161u4KysPpxWsHYzkjsJ9EltfKS4R0nkGRHWOzGOXH pVptbe7hEdxMJQPu+aMlfoetZ6QTOWLT7m9+9dNzE6TR5ttxF9a+gfgbeeba6rDn/AFbRP+Yb/ wCJr5r0yYiVQ3DKwr0v4feJf7BuNT/esouREvyj+7u/+KraS9pCxzy92Vz6bMgVcscAUx7uBBl pkA+teNSeMjdEn9/ITUX9v3Tf6uyf8a5/qK6sv60evS65YoP9bu+grOuPE6AfuYef9o15e2par J9y3VfrUDyaw/8Ay2jStFhaSD282dR4z1ya70fy5du0SBqrLeyPbweY52hFAz9K4vWkvY7N5bi 63gEfLSw6X5sEbyXUvzKDgVvotjDW51j6hAn350/76qrJrdmvW4X8Kwl0e0H3jI31NO/s+yX/A JY/qaOYepoyeJbMfxsfoKqzeKYB91JDTFhtk+7BF/3zT9yj7qqPpS5iiqfE00n+os2b9a5nxNq VxcTL9qh8lgvAx2rrzLgda4TxxPnUE9lxQmTYxpJs1btbjbFJ9KwzJV2Bv9EuCeyimauJ6dZHX XtIVOqS+RsG1DO+APpViPT5ZD++vsAdcDdVX7X9nSNB/dqt9sb5lzw3WoTMmkXL63tkKiC4ll4 6su2qLJEP7x+pqEzZOagmlx3oIP/S+ZacKh3+1LvqjMsCnrVcPT1k9qoRaWpVqqso9KsIy5qkS WEqxHVPdgcU1Lz2rQRsRmrzH92n0rKtJfMT6Vo5/cp9K0TM2X4X2bJPSvRPAW06lOrYfMWefrX msZ/dfhXd/D2T/iZ4/wCnX+q11wehzzPT43wPSn+dzVBZKc0mBk1pcyLbTVC1wKoyT5PtVZpfm 60rkh4jmzpM34fzqazn/wBDt/8Arkv8qyddlzpk/wCH86nsn/0G2/65J/Ki5PU0mm5pnm1UaXn im780AXvMpC9VC2BSF2NQWWS/FefeMZc6pJ7f/ErXcZ4rzvxY+dYuf94f+gLTTKRkFqvwHNnc/ T+hrKzWlacwOPVgKEzWR3jz73zTPNxmo1iIq1HCjD5qXMc3KQPJxTGUk4q1NCgwfSkQhpMnpil zBY//0/l+nUlLVGYtPFNpwqhD1qyvY1WWrMXQ1RLJ+1VJBiSra9KguF71Yi/ph4atcf8AHqv41 i6Z98j2rcX/AI9PxoRLJYD+6/Cuy8ESeVq9p/01hK/pmuLg/wBVXU+Fz/xNtI/4F/6Aa6oM56h 6eW5WpGDMKpcmRavD7tXzGNirKpXvVRyQauylaqygd6OYXKZert/xLpxVm0b/AEK1/wCuSf8Ao NV9Vx/Ztz9Kt6eqmytsj/lmv8qdyeUmjTcuTUwG3GKTtikznpSuXYVzkVHzTj9ajduTgfLU3KG u3NefeKOdWn+v9BXcySVwniX/AJCb00OJn2dqblmwV+Rdx+lXbUYiT3nX+YqnYs0bTOndQhrQt VyLYetyv81qkVI7nI2daYr7aVslhSwoSe2feoRmOZ/lFRhunHFXRbfLSG2x1GKok//U+YKWilq zIKcKbThTAkWrEXWqwqeKmSy3EM8UXMZ2Va0whbgf1q/fuhhcbBk+lakXMfTP9b+Fb8X/AB6v/ vVz+nf68V0Nv/qZh9DSiJj7X7tdL4ZP+n6W3+1j/wBCrmbTvXSeFjjU9KB6fbUT9a2iZSPSs4I qVW3cVPqaoPu0WO0P86ijnM+UrvGSM8/lVedPl6HFdSBBjkCmXTwpDj1pe0H7M4nUV/4l911q5 p8TG0g2gn5BWhfBB4ZvU6tzz+Nanh8/8SWzwOdnpT9oQomOttL/AM82/Kg2ko6D8q3rotx8uRS 28WYUOT0qfaGnIc+tpI3P3V/2qhMXJDn9K6Uw4dsFhVNoS55k7t1HvT5yeU55rUPLtj59ydtcB 4nTy9UkU9Rnv7mvUNkcOpwh8Mh656d/T8K8z8ZmM67e+RnyvMfbn03GtEwijNtf9TN/vJ/Jq3f D9pJqGoaXawAebLP8ueP89K5uGUj5B0Yg10vhoK1/pm9io3PyP916tMqR6Q/hbUYopp5fJ8qFx E7CQHk4/wDiqvWng6/bydzWi+bwN796w4I5sbWb5WNbUGqT28jeXNJtxj71RzGdjorP4e6gG/f XVsF9Fc/4V1dt4N0wxAXNohf1WVq4e21S7wGbOP8AbkI/rVuPxVNG5WIIdv8AdZm/rUe8VdH/1 fmGlpKKsyCnimU8UwHipo6gqWPrVEl+D74xV2TOzmqUHLrVqVgqlUOferIKVlxcr9a6S0+7N/u 1y9sf9JH+9XUWXVx/s0Q3FILX7zVvaK3lzW8v/PO7V/1WsG2/1jVq2pxp8/r5n/xJ/pWsDKZ7l d2e+BgHXf2qoYPK2+XIvHrmqNhNK7qjyu3400GQyY3uaNDLmNozIAMSL+tQSS7k2+ZH+v8AhWp 4c8PnV4nYysnl1rah4N+yWc9x9oyIo2fGPSrtEXOzhr9z/Zt0vmRnKngZ/wAKs6Tcuuk2qrKq4 UevrW94g8KfYtKvZmuk/dws+3b97AqpoGgfbtK0vy5lR7iOTkr93a1PQjmdyq12xb5pFx26/wC FRrdFN2JeO3J9BVnXNN/s6R0DLJt43Ad6zUVSmWXnpWXuornZZedXVv3o3Y61HLOf3YjKdfmqP ZH6CmtHGiFz060KcR8zIXEjP975dvGMf59K8u8RE/2rd57St/OvW7KH7ZHI0LACMZOev5da8g1 87tUuj6yE1pbqOD1KEZ/eLXX+DojPqmmIGx99s/8AfVccn+sFdd4WlMGrWJU/8sT/AEpplzPRG ivI5m2eW0ecDdjpVHy9UDMymJOc8OKtLJcy42kkZ7pUsdtK3+scZHWp9rFGPK2Z0sGpXGftE+f bzBTrKymjb955e3Of9ataws07ljTJLKMMgG7k+tL28WHsWf/W+YKKSlqjMKeKjp9MQ+poutQDr ViGqQmXE6irBQlOKZbrucCup0zTdtk91KvCqSv1reMbmLlynEw8T/8AAq6ux/1/1U1yn/LVj71 1ln/rovf/AAqYjkNh/wBea0rf/jzuh6MD+hrKDbbzb61rWB/dXQ+n9a1pmUz2Ow8oJGYguPart vhpkQ55OOK5vTRqJ07TpIby123KMVTH3cc8n6EVuraatAMzajosN0vP2eWb957cVPs7HPudvpW qpZXd15cACsEwuemBV/Uda+0aXdxeVgPCwzn2rzFNR1kOZMWUmVH8RpJ9d1dY9r2dvtbj5ZP/A K9b6CseieItVWXw5qcJj5NrL83/AAA1zmg6t9n0DSPL4lijnG7/AHmrkNV8S6j5NxBNaqpaNlb EnTIrGsdekj01VNqzRxp98N23f407CZ6FcXiMm2ububpBaRO7hGZlb8MjNczN4gWXqsw+jCqd/ ewXFrCjm4jAzh9mc1jytjO0M257kb8oIgRj1+b/AOtWha3NokzpdLM8Zj5VJgob5j1+U15rDdR xjCX0/wD34/8AsqmvdTWaXcl2QNoyCpHIFSoSQzr9Qhglv5zbRLFBtXCE5/pXlertm8l+tdENW mVcC9i/GuUu33ybvXH8qPeW5pAjT79dv4N2f2/b+YcAWX6/u64dPvVsr5puUMPVYh3x6f4Unqm XI9fGoW2MLcR4+tPNzFHlpJU215TELnOV+9/vVq6lFey/ZPJinfFugbYpPNc/ITznenVLPdg3C fSrmQZo8nsa8j8q7jmzLFKv+8pFeoWUiiKD/rkO9SlYq5//1/l6loUHNS7aszIqcKQ9aBQA8Va g61TBq1b7s8CmiWdT4asxdXOW+6OtdL4i1K2tdIe3jdfOZcBRXDWc88KFVm2A/wB2pPlb/E11x qWRzSp3d2ZoUlq6q0GPs+faqNuijHFX93KY/vD+dQkUyJx/pea0dKOftFZ1xxc1b0aQYl5525/ 8eFOHxES2PbvD+tC48M6LHBJIuywht5Rn+7jP6LWFqlzajUZHcrvz91fx9a8/sdRlhsofKcgoM cVoay5Gr3wz/wAtn/nT53YwcdTfvdZLafvhAQeZswDnsKy49VmeZAXP3hVMNnRH9RdL+qt/hVO 3P75PrWbDlNTVLljql0M/8tW/nU9u3/EknH/Tuv8A6OrP1EZ1Ob/roa2NLtHuNJIX+ODb/wCRc 1SegrHOc1fvreSfSbFUH9/+db+n+H9uC9dBDYxqioRwprHnLPModLvSf+PeT8q1Nc027e8DQws V8uPp/uCvQ1tEB3AU9o1WHzGHAXNTz6D6nlb6Verj/R5KwroYk/Afyr0nQ9ce71GaCfG1gdnHS vOL/wD4+GFXTdy0RR/eNa0NtNc3TeVGz7UX7tZKdTXo/gJM3mpeyxD/ANDqpO0Rs5kafej/AJd 5a0dR0meBgLdJ3+Vc898V6P5I9OaXygwyayVV2JPMI7LU1YYiufwro4dGuDErLqNwpPYp/wDXr qfs+BmlEeWYZ9qPbTZLjc//0PmLOKVX5pQqin59KoyIzGznIGKesK/xNTqUUAPQKPurUwNQipk RjQIlSrMWT0qKOMd+atxMq1qiS3BEf4uKvxvFbKWkIVcdTWPJdlR8vFZF7eGXjJNXzWI5bk019 NL99zU+kXBS+i56nb+dZGatW5wwPpUXKsdnZrusV/GtzXhjWLn6j+Wao6XameOUI2MSMv612Mu lGa/aZhgMFOf+AipbscsjAtoXk0eXA5MqH/0L/GrFno0shRgOO5rq7LTkhRlA6881pRWoA+5Sl MhGRHpKEyTN1PPpUvhRR/ZEH1YVsrHiIY/u1leEx/xKl/66sP0p9xmyq4x0+lPjHzN0FO9OlNU Hc9ZlEw8rviqskCTR7W5BHrT1p8Y+QeuBR9kZjRaLZWu6WCLDgHnNeSah/wAfkv8AvGvcL2XbZ yk/3DXh17/x9Sf7xrWlsUiJP4q9J8A5+16sR6oP/Qq84thmUD1Nek+Al/d6nIAT+/xx/uj/ABp 1fgB7naRt2x+NR/8ALNfl/GoY87um3NWVOBiuboMi/wCWnCrUkIJZzj+KgKOSRUlvgofqacPhY Pc//9H5n2inZHalEfqalCgdBVGRCFY9qlWL1NK0ir1NRG4/uCgRaUBaa1wi+59qqfPJ941Yjtu 7fKKdxjGupG6cVZgE20YGAe7UJ5cX+rXJ/vNTJ3kY4OTTEaNnbxy8l/MIqHXbAxRpOqYT7tRaD P8AZdWQ43x5wwroNYv7ZrWWHG5W/OtVZoyd0zjEq9FEwG4jiq0aMGyPzrpvC0wtrn7RJDFcEdB IM4qUVI73wJCwspTPGVk87PzDnmMf1rt9hEq8ZzGp/QVw2g6xPd6uJLyb5ADwOgrubWdZvs7p9 3yB/M1lONpHLYvRqDjgelSrEO9QxM2OnT1qypPfipYIEX5enGOcVh+EB/oB4/5eG/8AQRW+ZNq 49a5/wezf2bJj/nux/wDHRV3+IRukbBkimr8zHbTtxY4GKDgPjFZKRYbJBJx0NMTf9eKlDovQ8 +9RbuAq8HAp390ZV1dtml3ftE/8q8Uuf+PhvrXs2uMo0PUP732eTk/7prxib/Wn61ph9UPqSWA zdRf76/zr0nwKMWN4R943J/8AQErzjTf+PqL/AH1r0bwVt/s2QnPMx7fStK/wC6nUBcHjH4VYw wY/IOaqQMd5/nVsNuUNtBNc32RoSMMhwWVvapLX5YQfWmr/AHt35U1GPlIvHAql8IdT/9L5nM4 HSmGR2qQQov3n/KnhkX7q/nTMyKOFm7VOIUT77flTHmY96avOT6c0gJ/OA4iWhSzNzz9aZEnzZ T5qsKojX9834CqswuhFQM/GTjipiFQkyt+FV2uiflhFIkJbmU1RO5MLgn5YFwKlEYAzKc0i4Uc UjMTx0oCxZkMWzy/UZyBTtIydyluPaoIcICPWruj28kk7bBiP+8apK5DOm0BQ93HGo4OV/Su/s pGgOnZPBjK/+PNXOeDbyz0i/kDNaXbTKAqvjI+ldJdeKvDbPtvreWGROieW64+mK3lTucrZt27 l3fB/hJzVhSRz3+lc0PFFozH+z7GTDAj/AEi6Rf05NOm16+t41kbS98f/AEwuN/8ASuV0pCudO +WUVjeFBixn9pXplv4nsbmSGCUy2Up4xcjYpP8AvdKl8LL/AKLekdpZBmtOXck0hLs7c+tPLDb kd6hEPzYzirDJthTPqaw5ShinZ2psgw/B+bin7dudx6U6XCynjmlb3RmPrw26Te4OSYX757V5B L9+vYNf/wCQTc8YyuK8ff71bYZWiUtyxpv/AB8xf74r0bwRltGH/XaT/wBCNeeaWP8ASo/x/lX ovgc48Ow8nmSU8f8AXRqeJ0pj6nSQ8jpjFM+5wM49qdB1blc4zTFm2P8ANz74rmv7iEOX7p5z9 akdwnTvTUw7EjvSycFtlP7Iz//T+blg44quUOf9mtUCq86RB9zHn0q7GRV64VBuapvLVQPOb8B UbXP8MQxTFieT73SlsBI1z/DCMD2oSFn5kPFSpGqdKfQAIqoPlFPptITUgO8xc8daC2OTVeSZY hx1qozSTH2qgLZuS7bYq1LC6iiXbNISg/hHc1gxttQhep71csMK2e9XFiaOivIvtkHnvKtvtHy JI2S3+FULGVnaffE03ycnG4r71LDD9umRCa6Cw8KLtdjMwPbFddnPY5naO5yLS4fFdRoWpuLbE FyYpF/gdvkb/CuU1W3ltLto5OoqCOYAVhfkZpy8yPQLq9sdQtt1w4STpz1BrY8Ca/dabK9vYv8 AaFHz+R/fHqno3tXl8c4w/PvXWfDh9/iSKTeFESO+D/F8vQVrGV2ZShZHu1jryX8Edym2VD3Iz /OrDXNvN9+PH04xXF3bDRtQ+2RH/Q52xcp/db/np/jW2bhAetdPs0zk5jakWzmOYi0Z9M7hTZr DzWeSOeMFj0bNZHnFvu/rTPPZOh2ms3QiPmDxLZzRaJcSP90bejD1FeMN1r0rxZrv2bTHjupiV l4Cd2NcFe6dcW0UUsi/I67v9361Hs1BaG8GLpI/0pfo/wD6DXpHgyPb4btPU7m/NjXnWjY8/n+ 61er+B9b0T/hHNNtXktHuFt0V0aQqwbHNZ1KftFYb0L9vgCbjgLUIZG4NbW21k3GBhhvfdioDZ fxB4XP93of1rklh3ypCuVIRmUEAY9qgZvw+laa28iGTK8beMHNQMny4IbeOuaUqT5UM/9T5slu yfu1CEeQ81JHEqdalzTMhscSp9alzTaM0AO+tG6oyary3AXgcmgCy0gUc1Ve4MhwnA9aqM5c80 +NttA7GnpsNu8gWX7x6E0/U7LAMsHCfxL/drPJ2n5TxV2O63xS7+critU0Qykvz/d7dqtW4NVd vp1q5aSjd+8HPrUotnQaNC3nK1dxaswWuY0R4jjDrXTG8tLePM80aj616dFWRwVjnPFOnidTIF +cVxgttrfP1/u16BNcza2/laahS2/iuHH8qkj8OQxgYGfc96idL2juio1ORWZxFrps80yjbjzO BXceENEl07UFuG54xUunQoPEsELdIYzsH+2f/ALGusWMoc/zpwpqJnUqkE1/JdRvbXWn3BV1KH 7o/9mqXQby9l0a2ItpJWC7d3mKM4qTUZEgsJpZPuouaZ4Ofb4etc+5/WtTG+hM95rGfk0pPq13 /APWoa+uLa1uLjV1gt44xkFJC9aMsuBzXnWs3snifWRZWz40+A5d/X3pSdhwXMLZN/at7JrWor ts4OIIqbrWqNDKIZPmuZir3C/3E7R1JqWoQWlqJ4wPs1v8AJax/89H/AL30FcFNdytO8khLOxy TmsJy5TqjG50tndGJ9ygH2atxNVtJVAudOib3R8Y/76zXBxXpFW47/wClZqZTp3O9hn0xMfZp7 6xJ/wCWgyP5H+lbFrqd9Gw+y69FMOyS7fm/Paa82ivR6kVaW8yPvA/WtOdGPsj1QeINctRm5sI pPZSU/nV+28cjpLb3aAfewNyivKLe/kh/1MkkX/XNytaSa9d7QJJhJ/11jB/XrT0FytH/1fmsH PSnZAqIN8ooNMzHl6Y7heSagknA+51qsSWPNA7Ess7N06VEKSjNIodTc0lFMB4ep4zxUAFTJxS AsRjkVq21mXXJ8thx/GKyVNSeZz/qzVxJkdXa6Sp+V2kRvQ1t2GgWKMHdTIf9uuPsNT1BRsDym JeQjDcK2LfxTJDxPaH6rxXoQnA45xkd5BtRAqrge1SsyojO3Qc1x0fjG2A+aCYH8Kg1PxXHdWM iwwuOnXvW3tYnN7KRraKjajf3NxuaIB+GTrmunn8mO3JvJ22D+Nn2155pWr6olqLfTrPB6lyM8 1p22gX2pSiXWrliv/PMGlFlTjrqWZLh/EMqafp/mLpkR/eTMfvV21tthhjjThEGAKz7G1SCERW qKkK/hTNbnu7XTZZbODz5uypzj3xVbGb10RieONdkLf2VYH9/LxIR2HpVC2iSws/sSNtON9zL6 Cs3S4mtI2vbkF7yY/KD1yaztfv9iG0R9zH5p39WrFztqzqjDoivrGpm9vVMa4ij+WKP0Fa+naW LyENKApNYWhWjXVyGI4r0OziEaACopR5tWXUfLoc+/hWQ/wCqwaz5/Dt3F/yyb8q9CgrRgNbOn Ew9qzyBrC4j7Gmfv0617JcQW7JmWBXJ9qqnQLC5XPlOlR7Er2/c8pS5detWY74+tdzd+EbbnbO n/AqxrnwnIP8AVbW/3WzU+yZXtIs//9b5hEqheagklL/So6WgVhKWkopjClVc0VLjEYHc80CIq cBTsUtIYop602pFFAEsYrTtEqhEK0batYIykb1kFArViVD1UVjWzYFaMUld8GcjL5gtFQvJHHg c9KwbGJdR1MMEAj3bsY6DtUGr6g1zKLK15z96t7RrcWcOP4j1NV8TsL4UdDFtUcCnvN2FZr3G3 p1qCa52xue+DWzZz8pdtp/tVqAs/lz+9WVS4XDTXGAP9quXvJ4vswWJgfbvUdrJlwMVxOv71jo 9loT+Lr0Qst2OZXXYn9W/lXAjdPPj1Ndr4ms3vdBFzbEMlm2WHf5sf4Vh+G7HzJd7dBUS96Vja m0onSeH7IW9uMjk1vJVSP5Ripd1dyVjmepoQtV6JqyYmxWpZo0oyp6VRmy6HZWRk7VcjmRx84H 5VWtoXL4YVo6bpLXV6kMameWQ4WNaRmxUhhn/AOWWR60/+z4A2dpNejad4GjFsftdzlxwFgPyi tmLwfpO3H2eSQ+u8jH5VDmkNI//1/lijFLS0ANpacBS4oAZU0vDfSo2pxO4ZoENpaXFJQMcKlS ohUyCgRZiq/BxVCOrAmWMZY1tEzNmF8Cql9qTMfs9ryx71lvdy3J8uAYFa2mWiwDJ5f1rXmvoj O1i/otktsu5+ZT1NbXn7FrMWTauTURn3HNdCfKjF6mp53c9azpdQWe8+zo3C9TWbquoeTH5cZ/ eN+lYiF4WVu55rGtW6Fqmbk7fvDj8qVJHBFZRvN/3+tPW5jFcVzU6zT5/3ckfmYW4Vkf05qXS4 RBABXJC+MkiIvC12MbDbx0ruwzuYS0Lm+lD1UMlCvXXcixpxvWxpcuFkIXdjHArm43rovDT/u5 j/tf0qjKojZtr6KVfkOAK7n4X3NvD4mj8/H7yMxxn0bj/APV+NcDc20M7b/uS/wB9OtNt7ufTn DS8oD/rU/zxStcwPp9pY1wNoP4VHrd5JZ2KSwD5f42A6V5/4W8e2+owR2+rTeXJ/DcDofrXocJ /cBo5UnhYfUGuVw5GbRZ//9D5bpwWpIoXkOEUsfar2mRRfadtz1HY1aiQ5EVpYy3J+RePU0l3Z S2rYkX8e1dZGFVeOBVS8uBMjW8Keax/StvZox52cnimYI6V0H9gXJC7drZ/StSw8MxLzdvv/wB lalYeRftUcaWpMj1rc8QaN9gl3x8279D6e1YpiqJw5S4yuIGUd6d54HSm+WKesa1BQnnSN9yp4 LVpDmU06IVcjqySxbIkX3RV5JKoLQ8meBW2xDRckm3n/ZqKe6EMRY/gKr79q5PSs13a7n/2aHI OUmt0a5nMklXpIxOny9ulQH5VEMf4n2qzbMgAH8NZBIzJYJUPKmowpz0rZuH+YBVxTg4XrUcgF TT7J5JQz/KgrrfODAYHYCsaGYM+3oTV1TtGK6KWhlIt76USVV30b+a6bkWNBZa6Xw0/+hytn/l p/QVx6vWXe313bXhMJYJ7VXtLEOHMevLJU6SDvXk9n4ivh0l3exrYt/FVyn+thzV+0izF0Wdw1 ptfzLN/Kf8Au/wmtLSPFWpaTKEjmkgf+7u+Vv6GuJtvFluf9YrLWkNUstQj2eZG2f4TV3TI5Wj /0fDbeBIVwi4qrq8cLRZ/5b9sd6vJHLKP+eY/WrUFnFEd2Nz/AN5q7lE4rmLZWl7chVkLLF710 FraxQLhFqUCpFraMEiXK49RUi1FuqRcnrWxIXNsl1bvDKMo1ee6lZvZXTwydR0PqK9IFZniDTv t9plB+/j+77+1ZVqfMiqc+U8+xSrT3TBptebsdu5KtWENVlp2/ApiLLSY4HWmBqrZpk0uPlHWg B11OZD5a9KnhHkR5/iNV7ZAPnapWkx+8P8AwEVIxLiXy02/xN1NXbWRANrjPFYbtuarkj88Urg 0bGFAyhqMOAeazUmYLyeKdHNnAqrga1i+65HpWnK3z8VgRzNFOyK3FaEbkrz1q4PUyki3vpwaq u6l310XMy6r07cGqorU8NTuBZ8uNj059atW87wcOizx+hFQ2lvJcH5Bx61t2tpHFyfmf3rWESJ MYy6VJatNInk7RnFVLTTrXUbfzrKVsZxz2pni2fy9KYd3IWuKs7+a0l3wSsje1OclF2JjG6P/0 vIBTxUYqQV6aPOJKTlqUU/oK0EKgqUELVXzuu2mb/7xouMu+cO1TRNkVRiUnr0q2h5q0Scx4s0 sRN9rt1+Rj8/sa5mvUWVZEKvgqexrk9d04Is0j4XaPkC1zVaXU2p1LHM9KZuppPakziuFnWh7N tFNhTc2TUYy7Va+6Aq9TUFDic8fwCqlxLvanzPgbVqt1oAVPvVYbrTIl5p8nBoAYxwKRTimtT0 WgC1BIfMBatWJ90QNYsf+srUi4hWrhuZss76XdUGadmugksB6erVWWpFNMkv29xJBIJIWw3866 CzvVu0yvEg+8hrlA1SxylGDqcMO9aQqcpm4Gj4vimuLSIQgttb7oriJVeJyrjBrrLjUTMOTtkH pXNX0u64kLfMOlTWaeo6d1of/2Q== EMAIL;INTERNET;HOME: URL: TEL;CELL;HOME: TEL;VOICE;HOME: ORG: TEL;VOICE;WORK: TEL;CELL;WORK: ADR:;;;;;; TEL;VOICE;CAR: ROLE: TEL;VOICE: NOTE: TEL;FAX;WORK: ADR;HOME:;;;;;; BDAY: TITLE: EMAIL;INTERNET: TEL;PAGER: URL;HOME: TEL;VOICE;PREF: ADR;WORK:;;;;;; EMAIL;INTERNET;WORK: NICKNAME: TEL;WORK;PREF: TEL;FAX;HOME: TEL;FAX: END:VCARD [2013-03-01 07:12:57,574] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] Preferred item type: 3 [2013-03-01 07:12:57,585] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] givenname: Nokia [2013-03-01 07:12:57,585] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] cn: Nokia Test [2013-03-01 07:12:57,585] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] sn: Test [2013-03-01 07:12:57,585] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] o: [2013-03-01 07:12:57,586] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] ou: null [2013-03-01 07:12:57,586] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] telephone_number: [2013-03-01 07:12:57,586] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] mail: email@there.com [2013-03-01 07:12:57,586] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] locality: [2013-03-01 07:12:57,586] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] Parsed contact: com.funambol.common.pim.contact.Contact@1dd1ed2 [2013-03-01 07:12:57,600] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] c_name: 7 ==> /var/log/postgresql/postgresql-8.4-main.log <== 2013-03-01 07:12:57 EST ERROR: syntax error at or near "null" at character 13 2013-03-01 07:12:57 EST STATEMENT: INSERT INTO null (c_name, c_content, c_creationdate, c_lastmodified, c_version) VALUES ($1,$2,$3,$4,$5) ==> /opt/Funambol/logs/ds-server/ds-server.log <== [2013-03-01 07:12:57,603] [funambol.sogo] [ERROR] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] Exception occured in addvCardSyncItem: org.postgresql.util.PSQLException: ERROR: syntax error at or near "null" Position: 13 org.postgresql.util.PSQLException: ERROR: syntax error at or near "null" Position: 13 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) at ca.inverse.sogo.engine.source.SOGoContactUtilities.addvCardSyncItem(SOGoContactUtilities.java:93) at ca.inverse.sogo.engine.source.SOGoSyncSource.addSyncItem(SOGoSyncSource.java:1022) at com.funambol.server.engine.Sync4jStrategy.execNewOperation(Sync4jStrategy.java:2636) at com.funambol.server.engine.Sync4jStrategy.execSyncOperation(Sync4jStrategy.java:1456) at com.funambol.server.engine.Sync4jStrategy.sync(Sync4jStrategy.java:990) at com.funambol.server.engine.Sync4jEngine.sync(Sync4jEngine.java:692) at com.funambol.server.session.SyncSessionHandler.processModifications(SyncSessionHandler.java:1655) at com.funambol.server.session.SyncSessionHandler.processSyncMessage(SyncSessionHandler.java:1499) at com.funambol.server.session.SyncSessionHandler.processInitSyncMapMessage(SyncSessionHandler.java:960) at com.funambol.server.session.SyncSessionHandler.processMessage(SyncSessionHandler.java:527) at com.funambol.server.engine.SyncAdapter.processInputMessage(SyncAdapter.java:491) at com.funambol.server.engine.SyncAdapter.processMessage(SyncAdapter.java:442) at com.funambol.server.engine.SyncAdapter.processWBXMLMessage(SyncAdapter.java:265) at com.funambol.transport.http.server.LocalSyncHolder.processWBXMLMessage(LocalSyncHolder.java:118) at com.funambol.transport.http.server.Sync4jServlet.doPost(Sync4jServlet.java:398) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.funambol.transport.http.server.LogContextFilter.doFilter(LogContextFilter.java:137) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.funambol.transport.http.server.SyncResponseTimeFilter.doFilter(SyncResponseTimeFilter.java:151) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Thread.java:636) [2013-03-01 07:12:57,609] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] In commitSync()... [2013-03-01 07:12:57,668] [funambol.handler] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] moving to state: STATE_PKG3_RECEIVED [2013-03-01 07:12:57,679] [funambol.transport.http] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Request processed. [2013-03-01 07:12:58,017] [funambol.transport.http] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Handling incoming request [2013-03-01 07:12:58,017] [funambol.transport.http] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Request URL: https://collaboration.renegadetech.com:8443/funambol/ds/ [2013-03-01 07:12:58,017] [funambol.transport.http] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Requested sessionId: A2068746F45F65F67F5F819C9C1045B9 [2013-03-01 07:12:58,029] [funambol.handler] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] moving to state: STATE_PKG1_RECEIVING [2013-03-01 07:12:58,036] [funambol.transport.http] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Request processed. [2013-03-01 07:12:58,777] [funambol.transport.http] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Handling incoming request [2013-03-01 07:12:58,778] [funambol.transport.http] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Request URL: https://collaboration.renegadetech.com:8443/funambol/ds/ [2013-03-01 07:12:58,778] [funambol.transport.http] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Requested sessionId: A2068746F45F65F67F5F819C9C1045B9 [2013-03-01 07:12:58,789] [funambol.handler] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] moving to state: STATE_PKG3_RECEIVING [2013-03-01 07:12:58,790] [funambol.handler] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] moving to state: STATE_END [2013-03-01 07:12:58,790] [funambol.engine.source] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] sogo-card: 0 new items added, 0 existing items updated, 0 items deleted. [2013-03-01 07:12:58,790] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] In endSync()... [2013-03-01 07:12:58,790] [funambol.sogo] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [sogo-card] Closed the database connection. [2013-03-01 07:12:58,815] [funambol.handler] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] moving to state: STATE_ENDED [2013-03-01 07:12:58,815] [funambol.handler] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Synchronization completed [2013-03-01 07:12:58,820] [funambol.transport.http] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Request processed. [2013-03-01 07:12:58,821] [funambol.transport.http] [INFO] [A2068746F45F65F67F5F819C9C1045B9] [93.212.33.52] [IMEI:358279049775438] [spappalardo] [] Closing session A2068746F45F65F67F5F819C9C1045B9 ==> /var/log/postgresql/postgresql-8.4-main.log <== 2013-03-01 07:13:01 EST LOG: could not receive data from client: Connection reset by peer 2013-03-01 07:13:01 EST LOG: unexpected EOF on client connection logs.txt (45,887 bytes)

Pegasus 2013-03-04 11:48 reporter ~0005407	I have the contacts records stored in LDAP (as opposed to the Postgres DB) and just had a look at the source code for the Funambol connector. It looks like it just assumes that contacts are stored in the database so leaves _contact_table and _contact_quick_table empty, and the rest of the code assumes the same so doesn't check for null values here and errors result. Does contact sync work for single-domain SOGo systems with contacts in LDAP? If so, there's something I'm missing here and I would appreciate some direction. I'm happy to contribute code to fix this.

Pegasus 2013-03-05 21:03 reporter ~0005410	I just talked with Inverse support and they confirmed that the Funambol connector is not set up to get contacts from LDAP. They recommend modifying the connector to use DAV instead of direct SQL calls since that will be future-proof since then it can use anything SOGo can. They have plans to do this longer term (at least 6 months out) but I will start on it now since I need it sooner than that. :)

francis 2021-09-17 20:18 administrator ~0015473	Funambol is no longer supported.

Date Modified	Username	Field	Change
2013-03-02 11:30	Pegasus	New Issue
2013-03-02 11:30	Pegasus	File Added: logs.txt
2013-03-04 11:48	Pegasus	Note Added: 0005407
2013-03-05 21:03	Pegasus	Note Added: 0005410
2014-02-07 12:32	ludovic	Project	SOGo => Funambol SOGo Connector
2021-09-17 20:18	francis	Assigned To	=> francis
2021-09-17 20:18	francis	Status	new => closed
2021-09-17 20:18	francis	Resolution	open => won't fix
2021-09-17 20:18	francis	Note Added: 0015473