View Issue Details

IDProjectCategoryView StatusLast Update
0001777SOGowith SOGopublic2012-11-07 15:24
Reporterskliarie Assigned Towsourdeau 
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Target Version2.0.3Fixed in Version2.0.2 
Summary0001777: Added event in SOGo web interface and it appears shifted one hour in thunderbird+SOGo connector
Description

The timezone is set to Asia/Jerusalem in all components (Ubuntu, Lightning, .GNUstepDefaults, SOGo web).

SOGo 1.3.14
Inverse SOGo connector 10.0.1
Thunderbird 11.0.1

All events added from SOGo web interface appear one hour later in the Lightning.
This isn't true for the opposite direction, events created using the Lightning are shown correctly in SOGo web interface.

The bug is very similar to http://www.sogo.nu/bugs/view.php?id=180
Over there you asked reporterer to provice ics events. I don't know how to do that.

TagsNo tags attached.

Activities

Christian Mack

Christian Mack

2012-04-26 16:40

developer   ~0003820

Last edited: 2012-04-26 16:43

In order to provide an ics file, you have to:

  • create an additional calendar in SOGo
  • move both events you try to report into this new calendar
    If this doesn't work or changes the effect you try to show, create them in
    this new calendar in the first place
  • export the new calendar
skliarie

skliarie

2012-04-30 15:21

reporter   ~0003832

Last edited: 2012-04-30 15:24

I created the Test calendar, an event in it and I see the problem that SOGo does not take DST of the specified timezone into account:

The Asia/Jerusalem is marked as having timezone UTC+2, which is correct for winter time:
TZOFFSETFROM:+0200
TZOFFSETTO:+0200

Currently we have DST (Daylight Saving Time) in effect, so at the moment the time offset is UTC+3.

This explains why the event is shown in Thunderbird one hour earlier, as if it was filed under UTC+2 conditions.

BTW, the DST switch-over configuration on the SOGo server is correct:
zdump -v /etc/localtime |grep 2012
/etc/localtime Thu Mar 29 23:59:59 2012 UTC = Fri Mar 30 01:59:59 2012 IST isdst=0 gmtoff=7200
/etc/localtime Fri Mar 30 00:00:00 2012 UTC = Fri Mar 30 03:00:00 2012 IDT isdst=1 gmtoff=10800
/etc/localtime Sat Sep 22 22:59:59 2012 UTC = Sun Sep 23 01:59:59 2012 IDT isdst=1 gmtoff=10800
/etc/localtime Sat Sep 22 23:00:00 2012 UTC = Sun Sep 23 01:00:00 2012 IST isdst=0 gmtoff=7200

See attached the .ics calendar.

2012-04-30 15:22

 

test_created_from_sogo.ics (618 bytes)   
BEGIN:VCALENDAR
METHOD:PUBLISH
VERSION:2.0
PRODID:-//Inverse inc./SOGo 1.3.14//EN
BEGIN:VTIMEZONE
TZID:Asia/Jerusalem
X-LIC-LOCATION:Asia/Jerusalem
BEGIN:STANDARD
TZOFFSETFROM:+0200
TZOFFSETTO:+0200
TZNAME:IST
DTSTART:19700101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
UID:43D0-4F9EAB00-9-74C62400
SUMMARY:Test 10:00-11:00
DESCRIPTION:Created from SOGo web interface\n
CLASS:PUBLIC
CREATED:20120430T150846Z
DTSTAMP:20120430T150846Z
LAST-MODIFIED:20120430T150846Z
DTSTART;TZID=Asia/Jerusalem:20120502T090000
DTEND;TZID=Asia/Jerusalem:20120502T100000
TRANSP:OPAQUE
END:VEVENT
END:VCALENDAR
test_created_from_sogo.ics (618 bytes)   
ludovic

ludovic

2012-04-30 15:29

administrator   ~0003833

Look at the timezone file included in the sope-cards package.

skliarie

skliarie

2012-04-30 15:55

reporter   ~0003834

On my machine I have /usr/share/GNUstep/Libraries/gnustep-base/Versions/1.19/Resources/NSTimeZones/regions file.

It has line "2 Asia/Jerusalem" line. No mention for DST though.
It is provided by debian package gnustep-base-common (version 1.19.3-1ubuntu1).

There is no newer gnustep-base-common, albeit gnustep-common is of version 2.2.0-1

I tried to change the file to have "3 Asia/Jerusalem", restarted SOGo, but SOGo still thinks the time offset is UTC+2. How can I change the time offset on the fly? It is production machine with many users. Please help.

ludovic

ludovic

2012-04-30 16:07

administrator   ~0003835

Have a look at the timezone files located in /usr/lib/GNUstep/Libraries/Resources/NGCards/TimeZones/

They are included in the "sogo" package in Debian/Ubuntu packages.

skliarie

skliarie

2012-04-30 17:28

reporter   ~0003836

Yes, editing the /usr/lib/GNUstep/Libraries/Resources/NGCards/TimeZones/Asia/Jerusalem.ics file helped to temporarily (until the DST reversal) workaround the issue.

ludovic

ludovic

2012-04-30 18:20

administrator   ~0003837

I've just regenerated the timezone files using the latest tzdata file from ftp://munnari.oz.au/pub/oldtz/.

I've ran a diff for Asia/Jerusalem and there's no difference.

skliarie

skliarie

2012-05-01 06:14

reporter   ~0003839

Last edited: 2012-05-01 06:15

The last time files were changed over there is at 2006. The db must be obsolete, as in Israel (for example) the DST needs to be adjusted every year (with several months advance notice), as it depends on what ministers decide.

Why can't SOGo take the timezone information from the /usr/share/zoneinfo/* files that are provided by tzdata package? From my experience they are always correct and are updated automatically.

ludovic

ludovic

2012-05-01 19:28

administrator   ~0003840

If you look at that file:

ftp://munnari.oz.au/pub/oldtz/tzdata2012c.tar.gz

It was updated a few days ago.

Perhaps the solution will eventually be to support /usr/share/zoneinfo/* but in the meantime, can you help in finding a source with Olson timezone information that is up-to-date for Asia/Jerusalem?

ludovic

ludovic

2012-05-01 19:36

administrator   ~0003841

ftp://ftp.iana.org/tz/ gives me the same data as the link above.

skliarie

skliarie

2012-05-01 20:45

reporter   ~0003842

I don't know exact syntax of the tzdata file, but the definitions are looking correctly:
Rule Zion 2011 only - Apr 1 2:00 1:00 D
Rule Zion 2011 only - Oct 2 2:00 0 S
Rule Zion 2012 2015 - Mar Fri>=26 2:00 1:00 D
Rule Zion 2012 only - Sep 23 2:00 0 S

I don't quite understand meaning of "Zion" word in the above snippet. Even more confusing is presence of the following lines in the file:

Zone NAME GMTOFF RULES FORMAT [UNTIL]

Zone Asia/Jerusalem 2:20:56 - LMT 1880
2:20:40 - JMT 1918 # Jerusalem Mean Time?
2:00 Zion I%sT

Here is the relevant IST/DST information from the tzdata package:

root@mail:~# zdump -v /usr/share/zoneinfo/Asia/Jerusalem | grep 2011
/usr/share/zoneinfo/Asia/Jerusalem Thu Mar 31 23:59:59 2011 UTC = Fri Apr 1 01:59:59 2011 IST isdst=0 gmtoff=7200
/usr/share/zoneinfo/Asia/Jerusalem Fri Apr 1 00:00:00 2011 UTC = Fri Apr 1 03:00:00 2011 IDT isdst=1 gmtoff=10800
/usr/share/zoneinfo/Asia/Jerusalem Sat Oct 1 22:59:59 2011 UTC = Sun Oct 2 01:59:59 2011 IDT isdst=1 gmtoff=10800
/usr/share/zoneinfo/Asia/Jerusalem Sat Oct 1 23:00:00 2011 UTC = Sun Oct 2 01:00:00 2011 IST isdst=0 gmtoff=7200
root@mail:~#
root@mail:~# zdump -v /usr/share/zoneinfo/Asia/Jerusalem | grep 2012
/usr/share/zoneinfo/Asia/Jerusalem Thu Mar 29 23:59:59 2012 UTC = Fri Mar 30 01:59:59 2012 IST isdst=0 gmtoff=7200
/usr/share/zoneinfo/Asia/Jerusalem Fri Mar 30 00:00:00 2012 UTC = Fri Mar 30 03:00:00 2012 IDT isdst=1 gmtoff=10800
/usr/share/zoneinfo/Asia/Jerusalem Sat Sep 22 22:59:59 2012 UTC = Sun Sep 23 01:59:59 2012 IDT isdst=1 gmtoff=10800
/usr/share/zoneinfo/Asia/Jerusalem Sat Sep 22 23:00:00 2012 UTC = Sun Sep 23 01:00:00 2012 IST isdst=0 gmtoff=7200
root@mail:~#

I am lost here on making any conclusions...

ludovic

ludovic

2012-05-09 15:45

administrator   ~0003875

Timezone files have been updated but obviously, no changes were made to Asia/Jerusalem. I'm bumping that ticket to the next release. We might decide to use the OS's zoneinfo in future releases.

ludovic

ludovic

2012-09-25 02:47

administrator   ~0004539

Too intrusive for v2.0.0 which is close to be released - bumping to v2.0.1

wsourdeau

wsourdeau

2012-10-20 18:29

viewer   ~0004680

Hi Arie,

Could you test again with the next nightly build of SOGo, where the timezone files have been regenerated?

Thank you.

wsourdeau

wsourdeau

2012-11-07 15:24

viewer   ~0004790

This issue is considered fixed since 2.0.2

Issue History

Date Modified Username Field Change
2012-04-25 14:32 skliarie New Issue
2012-04-26 16:40 Christian Mack Note Added: 0003820
2012-04-26 16:43 Christian Mack Note Edited: 0003820
2012-04-30 15:21 skliarie Note Added: 0003832
2012-04-30 15:22 skliarie File Added: test_created_from_sogo.ics
2012-04-30 15:22 skliarie Note Edited: 0003832
2012-04-30 15:24 skliarie Note Edited: 0003832
2012-04-30 15:29 ludovic Note Added: 0003833
2012-04-30 15:55 skliarie Note Added: 0003834
2012-04-30 16:07 ludovic Note Added: 0003835
2012-04-30 17:28 skliarie Note Added: 0003836
2012-04-30 18:20 ludovic Note Added: 0003837
2012-05-01 06:14 skliarie Note Added: 0003839
2012-05-01 06:15 skliarie Note Edited: 0003839
2012-05-01 19:28 ludovic Note Added: 0003840
2012-05-01 19:36 ludovic Note Added: 0003841
2012-05-01 20:16 ludovic Project SOGo Connector => SOGo
2012-05-01 20:17 ludovic Product Version 10.0 =>
2012-05-01 20:17 ludovic Target Version => 1.3.15
2012-05-01 20:45 skliarie Note Added: 0003842
2012-05-09 15:45 ludovic Note Added: 0003875
2012-05-09 15:45 ludovic Target Version 1.3.15 => 1.3.16
2012-05-29 19:58 ludovic Target Version 1.3.16 => 1.3.17
2012-07-16 12:43 ludovic Target Version 1.3.17 => 1.3.18
2012-08-27 15:56 francis Target Version 1.3.18 => 2.0.0
2012-09-25 02:47 ludovic Note Added: 0004539
2012-09-25 02:47 ludovic Target Version 2.0.0 => 2.0.1
2012-10-03 17:05 wsourdeau Status new => assigned
2012-10-03 17:05 wsourdeau Assigned To => wsourdeau
2012-10-09 20:30 wsourdeau Target Version 2.0.1 => 2.0.2
2012-10-20 18:29 wsourdeau Note Added: 0004680
2012-10-20 18:29 wsourdeau Status assigned => feedback
2012-10-23 18:20 wsourdeau Target Version 2.0.2 => 2.0.3
2012-11-07 15:24 wsourdeau Note Added: 0004790
2012-11-07 15:24 wsourdeau Status feedback => resolved
2012-11-07 15:24 wsourdeau Fixed in Version => 2.0.2
2012-11-07 15:24 wsourdeau Resolution open => fixed