[SOGo] SOGo-Funambol calendar sync works only partly
hi, I'm new to SOGo, just spent the last weekend setting up stuff. The normal caldav/carddav stuff works great and the web interface is really a pleasure! For Outlook sync and legacy N900 phone sync though, I need the Funambol connector, and that's where my problems began... I followed the documentation setting up the connector. I configured Funambol and SOGo both to use postgresql as backend (but separate users and databases of course). In the Funambol Outlook client I configured the sogo-cal, sogo-card and sogo-todo remote sources and chose refresh-from-client. For todo-items and contacts it worked as it should, but for calendar only a fraction of the entries came through. The SOGo log doesn't say anything, but in the Funambol log I have a load of different exceptions: [2012-08-09 17:55:58,766] [funambol.sogo] [ERROR] [319562BAEF1A17B0A4342B2C1DB539E8] [77.7.175.202] [fmz-/C9E4NlLNXUE/CsuAM6H2w==] [andrel] [sogo-cal] Exception occured in addvEventSyncItem: org.postgresql.util.PSQLException: ERROR: character 0xe282ac of encoding UTF8 has no equivalent in LATIN1 org.postgresql.util.PSQLException: ERROR: character 0xe282ac of encoding UTF8 has no equivalent in LATIN1 - This one only happened once, so I doesn't matter that much [2012-08-09 17:55:58,767] [funambol.sogo] [ERROR] [319562BAEF1A17B0A4342B2C1DB539E8] [77.7.175.202] [fmz-/C9E4NlLNXUE/CsuAM6H2w==] [andrel] [sogo-cal] 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 - This accounts for more or less 70% of the exceptions I see, but maybe it's just a follow-up of an earlier problem? [2012-08-09 17:55:58,768] [funambol.sogo] [ERROR] [319562BAEF1A17B0A4342B2C1DB539E8] [77.7.175.202] [fmz-/C9E4NlLNXUE/CsuAM6H2w==] [andrel] [sogo-cal] Exception occured in getUserTimeZone(): 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 ... [2012-08-09 17:55:58,768] [funambol.sogo] [INFO] [319562BAEF1A17B0A4342B2C1DB539E8] [77.7.175.202] [fmz-/C9E4NlLNXUE/CsuAM6H2w==] [andrel] [sogo-cal] No timezone defined in SOGo for user: andrel - that's simply not true, the timezone is definitely set to Europe/Berlin, I doublechecked that in the database. Also, it did find the timezone for earlier entries. [2012-08-09 17:55:58,781] [funambol.sogo] [ERROR] [319562BAEF1A17B0A4342B2C1DB539E8] [77.7.175.202] [fmz-/C9E4NlLNXUE/CsuAM6H2w==] [andrel] [sogo-cal] Exception occured in addvEventSyncItem: 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 Any help appreciated... Thanks in advance! Regards, Andre -- users@sogo.nu https://inverse.ca/sogo/lists
Re: Re: [SOGo] SOGo/Funambol/Calendar
Hi, I am struggling with the same problem described here and some how I screwed it completely. I followed this command (no idea what it does) stated in this thread su - sogo sogo-tool user-preferences unset settings THE_USERNAME Mail and now I cannot login using funambol. It was working with contacts (no calendar, no tasks). But now it does not work at all, funambol says invalid login. In the logs I see: [2012-03-11 21:13:15,147] [funambol.handler] [INFO] [324C60863985DC5280861D92AC185FFA] [176.81.59.184] [fbb-598168674] [] [] User not authenticated [2012-03-11 21:13:15,147] [funambol.handler] [INFO] [324C60863985DC5280861D92AC185FFA] [176.81.59.184] [fbb-598168674] [] [] Authentication failed for device fbb-598168674. Make sure that the client used correct username and password and that there is a principal associating the user to the device. How can I reset that? I have tried sogo-tool user-preferences set settings THE_USERNAME Mail but gives an error. How can I fix this? Thanks a lot, regards -- users@sogo.nu https://inverse.ca/sogo/lists
Re: Re: [SOGo] SOGo/Funambol/Calendar
Hi, I answer myself. I found that the command I issued did nothing. The problem was, that after installing the new module funambol-sogo-1.0.9.s4j the port of ca/inverse/sogo/security/SOGoOfficer.xml was changed to 31000 so I had to change it back (apparently after everytime I issue bin/install-modules) to the port of my sogod (2). Thanks anyway. It works great with this version, I have contacts, calendar and tasks syncronising! -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo/Funambol/Calendar
Hi, After investigation my problem is the following. Since the upgrade from 1.3.9 to 1.3.11 the funambol synchronization with all existing users in database doesn't work anymore. (only for the calendar, it's ok with contact) With new users it's ok. If I use sogo-tool remove user it's ok for the user but he loose everything... If someone could have an idea for me it will be a very nice gift for christmas ;-) For existing users the funambol log says: Starting synchronization ... [sogo-cal] In beginSync()... [sogo-cal] Loading the JDBC driver for URL: jdbc:postgresql://localhost/sogo [sogo-cal] Context's user ID: xxx [sogo-cal] Context sync mode: 200 [sogo-cal] Context conflict resolution: 1 [sogo-cal] Context query: null Error processing message java.lang.Error: Lexical Error: Unmatched Input. For new user Starting synchronization ... [sogo-cal] In beginSync()... [sogo-cal] Loading the JDBC driver for URL: jdbc:postgresql://localhost/sogo [sogo-cal] Context's user ID: freedom [sogo-cal] Context sync mode: 201 [sogo-cal] Context conflict resolution: 1 [sogo-cal] Context query: null [sogo-cal] Device's charset: UTF-8 [sogo-cal] Device's timezone: null [sogo-cal] Preparing slow synchronization [sogo-cal] getAllSyncItemKeys() [sogo-cal] Preparation completed (last message in the package) and after the synchronization begin... Merry Christmas Sincerely Dominique BERTHET Ecole des Mines de Saint-Etienne (France) Le 19/12/2011 17:03, Dries Decock a écrit : Hi, I encountered the same problem, but setting the timezone for the individual user fixed my problem. Kind regards On Mon, 2011-12-19 at 17:01 +0100, Dominique BERTHET wrote: Hi, I have the same proble since my upgrade from SOGo 1.3.9 to 1.3.11 With 1.3.9 I we could sync contacts and calendar With 1.3.11 we could sync contacts but not calendar... I think that the problem come with the new version of SOGo... Perharps somethong change with the gestion of timezone data? My server is Ubuntu 10.04 LTS My error logs with Funambol are - on the server: [2011-12-19 16:50:07,477] [funambol.engine] [INFO] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [] Starting synchronization ... [2011-12-19 16:50:07,477] [funambol.sogo] [INFO] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [sogo-cal] In beginSync()... [2011-12-19 16:50:07,477] [funambol.sogo] [INFO] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [sogo-cal] Loading the JDBC driver for URL: jdbc:postgresql://localhost/sogo [2011-12-19 16:50:07,485] [funambol.sogo] [INFO] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [sogo-cal] Context's user ID: dberthet [2011-12-19 16:50:07,485] [funambol.sogo] [INFO] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [sogo-cal] Context sync mode: 201 [2011-12-19 16:50:07,485] [funambol.sogo] [INFO] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [sogo-cal] Context conflict resolution: 1 [2011-12-19 16:50:07,485] [funambol.sogo] [INFO] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [sogo-cal] Context query: null [2011-12-19 16:50:07,490] [funambol.handler] [ERROR] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [] Error processing message java.lang.Error: Lexical Error: Unmatched Input On the smartphone Mon Dec 19 16:50:05 HNEC 2011 [ERROR] [SyncManager] Server responded 511 to command SyncHdr Mon Dec 19 16:50:05 HNEC 2011 [ERROR] [SyncManager] SyncException(com.funambol.sync.SyncException: Server responded 511 to command SyncHdr) Thanx for your answers Dominique BERTHET Ecole des Mines de Saint-Etienne (France) Le 16/12/2011 19:59, František Kučera a écrit : Dne 16.12.2011 13:52, Wacław Michno napsal(a): [2011-12-16 13:02:05,902] [funambol.handler] [ERROR] [4790B38D97E466FCA616A0D3E5EE943F] [172.22.15.170] [fac-null] [myem...@example.pl mailto:myem...@example.pl] [] Error processing message java.lang.NoClassDefFoundError: org/apache/commons/configuration/plist/PropertyListConfiguration at ca.inverse.sogo.engine.source.SOGoUtilities.getSyncTags(SOGoUtilities.java:167) Hi, I had this error when user was new and has not yet set his timezone (only global timezone for whole SOGo server was configured). If user logs in SOGo web interface, opens configuration dialog and saves it, his personal timezone was set and this error disappears. But it is just workaround. Error message says that java class PropertyListConfiguration is missing. So I put these libraries: commons-configuration-1.6.jar commons-collections-3.2.1.jar commons-lang-2.2.jar commons-logging-1.1.1.jar into folder Funambol/tools/tomcat/lib/ (and restarted Funambol of course) Then synchronization
Re: [SOGo] SOGo/Funambol/Calendar
Hi, I have the same proble since my upgrade from SOGo 1.3.9 to 1.3.11 With 1.3.9 I we could sync contacts and calendar With 1.3.11 we could sync contacts but not calendar... I think that the problem come with the new version of SOGo... Perharps somethong change with the gestion of timezone data? My server is Ubuntu 10.04 LTS My error logs with Funambol are - on the server: [2011-12-19 16:50:07,477] [funambol.engine] [INFO] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [] Starting synchronization ... [2011-12-19 16:50:07,477] [funambol.sogo] [INFO] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [sogo-cal] In beginSync()... [2011-12-19 16:50:07,477] [funambol.sogo] [INFO] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [sogo-cal] Loading the JDBC driver for URL: jdbc:postgresql://localhost/sogo [2011-12-19 16:50:07,485] [funambol.sogo] [INFO] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [sogo-cal] Context's user ID: dberthet [2011-12-19 16:50:07,485] [funambol.sogo] [INFO] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [sogo-cal] Context sync mode: 201 [2011-12-19 16:50:07,485] [funambol.sogo] [INFO] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [sogo-cal] Context conflict resolution: 1 [2011-12-19 16:50:07,485] [funambol.sogo] [INFO] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [sogo-cal] Context query: null [2011-12-19 16:50:07,490] [funambol.handler] [ERROR] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [] Error processing message java.lang.Error: Lexical Error: Unmatched Input On the smartphone Mon Dec 19 16:50:05 HNEC 2011 [ERROR] [SyncManager] Server responded 511 to command SyncHdr Mon Dec 19 16:50:05 HNEC 2011 [ERROR] [SyncManager] SyncException(com.funambol.sync.SyncException: Server responded 511 to command SyncHdr) Thanx for your answers Dominique BERTHET Ecole des Mines de Saint-Etienne (France) Le 16/12/2011 19:59, František Kučera a écrit : Dne 16.12.2011 13:52, Wacław Michno napsal(a): [2011-12-16 13:02:05,902] [funambol.handler] [ERROR] [4790B38D97E466FCA616A0D3E5EE943F] [172.22.15.170] [fac-null] [myem...@example.pl] [] Error processing message java.lang.NoClassDefFoundError: org/apache/commons/configuration/plist/PropertyListConfiguration at ca.inverse.sogo.engine.source.SOGoUtilities.getSyncTags(SOGoUtilities.java:167) Hi, I had this error when user was new and has not yet set his timezone (only global timezone for whole SOGo server was configured). If user logs in SOGo web interface, opens configuration dialog and saves it, his personal timezone was set and this error disappears. But it is just workaround. Error message says that java class PropertyListConfiguration is missing. So I put these libraries: commons-configuration-1.6.jar commons-collections-3.2.1.jar commons-lang-2.2.jar commons-logging-1.1.1.jar into folder Funambol/tools/tomcat/lib/ (and restarted Funambol of course) Then synchronization works also for new users (which don't have their timezone configured yet). František Kučera -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo/Funambol/Calendar
Hi, I encountered the same problem, but setting the timezone for the individual user fixed my problem. Kind regards On Mon, 2011-12-19 at 17:01 +0100, Dominique BERTHET wrote: Hi, I have the same proble since my upgrade from SOGo 1.3.9 to 1.3.11 With 1.3.9 I we could sync contacts and calendar With 1.3.11 we could sync contacts but not calendar... I think that the problem come with the new version of SOGo... Perharps somethong change with the gestion of timezone data? My server is Ubuntu 10.04 LTS My error logs with Funambol are - on the server: [2011-12-19 16:50:07,477] [funambol.engine] [INFO] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [] Starting synchronization ... [2011-12-19 16:50:07,477] [funambol.sogo] [INFO] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [sogo-cal] In beginSync()... [2011-12-19 16:50:07,477] [funambol.sogo] [INFO] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [sogo-cal] Loading the JDBC driver for URL: jdbc:postgresql://localhost/sogo [2011-12-19 16:50:07,485] [funambol.sogo] [INFO] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [sogo-cal] Context's user ID: dberthet [2011-12-19 16:50:07,485] [funambol.sogo] [INFO] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [sogo-cal] Context sync mode: 201 [2011-12-19 16:50:07,485] [funambol.sogo] [INFO] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [sogo-cal] Context conflict resolution: 1 [2011-12-19 16:50:07,485] [funambol.sogo] [INFO] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [sogo-cal] Context query: null [2011-12-19 16:50:07,490] [funambol.handler] [ERROR] [6F3F398CA178B661681F58E0151AE0A2] [92.90.23.38] [fac-354316030736831] [dberthet] [] Error processing message java.lang.Error: Lexical Error: Unmatched Input On the smartphone Mon Dec 19 16:50:05 HNEC 2011 [ERROR] [SyncManager] Server responded 511 to command SyncHdr Mon Dec 19 16:50:05 HNEC 2011 [ERROR] [SyncManager] SyncException(com.funambol.sync.SyncException: Server responded 511 to command SyncHdr) Thanx for your answers Dominique BERTHET Ecole des Mines de Saint-Etienne (France) Le 16/12/2011 19:59, František Kučera a écrit : Dne 16.12.2011 13:52, Wacław Michno napsal(a): [2011-12-16 13:02:05,902] [funambol.handler] [ERROR] [4790B38D97E466FCA616A0D3E5EE943F] [172.22.15.170] [fac-null] [myem...@example.pl] [] Error processing message java.lang.NoClassDefFoundError: org/apache/commons/configuration/plist/PropertyListConfiguration at ca.inverse.sogo.engine.source.SOGoUtilities.getSyncTags(SOGoUtilities.java:167) Hi, I had this error when user was new and has not yet set his timezone (only global timezone for whole SOGo server was configured). If user logs in SOGo web interface, opens configuration dialog and saves it, his personal timezone was set and this error disappears. But it is just workaround. Error message says that java class PropertyListConfiguration is missing. So I put these libraries: commons-configuration-1.6.jar commons-collections-3.2.1.jar commons-lang-2.2.jar commons-logging-1.1.1.jar into folder Funambol/tools/tomcat/lib/ (and restarted Funambol of course) Then synchronization works also for new users (which don't have their timezone configured yet). František Kučera -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo/Funambol/Calendar
Please help. After updating SOGo 1.3.8 to 1.3.11 I have a problem with sync Calendar on the phone and tablet and other devices. Previously, everything worked perfectly for several months. How do I downgrade to 1.3.8? I really depends on stability. Software versions: Sogo version 1.3.11 Postgres 8.4 Ubuntu-Server 10.04.2 LTS Funambol Data Synchronization Server v.10.0.0 json_simple-1.1.jar funambol-sogo-1.0.8.s4j Time zone is set correctly in the properties of Funambol devices. I can not tell where the problem is with sogo or of Funambol. Below is a log of Sogo and with Funambol. SOGO--- Dec 16 12:56:04 sogod [24210]: [so-security]D validate object: 0x01832F40[SOGoUserFolder]: name=myem...@example.pl container=0x0131B150/(nil) Dec 16 12:56:04 sogod [24210]: [so-security]D validate permission 'access contents information' on object: 0x01832F40[SOGoUserFolder]: name=myem...@example.pl container=0x 0131B150/(nil) Dec 16 12:56:04 sogod [24210]: [so-security]D possible roles for permission 'access contents information': Authenticated, PublicUser Dec 16 12:56:04 sogod [24210]: [so-security]D got user: 0x0x18193b0[SOGoUser]: login=myem...@example.pl roles=Authenticated,Anonymous) Dec 16 12:56:04 sogod [24210]: [so-security]D user roles: Authenticated,Anonymous,Owner Dec 16 12:56:04 sogod [24210]: [so-security]D found a valid role: 'Authenticated'. Dec 16 12:56:04 sogod [24210]: [so-security]D successfully validated permission 'access contents information'. Dec 16 12:56:04 sogod [24210]: [so-security]D successfully validated object (perm=access contents information). Dec 16 12:56:04 sogod [24210]: [so-security]D validate object: SOGo[0x0x131b150]: name=SOGo Dec 16 12:56:04 sogod [24210]: [so-security]D object is public. Dec 16 12:56:04 sogod [24210]: [so-security]D validate key myem...@example.pl of object: SOGo[0x0x131b150]: name=SOGo Dec 16 12:56:04 sogod [24210]: [so-security]D found no security info for key (class SOGo): myem...@example.pl Dec 16 12:56:04 sogod [24210]: [so-security]D default is allow ... Dec 16 12:56:04 sogod [24210]: [so-security]D validate key freebusy.ifb of object: 0x01832F40[SOGoUserFolder]: name=myem...@example.pl container=0x0131B150/(nil) Dec 16 12:56:04 sogod [24210]: [so-security]D found no security info for key (class SOGoUserFolder): freebusy.ifb Dec 16 12:56:04 sogod [24210]: [so-security]D default is allow ... Dec 16 12:56:04 sogod [24210]: [so-security]D validate object: 0x01264EE0[SOGoFreeBusyObject]: name=freebusy.ifb container=0x01832F40/myem...@example.pl Dec 16 12:56:04 sogod [24210]: [so-security]D validate permission 'access contents information' on object: 0x01264EE0[SOGoFreeBusyObject]: name=freebusy.ifb container=0x 01832F40/myem...@example.pl Dec 16 12:56:04 sogod [24210]: [so-security]D possible roles for permission 'access contents information': Owner, Authenticated, PublicUser Dec 16 12:56:04 sogod [24210]: [so-security]D got user: 0x0x18193b0[SOGoUser]: login=myem...@example.pl roles=Authenticated,Anonymous) Dec 16 12:56:04 sogod [24210]: [so-security]D user roles: Authenticated,Anonymous,Owner Dec 16 12:56:04 sogod [24210]: [so-security]D found a valid role: 'Authenticated'. Dec 16 12:56:04 sogod [24210]: [so-security]D successfully validated permission 'access contents information'. Dec 16 12:56:04 sogod [24210]: [so-security]D successfully validated object (perm=access contents information). Dec 16 12:56:04 sogod [24210]: [so-security]D validate key freebusy.ifb of object: 0x01832F40[SOGoUserFolder]: name=myem...@example.pl container=0x0131B150/(nil) Dec 16 12:56:04 sogod [24210]: [so-security]D found no security info for key (class SOGoUserFolder): freebusy.ifb Dec 16 12:56:04 sogod [24210]: [so-security]D default is allow ... Dec 16 12:56:04 sogod [24210]: [so-security]D validate permission 'WebDAV Access' on object: 0x01264EE0[SOGoFreeBusyObject]: name=freebusy.ifb container=0x01832F40/wdrag @gradier.pl Dec 16 12:56:04 sogod [24210]: [so-security]D possible roles for permission 'WebDAV Access': Owner, Authenticated, PublicUser Dec 16 12:56:04 sogod [24210]: [so-security]D got user: 0x0x18193b0[SOGoUser]: login=myem...@example.pl roles=Authenticated,Anonymous) Dec 16 12:56:04 sogod [24210]: [so-security]D user roles: Authenticated,Anonymous,Owner Dec 16 12:56:04 sogod [24210]: [so-security]D found a valid role: 'Authenticated'. Dec 16 12:56:04 sogod [24210]: [so-security]D successfully validated permission 'WebDAV Access'. Dec 16 12:56:04 sogod [24210]: [so-security]D validate key GET of object: 0x01264EE0[SOGoFreeBusyObject]: name=freebusy.ifb container=0x01832F40/myem...@example.pl Dec 16 12:56:04 sogod [24210]: [so-security]D validate permission 'access contents information' on object: 0x01264EE0[SOGoFreeBusyObject]: name=freebusy.ifb container=0x 01832F40/myem...@example.pl Dec 16 12:56:04 sogod [24210]: [so-security]D possible roles for permission 'access contents information': Owner,
Re: [SOGo] SOGo/Funambol/Calendar
How do I downgrade to 1.3.8? sudo apt-get install sogo=1.3.8 ? -- users@sogo.nu https://inverse.ca/sogo/lists