[horde] Active Sync Server Error

Mon Jan 27 21:53:13 UTC 2014

Citeren Michael J Rubinsky <mrubinsk at horde.org>:

> Quoting Andreas Mauser <andreas at mauser.info>:
>
>> ----- Nachricht von Michael J Rubinsky <mrubinsk at horde.org> ---------
>>     Datum: Mon, 27 Jan 2014 13:50:40 -0500
>>       Von: Michael J Rubinsky <mrubinsk at horde.org>
>> Antwort an: mrubinsk at horde.org
>>   Betreff: Re: [horde] Active Sync Server Error
>>        An: Andreas Mauser <andreas at mauser.info>
>>        Cc: horde at lists.horde.org
>>
>>
>>> Quoting Andreas Mauser <andreas at mauser.info>:
>>>
>>>> ----- Nachricht von Michael J Rubinsky <mrubinsk at horde.org> ---------
>>>>   Datum: Mon, 27 Jan 2014 13:29:29 -0500
>>>>     Von: Michael J Rubinsky <mrubinsk at horde.org>
>>>> Antwort an: mrubinsk at horde.org
>>>> Betreff: Re: [horde] Active Sync Server Error
>>>>      An: Andreas Mauser <andreas at mauser.info>
>>>>      Cc: horde at lists.horde.org
>>>>
>>>>
>>>>> Quoting Andreas Mauser <andreas at mauser.info>:
>>>>>
>>>>>> ----- Nachricht von Michael J Rubinsky <mrubinsk at horde.org> ---------
>>>>>> Datum: Mon, 27 Jan 2014 12:39:35 -0500
>>>>>>   Von: Michael J Rubinsky <mrubinsk at horde.org>
>>>>>> Antwort an: mrubinsk at horde.org
>>>>>> Betreff: Re: [horde] Active Sync Server Error
>>>>>>    An: Andreas Mauser <andreas at mauser.info>
>>>>>>    Cc: horde at lists.horde.org
>>>>>>
>>>>>>
>>>>>>> Quoting Andreas Mauser <andreas at mauser.info>:
>>>>>>>
>>>>>>>> ----- Nachricht von Michael J Rubinsky <mrubinsk at horde.org> ---------
>>>>>>>> Datum: Mon, 27 Jan 2014 09:17:00 -0500
>>>>>>>> Von: Michael J Rubinsky <mrubinsk at horde.org>
>>>>>>>> Antwort an: mrubinsk at horde.org
>>>>>>>> Betreff: Re: [horde] Active Sync Server Error
>>>>>>>>  An: Andreas Mauser <andreas at mauser.info>
>>>>>>>>  Cc: horde at lists.horde.org
>>>>>>>>
>>>>>>>>
>>>>>>>>> Quoting Andreas Mauser <andreas at mauser.info>:
>>>>>>>>>
>>>>>>>>>> ----- Nachricht von mrubinsk at horde.org ---------
>>>>>>>>>> Datum: Sun, 26 Jan 2014 13:40:53 -0500
>>>>>>>>>> Von: mrubinsk at horde.org
>>>>>>>>>> Betreff: RE: [horde] Active Sync Server Error
>>>>>>>>>> An: Andreas Mauser <andreas at mauser.info>
>>>>>>>>>> Cc: horde at lists.horde.org
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>> No idea then.  The error message indicates the calendar  
>>>>>>>>>>> can either not be found or the user does not have  
>>>>>>>>>>> permissions on it.  
>>>>>>>>>>
>>>>>>>>>> Hm, I am using my calender and it does sync OK.
>>>>>>>>>>
>>>>>>>>>> Is this the emssage you refer to which tells that it is a  
>>>>>>>>>> calender which is .. inaccessible oder missing?:
>>>>>>>>>>
>>>>>>>>>> Jan 26 22:03:12 web HORDE: [kronolith] Share name  
>>>>>>>>>> bARQ8EIvnCJ4Iu2ptfZOdg1 not found [pid 2213 on line 199 of  
>>>>>>>>>> "/usr/share/pear/Horde/Share/Base.php"]
>>>>>>>>>> Jan 26 22:03:12 web HORDE: [horde] Returning HTTP 500 while  
>>>>>>>>>> handling Sync command. [pid 2213 on line 156 of  
>>>>>>>>>> "/var/www/html/mauser.info/mailoffice/rpc.php"]
>>>>>>>>>> Jan 26 22:03:12 web HORDE: [horde] Error in communicating  
>>>>>>>>>> with ActiveSync server: Permission Denied [pid 2213 on line  
>>>>>>>>>> 162 of "/usr/share/pear/Horde/Rpc/ActiveSync.php"]
>>>>>>>>>> Jan 26 22:03:12 web HORDE: [horde] #0 [internal function]:  
>>>>>>>>>> Kronolith_Api->listEvents(1388507558, 1389560592, Array,  
>>>>>>>>>> false, false, false, true, false)
>>>>>>>>>
>>>>>>>>> Yes.
>>>>>>>>>
>>>>>>>>>> I cannot remember a calender which has been modified in a  
>>>>>>>>>> way that such a problem could occur.
>>>>>>>>>> Can I check/set permissions in the Horde Permissions?
>>>>>>>>>
>>>>>>>>> It is done in Kronolith's calendar view. Though you need to  
>>>>>>>>> find out which calendar the specified id specifies.
>>>>>>>>
>>>>>>>> Thank you for the hints. I checked the ID of my calender  
>>>>>>>> looking in Calender/Edit/Abbonements to find out the ID.
>>>>>>>>
>>>>>>>> This ID is not the same ID as given in the error message.
>>>>>>>>
>>>>>>>> When I do a search in phpmyadmin I find the ID which is given  
>>>>>>>> in the error message in addition to the real ID of my  
>>>>>>>> personal calender.
>>>>>>>> I do not have more than one calender.
>>>>>>>>
>>>>>>>> How can I tell if this ID is still needed by anything in the  
>>>>>>>> system, and can I safely delete all traces regarding this ID?
>>>>>>>
>>>>>>> Assuming you are using sql for all calendar storage - you  
>>>>>>> should check the kronolith_events table for that calendar_id.
>>>>>>
>>>>>> I do use SQL for all calender storage.
>>>>>> When I check the kronolith-events table I see all the events of  
>>>>>> all users but the ID in error I can not find in this table.
>>>>>>
>>>>>> I find the ID in error in:
>>>>>>
>>>>>> horde_dav_collections
>>>>>> horde_histories
>>>>>> horde_prefs
>>>>>
>>>>> ^^^ This is why I told you to reset the calendar related prefs.  
>>>>> If that calendar does not exist then it should not be set as any  
>>>>> preference.
>>>>
>>>> This is what I did. I went trough all User Settings of Kronolith  
>>>> and saved it all again.
>>>> I clearde horde-cache, and rebooted.
>>>> I have only 1 calender in use, and no additional calenders.
>>>>
>>>> But it did not help.
>>>
>>> If it's still listed in prefs, then something isn't right. Try  
>>> removing the pref manually and recreating the account on the  
>>> device. Otherwise, I don't know what else to tell you.
>>
>>
>> last thing: while recreating the accounts the following came up:
>>
>> Jan 27 20:13:51 web HORDE: [horde] SQL QUERY FAILED:  
>> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate  
>> entry '{52e6afed-b684-438e-9b95-0d350a001807}2' for key 'PRIMARY'
>>
>> Do I need to just search and delete one of them?
>
> No, this is a normal occurrence when the client reissues a request  
> with the same synckey. Could be because the previous response was  
> interrupted, or not understood by the client. The library takes care  
> of cleaning it up.

FWIW, I'm seeing something similar in the horde log (every half hour or so):

2014-01-27T22:43:21+01:00 ERR: horde [horde] SQL QUERY FAILED:  
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry  
'{52e6bdd0-8e90-4592-84dd-1b97c0a8010a}2' for key 'PRIMARY'

I also tried to recreate this account to no avail, it fails to sync  
the calender. This is with the latest Horde packages from PEAR.  
Another device (but identical make & model) used by a different user  
synchronizes with no problem at all.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5849 bytes
Desc: S/MIME Signature
URL: <http://lists.horde.org/archives/horde/attachments/20140127/cff735c6/attachment.bin>