View Issue Details
| 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:
| ||||
| Additional Information | I've attached the complete log conversation, but here are the interesting bits: When Funambol.sogo does this: [sogo-card] getAllSyncItemKeys() When Funambol.sogo is doing "getSyncItemKeysFromTwin", postgres shows: When Funambol.sogo tries "getSyncItemFromId( { keyValue: 7 } )", I get: And finally, when Funambol.sogo shows: ...postgres shows: | ||||
| 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
|
|
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. |
|
|
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. :) |
|
|
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 |