[horde] Horde 5.1.1 problems with ActiveSync on Android
Simon Wilson
simon at simonandkate.net
Tue Jul 16 02:44:54 UTC 2013
>>>>>> I upgraded from 5.0.1 to 5.1.1 today.
>>>>>> Now Activesync doesn't work anymore as expected. Mail syncs
>>>>>> fine, contacts and calendars do not.
>>>>>> I lost all contacts and calendars on the android devices. They
>>>>>> are still available in Horde, but don't sync.
>>>
>>> Same Problem here. Everything syncs except the Contacts. This used
>>> to work before.
>>>>>>
>>>>>> I am using two different Android clients for testing, both
>>>>>> running different versions of Cyanogen Mod.
>>>>>> They used to sync fine with 5.0.1.
>>>>>
>>>>> Cannot reproduce. Works fine for me with numerous versions of
>>>>> Android, both stock and CM.
>>>>>
>>>>> Any errors in the server log, horde log? What does the
>>>>> activesync log show?
>>>>>
>>>
>>> Not sure if this is the same problem;
>>> I tried to sync a turba adressbook with only one contact via activesync.
>>> The synclog stops after the provisioning is done. Nothing more is logged.
>>>
>>> I'm syncing to a xperia z with android 4.2.2.
>>>>>
>>>>>
>>>>
>>>> I investigated a bit further.
>>>> Wiped my android, and just enabled contacts sync.
>>>> This happens when trying to sync contacts:
>>>>
>>>> http://pastebin.com/AF38BYS2
>>>>
>>>> Maybe this error is relevant?
>>>> (Line 180)
>>>> 2013-07-10T15:10:51+00:00 NOTICE: [8428] Error saving state for
>>>> synckey {51dd790e-4830-4ca4-91e6-20ebc0a80102}2: QUERY FAILED:
>>>> Duplicate entry '{51dd790e-4830-4ca4-91e6-20ebc0a80102}2' for key
>>>> 'PRIMARY'
>>>>
>>>> This is how a request in Apache looks like:
>>>> Android ActiveSync Client is Android/4.1.2-EAS-1.3
>>>>
>>>> 62.143.158.113 - myserver.dyndns.org\\mailbox
>>>> [10/Jul/2013:17:10:38 +0200] "POST
>>>> /Microsoft-Server-ActiveSync?Cmd=Sync&User=myserver.dyndns.org%5Cmailbox&DeviceId=androidc1491253035&DeviceType=Android HTTP/1.1" 200 585 "-"
>>>> "Android/4.1.2-EAS-1.3"
>>>>
>>>> Because i completely wiped my phone I think it must be a change
>>>> in Horde from 5.0.1 to 5.1.1 that broke it somehow for me.
>>>> It worked great for a long time before.
>>>>
>>>> Thanks for any input.
>>>>
>>> For the moment i sync my contacts via the new CardDav Service.
>>> This works perfectly.
>>>>
>>>>
>>>>
>>>>
Happening to me also.
I reset the device's AS connection as part of checking something else,
and Contacts no longer Sync at all to the Android device. Still sync
to iPad OK. Email, tasks, calendar appear to sync fine.
I did a second delete / reset on the phone's AS horde connection, and
re-enabled with just Contacts, and still nothing.
Horde error log shows an SQL QUERY FAILED error for the INSERT INTO
horde_activesync_state, followed by an enormous list of \"NewMessage\"
entries for what looks like each of my contacts. Here is an extract:
2013-07-16T01:33:36+00:00 ERR: HORDE [horde] SQL QUERY FAILED:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry
'{51e498a8-a9e4-439e-a493-0b3dc0a801e6}2' for key 'PRIMARY'
INSERT INTO horde_activesync_state (sync_key, sync_data, sync_devid,
sync_time, sync_folderid, sync_user, sync_pending) VALUES
('{51e498a8-a9e4-439e-a493-0b3dc0a801e6}2',
'O:34:"Horde_ActiveSync_Folder_Collection":4:{s:15:"haveInitialSync";b
:1;s:10:"*_status";a:0:{}s:12:"*_serverid";s:10:"@Contacts@";s:9:"
*_class";s:8:"Contacts";}', 'SEC10D1C297BE813', 1373938414,
'@Contacts@', 'simon',
'a:361:{i:0;a:3:{s:2:\"id\";s:60:\"20130311055925.-LOYZLAqDHeVWI5o1ubL
uw5 at mail.simonandkate.net\";s:4:\"type\";s:6:\"change\";s:5:\"flags\";
s:10:\"NewMessage\";}i:1;a:3:{s:2:\"id\";s:62:\"20130129094340.XFDFhY9
RNmOQJmbNuE1bJQ4 at server.simonandkate.net\";s:4:\"type\";s:6:\"change\"
;s:5:\"flags\";s:10:\"NewMessage\";}i:2;a:3:{s:2:\"id\";s:62:\"2013012
9094340.nrhEoNigM5oS60dsxbLT6A2 at server.simonandkate.net\";s:4:\"type\"
;s:6:\"change\";s:5:\"flags\";s:10:\"NewMessage\";}i:3;a:3:{s:2:\"id\"
;s:62:\"20130129094341.XLaIPJnNhrOyHhJ6bJ-e7Q2 at server.simonandkate.net
The phone AS debug log shows what appears to be the first 6 entries
sync to the device (but which never actually show on the device), then
stops with 361 to go with this:
2013-07-16T02:13:26+00:00 INFO: [1609] Updating state during change
2013-07-16T02:13:26+00:00 DEBUG: [1609] O </Commands>
2013-07-16T02:13:26+00:00 INFO: [1609] Saving state: Array
(
[0] => {51e4ac44-eb80-4b09-ab9f-064dc0a801e6}2
[1] => Horde_Db_Value_Binary Object
(
[_value:protected] =>
O:34:"Horde_ActiveSync_Folder_Collection":4:{s:15:"haveInitialSync";b:1;s:10:"
)
[2] => SEC10D1C297BE813
[3] => 1373940805
[4] => @Contacts@
[5] => simon
[6] => 361
)
2013-07-16T02:13:26+00:00 DEBUG: [1609] O </Folder>
2013-07-16T02:13:26+00:00 DEBUG: [1609] O </Folders>
2013-07-16T02:13:26+00:00 DEBUG: [1609] O </Synchronize>
2013-07-16T02:13:26+00:00 INFO: [1609] Replacing SYNC_CACHE entry for
user simon and device SEC10D1C297BE813:
a:11:{s:18:"confirmed_synckeys";a:1:{s:39:"{51e4ac44-eb80-4b09-ab9f-064dc0a801e6}2";b:1;}s:17:"lasthbsyncstarted";i:1373940634;s:17:"lastsyncendnormal";i:1373940806;s:9:"timestamp";s:10:"1373940806";s:4:"wait";b:0;s:10:"hbinterval";b:0;s:7:"folders";a:103:{s:8:"fb8437b7";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:11:"INBOX/Trash";}s:8:"f78d5bbf";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:40:"INBOX/Saved Emails/Computer Stuff/Bacula";}s:8:"f53a087b";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:13:"user/benjamin";}s:8:"f378939c";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:31:"INBOX/Saved Emails/Vet Supplies";}s:8:"efba87b7";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:66:"INBOX/Saved Emails/Computer Stuff/Mailing Lists/Horde/BugsHordeOrg";}s:8:"ed6da38b";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:27:"INBOX/Saved
Emails/Jobs/SMS";}s:8:"ec9e70b4";a:2:{s:5:"cl
ass";s:5:"Email";s:8:"serverid";s:23:"INBOX/Saved
Emails/Jobs";}s:8:"ebc50e25";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:13:"user/chiarina";}s:8:"eb9d2531";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:48:"INBOX/Saved Emails/Finances/Colonial First State";}s:8:"e9e0fc0f";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:48:"INBOX/Saved Emails/Software Serials and Receipts";}s:8:"e91c0573";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:39:"INBOX/Saved Emails/MTG/Shipping advices";}s:8:"e804b887";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:49:"INBOX/Saved Emails/Real Estate/LJ Hooker Stafford";}s:8:"e59a7912";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:11:"user/server";}s:8:"e57c6070";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:26:"user/chiarina/Saved Emails";}s:8:"e0e3da23";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:30:"INBOX/Saved Emails/Family Tree";}s:8:"e04ee1cb";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:30:"INBOX/Saved
Emails/Photography";}s:8:"de08ab14";a:2:
{s:5:"class";s:5:"Email";s:8:"serverid";s:24:"INBOX/Saved
Emails/Legal";}s:8:"dba9fd6f";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:19:"user/benjamin/Trash";}s:8:"db43842b";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:27:"INBOX/Saved Emails/Holidays";}s:8:"d8c899d1";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:46:"INBOX/Saved Emails/Finances/Salary Sacrificing";}s:8:"d7d1f9b6";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:25:"user/server/Deleted Items";}s:8:"d5cc415f";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:47:"INBOX/Saved Emails/Computer Stuff/Mailing Lists";}s:8:"cdf322d0";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:33:"INBOX/Saved Emails/Computer Stuff";}s:8:"ca740763";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:26:"INBOX/Saved Emails/Shipito";}s:8:"c83146f8";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:43:"INBOX/Saved Emails/Finances/Company Pty Ltd";}s:8:"c819441b";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:45:"INBOX/Saved Emails/Computer
Stuff/Google
Play";}s:8:"c2222c89";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:55:"INBOX/Saved Emails/Computer Stuff/Mailing Lists/Amavisd";}s:8:"bf17abc8";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:41:"INBOX/Saved Emails/MTG/eBay Confirmations";}s:8:"bdd8a6a4";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:51:"INBOX/Saved Emails/Computer Stuff/Mailing Lists/KVM";}s:8:"bca39b28";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:36:"INBOX/Saved Emails/Family Tree/Filed";}s:8:"bb59aae8";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:18:"user/chiarina/Yoyo";}s:8:"b8e9ebc3";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:20:"user/benjamin/Drafts";}s:8:"b7c1f340";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:18:"user/server/Drafts";}s:8:"b6fc10a2";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:14:"user/dom/Trash";}s:8:"b2985e34";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:5:"INBOX";}s:8:"aace75e9";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:39:"INBOX/Saved Emails/MTG/Wizards
Cupboard";}s:8:"a
8772e43";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:26:"INBOX/Saved
Emails/MTG/RCW";}s:8:"a589b6be";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:23:"INBOX/Saved Emails/Home";}s:8:"a4641f48";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:53:"INBOX/Saved Emails/Computer Stuff/Mailing Lists/Horde";}s:7:"@Tasks@";a:2:{s:5:"class";s:5:"Tasks";s:8:"serverid";s:7:"@Tasks@";}s:7:"@Notes@";a:2:{s:5:"class";s:5:"Notes";s:8:"serverid";s:7:"@Notes@";}s:10:"@Contacts@";a:2:{s:5:"class";s:8:"Contacts";s:8:"serverid";s:10:"@Contacts@";}s:10:"@Calendar@";a:2:{s:5:"class";s:8:"Calendar";s:8:"serverid";s:10:"@Calendar@";}s:8:"9eae853d";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:8:"user/dom";}s:8:"9ba0de53";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:21:"user/dom/Saved Emails";}s:8:"9a064919";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:33:"INBOX/Saved Emails/ISPs and Email";}s:8:"99043ab1";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:27:"INBOX/Saved
Emails/Personal";}s:8:"98cef338";
a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:13:"user/dom/Sent";}s:8:"987e7b09";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:20:"user/chiarina/Drafts";}s:8:"96d1dd3e";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:49:"INBOX/Saved Emails/Computer Stuff/Postfix Reports";}s:8:"946182cb";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:31:"INBOX/Saved Emails/Jobs/Aurizon";}s:8:"910fd78c";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:18:"user/benjamin/Spam";}s:8:"8db30557";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:18:"INBOX/Saved Emails";}s:8:"8ce7693b";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:31:"INBOX/Saved Emails/Personal/CSU";}s:8:"8ae4829a";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:30:"INBOX/Saved Emails/VA Personal";}s:8:"8a6cd170";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:41:"INBOX/Saved Emails/Family Tree/For
Action";}s:8:"85802c02";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:15:"user/dom/Drafts";}s:8:"84f4a4e3";a:2:{s:5:"class";s:5:"Email";s:8:"serverid"
;s:13:"user/dom/Spam";}s:8:"82f990a6";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:17:"user/server/Trash";}s:8:"818c2b55";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:43:"INBOX/Saved Emails/MTG/Decks and Collection";}s:8:"80a44576";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:22:"INBOX/Saved Emails/ACS";}s:8:"7a93cba1";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:27:"INBOX/Saved Emails/MTG/WOTC";}s:8:"77c53b19";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:25:"INBOX/Saved Emails/Amazon";}s:8:"76053c87";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:31:"INBOX/Saved Emails/MTG/Receipts";}s:8:"740074a2";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:39:"INBOX/Saved Emails/Computer Stuff/Apple";}s:8:"716be95d";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:38:"INBOX/Saved Emails/Jobs/Robert Walters";}s:8:"6f59fb8b";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:10:"INBOX/Spam";}s:8:"6f3cd6b9";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:26:"INBOX/Saved
Emails/Cars/VW";}s:8:"6d6
d1117";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:33:"INBOX/Saved
Emails/Finances/Bills";}s:8:"6b811a03";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:33:"INBOX/Saved Emails/Amazon/Audible";}s:8:"6adffda1";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:51:"INBOX/Saved Emails/Computer Stuff/Mailing Lists/SPF";}s:8:"69de9be9";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:28:"INBOX/Saved Emails/MyNetFone";}s:8:"657c0203";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:38:"INBOX/Saved Emails/Website Memberships";}s:8:"64d3fbad";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:10:"INBOX/Sent";}s:8:"64b33fa7";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:19:"user/chiarina/Trash";}s:8:"6442774c";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:55:"INBOX/Saved Emails/Computer Stuff/Mailing Lists/Postfix";}s:8:"62be66e9";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:57:"INBOX/Saved Emails/Computer Stuff/Mailing
Lists/LMSensors";}s:8:"60421dc8";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:
27:"INBOX/Saved
Emails/Cars/BMW";}s:8:"5b24437e";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:18:"user/benjamin/Sent";}s:8:"572d15ee";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:26:"user/benjamin/Saved Emails";}s:8:"4ffc2030";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:18:"user/chiarina/Sent";}s:8:"4dedd617";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:27:"INBOX/Saved Emails/Railways";}s:8:"4b4ba0ad";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:39:"INBOX/Saved Emails/Finances/Accountants";}s:8:"47d51059";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:37:"INBOX/Saved Emails/MTG/Games Paradise";}s:8:"428893e4";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:29:"INBOX/Saved Emails/MTG/Orders";}s:8:"40bffb5e";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:42:"INBOX/Saved Emails/Computer Stuff/Logwatch";}s:8:"3e9931cc";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:16:"user/server/Spam";}s:8:"3b30bae6";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:68:"INBOX/Saved
Emails/Compute
r Stuff/Mailing Lists/Horde/Archived
Horde";}s:8:"383d1861";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:23:"INBOX/Saved Emails/eBay";}s:8:"354737e3";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:23:"INBOX/Saved Emails/Cars";}s:8:"33e14b67";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:36:"INBOX/Saved Emails/Finances/Receipts";}s:8:"2b6919d8";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:44:"INBOX/Saved Emails/Real Estate/Cressbrook St";}s:8:"252f0282";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:33:"INBOX/Saved Emails/MTG/eBay other";}s:8:"235fcbcd";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:60:"INBOX/Saved Emails/Computer Stuff/Mailing Lists/SpamAssassin";}s:8:"21b4b17b";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:26:"INBOX/Saved Emails/Parking";}s:8:"207fc547";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:30:"INBOX/Saved Emails/Real Estate";}s:8:"1f3803af";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:27:"INBOX/Saved
Emails/Finances";}s:8:"1be21ab4";a:2:{s:5:"class
";s:5:"Email";s:8:"serverid";s:29:"INBOX/Saved
Emails/Cars/Mazda";}s:8:"18a72080";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:12:"INBOX/Drafts";}s:8:"16a0b639";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:18:"user/chiarina/Spam";}s:8:"07cd899e";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:31:"INBOX/Saved Emails/Finances/NAB";}s:8:"023b7be3";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:16:"user/server/Sent";}s:8:"011a48e2";a:2:{s:5:"class";s:5:"Email";s:8:"serverid";s:22:"INBOX/Saved
Emails/MTG";}}s:9:"hierarchy";s:39:"{51e4ac3d-1b70-4f5b-ab50-0cbdc0a801e6}1";s:11:"collections";a:1:{s:10:"@Contacts@";a:11:{s:5:"class";s:8:"Contacts";s:10:"windowsize";s:1:"5";s:10:"truncation";i:0;s:11:"mimesupport";i:0;s:14:"mimetruncation";i:8;s:8:"conflict";i:1;s:9:"bodyprefs";a:1:{i:1;a:2:{s:4:"type";s:1:"1";s:14:"truncationsize";s:6:"400000";}}s:8:"serverid";s:10:"@Contacts@";s:11:"lastsynckey";s:39:"{51e4ac44-eb80-4b09-ab9f-064dc0a801e6}2";s:14:"deletesasmoves";b:1;s:10:"filtertype"
;s:1:"0";}}s:13:"pingheartbeat";b:0;s:14:"synckeycounter";a:1:{s:10:"@Contacts@";a:1:{s:39:"{51e4ac44-eb80-4b09-ab9f-064dc0a801e6}1";i:1;}}}
2013-07-16T02:13:26+00:00 INFO: [1609] User simon logged off
I will post up the full log files later on.
Simon.
--
Simon Wilson
M: 0400 12 11 16
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-keys
Size: 1339 bytes
Desc: PGP Public Key
URL: <http://lists.horde.org/archives/horde/attachments/20130716/06183673/attachment-0002.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: PGP Digital Signature
URL: <http://lists.horde.org/archives/horde/attachments/20130716/06183673/attachment-0003.bin>
More information about the horde
mailing list