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
