[horde] Active Sync Server Error

Mon Jan 27 19:26:32 UTC 2014

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.

-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject

-------------- 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/0663d5fb/attachment.bin>