Outlook sync client

Ask your questions and get help with Zimbra's Outlook Connector.
DenRaf
Posts: 17
Joined: Fri Sep 12, 2014 11:10 pm

Outlook sync client

Post by DenRaf »

Thx Hillman for your help.
Yes, I use the separate admin tool. It works untill the depth where I can see the different modules. When I want to open the zimbra module it gives me an unexpected error.
But I'm still not able to sync. I always get: "Unable to open database" on my device and there is nothing relative in the logs. Any idea?
jproig
Posts: 46
Joined: Fri Sep 12, 2014 10:42 pm

Outlook sync client

Post 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
User avatar
hillman
Advanced member
Advanced member
Posts: 76
Joined: Fri Sep 12, 2014 10:34 pm

Outlook sync client

Post by hillman »

[quote user="DenRaf"]

Yes, I use the separate admin tool. It works untill the depth where I can see the different modules. When I want to open the zimbra module it gives me an unexpected error.
But I'm still not able to sync. I always get: "Unable to open database" on my device and there is nothing relative in the logs. Any idea?[/QUOTE]
I still don't know that much about how this all works, but it sounds like the Zimbra connector may not be initializing properly. When you installed the module, did you answer 'yes' when it asked you if you wanted to re-install the database when it got to the Zimbra module?
As for logging, you can drastically increase the logging level:
Edit Sync4j/server/config/sync4j/server/logging/Logging.xml
In the first block of properties (the one that ends with "logs/syncserver.log"), set the property "level" to "ALL" and restart the server.
User avatar
hillman
Advanced member
Advanced member
Posts: 76
Joined: Fri Sep 12, 2014 10:34 pm

Outlook sync client

Post by hillman »

[quote user="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[/QUOTE]
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.
jproig
Posts: 46
Joined: Fri Sep 12, 2014 10:42 pm

Outlook sync client

Post by jproig »

What we need to start? lets do it

I dont know where to start, but we can organize.

Juan
DenRaf
Posts: 17
Joined: Fri Sep 12, 2014 11:10 pm

Outlook sync client

Post by DenRaf »

[quote user="hillman"]I still don't know that much about how this all works, but it sounds like the Zimbra connector may not be initializing properly. When you installed the module, did you answer 'yes' when it asked you if you wanted to re-install the database when it got to the Zimbra module?
As for logging, you can drastically increase the logging level:
Edit Sync4j/server/config/sync4j/server/logging/Logging.xml
In the first block of properties (the one that ends with "logs/syncserver.log"), set the property "level" to "ALL" and restart the server.[/QUOTE]
There isn't anything new anymore in those logs. If I use syncml 1.2, which is not supported, I get some errors in syncserver.log. When I 1.1, like it should, I don't get any logging, even when it is on ALL. Only in catalina.out I see some logging.
User avatar
hillman
Advanced member
Advanced member
Posts: 76
Joined: Fri Sep 12, 2014 10:34 pm

Outlook sync client

Post by hillman »

If you figure it out, let us know -- I didn't have any problems getting the logging to work, or getting the zimbra connector to load, so I don't really have any experience with a "broken" server.
Re: How to start. Assuming you can get the connector working and successfully sync to a PDA, start finding bugs. Then dive into the code and figure out how it all works. Depending on your java experience, that could take you anywhere from a few hours (java developer) to several weeks (me). Then we'll take it from there..
jproig
Posts: 46
Joined: Fri Sep 12, 2014 10:42 pm

Outlook sync client

Post by jproig »

Hillman, i cant make it work.

I am using the tar.gz you have posted.

In my blackberry 8700 using the sync4j-blabkberry 1.2

when i try to sync i get this in my phone: Synch failed. Error Sync Modification: Synchronization failde, connection broken

an in the server log:

[Oct 23, 2007 10:47:06 PM][sync4j.zimbraConnector] FINEST: XMLReponse: lifetime = 172800000

[Oct 23, 2007 10:47:06 PM][sync4j.zimbraConnector] FINEST: XMLReponse: sessionId = 56490

[Oct 23, 2007 10:47:06 PM][sync4j.zimbraConnector] FINEST: XMLReponse: pref = (GMT-03.00) Buenos Aires / Georgetown

[Oct 23, 2007 10:47:06 PM][sync4j.zimbraConnector] FINEST: Setting timezone to (GMT-03.00) Buenos Aires / Georgetown

[Oct 23, 2007 10:47:06 PM][sync4j.zimbraConnector] FINEST: XMLReponse: prefs = (GMT-03.00) Buenos Aires / Georgetown

[Oct 23, 2007 10:47:06 PM][sync4j.zimbraConnector] FINEST: XMLReponse: AuthResponse = (GMT-03.00) Buenos Aires / Georgetown

[Oct 23, 2007 10:47:06 PM][sync4j.zimbraConnector] FINEST: Init sync4j.zimbra.engine.source.ZimbraContactSyncSource with sourceUri: vcard

[Oct 23, 2007 10:47:06 PM][sync4j.zimbraConnector] FINEST: CachedSyncSource: datasource lookup

[Oct 23, 2007 10:47:06 PM][sync4j.zimbraConnector] FINEST: CachedSyncSource: datasource lookup done using java:comp/env/ prefix

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: ZimbraOfficer authenticate() Start

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: Username: juan.roig@globant.com

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: SENDING REQUEST: juan.roig@globa

nt.comXXXXXX

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: sessionId = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: mbx = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: tags = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: grant = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: acl = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: link = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: link = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: folder = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: refresh = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: change = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: context = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: soap:Header = null

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: authToken = 0_64e0052312b28d185f9eb9d91e419e48cac5393a_69643d33363a30316337326664652d6

23134362d343066342d626133382d6165306165656261393135373b6578703d31333a313139333337303238343937313b

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: lifetime = 172800000

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: sessionId = 56517

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: pref = (GMT-03.00) Buenos Aires / Georgetown

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: Setting timezone to (GMT-03.00) Buenos Aires / Georgetown

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: prefs = (GMT-03.00) Buenos Aires / Georgetown

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: XMLReponse: AuthResponse = (GMT-03.00) Buenos Aires / Georgetown

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: Init sync4j.zimbra.engine.source.ZimbraContactSyncSource with sourceUri: vcard

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: CachedSyncSource: datasource lookup

[Oct 23, 2007 10:50:59 PM][sync4j.zimbraConnector] FINEST: CachedSyncSource: datasource lookup done using java:comp/env/ prefix

And in my zibra server i see the auth successed

any ideas?
DenRaf
Posts: 17
Joined: Fri Sep 12, 2014 11:10 pm

Outlook sync client

Post by DenRaf »

Does this only work on the Network edition or does it work also on the opensource version?
User avatar
hillman
Advanced member
Advanced member
Posts: 76
Joined: Fri Sep 12, 2014 10:34 pm

Outlook sync client

Post by hillman »

It will work with either version. The connector just uses Zimbra's standard SOAP calls to communicate with the server.
Re: Blackberry sync problem. I don't see anything in that log that indicates why it's dropping the connection. But I also don't know whether the blackberry syncml client that's available actually works. I seem to remember reading somewhere that it doesn't, and a colleague of mine was unable to get it to work with Oracle's SyncML interface.
When I'm back at work next week, I'll get him to try his Blackberry against my Zimbra connector and see if we get any further than you did. In the meantime, you could try other SyncML clients (e.g. Outlook, Mozilla, etc) and see if you get any further.
Post Reply