Relationship Graph

View IssueDependency GraphShow Summary
Relationship Graph
related to related to child of child of duplicate of duplicate of

View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0002179SOGoWeb Calendarpublic2013-01-14 02:222019-08-05 14:54
Reportergray_graff Assigned To 
PrioritynormalSeveritytweakReproducibilityalways
Status newResolutionopen 
Product Version2.0.3a 
Target Versionsoon 
Summary0002179: Missing RDATE support in timezones
Description

Time shifts when saving/modifying events in SOGo web interface

version 2.0.3a (rhel5)
CentOS release 5.8

Additional Information

iCalTimeZonePeriod only supports RRULEs.

TagsNo tags attached.

Relationships

Relationship GraphDependency Graph
has duplicate 0003297 new web calendar get wrong date 
has duplicate 0003024 assignedludovic Web Calendar shows events time-shifted 
has duplicate 0004186 resolvedfrancis repeating events with freely selectable repeating days 

Activities

francis

francis

2013-01-14 13:46

administrator   ~0005164

Give a proper example that can be reproduced. Specify your timezone.
zymanch

zymanch

2013-01-15 10:09

reporter   ~0005179

Last edited: 2013-01-15 10:29

have the same situation

software:

Debian 6.0.6 x64

libsope-appserver4.9 -- 4.9.r1664.20121206
libsope-core4.9 -- 4.9.r1664.20121206
libsope-gdl1-4.9 -- 4.9.r1664.20121206
libsope-ldap4.9 -- 4.9.r1664.20121206
libsope-mime4.9 -- 4.9.r1664.20121206
libsope-xml4.9 -- 4.9.r1664.20121206
sope4.9-libxmlsaxdriver -- 4.9.r1664.20121206
sogo -- 2.0.3a-1

time settings:

date

Tue Jan 15 13:10:50 MSK 2013

cat /etc/timezone

Europe/Moscow

cat /home/sogo/GNUstep/Defaults/.GNUstepDefaults | grep -i timezone

SOGoTimeZone = Europe/Moscow;

and when I create an event from 17.00 till 18.00, I have event source like this:

BEGIN:VEVENT
UID:3B61-50F51C80-7-63928580
SUMMARY:New Event
CLASS:PUBLIC
CREATED:20130115T090902Z
DTSTAMP:20130115T090902Z
LAST-MODIFIED:20130115T090902Z
DTSTART;TZID=Europe/Moscow:20130115T153000
DTEND;TZID=Europe/Moscow:20130115T163000
TRANSP:OPAQUE
END:VEVENT
END:VCALENDAR

you can see time shift - 1:30

and what else is very strange for me, I have double time zone records in web-interface Preferences

already compiled sogo 2.0.3a, sogo 2.0.2a and sope from source - nothing changed
gray_graff

gray_graff

2013-01-15 11:52

reporter   ~0005181

date

Tue Jan 15 19:52:53 KRAT 2013
/usr/share/zoneinfo/Asia/Krasnoyarsk = /etc/localtime

Asia/Krasnoyarsk also in sogo web and thunderbird

cat /home/sogo/GNUstep/Defaults/.GNUstepDefaults | grep -i -A1 timezone

    <key>SOGoTimeZone</key>
    <string>Asia/Krasnoyarsk</string>

rpm -qa | egrep 'sogo|sope|tzdata'

sope49-xml-4.9-20121206_1664.el5.1
sope49-ldap-4.9-20121206_1664.el5.1
sope49-gdl1-postgresql-4.9-20121206_1664.el5.1
sope49-sbjson-2.3.1-20121206_1664.el5.1
sope49-core-4.9-20121206_1664.el5.1
sope49-gdl1-contentstore-2.0.3a-1.el5
sope49-mime-4.9-20121206_1664.el5.1
sope49-cards-2.0.3a-1.el5
tzdata-java-2012i-2.el5
tzdata-2012i-2.el5
sogo-2.0.3a-1.el5
sogo-tool-2.0.3a-1.el5
sope49-gdl1-4.9-20121206_1664.el5.1
sope49-appserver-4.9-20121206_1664.el5.1
sogo-devel-2.0.3a-1.el5

web
http://i.imgur.com/01H1C.png
thunderbird
http://i.imgur.com/0iMMx.png
gray_graff

gray_graff

2013-01-15 11:55

reporter   ~0005182

BEGIN:VCALENDAR
PRODID:-//Mozilla.org/NONSGML Mozilla Calendar V1.1//EN
VERSION:2.0
BEGIN:VTIMEZONE
TZID:Asia/Krasnoyarsk
X-LIC-LOCATION:Asia/Krasnoyarsk
BEGIN:STANDARD
TZOFFSETFROM:+0800
TZOFFSETTO:+0800
TZNAME:KRAT
DTSTART:19700101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
CREATED:20130115T114700Z
LAST-MODIFIED:20130115T114700Z
DTSTAMP:20130115T114700Z
UID:EB5-50F54180-7B-4166A680
SUMMARY:event from web (14:00)
DTSTART;TZID=Asia/Krasnoyarsk:20130115T120000
DTEND;TZID=Asia/Krasnoyarsk:20130115T130000
CLASS:PUBLIC
TRANSP:OPAQUE
END:VEVENT
END:VCALENDAR
ludovic

ludovic

2013-01-15 14:00

administrator   ~0005188

zymanch, unless you toyed around with the event, it's wrong because it has no VTIMEZONE definitions.

gray_graff your event is also wrong as you should have 2 VTIMEZONE definitions (STANDARD and DAYLIGHT). Moreover, you should have plenty of RDATE entries too.

So you must have messed up with the timezone files included in SOGo.
zymanch

zymanch

2013-01-15 14:08

reporter   ~0005189

ludovic, I'm sorry, here - full source code of my event

BEGIN:VCALENDAR
PRODID:-//Inverse inc./SOGo 2.0.3//EN
VERSION:2.0
BEGIN:VTIMEZONE
TZID:Europe/Moscow
X-LIC-LOCATION:Europe/Moscow
BEGIN:STANDARD
TZOFFSETFROM:+023020
TZOFFSETTO:+0230
TZNAME:MMT
DTSTART:18800101T000000
RDATE:18800101T000000
END:STANDARD
BEGIN:STANDARD
TZOFFSETFROM:+0230
TZOFFSETTO:+023048
TZNAME:MMT
DTSTART:19160703T000000
RDATE:19160703T000000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:+023048
TZOFFSETTO:+033048
TZNAME:MST
DTSTART:19170701T230000
RDATE:19170701T230000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+033048
TZOFFSETTO:+023048
TZNAME:MMT
DTSTART:19171228T000000
RDATE:19171228T000000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:+023048
TZOFFSETTO:+043048
TZNAME:MDST
DTSTART:19180531T220000
RDATE:19180531T220000
END:DAYLIGHT
BEGIN:DAYLIGHT
TZOFFSETFROM:+043048
TZOFFSETTO:+033048
TZNAME:MST
DTSTART:19180916T010000
RDATE:19180916T010000
END:DAYLIGHT
BEGIN:DAYLIGHT
TZOFFSETFROM:+033048
TZOFFSETTO:+043048
TZNAME:MDST
DTSTART:19190531T230000
RDATE:19190531T230000
END:DAYLIGHT
BEGIN:DAYLIGHT
TZOFFSETFROM:+043048
TZOFFSETTO:+0400
TZNAME:MSD
DTSTART:19190701T020000
RDATE:19190701T020000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0400
TZOFFSETTO:+0300
TZNAME:MSK
DTSTART:19190816T000000
RDATE:19190816T000000
RDATE:19211001T000000
RDATE:19811001T000000
RDATE:19821001T000000
RDATE:19831001T000000
RDATE:19840930T030000
RDATE:19850929T030000
RDATE:19860928T030000
RDATE:19870927T030000
RDATE:19880925T030000
RDATE:19890924T030000
RDATE:19900930T030000
RDATE:19920926T230000
RDATE:19930926T030000
RDATE:19940925T030000
RDATE:19950924T030000
RDATE:19961027T030000
RDATE:19971026T030000
RDATE:19981025T030000
RDATE:19991031T030000
RDATE:20001029T030000
RDATE:20011028T030000
RDATE:20021027T030000
RDATE:20031026T030000
RDATE:20041031T030000
RDATE:20051030T030000
RDATE:20061029T030000
RDATE:20071028T030000
RDATE:20081026T030000
RDATE:20091025T030000
RDATE:20101031T030000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:+0300
TZOFFSETTO:+0400
TZNAME:MSD
DTSTART:19210214T230000
RDATE:19210214T230000
RDATE:19810401T000000
RDATE:19820401T000000
RDATE:19830401T000000
RDATE:19840401T000000
RDATE:19850331T020000
RDATE:19860330T020000
RDATE:19870329T020000
RDATE:19880327T020000
RDATE:19890326T020000
RDATE:19900325T020000
RDATE:19920328T230000
RDATE:19930328T020000
RDATE:19940327T020000
RDATE:19950326T020000
RDATE:19960331T020000
RDATE:19970330T020000
RDATE:19980329T020000
RDATE:19990328T020000
RDATE:20000326T020000
RDATE:20010325T020000
RDATE:20020331T020000
RDATE:20030330T020000
RDATE:20040328T020000
RDATE:20050327T020000
RDATE:20060326T020000
RDATE:20070325T020000
RDATE:20080330T020000
RDATE:20090329T020000
RDATE:20100328T020000
END:DAYLIGHT
BEGIN:DAYLIGHT
TZOFFSETFROM:+0400
TZOFFSETTO:+0500
TZNAME:MSD
DTSTART:19210320T230000
RDATE:19210320T230000
END:DAYLIGHT
BEGIN:DAYLIGHT
TZOFFSETFROM:+0500
TZOFFSETTO:+0400
TZNAME:MSD
DTSTART:19210901T000000
RDATE:19210901T000000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0300
TZOFFSETTO:+0200
TZNAME:EET
DTSTART:19221001T000000
RDATE:19221001T000000
RDATE:19910929T030000
END:STANDARD
BEGIN:STANDARD
TZOFFSETFROM:+0200
TZOFFSETTO:+0300
TZNAME:MSK
DTSTART:19300621T000000
RDATE:19300621T000000
RDATE:19920119T020000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:+0300
TZOFFSETTO:+0300
TZNAME:EEST
DTSTART:19910331T020000
RDATE:19910331T020000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0300
TZOFFSETTO:+0400
TZNAME:MSK
DTSTART:20110327T020000
RDATE:20110327T020000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
UID:3B61-50F51C80-7-63928580
SUMMARY:New Event
CLASS:PUBLIC
CREATED:20130115T090902Z
DTSTAMP:20130115T090902Z
LAST-MODIFIED:20130115T090902Z
DTSTART;TZID=Europe/Moscow:20130115T153000
DTEND;TZID=Europe/Moscow:20130115T163000
TRANSP:OPAQUE
END:VEVENT
END:VCALENDAR
francis

francis

2013-01-15 15:16

administrator   ~0005191

The problem is that SOGo doesn't handle RDATES (see iCalTimeZonePeriod.m).

For the moment, I rolled back (and updated) the timezones definitions to a more compatible format (with no RDATE). This is the format used by Thunderbird/Lightning.

See https://github.com/inverse-inc/sogo/commit/9ac8e9f0e116d4630b1637f2938d541e0e23e796
zymanch

zymanch

2013-01-15 15:48

reporter   ~0005192

francis, excuse me for the stupid question, but where I can find files for editing?
I already changed time-zone file in /usr/lib/GNUstep/Libraries/Resources/NGCards/TimeZones/Europe, but after sogo server, apache & memcached restart noting changes - event source stay the same like before editing.
zymanch

zymanch

2013-01-16 17:51

reporter   ~0005203

now it's ok; it was in /usr/local/lib/...
ludovic, francis thanks for your help!
gray_graff

gray_graff

2013-01-17 02:31

reporter   ~0005207

with new file - all ok :)

Issue History

Date Modified Username Field Change
2013-01-14 02:22 gray_graff New Issue
2013-01-14 13:46 francis Note Added: 0005164
2013-01-15 10:09 zymanch Note Added: 0005179
2013-01-15 10:10 zymanch Note Edited: 0005179
2013-01-15 10:10 zymanch Note Edited: 0005179
2013-01-15 10:12 zymanch Note Edited: 0005179
2013-01-15 10:20 zymanch Note Edited: 0005179
2013-01-15 10:21 zymanch Note Edited: 0005179
2013-01-15 10:29 zymanch Note Edited: 0005179
2013-01-15 11:52 gray_graff Note Added: 0005181
2013-01-15 11:55 gray_graff Note Added: 0005182
2013-01-15 14:00 ludovic Note Added: 0005188
2013-01-15 14:08 zymanch Note Added: 0005189
2013-01-15 15:16 francis Note Added: 0005191
2013-01-15 15:18 francis Target Version => soon
2013-01-15 15:18 francis Summary Time shifts when saving/modifying events in SOGo web interface (again) => Missing RDATE support in timezones
2013-01-15 15:18 francis Description Updated
2013-01-15 15:18 francis Additional Information Updated
2013-01-15 15:48 zymanch Note Added: 0005192
2013-01-16 17:51 zymanch Note Added: 0005203
2013-01-17 02:31 gray_graff Note Added: 0005207
2013-08-09 19:59 ludovic Severity major => tweak
2015-07-30 10:35 francis Relationship added has duplicate 0003297
2015-08-03 07:49 Christian Mack Relationship added has duplicate 0003024
2019-08-05 14:54 Christian Mack Relationship added has duplicate 0004186