View Issue Details

IDProjectCategoryView StatusLast Update
0003848SOGoBackend Calendarpublic2016-11-02 00:27
Reporterat Assigned Toludovic  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionno change required 
Platform[Server] LinuxOSUbuntuOS Version14.04 LTS
Product Version3.2.0 
Summary0003848: Event start/end time shifts
Description

Start/end time shifted wherever I create event with outlook, web calendar, iphone or android calendar. However if you check event's source, it looks ok

TZID:Europe/Moscow
X-LIC-LOCATION:Europe/Moscow
BEGIN:STANDARD
TZOFFSETFROM:+0300
TZOFFSETTO:+0300
TZNAME:MSK
...
DTSTART;TZID=Europe/Moscow:20161018T180000
DTEND;TZID=Europe/Moscow:20161018T183000

Repeating error messages in sogo log

sogod[20225] Unable to obtain time zone `leap-seconds.list'... <NSException: 0x7fe3234ec158> NAME:GSTimeZoneFileException REASON:TZ_MAGIC is incorrect INFO:(null)

cat /etc/timezone
Europe/Moscow

cat /etc/sogo/sogo.conf
...
SOGoTimeZone = "Europe/Moscow";
...

also added timezones to mysql

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql

so
mysql> SELECT CONVERT_TZ(now(),'UTC','Europe/Moscow') AS time;
returns
+---------------------+
| time |
+---------------------+
| 2016-10-19 18:17:26 |
+---------------------+
1 row in set (0.00 sec)

Steps To Reproduce

Create event, check start/end time.

TagsNo tags attached.

Activities

Christian Mack

Christian Mack

2016-10-20 08:14

developer   ~0010757

Could you please attach a complete example event created with outlook?

at

at

2016-10-20 09:24

reporter   ~0010758

Last edited: 2016-10-21 07:21

This one was created in web calendar and actually scheduled at 1PM, but displays at 9 AM in web calendar and android calendar

BEGIN:VCALENDAR
PRODID:-//Inverse inc./SOGo 3.2.0//EN
VERSION:2.0
BEGIN:VTIMEZONE
TZID:Europe/Moscow
X-LIC-LOCATION:Europe/Moscow
BEGIN:STANDARD
TZOFFSETFROM:+0300
TZOFFSETTO:+0300
TZNAME:MSK
DTSTART:19700101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
UID:15F-58088B00-1-62021C00
SUMMARY:Web Calendar Test
CLASS:PUBLIC
TRANSP:OPAQUE
DTSTART;TZID=Europe/Moscow:20161020T110000
DTEND;TZID=Europe/Moscow:20161020T120000
CREATED:20161020T091540Z
DTSTAMP:20161020T091540Z
LAST-MODIFIED:20161020T091540Z
END:VEVENT
END:VCALENDAR

Next one was created in android calendar, actually scheduled at 2 PM, displays at 2PM in android calendar and at 12AM in web calendar

BEGIN:VCALENDAR
PRODID:-//Inverse inc./SOGo 3.2.0//EN
VERSION:2.0
BEGIN:VTIMEZONE
TZID:Europe/Moscow
X-LIC-LOCATION:Europe/Moscow
BEGIN:STANDARD
TZOFFSETFROM:+0300
TZOFFSETTO:+0300
TZNAME:MSK
DTSTART:19700101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
UID:4c33d07a-45ad-4541-a814-23214d1cd900
SUMMARY:Android Calendar Test
CLASS:PUBLIC
DTSTART;TZID=Europe/Moscow:20161020T140000
DTEND;TZID=Europe/Moscow:20161020T150000
BEGIN:VALARM
TRIGGER;VALUE=DURATION:-PT10M
ACTION:DISPLAY
END:VALARM
ORGANIZER;PARTSTAT=ACCEPTED:mailto:at@host.ru
END:VEVENT
END:VCALENDAR

I will add outlook one later.

at

at

2016-10-20 16:19

reporter   ~0010763

Last edited: 2016-10-20 16:20

Also created outlook event

Actually scheduled on 22:00, displayes in outlook as 22:00, but in web & android calendars displays as 20:00
sources are

BEGIN:VCALENDAR
PRODID:-//Inverse inc./SOGo 3.2.0//EN
VERSION:2.0
BEGIN:VTIMEZONE
TZID:Europe/Moscow
X-LIC-LOCATION:Europe/Moscow
BEGIN:STANDARD
TZOFFSETFROM:+0300
TZOFFSETTO:+0300
TZNAME:MSK
DTSTART:19700101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
UID:040000008200E00074C5B7101A82E0080000000090A68A48062BD201000000000000000
010000000D4CDEE3BDD8F0E4B83FFE98A01F8AC62
SUMMARY:Outlook Calendar Test
CLASS:PUBLIC
DESCRIPTION:Test
DTSTART;TZID=Europe/Moscow:20161020T220000
DTEND;TZID=Europe/Moscow:20161020T230000
BEGIN:VALARM
TRIGGER;VALUE=DURATION:-PT15M
ACTION:DISPLAY
END:VALARM
END:VEVENT
END:VCALENDAR

at

at

2016-10-22 12:51

reporter   ~0010778

Switched MySql timezone with no effect.

Reconfigured tzdata with no effect.

Reinstall iRedMail and SOGo on the same VM an there is no bug there.

Any ideas?

ludovic

ludovic

2016-10-22 12:54

administrator   ~0010779

Are you absolutely sure that you have installed the 14.04 LTS on a 14.04 LTS distro?

If you mess repos, you WILL have timezone issues.

at

at

2016-10-22 12:58

reporter   ~0010780

lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 14.04.5 LTS
Release: 14.04
Codename: trusty

I actually could mess with repos

/etc/apt/sources.list

deb http://packages.inverse.ca/SOGo/nightly/3/ubuntu trusty trusty

dpkg -l | grep sogo
ii sogo:amd64 3.2.0.20161021-1 amd64 a modern and scalable groupware
ii sogo-activesync 3.2.0.20161021-1 amd64 a modern and scalable groupware - ActiveSync module

Any more checks?

at

at

2016-10-22 13:15

reporter   ~0010781

And I diff-ed all the packages installed on both VMs. 1st with bug and 2nd without

diff /root/dpkg.list /root/dpkg2.list
12,14d11
< ii apache2 2.4.7-1ubuntu4.13 amd64 Apache HTTP Server
< ii apache2-bin 2.4.7-1ubuntu4.13 amd64 Apache HTTP Server (binary files and modules)
< ii apache2-data 2.4.7-1ubuntu4.13 all Apache HTTP Server (common files)
43,46c40,43
< ii clamav 0.98.7+dfsg-0ubuntu0.14.04.1 amd64 anti-virus utility for Unix - command-line interface
< ii clamav-base 0.98.7+dfsg-0ubuntu0.14.04.1 all anti-virus utility for Unix - base package
< ii clamav-daemon 0.98.7+dfsg-0ubuntu0.14.04.1 amd64 anti-virus utility for Unix - scanner daemon
< ii clamav-freshclam 0.98.7+dfsg-0ubuntu0.14.04.1 amd64 anti-virus utility for Unix - virus database update utility

ii clamav 0.99.2+addedllvm-0ubuntu0.14.04.1 amd64 anti-virus utility for Unix - command-line interface
ii clamav-base 0.99.2+addedllvm-0ubuntu0.14.04.1 all anti-virus utility for Unix - base package
ii clamav-daemon 0.99.2+addedllvm-0ubuntu0.14.04.1 amd64 anti-virus utility for Unix - scanner daemon
ii clamav-freshclam 0.99.2+addedllvm-0ubuntu0.14.04.1 amd64 anti-virus utility for Unix - virus database update utility
49,50d45
< ii console-common 0.7.88 all basic infrastructure for text console configuration
< ii console-data 2:1.12-3 all keymaps, fonts, charset maps, fallback tables for console-tools
121d115
< ii htop 1.0.2-3 amd64 interactive processes viewer
152d145
< ii libapache2-mod-php5 5.5.9+dfsg-1ubuntu4.20 amd64 server-side, HTML-embedded scripting language (Apache 2 module)
155,158d147
< ii libapr1:amd64 1.5.0-1 amd64 Apache Portable Runtime Library
< ii libaprutil1:amd64 1.5.3-1 amd64 Apache Portable Runtime Utility Library
< ii libaprutil1-dbd-sqlite3:amd64 1.5.3-1 amd64 Apache Portable Runtime Utility Library - SQLite3 Driver
< ii libaprutil1-ldap:amd64 1.5.3-1 amd64 Apache Portable Runtime Utility Library - LDAP Driver
189c178
< ii libclamav6 0.98.7+dfsg-0ubuntu0.14.04.1 amd64 anti-virus utility for Unix - library

ii libclamav7 0.99.2+addedllvm-0ubuntu0.14.04.1 amd64 anti-virus utility for Unix - library
295d283
< ii liblcms2-2:amd64 2.5-0ubuntu4.1 amd64 Little CMS 2 color management library
313d300
< ii libmemcached10:amd64 1.0.8-1ubuntu2 amd64 C and C++ client library to the memcached server
348d334
< ii libopts25:amd64 1:5.18-2ubuntu2 amd64 automated option processing library based on autogen
365d350
< ii libpkcs11-helper1:amd64 1.11-1 amd64 library that simplifies the interaction with PKCS#11
437,438d421
< ii libwebp5:amd64 0.4.0-4 amd64 Lossy compression of digital photographic images.
< ii libwebpmux1:amd64 0.4.0-4 amd64 Lossy compression of digital photographic images.
514d496
< ii nginx 1.4.6-1ubuntu3.5 allsmall, powerful, scalable web/proxy server
519d500
< ii ntp 1:4.2.6.p5+dfsg-3ubuntu2.14.04.10 amd64 Network Time Protocol daemon and utility programs
525d505
< ii openvpn 2.3.2-7ubuntu3.1 amd64 virtual private network daemon
536,537d515
< ii php-pear 5.5.9+dfsg-1ubuntu4.20 all PEAR - PHP Extension and Application Repository
< ii php5 5.5.9+dfsg-1ubuntu4.20 all server-side, HTML-embedded scripting language (metapackage)
547d524
< ii php5-memcached 2.1.0-6build1 amd64 memcached extension module for PHP5, uses libmemcached
575d551
< ii python-imaging 2.3.0-1ubuntu3.3 all Python Imaging Library compatibility layer
580d555
< ii python-memcache 1.53-1build1 all pure python memcached client
586d560
< ii python-pil 2.3.0-1ubuntu3.3 amd64 Python Imaging Library (Pillow fork)
591d564
< ii python-setuptools 3.3-1ubuntu2 all Python Distutils Enhancements
595d567
< ii python-support 1.0.15 all automated rebuilding support for Python modules
624d595
< ii rpl 1.5.5-1 all intelligent recursive search/replace utility

at

at

2016-10-22 14:36

reporter   ~0010782

In AJAX saveAsApointment request we got

alarm : {}
categories : []
classification : "public"
completedDate : ""
delta : 60
destinationCalendar : "personal"
dueDate : ""
dueTime : ""
end : "2016-10-22T16:00:30.838Z"
endDate : "2016-10-22"
endTime : "19:00"
freebusy : {20161022: {18: [1, 1, 1, 1]}}
id : "2E24-580B7680-1-1E6E2000.ics"
isNew : true
pid : "personal"
repeat : {days: [], frequency: "never", interval: 1, month: {occurrence: "1", day: "SU", type: "bymonthday"},…}
selected : false
sendAppointmentNotifications : 1
start :
"2016-10-22T15:00:30.838Z"
startDate : "2016-10-22"
startTime : "18:00"
summary : "ev_unq_19"
type : "appointment"

in response we got

["2E24-580B7680-1-1E6E2000.ics", "personal","Personal Calendar", 1 ,1,"ev_unq_19",1477134000,"14:00",1477137600,"",0,0,null,0,null,"","at@host.ru",0,0,null,null,1,1,1,0,"","14:00","15:00"

in mysql db we got

BEGIN:VCALENDAR
PRODID:-//Inverse inc./SOGo 3.2.0//EN
VERSION:2.0
BEGIN:VTIMEZONE
TZID:Europe/Moscow
X-LIC-LOCATION:Europe/Moscow
BEGIN:STANDARD
TZOFFSETFROM:+0300
TZOFFSETTO:+0300
TZNAME:MSK
DTSTART:19700101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
UID:2E24-580B7680-1-1E6E2000
SUMMARY:ev_unq_19
CLASS:PUBLIC
TRANSP:OPAQUE
DTSTART;TZID=Europe/Moscow:20161022T160000
DTEND;TZID=Europe/Moscow:20161022T170000
CREATED:20161022T142400Z
DTSTAMP:20161022T142400Z
LAST-MODIFIED:20161022T142400Z
END:VEVENT
END:VCALENDAR

So we actually scheduled event on 19:00, then on backend shifted time to 16:00 and persisted in db, and then shifted it once more to 14:00 while processing responce for frontend.

at

at

2016-10-29 08:30

reporter   ~0010796

Last edited: 2016-10-29 08:30

Sloved with data migration on a new server, probably it was an ubuntu issue. Closed, I guess.

Issue History

Date Modified Username Field Change
2016-10-19 12:24 at New Issue
2016-10-20 08:14 Christian Mack Note Added: 0010757
2016-10-20 09:24 at Note Added: 0010758
2016-10-20 16:19 at Note Added: 0010763
2016-10-20 16:20 at Note Edited: 0010763
2016-10-21 07:21 at Note Edited: 0010758
2016-10-22 12:51 at Note Added: 0010778
2016-10-22 12:54 ludovic Note Added: 0010779
2016-10-22 12:58 at Note Added: 0010780
2016-10-22 13:15 at Note Added: 0010781
2016-10-22 14:36 at Note Added: 0010782
2016-10-29 08:30 at Note Added: 0010796
2016-10-29 08:30 at Note Edited: 0010796
2016-11-02 00:26 ludovic Status new => closed
2016-11-02 00:27 ludovic Assigned To => ludovic
2016-11-02 00:27 ludovic Resolution open => no change required