Problem with ICS calendar events

ulysse31 2010-07-21 15:31:13 UTC #1

Hi all,

After upgrading from 1.6.001 to 1.6.003, some users that use the iphone to sync read-only calendar with ICS export, reported me that some events disapeared from their iphone, or doesnt appear.
I checked the .ics of the concerned user and i realize that some events (that has the same name although) have the same “UID:” on the ics, I checked on the database, and yes those events have the same cal_uid, is it normal ? can two different events (event with the same name) can have the same cal_uid/UID ?

Thanks a lot for your help.

Ralf_Becker_Stylite 2010-07-21 15:46:46 UTC #2

Events of a recurring event including exceptions share the same UID.

Why use an export anyway, CalDAV is much easier.

Ralf

Hi all,

After upgrading from 1.6.001 to 1.6.003, some users that use the iphone to
sync read-only calendar with ICS export, reported me that some events
disapeared from their iphone, or doesnt appear.
I checked the .ics of the concerned user and i realize that some events
(that has the same name although) have the same “UID:” on the ics, I checked
on the database, and yes those events have the same cal_uid, is it normal ?
can two different events (event with the same name) can have the same
cal_uid/UID ?

Thanks a lot for your help.

–
Ralf Becker
Director Software Development

Stylite GmbH
[open style of IT]

Morschheimer Strasse 15
67292 Kirchheimbolanden

fon +49 (0) 6352 70629-0
fax +49 (0) 6352 70629-30
mailto: rb@stylite.de

www.stylite.de
www.egroupware.org

Geschäftsführer Andre Keller,
Gudrun Müller, Ralf Becker
Registergericht Kaiserslautern HRB 30575
Umsatzsteuer-Id / VAT-Id: DE214280951

This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first – http://p.sf.net/sfu/sprint-com-first

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

ulysse31 2010-07-22 11:23:14 UTC #3

I use export because GroupDAV is for some reason not working,
It seams to work with an ICal, but on an Iphone the calendar doesn’t appear (IOS 3.1.2 or 4.0).
I have tried both http:///egroupware/caldav.php (IOS 4.0) and http:///egroupware/caldav.php/calendar/ (IOS 3.x).
Here is what I have on the access log for groupdav with IOS 4.0 :
[21/Jul/2010:11:45:31 +0200] “PROPFIND /egroupware/groupdav.php/ HTTP/1.1” 401 91
[21/Jul/2010:11:45:32 +0200] “PROPFIND /egroupware/groupdav.php/ HTTP/1.1” 207 1063
[21/Jul/2010:11:45:32 +0200] “PROPFIND /egroupware/groupdav.php/calendar/ HTTP/1.1” 207 94605
[21/Jul/2010:11:46:22 +0200] “PROPFIND /egroupware/groupdav.php/calendar/ HTTP/1.1” 207 94605
[21/Jul/2010:11:46:54 +0200] “PROPFIND /egroupware/groupdav.php/calendar/ HTTP/1.1” 207 94605
[21/Jul/2010:13:41:06 +0200] “PROPFIND /egroupware/groupdav.php/ HTTP/1.1” 401 91
[21/Jul/2010:13:41:06 +0200] “PROPFIND /egroupware/groupdav.php/ HTTP/1.1” 207 1063
[21/Jul/2010:13:41:07 +0200] “PROPFIND /egroupware/groupdav.php/calendar/ HTTP/1.1” 207 94605
[21/Jul/2010:13:42:31 +0200] “PROPFIND /egroupware/groupdav.php/calendar/ HTTP/1.1” 207 94605
[21/Jul/2010:13:43:01 +0200] “PROPFIND /egroupware/groupdav.php/calendar/ HTTP/1.1” 207 94605
[21/Jul/2010:13:49:35 +0200] “PROPFIND /egroupware/groupdav.php/ HTTP/1.1” 401 91
[21/Jul/2010:13:46:15 +0200] “PROPFIND /egroupware/groupdav.php/calendar/ HTTP/1.1” 207 94605
[21/Jul/2010:13:49:35 +0200] “PROPFIND /egroupware/groupdav.php/ HTTP/1.1” 207 1063
[21/Jul/2010:13:45:33 +0200] “PROPFIND /egroupware/groupdav.php/calendar/ HTTP/1.1” 207 94605
[21/Jul/2010:13:49:36 +0200] “PROPFIND /egroupware/groupdav.php/calendar/ HTTP/1.1” 207 94605
[21/Jul/2010:15:27:42 +0200] “PROPFIND /egroupware/groupdav.php/ HTTP/1.1” 401 91
[21/Jul/2010:15:27:42 +0200] “PROPFIND /egroupware/groupdav.php/ HTTP/1.1” 207 1063
[21/Jul/2010:15:27:46 +0200] “PROPFIND /egroupware/groupdav.php/ HTTP/1.1” 401 91
[21/Jul/2010:15:27:46 +0200] “PROPFIND /egroupware/groupdav.php/ HTTP/1.1” 207 1063
[21/Jul/2010:15:27:47 +0200] “PROPFIND /egroupware/groupdav.php/calendar/ HTTP/1.1” 207 94605
[21/Jul/2010:15:29:41 +0200] “PROPFIND /egroupware/groupdav.php/calendar/ HTTP/1.1” 207 94605
[21/Jul/2010:15:32:01 +0200] “PROPFIND /egroupware/groupdav.php/ HTTP/1.1” 401 91
[21/Jul/2010:15:32:01 +0200] “PROPFIND /egroupware/groupdav.php/ HTTP/1.1” 207 1063
[21/Jul/2010:15:32:06 +0200] “PROPFIND /egroupware/groupdav.php/ HTTP/1.1” 401 91
[21/Jul/2010:15:32:06 +0200] “PROPFIND /egroupware/groupdav.php/ HTTP/1.1” 207 1063
[21/Jul/2010:15:34:00 +0200] “PROPFIND /egroupware/groupdav.php/calendat/ HTTP/1.1” 401 91
[21/Jul/2010:15:34:19 +0200] “PROPFIND /egroupware/groupdav.php/calendat/ HTTP/1.1” 401 91
[21/Jul/2010:15:35:01 +0200] “PROPFIND /egroupware/groupdav.php/calendar/ HTTP/1.1” 401 91
[21/Jul/2010:15:31:23 +0200] “PROPFIND /egroupware/groupdav.php/calendar/ HTTP/1.1” 207 93497
[21/Jul/2010:15:35:20 +0200] “PROPFIND /egroupware/groupdav.php/calendar/ HTTP/1.1” 401 91

I have enabled debug on the code, here is what i got on the error_log :
[Wed Jul 21 15:35:28 2010] [error] [client xxx.xxx.xxx.xxx] groupdav::_parse_path called with (’/calendar/’) id=, app=’’, user=
[Wed Jul 21 15:35:28 2010] [error] [client xxx.xxx.xxx.xxx] groupdav::_parse_path(‘calendar/’) returning false: id=’’, app=‘calendar’, user=‘2287’, user_prefix=’’
[Wed Jul 21 15:35:28 2010] [error] [client xxx.xxx.xxx.xxx] groupdav::PROPFIND: user=‘2287’, app=‘calendar’, id=’’
[Wed Jul 21 15:35:29 2010] [error] [client xxx.xxx.xxx.xxx] groupdav_handler::app_handler(‘calendar’, ‘/egroupware/groupdav.php’, ‘http://egw.example.com/egroupware/groupdav.php/principals/users//’)
[Wed Jul 21 15:35:29 2010] [error] [client xxx.xxx.xxx.xxx] groupdav::: user=‘2287’, app=‘calendar’
[Wed Jul 21 15:36:45 2010] [error] [client xxx.xxx.xxx.xxx] groupdav: $_SERVER=Array([UNIQUE_ID] => 5IfmOcCoCiIAAFF4T3IAAAAP[SCRIPT_URL] => /egroupware/groupdav.php/calendar[SCRIPT_URI] => http://egw.example.com/egroupware/groupdav.php/calendar[HTTP_HOST] => egw.example.com[HTTP_USER_AGENT] => Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.0.19) Gecko/2010033100 Iceweasel/3.0.6 (Debian-3.0.6-3)[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8[HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5[HTTP_ACCEPT_ENCODING] => gzip,deflate[HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7[HTTP_KEEP_ALIVE] => 300[HTTP_CONNECTION] => keep-alive[HTTP_COOKIE] => last_loginid=; last_domain=default; sessionid=c92efdb2c52c39492c42bfff4d940aa1; kp3=iznWSXWXn7kFhKeewrNwLiAf; domain=default; eGW_remember=%40default%3A%3A%3A%3A%3Dv4ewejZ%3A%3A%3A%3Atext[PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin[SERVER_SIGNATURE] => Apache/2.2.3 (Unix) DAV/2 mod_ssl/2.2.3 OpenSSL/0.9.8d PHP/5.2.0 mod_apreq2-20051231/2.5.7 mod_perl/2.0.2 Perl/v5.8.7 Server at egw.example.com Port 80[SERVER_SOFTWARE] => Apache/2.2.3 (Unix) DAV/2 mod_ssl/2.2.3 OpenSSL/0.9.8d PHP/5.2.0 mod_apreq2-20051231/2.5.7 mod_perl/2.0.2 Perl/v5.8.7[SERVER_NAME] => egw.example.com[SERVER_ADDR] => 192.168.10.34[SERVER_PORT] => 80[REMOTE_ADDR] => xxx.xxx.xxx.xxx[DOCUMENT_ROOT] => /opt/lampp/htdocs[SERVER_ADMIN] => admin@example.com[SCRIPT_FILENAME] => /opt/lampp/htdocs/egroupware/groupdav.php[REMOTE_PORT] => 57027[GATEWAY_INTERFACE] => CGI/1.1[SERVER_PROTOCOL] => HTTP/1.1[REQUEST_METHOD] => GET[QUERY_STRING] => [REQUEST_URI] => /egroupware/groupdav.php/calendar[SCRIPT_NAME] => /egroupware/groupdav.php[PATH_INFO] => /calendar[PATH_TRANSLATED] => /opt/lampp/htdocs/calendar[PHP_SELF] => /egroupware/groupdav.php/calendar[PHP_AUTH_USER] => [PHP_AUTH_PW] => xxxxxxxxx[REQUEST_TIME] => 1279719404[argv] => Array()[argc] => 0)
[Wed Jul 21 15:36:45 2010] [error] [client xxx.xxx.xxx.xxx] groupdav::GET(Array([path] => /calendar))
[Wed Jul 21 15:36:45 2010] [error] [client xxx.xxx.xxx.xxx] groupdav::_parse_path called with (’/calendar’) id=, app=’’, user=
[Wed Jul 21 15:36:45 2010] [error] [client xxx.xxx.xxx.xxx] groupdav::_parse_path(‘calendar’) returning false: id=’’, app=‘calendar’, user=‘2287’, user_prefix=’’
[Wed Jul 21 15:36:45 2010] [error] [client xxx.xxx.xxx.xxx] groupdav::PROPFIND(Array([path] => /calendar[depth] => 1))
[Wed Jul 21 15:36:45 2010] [error] [client xxx.xxx.xxx.xxx] groupdav::_parse_path called with (’/calendar’) id=, app=’’, user=
[Wed Jul 21 15:36:45 2010] [error] [client xxx.xxx.xxx.xxx] groupdav::_parse_path(‘calendar’) returning false: id=’’, app=‘calendar’, user=‘2287’, user_prefix=’’
[Wed Jul 21 15:36:45 2010] [error] [client xxx.xxx.xxx.xxx] groupdav::PROPFIND: user=‘2287’, app=‘calendar’, id=’’
[Wed Jul 21 15:36:45 2010] [error] [client xxx.xxx.xxx.xxx] groupdav_handler::app_handler(‘calendar’, ‘/egroupware/groupdav.php’, ‘http://egw.example.com/egroupware/groupdav.php/principals/users//’)
[Wed Jul 21 15:36:45 2010] [error] [client xxx.xxx.xxx.xxx] groupdav::: user=‘2287’, app=‘calendar’
[Wed Jul 21 15:36:45 2010] [error] [client xxx.xxx.xxx.xxx] calendar_groupdav::propfind(/calendar/,Array([path] => /calendar[depth] => 1),2287,)
[Wed Jul 21 15:36:45 2010] [error] [client xxx.xxx.xxx.xxx] calendar_groupdav::propfind(/calendar/,2287,) filter=Array([users] => 2287[start] => 1271079405[end] => 1311255405[enum_recuring] => [daywise] => [date_format] => server[show_rejected] => 1)
[Wed Jul 21 15:38:53 2010] [error] [client xxx.xxx.xxx.xxx] calendar_groupdav::propfind_callback(/calendar/) took 128.841967821 to return 83 items
[Wed Jul 21 15:38:55 2010] [error] [client xxx.xxx.xxx.xxx] calendar_groupdav::propfind_callback(/calendar/) took 1.43781709671 to return 0 items

But I found nothing on it that could give me a clue on what is going wrong.
Actually users use ics export, if someone can give me a working groupdav, why not. but AFAIK it is not functionnal (and from what i read on the forum/bug report, I am not the only one).
To return to my main problem, the two event that i have found with the same UID are have the same name, but one is a recurring event, the other is not (the user told me they are distinct events they just have the same name but one appends only 1 time on a wednesday the other was a recurring event all the fridays).

ulysse31 2010-09-30 10:51:39 UTC #4

Ok,

Ok, I finally got it working on caldav (the web server was to slow answering the iphone caldav answers => new server => working), but i steel have the same problem some events does not show up (in ics or in caldav).
With EGW 1.6, there is a bug on the recurring events, a modified event thru the web interface is not sync’ed to the iphone, to reproduce the bug :

Go to the web interface => calendar application.
create a new event with recurring for example every weeks during 2 months.
go to the event next week, edit it with exception (only this event of the recurrence).
change something (ex: the name or participantes …).

if you check the event on your Iphone, you have the repeated event but the not edited one, it just wont appear on the iphone.
After long hours of research and tests, here is what I have found :
when a recurring event is create a new element in the table egw_cal is created with a unique cal_id (of course) and a cal_uid like : calendar-<cal_id>-, when you edit only one element of the recurrence, a new element is created with a unique cal_id BUT with the same cal_uid then the recurrence. the cal_uid for that new element does not match calendar-<cal_id>- ! the result is that when a groupdav/ICS client sync the elements it gives him multiple events with the same UID ! which is bad.
the only way i have found to correct that is to edit directly the mysql database and regenerate the cal_uid to match with is cal_id (and set cal_reference to 0, don’t know exactly what it is, i suppose it is a reference to the recurrence that it belongs to … but it is not implemented on the groupdav app …).

Can someone give me confirmations of this problem, or does someone knows how to correct that problem ? I mean in a usable way (other than telling the users to not modify a single element of a recurrence, and tell them to delete an element and recreate a new one if the really need to change one occurrence) ?
Thanks,

yann 2010-10-20 10:13:36 UTC #5

We have still problem with IOS 4 and Caldav sync with egroupware

Our caldav was working well before the update of Egroupware 1.6.003 and/or the update of IOS 4but, on the iphone (we don’t know which one) .

Important point 1: Caldav was working with egroupware 1.6.002 and IOS 3 only with Wifi. (it didn’t work with Edge or 3G)
Important point 2: Apple’s support (bug level 2) told us that it was because of egroupware and refuse to inspect more

The problem : I can create on the iphone the Caldav account with a right validation BUT the Calendar doesn’t appear in the list after. So I can’t view it in the iphone’s calendar App:

Step 1: CalDAV account creation on Iphone

Server: www.example.com
User: john.smith
Password: *****
Advanced :

No SSL
Port 80
Url: http://www.example.com:80/egroupware/groupdav.php/calendar

note: I have tried also with http://www.example.com:80/egroupware/groupdav.php , same result

Step 2: Validation of the new account

I click on “Register”, The iPhone accepts the new account

Step 3: Calendar not listed

I click on on the Iphone’s Calendar App And the egroupware calendar doesn’t appear

Anything has changed in eGroupWare’s CalDAV with the upgrade ? Any idea how to make the calendar appear in the list ?

Ralf_Becker_Stylite 2010-10-21 07:59:35 UTC #6

We had yesterday an intensive bug fixing session yesterday with iPhone
OS 4.0.1, 4.1 and 4.2beta as well as current contacts and iCal app from
Snow Leopard.

The fixes are currently only in Trunk, but they will be ported to EPL
10.1 and 1.8 today.