SOGo | BTS

Dependency Graph View Issue ] Relation Graph ] Vertical ]
related to child of duplicate of


View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0001766SOGoWeb Calendarpublic2012-04-10 08:392012-09-04 15:11
Reportertim_bln 
Assigned Tofrancis 
PrioritynormalSeveritymajorReproducibilityalways
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version1.3.14 
Target VersionFixed in Version1.3.18 
Summary0001766: Time shifts when saving/modifying events in SOGo web interface
DescriptionHi SOGo developers and users!

Sine about November, I have quite a servere problem with the Web Calender in SOGo. When Saving / Modifying events in SOGo web interface, the events (time) shift 2 hours back.

Background
System time is set to UTC, system timezone is CET - Running OS is Debian, using the original Debian packages. Problem accures either using 1.3 or 2.0 SOGo packages.

Example:
you create an event in the web interface, e.g. starting at 11 am - then saving - and the event appears at 9 am instead.

I can always reproduce this problem, The Problem is not a client Problem, was e.g. on http://sogo-demo.inverse.ca [^] everything works fine. It is also not a browser or OS issue. The problem is producable either on Linux with Firefox, or Windows with Chrome, IE9 etc. Must be a server issue...

Also with other clients, the problem is not there. When I connect to the server with my Android Phone via CalDAV or using thunderbird / iceweasel with the plugins (CalDAV) there is no timeshift when saving.

example:

- I add an event at 11 am on my mobile phone, it stays at 11 am
- on thunderbird (also connected via caldav) this new event appears correctly at 11 am
- when logging into the SOGo Web Interface, the web-calandar shows the event at 9 AM instead 11.
- The timezone in the SOGo settings is set correctly to "Europe/Berlin" - also when checking the settings in the web-interface, it shows "Europe/Berlin" corretly.

Somehow it must be a timezone problem, but I can not fix it, as the configuration seems to be correct.

I can reproduce the problem on different Debian Systems, even in a clean virtual machine... thought after a new server setup it would work up, but unfortunately it doesn't...

What do you think?
TagsNo tags attached.
Attached Filespng file icon sogo.png [^] (78,899 bytes) 2012-04-10 08:51


png file icon sogo2.png [^] (14,161 bytes) 2012-04-10 08:53


png file icon Screenshot-1.png [^] (17,648 bytes) 2012-04-16 14:56


jpg file icon screen.jpg [^] (44,079 bytes) 2012-04-20 12:32

-  Notes
(0003706)
tim_bln (reporter)
2012-04-10 09:06

as you see on the pictures. The time is set correctly, the red line is nearly at 15:00 (3PM) - So, SOGo knows the correct time and timezone.

now I create an event as shown in the first screenshot: 3-5 PM, so after saving, the new event should appear directly under the red line.

Actually it doesn't. The new event is saved with a timeshift - 2 hours back - starting at 1 PM instead of 3 PM

It must be a bug in the saving mechanismn, as now the time-shifted event also appears time shifted on devices connected via CalDAV. (mobile phones etc.)

I can modify the event with the mobile phone or via thunderbird to let it start at 3 PM. This works fine. But in the Web Interface, the event always appears 2 hours back... (e.g. if I move it starting at 5PM - on all CalDAV devices everything is fine, but in the web-interface it shows the event at 3PM.
(0003746)
remd (reporter)
2012-04-16 14:57

I am also having this issue. The red line shows the correct time and timezone, but when I save an event in the web interface it shifts back 2 hours (enter 5PM start time -- save -- SOGo web interface shows it at 3PM).

This very well may be a display error, as inspecting the database shows that SOGo is storing the time correctly. In this example I have made an event starting at 5PM - 6PM (1700 - 1800). In the web interface it displays at 3PM, however the database is storing the time correctly. (see Screenshot-1.png)

VERSION:2.0
PRODID:-//Inverse inc./SOGo 1.3.14//EN
BEGIN:VEVENT
UID:1335-4F8C6980-F-445C9A00
SUMMARY:New Event
CLASS:PUBLIC
CREATED:20120416T184904Z
DTSTAMP:20120416T184904Z
LAST-MODIFIED:20120416T184904Z
DTSTART;TZID=America/Detroit:20120417T170000
DTEND;TZID=America/Detroit:20120417T180000
TRANSP:OPAQUE
SEQUENCE:1| 1335-4F8C6980-F-445C9A00.ics | BEGIN:VCALENDAR
END:VEVENT
BEGIN:VTIMEZONE
TZID:America/Detroit
X-LIC-LOCATION:America/Detroit
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:19700308T020000
RRULE:BYDAY=2SU;FREQ=YEARLY;BYMONTH=3
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:19701101T020000
RRULE:BYDAY=1SU;FREQ=YEARLY;BYMONTH=11
END:STANDARD
END:VTIMEZONE
END:VCALENDAR
(0003801)
cmaldonado (reporter)
2012-04-21 13:50

as the file screen.jpg [^] (44,079 bytes) 2012-04-20 12:32

shows an event which ICS file:

BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Inverse inc./SOGo 1.3.14//EN
BEGIN:VEVENT
UID:4AA-4F918880-5-18AE34A0
SUMMARY:prueba 2pm
CLASS:PUBLIC
CREATED:20120420T160307Z
DTSTAMP:20120420T160307Z
LAST-MODIFIED:20120420T160516Z
DTSTART;TZID=America/Caracas:20120420T140000
DTEND;TZID=America/Caracas:20120420T183000
TRANSP:OPAQUE
SEQUENCE:2
END:VEVENT
BEGIN:VTIMEZONE
TZID:America/Caracas
X-LIC-LOCATION:America/Caracas
BEGIN:STANDARD
TZOFFSETFROM:-0430
TZOFFSETTO:-0430
TZNAME:VET
DTSTART:19700101T000000
END:STANDARD
END:VTIMEZONE
END:VCALENDAR

this is also SOGo 1.3.14 on Debian 6.0.4 (32 bit), installed from the packages at the inverse.ca repository

oddly enough, same version of SOGo on the same version of Debian on another installation (different customer) is working properly

both are virtualized the one that fails is under vmware and the one that works is inside an openvz container, I don't think if has anything to do with it, but it's a difference

Carlos Maldonado
User avatar (0003802)
ludovic (administrator)
2012-04-21 13:52

Carlos, could you spend some time on checking exactly what is different between the two systems? Look at the system timezone, GNUstep packages installed, etc.
(0003804)
cmaldonado (reporter)
2012-04-21 14:45

Yeah Ludovic, I sure can

Although I will have to get back to you on this next Tuesday, because one of the installations is a closed network testing environment which I can't access from here

I can get a list of Debian Packages, GNUStep packages, timezones, postgresql versions, sope versions, locales ... but what else do you think would be useful?

Thanks a lot for your attention

CM
(0003812)
tim_bln (reporter)
2012-04-25 05:29

here mysql, gnustep 1.22.1-2, sope 4.9.r1664.2012, system timezone Europe/Berlin

configuration is the same, issue suddenly occured after a package upgrade (maybe affected by gnustep or sope)

You can easily check the situation on Debian 7 (Wheezy) (you will have to check the issue anyway to keep the code compatible to next debian stable release, ubuntu server etc.)
(0003819)
cmaldonado (reporter)
2012-04-26 12:28
edited on: 2012-05-16 01:54

this is the installation data from the setup that doesn't work properly


sogo @ client-1

root@sogo1-int:~# dpkg -l|grep gnustep
ii gnustep-base-common 1.20.1-6 GNUstep Base library - common files
ii gnustep-base-runtime 1.20.1-6 GNUstep Base library - daemons and tools
ii gnustep-common 2.4.0-3 Common files for the core GNUstep environment
ii gnustep-make 2.4.0-3 Basic GNUstep Makefiles
ii libgnustep-base1.20 1.20.1-6 GNUstep Base library

root@sogo1-int:~# dpkg -l|grep sope
ii libsope-appserver4.9 4.9.r1664.20120323 SOPE application server libraries
ii libsope-core4.9 4.9.r1664.20120323 Core libraries of the SOPE application server
ii libsope-gdl1-4.9 4.9.r1664.20120323 GNUstep database libraries for SOPE
ii libsope-ldap4.9 4.9.r1664.20120323 SOPE libraries for LDAP access
ii libsope-mime4.9 4.9.r1664.20120323 SOPE libraries for MIME processing
ii libsope-xml4.9 4.9.r1664.20120323 SOPE libraries for XML processing
ii sope4.9-gdl1-mysql 4.9.r1664.20120323 MySQL connector for SOPE's fork of the GNUstep database environment
ii sope4.9-gdl1-postgresql 4.9.r1664.20120323 PostgreSQL connector for SOPE's fork of the GNUstep database environment
ii sope4.9-libxmlsaxdriver 4.9.r1664.20120323 XML Parser for SOPE's SAX engine

root@sogo1-int:~# uname -a
Linux sogo1-int.ops.client-1.net 2.6.32-5-686 0000001 SMP Mon Mar 26 05:20:33 UTC 2012 i686 GNU/Linux
root@sogo1-int:~# cat /etc/debian_version
6.0.4

root@sogo1-int:~# dpkg -l|grep postgres
ii postgresql 8.4.11-0squeeze1 object-relational SQL database (supported version)
ii postgresql-8.4 8.4.11-0squeeze1 object-relational SQL database, version 8.4 server
ii postgresql-client-8.4 8.4.11-0squeeze1 front-end programs for PostgreSQL 8.4
ii postgresql-client-common 113 manager for multiple PostgreSQL client versions
ii postgresql-common 113 PostgreSQL database-cluster manager
ii sope4.9-gdl1-postgresql 4.9.r1664.20120323 PostgreSQL connector for SOPE's fork of the GNUstep database environment

root@sogo1-int:~# dpkg -l|grep tzdata
ii tzdata 2011n-0squeeze1 time zone and daylight-saving time data

root@sogo1-int:~# date
Thu Apr 26 10:28:11 VET 2012

/home/sogo/GNUstep/Defaults/.GNUstepDefaults


?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//GNUstep//DTD plist 0.9//EN" "http://www.gnustep.org/plist-0_9.xml"> [^]
<plist version="0.9">
<dict>
    <key>NSGlobalDomain</key>
    <dict>
    </dict>
    <key>sogod</key>
    <dict>
        <key>OCSFolderInfoURL</key>
        <string>postgresql://sogo:Passw0rd@localhost:5432/sogo/sogo_folder_info</string>
        <key>OCSSessionsFolderURL</key>
        <string>postgresql://sogo:Passw0rd@localhost:5432/sogo/sogo_sessions_folder</string>
        <key>SOGoACLsSendEMailNotifications</key>
        <string>YES</string>
        <key>SOGoAppointmentSendEMailNotifications</key>
        <string>YES</string>
        <key>SOGoDraftsFolderName</key>
        <string>INBOX.Drafts</string>
        <key>SOGoFoldersSendEMailNotifications</key>
        <string>YES</string>
        <key>SOGoForceIMAPLoginWithEmail</key>
        <string>YES</string>
        <key>SOGoMailShowSubscribedFoldersOnly</key>
        <string>YES</string>
        <key>SOGoForwardEnabled</key>
        <string>NO</string>
        <key>SOGoIMAPAclStyle</key>
        <string>rfc4314</string>
        <key>SOGoIMAPServer</key>
        <string>imap://mailstore1-int.ops.client-1.net:143</string>
        <key>SOGoLanguage</key>
        <string>Spanish</string>
        <key>SOGoMailDomain</key>

        <string>client-1.com.ve</string>
        <key>SOGoMailMessageCheck</key>
        <string>every_5_minutes</string>
        <key>SOGoMailingMechanism</key>
        <string>smtp</string>
        <key>SOGoMemcachedHost</key>
        <string>localhost</string>
        <key>SOGoPageTitle</key>
        <string>SOGo client-1 - Herramienta Colaborativa</string>
        <key>SOGoProfileURL</key>
        <string>postgresql://sogo:Passw0rd@localhost:5432/sogo/sogo_user_profile</string>
        <key>SOGoSMTPServer</key>
        <string>ispmail1.client-1.net</string>
        <key>SOGoSentFolderName</key>
        <string>INBOX.Sent</string>
        <key>SOGoSharedFolderName</key>
        <string>Shared</string>
        <key>SOGoTimeZone</key>
        <string>America/Caracas</string>
        <key>SOGoTrashFolderName</key>
        <string>INBOX.Trash</string>
        <key>SOGoUserSources</key>
        <array>
            <dict>
                <key>CNFieldName</key>
                <string>cn</string>
                <key>IDFieldName</key>
                <string>mail</string>
                <key>UIDFieldName</key>
                <string>uid</string>
                <key>baseDN</key>
                <string>ou=People,dc=client-1,dc=com,dc=ve</string>
                <key>bindDN</key>
                <string>cn=authsysuser,ou=Correo,ou=Aplicaciones,o=client-1,dc=client-1,dc=com,dc=ve</string>

                <key>bindFields</key>
                <string>cn,mail,uid</string>
                <key>bindPassword</key>
                <string>xxxxxxxx</string>
                <key>canAuthenticate</key>
                <string>YES</string>
                <key>displayName</key>
                <string>Paginas Blancas client-1</string>
                <key>hostname</key>
                <string>mail.client-1.net</string>
                <key>id</key>
                <string>client-1</string>
                <key>isAddressBook</key>
                <string>YES</string>
                <key>port</key>
                <string>389</string>
            </dict>
        </array>
        <key>SOGoVacationEnabled</key>
        <string>NO</string>
        <key>SOGoAddressBookDAVAccessEnabled</key>
        <string>YES</string>
        <key>SOGoCalendarDAVAccessEnabled</key>
        <string>YES</string>
        <key>WOWorkersCount</key>
        <string>9</string>
    </dict>
</dict>
</plist>


this is the installation data from the sogo that does work properly

sogo @ client-2

root@correo:~# dpkg -l|grep gnustep
ii gnustep-base-common 1.20.1-6 GNUstep Base library - common files
ii gnustep-base-runtime 1.20.1-6 GNUstep Base library - daemons and tools
ii gnustep-common 2.4.0-3 Common files for the core GNUstep environment
ii gnustep-make 2.4.0-3 Basic GNUstep Makefiles
ii libgnustep-base1.20 1.20.1-6 GNUstep Base library
root@correo:~# dpkg -l|grep sope
ii libsope-appserver4.9 4.9.r1664.20120323 SOPE application server libraries
ii libsope-core4.9 4.9.r1664.20120323 Core libraries of the SOPE application server
ii libsope-gdl1-4.9 4.9.r1664.20120323 GNUstep database libraries for SOPE
ii libsope-ldap4.9 4.9.r1664.20120323 SOPE libraries for LDAP access
ii libsope-mime4.9 4.9.r1664.20120323 SOPE libraries for MIME processing
ii libsope-xml4.9 4.9.r1664.20120323 SOPE libraries for XML processing
ii sope4.9-gdl1-postgresql 4.9.r1664.20120323 PostgreSQL connector for SOPE's fork of the GNUstep database environment
ii sope4.9-libxmlsaxdriver 4.9.r1664.20120323 XML Parser for SOPE's SAX engine


root@correo:~# uname -a
Linux correo 2.6.32-6-pve 0000001 SMP Mon Sep 26 06:32:53 CEST 2011 i686 GNU/Linux
root@correo:~# cat /etc/debian_version
6.0.4

root@correo:~# dpkg -l|grep postgres
ii postgresql 8.4.10-0squeeze1 object-relational SQL database (supported version)
ii postgresql-8.4 8.4.10-0squeeze1 object-relational SQL database, version 8.4 server
ii postgresql-client-8.4 8.4.10-0squeeze1 front-end programs for PostgreSQL 8.4
ii postgresql-client-common 113 manager for multiple PostgreSQL client versions
ii postgresql-common 113 PostgreSQL database-cluster manager
ii sope4.9-gdl1-postgresql 4.9.r1664.20120323 PostgreSQL connector for SOPE's fork of the GNUstep database environment

root@correo:~# dpkg -l|grep tzdata
ii tzdata 2011n-0squeeze1 time zone and daylight-saving time data

root@correo:~# date
Thu Apr 26 15:26:27 UTC 2012

/home/sogo/GNUstep/Defaults/.GNUstepDefaults contents


<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//GNUstep//DTD plist 0.9//EN" "http://www.gnustep.org/plist-0_9.xml"> [^]
<plist version="0.9">
<dict>
    <key>NSGlobalDomain</key>
    <dict>
    </dict>
    <key>sogod</key>
    <dict>
        <key>OCSFolderInfoURL</key>
        <string>postgresql://sogo:sogo@dbsogo.client-2.gob.ve:5432/sogo/sogo_folder_info</string>
        <key>OCSSessionsFolderURL</key>
        <string>postgresql://sogo:sogo@dbsogo.client-2.gob.ve:5432/sogo/sogo_sessions_folder</string>
        <key>SOGoACLsSendEMailNotifications</key>
        <string>YES</string>
        <key>SOGoAppointmentSendEMailNotifications</key>
        <string>YES</string>
        <key>SOGoDraftsFolderName</key>
        <string>Borradores</string>
        <key>SOGoFoldersSendEMailNotifications</key>
        <string>YES</string>
        <key>SOGoForwardEnabled</key>
        <string>YES</string>
        <key>SOGoIMAPServer</key>
        <string>imap://192.168.22.41</string>
        <key>SOGoLanguage</key>
        <string>Spanish</string>
        <key>SOGoMailDomain</key>
        <string>client-2.gob.ve</string>
        <key>SOGoMailMessageCheck</key>
        <string>every_5_minutes</string>
        <key>SOGoMailingMechanism</key>
        <string>smtp</string>
        <key>SOGoMemcachedHost</key>
        <string>127.0.0.1</string>
        <key>SOGoPageTitle</key>
        <string>SOGo client-2 - Herramienta Colaborativa</string>
        <key>SOGoProfileURL</key>
        <string>postgresql://sogo:sogo@dbsogo.client-2.gob.ve:5432/sogo/sogo_user_profile</string>
        <key>SOGoSMTPServer</key>
        <string>192.168.22.14</string>
        <key>SOGoSentFolderName</key>
        <string>Enviados</string>
        <key>SOGoSieveScriptsEnabled</key>
        <string>YES</string>
        <key>SOGoSieveServer</key>
        <string>sieve://192.168.22.14:2000</string>
        <key>SOGoTimeZone</key>
        <string>America/Caracas</string>
        <key>SOGoTrashFolderName</key>
        <string>Papelera</string>
        <key>SOGoUserSources</key>
        <array>
            <dict>
                <key>CNFieldName</key>
                <string>cn</string>
                <key>IDFieldName</key>
                <string>uid</string>
                <key>UIDFieldName</key>
                <string>uid</string>
                <key>baseDN</key>
                <string>ou=people,dc=client-2,dc=gob,dc=ve</string>
                <key>bindDN</key>
                <string>cn=admin,dc=client-2,dc=gob,dc=ve</string>
                <key>bindPassword</key>
                <string>xxxxxxxxx</string>
                <key>canAuthenticate</key>
                <string>YES</string>
                <key>displayName</key>
                <string>Paginas Blancas client-2</string>
                <key>hostname</key>
                <string>localhost</string>
                <key>id</key>
                <string>client-2</string>
                <key>isAddressBook</key>
                <string>YES</string>
                <key>port</key>
                <string>389</string>
            </dict>
        </array>
        <key>SOGoVacationEnabled</key>
        <string>YES</string>
        <key>SOGoAddressBookDAVAccessEnabled</key>
        <string>YES</string>
        <key>SOGoCalendarDAVAccessEnabled</key>
        <string>YES</string>
        <key>WOWorkersCount</key>
        <string>9</string>
    </dict>
</dict>
</plist>

when I noticed that one server was using UTC time, I tried changing it to see if it worked properly and it didn't, so I reverted the changes and this is how they are set up at the moment

Carlos Maldonado

(0004296)
phandaal (reporter)
2012-08-08 04:17
edited on: 2012-08-08 11:07

I am also seeing the problem :
1.3.17 fresh install
2.0.0 fresh install

<key>SOGoTimeZone</key>
<string>Europe/Paris</string>

System timezone Europe/Paris (UTC+0200)

Event created on 14h00 appears at 10h00 in the WebUI (and is labelled 10h- in the popup when clicking on it), database entry shows 12h00 for DTSTART
Event modified in the WebUI (D&D from 10h00 to 16h00), appears at 14h00 in the WebUI, database entry shows 16h00 for DTSTART

Events created in Lightning show at correct time, database entry correct to.
Moving an event in Lightning modifies correctly the database and shows at the right position.

Event created in Lightning at 14h00 shows at 12h00 in WebUI.

I tried several combinations of SOGoTimeZones and system time zones without making the problem dissapear.
It appears to be a problem related to the information exchange between the WebUI and the server. The time shift is applied two times at creation and one time at display, time shift seems to be related to shift between server/sogotimezone and UTC (I am at UTC+2, events shift by 2 hours).

(0004300)
phandaal (reporter)
2012-08-08 11:06

Just recompiled 1.3.17 from sources on Debian, the problem does _not_ occur in the recompiled version. All events are correctly placed and labelled on the WebUI and in Lightning, when created and/or moved. Exact same configuration (and same server) as the previous version (packages from inverse.ca/debian).
I did no modification to the sources, they are straight from the monotone repository.

How are the .deb available on the inverse.ca/debian repository compiled ?
User avatar (0004359)
ludovic (administrator)
2012-08-21 12:44

We will produce shortly packages for Wheezy, so you might want to try this.
(0004379)
tim_bln (reporter)
2012-08-26 13:19

Oh Thank you Ludovic !

Problem is solved with that Wheezy Packages! Thank you so much! And all the others cmaldonado and phandaal! (you got the great idea to recompile the sources with the same settings...)

- Issue History
Date Modified Username Field Change
2012-04-10 08:39 tim_bln New Issue
2012-04-10 08:51 tim_bln File Added: sogo.png
2012-04-10 08:53 tim_bln File Added: sogo2.png
2012-04-10 09:06 tim_bln Note Added: 0003706
2012-04-11 03:38 Christian Mack Note Added: 0003714
2012-04-11 03:38 Christian Mack Note Deleted: 0003714
2012-04-16 14:56 remd File Added: Screenshot-1.png
2012-04-16 14:57 remd Note Added: 0003746
2012-04-20 12:32 cmaldonado File Added: screen.jpg
2012-04-21 13:50 cmaldonado Note Added: 0003801
2012-04-21 13:52 ludovic Note Added: 0003802
2012-04-21 14:45 cmaldonado Note Added: 0003804
2012-04-25 05:29 tim_bln Note Added: 0003812
2012-04-25 13:28 wsourdeau Relationship added related to 0001778
2012-04-26 12:28 cmaldonado Note Added: 0003819
2012-04-26 12:29 cmaldonado Note Edited: 0003819
2012-04-26 12:32 cmaldonado Note Edited: 0003819
2012-05-16 01:54 cmaldonado Note Edited: 0003819
2012-08-08 04:17 phandaal Note Added: 0004296
2012-08-08 11:06 phandaal Note Added: 0004300
2012-08-08 11:07 phandaal Note Edited: 0004296
2012-08-21 12:44 ludovic Note Added: 0004359
2012-08-26 13:19 tim_bln Note Added: 0004379
2012-09-04 15:10 francis Status new => resolved
2012-09-04 15:10 francis Fixed in Version => 1.3.18
2012-09-04 15:10 francis Resolution open => fixed
2012-09-04 15:10 francis Assigned To => francis
2013-05-14 04:34 Christian Mack Relationship added related to 0002320


Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker