[sync] BlackBerry and Two-Way Sync

[list at cykotix.com]

Quoting list at cykotix.com:

> Quoting Patrick Lahni <list at cykotix.com>:
>
>> I appear to have fixed it!  I went back through and stripped any  
>> non-essential data from horde_cache, horde_histories,  
>> horde_histories_seq, horde_sessionhandler, horde_syncml_anchors,  
>> horde_syncml_map, horde_tokens, horde_vfs, horde_vfs_seq.  Low and  
>> behold it seems to be working.  New contacts get the Created field.  
>>  Existing contacts though do not have the Created field.  However,  
>> once I go through and resave them, they get the Last Modified field.
>>
>> Weird, eh?
>
> I've spoken too soon.  I am able to sync calendar/notes/tasks now  
> (though with some oddities and duplication at times), but it seems  
> to work after I try updating on both ends a couple of times.
>
> Contacts are still proving to be a royal pain.  However, I think it  
> is almost working:
>
>
> DEBUG:  Backend of class SyncML_Backend_Horde created
> DEBUG:  Started at 2009-07-21 14:35:36. Packet logged in  
> /tmp/sync/client_2530.xml
> DEBUG:  New session created: f7df89a9e23a2728c73299f2987332b6
> DEBUG:  Checking authentication for user user at xxx.com
> DEBUG:  Authenticated: yes; version: 1.2; message ID: 1; source URI:  
> fbb-817125350; target URI: https://xxx.xxx.com/rpc.php; user:  
> user at xxx.com; charset: UTF-8; wbxml: no
> DEBUG:  SQL Query by SyncML_Backend_Horde::readSyncAnchors(): SELECT  
> syncml_clientanchor, syncml_serveranchor FROM horde_syncml_anchors  
> WHERE syncml_syncpartner = ? AND syncml_db = ? AND syncml_uid = ?,  
> values: fbb-817125350, contacts, user at xxx.com
> DEBUG:  Previous sync found for database card; client timestamp:  
> 1248199115023
> DEBUG:  Anchor timestamps match, TwoWaySync possible. Syncing data  
> since 2009-07-21 14:00:45
> DEBUG:  Creating SyncML_Sync object for database card; sync type 200
> DEBUG:  Received <Final> from client.
> DEBUG:  Handle <Final> for state Init
> DEBUG:  Sending <Final> to client
> DEBUG:  Return message completed
> DEBUG:  Finished at 2009-07-21 14:35:37. Packet logged in  
> /tmp/sync/server_2530.xml
>
> DEBUG:  Backend of class SyncML_Backend_Horde created
> DEBUG:  Started at 2009-07-21 14:35:44. Packet logged in  
> /tmp/sync/client_2531.xml
> DEBUG:  Existing session continued: f7df89a9e23a2728c73299f2987332b6
> DEBUG:  Authenticated: yes; version: 1.2; message ID: 2; source URI:  
> fbb-817125350; target URI: https://xxx.xxx.com/rpc.php; user:  
> user at xxx.com; charset: UTF-8; wbxml: no
> DEBUG:  Created device class SyncML_Device_Sync4j
> DEBUG:  Received <Final> from client.
> DEBUG:  Handle <Final> for state Sync
> DEBUG:  Creating <Sync> output for server changes in database card
> DEBUG:  Created device class SyncML_Device_Sync4j
> DEBUG:  Compiling server changes from 2009-07-21 14:00:45 to  
> 2009-07-21 14:35:37
> DEBUG:  SQL Query by SyncML_Backend_Horde::_getChangeTS(): SELECT  
> syncml_timestamp FROM horde_syncml_map WHERE syncml_syncpartner = ?  
> AND syncml_db = ? AND syncml_uid = ? AND syncml_suid = ?, values:  
> fbb-817125350, contacts, user at xxx.com,  
> 20090721140202.11051nz9l8sy18cg at xxx.xxx.com
> DEBUG:  Added to server from client:  
> 20090721140202.11051nz9l8sy18cg at xxx.xxx.com ignored
> DEBUG:  SQL Query by SyncML_Backend_Horde::_getChangeTS(): SELECT  
> syncml_timestamp FROM horde_syncml_map WHERE syncml_syncpartner = ?  
> AND syncml_db = ? AND syncml_uid = ? AND syncml_suid = ?, values:  
> fbb-817125350, contacts, user at xxx.com,  
> 20090721140202.63851yi2f67y8z9c at xxx.xxx.com
>
> [snip, much more of that same type entry]
>
> DEBUG:  Adding to client from db contacts, server id  
> 20090721140648.17794j6z0zcatta8 at xxx.xxx.com
> DEBUG:  SQL Query by SyncML_Backend_Horde::_getChangeTS(): SELECT  
> syncml_timestamp FROM horde_syncml_map WHERE syncml_syncpartner = ?  
> AND syncml_db = ? AND syncml_uid = ? AND syncml_suid = ?, values:  
> fbb-817125350, contacts, user at xxx.com,  
> 20090721140202.25067bwebpfg6pcs at user.xxx.com
> DEBUG:  SQL Query by SyncML_Backend_Horde::_getCuid(): SELECT  
> syncml_cuid FROM horde_syncml_map WHERE syncml_syncpartner = ? AND  
> syncml_db = ? AND syncml_uid = ? AND syncml_suid = ?, values:  
> fbb-817125350, contacts, user at xxx.com,  
> 20090721140202.25067bwebpfg6pcs at xxx.xxx.com
> DEBUG:  Modifying on client from db contacts, client id 1146025301  
> -> server id 20090721140202.25067bwebpfg6pcs at xxx.xxx.com
> DEBUG:  Sending 2 server changes for client URI card
> DEBUG:  Sending add from server: 20090721140648.17794j6z0zcatta8 at xxx.xxx.com
> DEBUG:  Created device class SyncML_Device_Sync4j
> DEBUG:  Sending replace from server:  
> 20090721140202.25067bwebpfg6pcs at xxx.xxx.com
> DEBUG:  Created device class SyncML_Device_Sync4j
> DEBUG:  Sending <Final> to client
> DEBUG:  Return message completed
> DEBUG:  Finished at 2009-07-21 14:35:44. Packet logged in  
> /tmp/sync/server_2531.xml
>
> I modified 1 entry and added another server side, yet they are not  
> updating on the device.  Logging is set to ERROR and the device log  
> is empty.
>
> Any ideas where to run with this?

Been a couple of days with me tinkering with this to no avail.  Still  
getting the same behavior.  Any thoughts on this?

-Patrick


----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.