[sync] [horde] Sync with Funambol

[Paul Faure]

> > My setup is simple.
> > Client (Outlook or iPhone) <-> Server (Horde) <-> DB (mysql)
> 
> Is this the setup when doing the synchronization, i.e. with a SyncML client?

Yea, thats the setup. SyncML client (Funambol) on Outlook or iPhone. 

> > I would imagine this is the most popular setup out there.
> >
> > In order to make my contacts more accessible, I installed OpenLDAP with
> > the DB backend. This is a read only LDAP setup, so you can't modify
> > contacts or add them through LDAP. OpenLDAP simply uses the horde DB to
> > display the contacts.
> >
> > Client (Outlook) <- Server (OpenLDAP) <- DB (mysql)
> 
> But how is Turba accessing the address book? Through SQL or LDAP?

Turba uses SQL. No portion of Horde uses LDAP.

Its OpenLDAP which uses the Horde DB.

> > The one change I had to do to the horde env/setup is the addition of the
> > "id" column in the turba table. This is because the SQL backend for
> > OpenLDAP requires an INT as the unique key.
> > I implemented this setup about 6 months ago and it all worked fine until
> > the recent upgrade.
> 
> And how did you map the column in Turba? To which attribute?

I didnt change the Turba code, so its using the same default column.

> > Could you point me in the direction of where in Horde the UID is
> > generated? I will add all kinds of debug output and track this one down.
> 
> In Turba_Driver::add(), the call to generateUID().

Thanks, I will take a look shortly.

Paul