Quote:
Originally Posted by jproig  Ok hillman,
can you post the rigth way to configure the conector to work with postgresql?
I mean the install.properties and the server.xml files...
Do you have any doc for the bugs you are working on?
Thanks
Juan |
Sorry, I've never set postgresql up. The .doc file that came with the Zimbra connector includes numerous changes you need to make if you want to run with mysql (I assume the changes for postgresql would be similar), but none of those changes are necessary if you use the bundled hysqldb (which is the default). Since hysqldb still writes everything to disk, and since I'm only doing development work, I saw no need to add more complexity by adding an external database to the mix.
As far as bugs go: The big one right now is timezone shifting, at least on the Windows Mobile 2003 PDA that I'm testing with right now. Meetings in Zimbra are reported using the local time zone, whereas on the PDA they're reported (via SyncML) in GMT. The connector is not properly accounting for this so it mangles the meetings whenever they sync from the PDA back to Zimbra - meetings shift by 7 hours (in my case), and all-day meetings become 24 hour meetings that stretch from 7am-6:59am (this is because the iCalendar format doesn't have an "allday" flag, it represents all-day meetings as going from 00:00 to 23:59, but when they get shifted by 7 hours, they no longer match this "allday" pattern)
Once that's fixed, I think there are issues to do with fields being lost when they get synced back to Zimbra. The problem is that the iCalendar format can't represent every field that Zimbra can, so the PDA contains a subset of what's in Zimbra. When you change a meeting on the PDA side, it appears that, at least under some circumstances, it's resynced back by first deleting the meeting in Zimbra and then recreating it. The right thing to do would be to fetch all of the extra fields from Zimbra before deleting the meeting (if it's even necessary to delete them).
And then of course there's the much bigger project of porting to Funambol 6.