[SOGo] SOGo-Funambol calendar sync works only partly

[Andre Landwehr]

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

[SOGo] Re: SOGo-Funambol calendar sync works only partly

[Andre Landwehr]

Am 10.08.2012 13:03, schrieb Andre Landwehr:

...
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:
...


hi again,

I noticed that my sogo postgresql database was LATIN1 encoded. I dumped, 
dropped and recreated it with UTF-8 encoding and suddenly pushing 
Outlooks calendar in via Funambol works like a charm!

Next step is the N900, let's see if that one's up for a fight, too :-

Take care,
Andre
--
users@sogo.nu
https://inverse.ca/sogo/lists