[horde] Activesync not working

[Michael J Rubinsky]

Quoting Louis-Philippe Allard <lp.allard.1 at gmail.com>:

> Quoting Michael J Rubinsky <mrubinsk at horde.org>:
>>> Quoting Louis-Philippe Allard <lp.allard.1 at gmail.com>:
>>  >
>>  >> Hello,
>>  >>
>>  >>  My Activesync is still not working.  Actually its getting worst. Just
>>  >> upgraded to the latest horde framework with
>>  >>
>>  >>  "pear upgrade -a -B- c horde" and NO errors whatsoever.   
>> Reconfigured the
>>  >> config files and updated the DB schemas.
>>  >>
>>  >>  Symptoms:
>>  >>
>>  >>  Multiple (up to 30+) copies of the same event in Kronolith with exact
>>  >> same properties while there is only one on the iphone;
>>  >>  Most items of my calendar (NOT ALL OF THEM) are being duplicated;
>>  >>  Copies of the same event on the WRONG days;
>>  >>  Some events have wrong hours;
>>  >>  ALL events of the last 3 to 4 months have not been deleted/modified in
>>  >> Kronolith while they were on the iphone;
>>  >>  SOME events of the future have not been deleted/modified in Kronolith
>>  >> while they were on the iphone;
>>  >>
>>  >>  A few months ago, I've mailed this mail-list to inform that I had
>>  >> *severe* problems with activesync, and basically since then, I tried to
>>  >> completely avoid Kronolith because every time I do something  
>> with it and it
>>  >> sync to my iphone, everything gets screwed up.  I must say that contacts
>>  >> are working perfectly, which makes me believe that the problem is
>>  >> kronolith.
>>  >
>>  > Not sure what's going on with your setup, but AS is working perfectly
>>  > for me on many different devices, including iPhone/iPad/iPodTouch.
>>  > Also working fine on my normal day-to-day Android phone. I'm fairly
>>  > hard on my calendar, and edits on the server and/or devices sync fine
>>  > both ways. Something obviously is very broken on your setup.
>>  >
>>  >>  Today I decided to sync clean by deleting the exchange account on the
>>  >> iphone and resync'ing everything.
>>  >>
>>  >>  3 questions:
>>  >>
>>  >>  1-Whats going on?
>>  >
>>  > With what, exactly? If you are asking about the above posted issues,
>>  > I have no idea until I see a *complete* sync log, server log, horde
>>  > log, and possibly wiretrace. As mentioned, this is working fine here.
>>  > Duplicate events are usually due to some error during the sync
>>  > process that prevents the server from recording the sync state. Would
>>  > need to see the above mentioned logs to further track down. No idea
>>  > about the mismatched dates/times. I have not yet come across such a
>>  > bug report yet. Possibly a problem with timezones, datetime format
>>  > being stored in the database.
>>  >
>>  >>  2-How do I delete several events at the same time?
>>  >
>>  > From Kronolith? You can't. You can manually remove the event entries
>>  > from the kronolith_events table if you like, though.
>>  >
>>  >>  3-How do I export the calendar? The Import/Export menu entry  
>> is supposed
>>  >> to be there but unless I am becoming blind, I cant see it...
>>  >
>>  > From the dynamic interface, it's on the calendar detail dialog (click
>>  > on the arrow to the right of the calendar name in the sidebar). From
>>  > the traditional interface, it's an application menu item.
>>  >
>>  >>  When I successfully export my calendar I will try to re-sync with my
>>  >> iphone and send the AS log to this maillist.
>>  >
>>  > Could also be potentially corrupt data in kronolith. You can try
>>  > creating some new events on a fresh calendar, or alternatively try
>>  > importing only a few of your events one at a time to see if one of
>>  > the events is triggering the errors.
>>  >
>>  > --
>>  > mike
>>  >
>>  > The Horde Project (www.horde.org[1])
>>  > mrubinsk at horde.org
>>  >
>>  > --
>>  > Horde mailing list
>>  > Frequently Asked Questions: http://horde.org/faq/
>>  > To unsubscribe, mail: horde-unsubscribe at lists.horde.org
> OK more testing:
>
>  From a clean slate (all info deleted on iphone, I even deleted the
> exchange account on it), and everything OK in kronolith (after a lenghty
> and very painful cleanup of my calendar, I re-added the exchange account
> and re-activated the sync with my calendar & contacts.
>
> Results:
>
> The calendar on kronolith stayed intact while the calendar in iphone is
> all screwed up (missing events, weeks completely blanked, wrong dates,
> etc...).
>
>    My conclusion: it still does not work.
>
>    Attached is the AS log (I deleted the log prior to retrying clean) so
> you wont see anything relating to past attempts.
>    I will attach the horde general log if need be, but its well over 35MB..
>    Anything else please ask.


Thanks for the log. Nothing seems to be wrong at the protocol level. I  
notice the uids of the entries seem to suggest that these entries  
originated from a KDE calendar app. It's possible something was messed  
up with the calendar data on import into Horde. Have you tried  
creating a new calendar like I suggested? I would try a new calendar  
with just a few of your entries added via Kronolith, i.e., not  
imported. See if the error(s) still occur or not. If they do not  
occur, it's likely a data corruption issue from the KDE data.

You could also send me the (Kronolith) .ics export of your data and I  
can see if I can reproduce your issues with your current data.

-- 
mike

The Horde Project (www.horde.org)
mrubinsk at horde.org