Bug 254525 - US DST 2007 Timezone Changes not in Evolution
Summary: US DST 2007 Timezone Changes not in Evolution
Status: RESOLVED FIXED
Alias: None
Product: openSUSE 10.2
Classification: openSUSE
Component: Evolution (show other bugs)
Version: Final
Hardware: 32bit Other
: P5 - None : Major (vote)
Target Milestone: ---
Assignee: Forgotten User ex4EZfzxBL
QA Contact: Akhil Laddha
URL:
Whiteboard:
Keywords: calendar
Depends on:
Blocks:
 
Reported: 2007-03-14 16:13 UTC by John Ellis
Modified: 2007-08-22 06:45 UTC (History)
1 user (show)

See Also:
Found By: Customer
Services Priority:
Business Priority:
Blocker: ---
Marketing QA Status: ---
IT Deployment: ---


Attachments
Screenshot of Calendar Errors (108.30 KB, image/jpeg)
2007-03-14 16:15 UTC, John Ellis
Details
Patch for New York only (547 bytes, patch)
2007-03-19 16:10 UTC, John Ellis
Details | Diff
Sample meeting that is incorrectly added to Evolution (1.09 KB, text/calendar)
2007-03-26 15:09 UTC, John Ellis
Details
Timezone records for my cache.ics (2.22 KB, text/calendar)
2007-03-28 19:17 UTC, John Ellis
Details

Note You need to log in before you can comment on or make changes to this bug.
Description John Ellis 2007-03-14 16:13:42 UTC
Evolution apparently didn't switch over on March 11th to accept the new DST changes in the United States. Now calendar appointments are incorrectly persisted, and the running clock in the calendar component is off by an hour.

I'm guessing this is related to http://bugzilla.gnome.org/show_bug.cgi?id=301363 and the iCal libraries (or something statically linked within Evolution) wasn't updated. I updated to the versions of Evolution & iCal in Factory-OSS, but it's still borked.
Comment 1 John Ellis 2007-03-14 16:15:22 UTC
Created attachment 124384 [details]
Screenshot of Calendar Errors

Attached is the weirdness I'm seeing - noticed the calendar believes it is nearly 11:00, when in fact it's nearly 12:00.
Comment 2 John Ellis 2007-03-19 16:10:22 UTC
Created attachment 125285 [details]
Patch for New York only

You can see additional bug reports:
http://bugzilla.gnome.org/show_bug.cgi?id=417461

And Ubuntu's fix:
https://launchpad.net/ubuntu/+source/evolution/+bug/91637

I had to manually hack & fix New York's timezone info file, which set the appropriate DST settings.
Comment 3 John Ellis 2007-03-26 15:09:51 UTC
Created attachment 126525 [details]
Sample meeting that is incorrectly added to Evolution

Appointments are still not added correctly, even though Evolution's "clock" is now displaying the correct time. Accepting the attached appointment should schedule it for 9 AM, but instead it's added at 10 AM.
Comment 4 John Ellis 2007-03-27 18:18:05 UTC
This appears to be a bug in the webdav module. If I accept the attached appointment (id=126525) into a webdavs folder via the Exchange connector, the time is an hour late. If I copy or accept the appointment into the native Evolution calendar on the file system then the correct hour appears. When I login to our OWA installation in a Web browser the appointment appears scheduled at the correct time.

Additionally, if I create an appointment within Evolution itself things appear to work correctly. The appointment is scheduled at the correct time, copying to the local file system's calendar maintains the correct hour, and OWA shows the correct time in the browser.

It appears the root of the cause is adding an appointment to a webdav calendar via e-mail.
Comment 5 Forgotten User ex4EZfzxBL 2007-03-28 18:39:38 UTC
John - Do you have the timezone update fix ? You can check by querying the changelog information,
rpm -q --changelog evolution-data-server |less

the following information should be appearing,

* Thu Mar 08 2007 - pchenthill@novell.com
bnc-251573-timezone-update.diff: Updates the timezone information. 

Also please run the following command. 
$find .evolution/exchange/ -name '*.ics' and send me the cache.ics for the particular calendar if possible. I want to check if the timezone present in the cache is the updated one. 
Comment 6 John Ellis 2007-03-28 19:17:05 UTC
Created attachment 127174 [details]
Timezone records for my cache.ics

I don't see the evolution-data-server fix - it doesn't appear that the update mirrors have it yet. I've been running YOU daily to check for updates and just applied the keyring fallback patch, but I currently don't see any updates for Evolution in YaST2.

I can't attache the whole cache.ics file unfortunately (confidential corporate crapola), but I have attached the VTIMEZONE records for the cache.ics. If you'd like me to dig for other info (or work on stripping all the confidential stuff out) let me know.

I removed & regenerated the cache.ics files, but the problem persisted.

I also tried this on a brand-new install of Kubuntu Edgy Eft beta, and the same issue persists on their Evolution distro. The hour appears correctly, but appointments are added an hour late.
Comment 7 Forgotten User ex4EZfzxBL 2007-03-29 07:45:21 UTC
I have identified the issue. Its because a old meeting request sent from exchange is still using the wrong timezone information. The timezone information present in the cache is,

BEGIN:VTIMEZONE
TZID:(GMT-05.00) Eastern Time (US & Canada)
X-MICROSOFT-CDO-TZID:10
BEGIN:STANDARD
DTSTART:16010101T020000
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=-1SU;BYMONTH=10
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:16010101T020000
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=1SU;BYMONTH=4 //* wrong information *
END:DAYLIGHT
END:VTIMEZONE

The timezone present in the meeting sent is correct. Since the old and new timezones sent from exchange have same tzids and has no information to indicate the updated one. 

Have you run the migration tool on exchange server to migrate the timezones present in outlook calendar events ?
Comment 8 Forgotten User ex4EZfzxBL 2007-03-29 10:03:14 UTC
I have a thought about a solution for this issue. I will try to make out a patch soon.
Comment 9 John Ellis 2007-03-29 14:02:35 UTC
I'm fairly sure they ran both the DST updater and the migration tool on the Exchange 2003 server... it appears things migrated & currently work fine on OWA and Outlook, just Evolution is skewed.

Lookin' forward to the patch. Thanks!
Comment 10 Srinivasa Ragavan 2007-08-14 11:32:06 UTC
Chen: Didn't you make a tool to migrate cache? 
Comment 11 Forgotten User ex4EZfzxBL 2007-08-22 06:45:40 UTC
srini, the tool was made for the personal calendar. I have given a test build with the updated timezones and got the reply from the reporter as it fixed the issue. The update has been release for 10.2.