[horde] Can't sync calendar & contacts, ActiveSync, horde4, android 4.0.2

[Daniel Basa]

Hi Horde list,

to cut a long story short:

I can't sync my calendar (contacts) with active sync using horde 4 and
android 4.0.2.
My Galaxy Nexus tells me there are no calendars. The synced contacts to
not show up in the address book.

Here comes the long story:

I have set up Horde Groupware Webmail Edition for use as a webmailer and
to sync calendars and contacts with mobile phones using ActiveSync
(android and iOS).
My server uses exim4 and dovecot. Horde is authenticating over imap, so
there are no horde specific users.
I am using apache 2.2.14 with FastCGI on Ubuntu 10.04. I had some
trouble getting the ActiveSync authentication to work
but found a solution for it on the horde mailinglists (and on the web
https://maurus.net/weblog/).
Authentication seems to work by now. My horde activesync.log sais the
following.

+----[ activesync.log ]
| 2012-01-31T17:44:17+01:00 INFO: Horde_ActiveSync_Driver_Horde::logon
attempt for: username at domain.com
| 2012-01-31T17:44:18+01:00 DEBUG: [] OPTIONS request received for user
username at domain.com
+----------------------

After having some trouble where I could not see my device in the Device
Management section in the Active Sync settings I cleaned my MySQL tables
and connected again. The authentication succeeded and the device was
(is) displayed now in the Device Management section:

+----[ Device Management ]-------------------------------------------
+ Device   |	Last Sync Time     |	Status
+--------------------------------------------------------------------
+ Android  |	31. Jan 2012 17:44 | Not Provisioned
+	   |			   | Device id:androidc1771218180
+	   |			   | Policy Key:0
+	   |			   | User Agent:Android/4.0.2-EAS-1.3
+--------------------------------------------------------------------

Everything seems good from this point as far as I understand (don't know
what "not provisioned" means exactly and can't figure it out - I am not
a native speaker) but, I have trouble syncing my calendar. The Android
Calendar app does not show/find any Calendars. Syncing my Contacts does
not work either, though there are no error messages.

First I did an upgrade of horde (pear upgrade -a -B -c horde) at 17:47
UTC+1 on January the 31st 2012 and restarted apache but that changed
nothing.
I am running horde 4.0.13 now (atleast I am told that by the help button
from the horde webmail interface).

I searched the mailing list (the web too but nothing found there worked
out) and found two interesting threads

First:

Hanns Mattes device was not showing up in his active sync settings and
he got the following sync.log

,----[ /var/log/sync.log ]
| 2012-01-27T23:09:09+01:00 INFO: Horde_ActiveSync_Driver_Horde::logon
attempt for: hannsldap <at> hannsmattes.de
| 2012-01-27T23:09:09+01:00 DEBUG: [] OPTIONS request received for user
hannsldap <at> hannsmattes.de
| 2012-01-27T23:09:09+01:00 INFO: Horde_ActiveSync_Driver_Horde::logon
attempt for: hannsldap <at> hannsmattes.de
| 2012-01-27T23:09:09+01:00 DEBUG: [androidc1405421619] FOLDERSYNC
request received for user hannsldap <at> hannsmattes.de
| 2012-01-27T23:09:09+01:00 DEBUG: [androidc1405421619] loadDeviceInfo:
| 2012-01-27T23:09:09+01:00 DEBUG: Resetting PING state
| 2012-01-27T23:09:09+01:00 DEBUG: Resetting PING state
| 2012-01-27T23:09:09+01:00 DEBUG: [androidc1405421619] Device entry
does not exist for user

In the thread (By Hanns Mattes; Title: Activesync) he was given the
advice to make sure his database schema is up to date and to try
migrating the activesync tables down, then back up. i.e.:

$ horde-db-migrate /path/to/framework/ActiveSync/migration down

$ horde-db-migrate /path/to/framework/ActiveSync/migration up

I don't get such a log (see my log from above) but the aiding person
said that his log was correct (except for the double PING). Thought this
might be a clue?!

Second:

A thread by Martin Hochreiter with the title "ActiveSync | Android 3.2"

He had the sync working with android 2.3 but with android 3.2 it is
somehow broken and he gets only "no calendars" (from his calendar app I
guess - like me) after configuration. Unfortunately he has some problems
with the logging too and the thread ends with the next post. Giving no
solution for the sync problem (at least not for me).

Can somebody point me into the right direction or provide some insight
if he or she has had the same issue?

Many thanks in advance,
Daniel