Relationship Graph

Relationship Graph
related to related to child of child of duplicate of duplicate of

View Issue Details

IDProjectCategoryView StatusLast Update
0003299SOGoWeb Calendarpublic2016-12-15 14:38
Reporteraccumulator Assigned Toludovic  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionsuspended 
Platform[Server] LinuxOSDebianOS Version7 (Wheezy)
Product Version2.3.1 
Summary0003299: Incorrect time on calendar event in timezone Europe/Brussels
Description

creating an appointment on the Jolla phone and syncing it to SOGo with SyncEvolution shows the event 1 hour off of what it should be.

event is created at 14:00 but shows in web calendar at 15:00

raw event source :

BEGIN:VCALENDAR
PRODID:-//Synthesis AG//NONSGML SyncML Engine V3.4.0.47//EN
VERSION:2.0
BEGIN:VTIMEZONE
TZID:Europe/Brussels
BEGIN:STANDARD
DTSTART:19671029T030000
RRULE:FREQ=MONTHLY;INTERVAL=12;BYDAY=-1SU
TZOFFSETFROM:+0200
TZOFFSETTO:+0100
TZNAME:CET
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:19870329T020000
RRULE:FREQ=MONTHLY;INTERVAL=12;BYDAY=-1SU
TZOFFSETFROM:+0100
TZOFFSETTO:+0200
TZNAME:CEST
END:DAYLIGHT
END:VTIMEZONE
BEGIN:VEVENT
LAST-MODIFIED:20150802T093740Z
DTSTAMP:20150802T093740Z
CREATED:20150802T093723Z
UID:1e65bc81-57df-4167-a9f1-5eaafa492bea
TRANSP:OPAQUE
SUMMARY:Jolla 1400 tz brussels
DTSTART;TZID=Europe/Brussels:20150802T140000
DTEND;TZID=Europe/Brussels:20150802T150000
BEGIN:VALARM
TRIGGER;X-WEBSTATUS=triggered;VALUE=DURATION:-P2D
ACTION:AUDIO
END:VALARM
CLASS:PUBLIC
END:VEVENT
END:VCALENDAR


similar problems occur on Europe/Amsterdam timezone with even stranger offsets, but I'll leave these out of this bug to not complicate things.

There seem to be serious timezone interpretation issues in SOGo..

TagsNo tags attached.

Activities

waterstorm

waterstorm

2015-09-23 05:26

reporter   ~0008934

I can confirm the timezone / offset bugs.

I have the timezone in SOGo set to Europe/Berlin, if I create an appointment in the SOGo webinterface, it gets a four hour offset (e.g. if I select 10 AM it will create an appointment at 6 AM).

If I create an appointment in Thunderbird/Lightning and set it to 10 AM it will show up in SOGo as 8 AM (but correct in TB). Different offset, same problem. (Yes the timezone in TB/Lightning is set correctly!).

This happened after the upgrade to 2.3.1 it did work in the version before (2.3.0)!
I hope you can fix this issue soon, this is a really annoying bug :(

Christian Mack

Christian Mack

2015-09-24 02:43

developer   ~0008938

Please upgrade to 2.3.2.
I think this was fixed with 0003344

waterstorm

waterstorm

2015-09-24 04:07

reporter   ~0008941

Thanks for the hint, I just upgraded to 2.3.2.

However this is still not fixed. Now all my entries are shifted by 2 hours, even the ones created before upgrading 2.3.1.

It does not sound like the issue described in your link. It does not correlate with a date in my experience, it just shifts all events by 2 hours. However they appear correctly in Thunderbird, so maybe it is just an issue with the webinterface.

Please advice.

Christian Mack

Christian Mack

2015-09-24 04:39

developer   ~0008942

Could you open one of these events and store it again?
If your problem is related to the above bug, this will fix it.

waterstorm

waterstorm

2015-09-24 04:48

reporter   ~0008943

I already tried this. It does not help, it will still store the event with the 2 hour offset.

ludovic

ludovic

2015-09-24 08:40

administrator   ~0008946

Show your complete list of installed SOGo AND SOPE packages.

waterstorm

waterstorm

2015-09-24 10:16

reporter   ~0008948

All packages with sope or sogo in the name on Debian.

-> # dpkg-query -l 'sope'
||/ Name Version Architecture

ii libsope-appserver4.9 4.9.r1664.20150923 amd64
ii libsope-core4.9 4.9.r1664.20150923 amd64
ii libsope-gdl1-4.9 4.9.r1664.20150923 amd64
ii libsope-ldap4.9 4.9.r1664.20150923 amd64
ii libsope-mime4.9 4.9.r1664.20150923 amd64
ii libsope-xml4.9 4.9.r1664.20150923 amd64
rc libsope1 2.2.9-2 amd64
un sope-libxmlsaxdriver <none> <none>
un sope4.9-db-connector <none> <none>
ii sope4.9-gdl1-mysql 4.9.r1664.20150923 amd64
ii sope4.9-libxmlsaxdriver 4.9.r1664.20150923 amd64

-> # dpkg-query -l 'sogo'
||/ Name Version Architecture

ii sogo:amd64 2.3.2.20150924-1 amd64
ii sogo-activesync 2.3.2.20150924-1 amd64

ludovic

ludovic

2015-09-24 10:21

administrator   ~0008949

These packages are coming from which repo? And they are installed on what Debian version?

waterstorm

waterstorm

2015-09-24 10:24

reporter   ~0008950

Sorry :) It's a Debian 8.2
Linux xa2 3.16.0-4-amd64 0000001 SMP Debian 3.16.7-ckt11-1+deb8u3 (2015-08-04) x86_64 GNU/Linux

Using this SOGo Repo:
deb http://inverse.ca/debian-nightly jessie jessie

ludovic

ludovic

2015-09-24 10:27

administrator   ~0008951

Show your sogod.conf file.

waterstorm

waterstorm

2015-09-24 10:35

reporter   ~0008952

-> # cat /etc/sogo/sogo.conf
{
OCSEMailAlarmsFolderURL = mysql://sogo:db:3306/sogo/sogo_sessions_folder;
OCSFolderInfoURL = mysql://sogo:db:3306/sogo/sogo_folder_info;
OCSSessionsFolderURL = mysql://sogo:db:3306:3306/sogo/sogo_sessions_folder;
NGImap4ConnectionStringSeparator = ".";
SOGoACLsSendEMailNotifications = NO;
SOGoAppointmentSendEMailNotifications = YES;
SOGoBusyOffHours = YES;
SOGoCalendarDefaultRoles = ("PublicViewer", "ConfidentialDAndTViewer");
SOGoContactsDefaultRoles = ("ObjectViewer");
SOGoEnablePublicAccess = YES;
SOGoDraftsFolderName = "INBOX/Drafts";
SOGoFirstDayOfWeek = 1;
SOGoFoldersSendEMailNotifications = NO;
SOGoForwardEnabled = YES;
SOGoIMAPServer = localhost;
SOGoLanguage = German;
SOGoMailAuxiliaryUserAccountsEnabled = YES;
SOGoMailComposeMessageType = html;
SOGoRefreshViewCheck = "every_5_minutes";
SOGoMailReplyPlacement = above;
SOGoMailSignaturePlacement = above;
SOGoForceIMAPLoginWithEmail = YES;
SOGoMailingMechanism = smtp;
SOGoPasswordChangeEnabled = YES;
SOGoProfileURL = mysql://sogo:db:3306/sogo/sogo_user_profile;
SOGoSMTPServer = localhost;
SOGoSentFolderName = "INBOX/Sent";
SOGoSieveScriptsEnabled = YES;
SOGoSieveServer = "sieve://localhost:2000";
SOGoSupportedLanguages = (German, English);
SOGoTimeZone = "Europe/Berlin";
SOGoTrashFolderName = "INBOX/Trash";
SOGoVacationEnabled = YES;
WOWatchDogRequestTimeout = 10;
WOWorkersCount = 20;
SOGoMaximumPingInterval = 3540;
SOGoMaximumSyncInterval = 3540;
SOGoInternalSyncInterval = 30;
domains = {
"general" = {
SOGoUserSources = (
{
canAuthenticate = YES;
id = "general";
isAddressBook = NO;
type = sql;
userPasswordAlgorithm = crypt;
viewURL = "mysql://sogo:db:3306/sogo_usersource/general";
}
);
};
};
}

(while sogo:db:3306 is the replaced mysql login)

ludovic

ludovic

2015-09-24 10:39

administrator   ~0008953

I have no clue why you have issues with the latest packages and this configuration. We would need to work more closely with you by having (if possible) SSH access to your server. For us to do that, a valid support contract is required. See http://inverse.ca/#support-plans for the options.

Jens Erat

Jens Erat

2015-09-25 03:29

reporter   ~0008954

Did you try opening and saving the appointment in the SOGo web UI after installing the 2.3.2 update? I think some "cache" columns (if you consider the ICS text blob the "original" version) in the calendar table must be rewritten to fix appointments being displayed at the wrong time.

waterstorm

waterstorm

2015-09-25 04:47

reporter   ~0008955

Yes, I restarted Apache and SOGo. After opening and saving an event, it is still shifted by 2 hours.

However I just found that if I create a new event, it will be shifted by 4 hours instead of "only" 2. If I open it up and save it again, then it is shifted by 2 hours and not by 4 anymore. This is some strange behavior :/ Sounds like some kind of timezone problem, but everything is set correctly in the config.

waterstorm

waterstorm

2015-09-25 04:53

reporter   ~0008956

Just for a bit more information I appended the raw info of the events.
Hopefully someone may be able to help me out here.

I create a new event at 12:00, it will show up in the webinterface as 8:00 and the raw source looks like this:
BEGIN:VCALENDAR
PRODID:-//Inverse inc./SOGo 2.3.2//EN
VERSION:2.0
BEGIN:VTIMEZONE
TZID:Europe/Berlin
X-LIC-LOCATION:Europe/Berlin
BEGIN:DAYLIGHT
TZOFFSETFROM:+0100
TZOFFSETTO:+0200
TZNAME:CEST
DTSTART:19700329T020000
RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0200
TZOFFSETTO:+0100
TZNAME:CET
DTSTART:19701025T030000
RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
UID:62E1-56050A80-13-1A0EEC60
SUMMARY:test event
CLASS:PUBLIC
CREATED:20150925T084905Z
DTSTAMP:20150925T084905Z
LAST-MODIFIED:20150925T084905Z
DTSTART;TZID=Europe/Berlin:20150926T100000
DTEND;TZID=Europe/Berlin:20150926T110000
TRANSP:OPAQUE
END:VEVENT
END:VCALENDAR

If i open it up, change the time from 8:00 to 12:00 and save it, it will be in the calendar at 10:00 and the raw is as follows:

BEGIN:VCALENDAR
PRODID:-//Inverse inc./SOGo 2.3.2//EN
VERSION:2.0
BEGIN:VTIMEZONE
TZID:Europe/Berlin
X-LIC-LOCATION:Europe/Berlin
BEGIN:DAYLIGHT
TZOFFSETFROM:+0100
TZOFFSETTO:+0200
TZNAME:CEST
DTSTART:19700329T020000
RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0200
TZOFFSETTO:+0100
TZNAME:CET
DTSTART:19701025T030000
RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
UID:62E1-56050A80-13-1A0EEC60
SUMMARY:test event
CLASS:PUBLIC
CREATED:20150925T084905Z
DTSTAMP:20150925T084905Z
LAST-MODIFIED:20150925T085132Z
DTSTART;TZID=Europe/Berlin:20150926T120000
DTEND;TZID=Europe/Berlin:20150926T130000
TRANSP:OPAQUE
SEQUENCE:1
END:VEVENT
END:VCALENDAR

ludovic

ludovic

2016-12-15 14:38

administrator   ~0011002

Suspending for now, provide more evidence if the bug is still happening.

Issue History

Date Modified Username Field Change
2015-08-02 05:48 accumulator New Issue
2015-09-23 05:26 waterstorm Note Added: 0008934
2015-09-24 02:43 Christian Mack Note Added: 0008938
2015-09-24 04:07 waterstorm Note Added: 0008941
2015-09-24 04:39 Christian Mack Note Added: 0008942
2015-09-24 04:48 waterstorm Note Added: 0008943
2015-09-24 08:40 ludovic Note Added: 0008946
2015-09-24 10:16 waterstorm Note Added: 0008948
2015-09-24 10:21 ludovic Note Added: 0008949
2015-09-24 10:24 waterstorm Note Added: 0008950
2015-09-24 10:27 ludovic Note Added: 0008951
2015-09-24 10:35 waterstorm Note Added: 0008952
2015-09-24 10:39 ludovic Note Added: 0008953
2015-09-25 03:29 Jens Erat Note Added: 0008954
2015-09-25 04:47 waterstorm Note Added: 0008955
2015-09-25 04:53 waterstorm Note Added: 0008956
2016-12-15 14:38 ludovic Note Added: 0011002
2016-12-15 14:38 ludovic Status new => closed
2016-12-15 14:38 ludovic Assigned To => ludovic
2016-12-15 14:38 ludovic Resolution open => suspended