Re: [SOGo] Timezone bug
Emmanuel Dreyfus wrote: > I have a timezone problem with invitations and Thunderbird Erratum: not about invitations but events. But the same problem happens with events generated from invitations. -- Emmanuel Dreyfus http://hcpnet.free.fr/pubz m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Timezone bug
Hello I have a timezone problem with invitations and Thunderbird (not related to the downgrade question in <1pc7rkg.1u73dxc3iterxm%m...@netbsd.org> it happened before). If I create an event in Thunderbird at 11:00, it shows in SOGo web interface at 9:00 If I create an event in SOGo web interfac at 11:00, it shows in Thunderbird at 13:00 This is Thunderbird 78.11.0 and it happens both with SOGo 2.4.1 and 4.0.1. Both software settings show timezone Europe/Paris. On the server, defaults read sogod SOGoTimeZone returns Europe/Paris. Below are both events in the database. First one is created by SOGo web interface, last one is created by Thunderbird, both at 11:00. It seems the web interface display events 2 hours before where is defined here. I guess there is a setting I missed somewhere? c_name: 6E38-60EDA700-17-6B8B4580.ics c_content: BEGIN:VCALENDAR PRODID:-//Inverse inc./SOGo 2.4.1//EN VERSION:2.0 BEGIN:VTIMEZONE TZID:Europe/Paris X-LIC-LOCATION:Europe/Paris BEGIN:DAYLIGHT TZOFFSETFROM:+0100 TZOFFSETTO:+0200 TZNAME:CEST DTSTART:19700329T02 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 TZOFFSETTO:+0100 TZNAME:CET DTSTART:19701025T03 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU END:STANDARD END:VTIMEZONE BEGIN:VEVENT UID:6E38-60EDA700-17-6B8B4580 SUMMARY:test créé par SOGo CLASS:PUBLIC CREATED:20210713T144616Z DTSTAMP:20210713T144616Z LAST-MODIFIED:20210713T144616Z DTSTART;TZID=Europe/Paris:20210714T13 DTEND;TZID=Europe/Paris:20210714T14 TRANSP:OPAQUE END:VEVENT END:VCALENDAR c_creationdate: 1626187576 c_lastmodified: 1626187576 c_version: 0 c_deleted: NULL c_name: cdec1320-dc0e-834a-b73d-9f2e4e45d633.ics c_content: BEGIN:VCALENDAR PRODID:-//Mozilla.org/NONSGML Mozilla Calendar V1.1//EN VERSION:2.0 BEGIN:VTIMEZONE TZID:Europe/Paris BEGIN:DAYLIGHT TZOFFSETFROM:+0100 TZOFFSETTO:+0200 TZNAME:CEST DTSTART:19700329T02 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 TZOFFSETTO:+0100 TZNAME:CET DTSTART:19701025T03 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED:20210713T144621Z LAST-MODIFIED:20210713T144641Z DTSTAMP:20210713T144641Z UID:cdec1320-dc0e-834a-b73d-9f2e4e45d633 SUMMARY:test créé par Thunderbird DTSTART;TZID=Europe/Paris:20210715T11 DTEND;TZID=Europe/Paris:20210715T12 TRANSP:OPAQUE CLASS:PUBLIC END:VEVENT END:VCALENDAR c_creationdate: 1626187601 c_lastmodified: 1626187601 c_version: 0 c_deleted: NULL -- Emmanuel Dreyfus http://hcpnet.free.fr/pubz m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
AW: [SOGo] Timezone bug
Hi, what timezone is set on your server and what time does it show? If your server is set to UTC and the time isn't UTC you will get this offset... Bye, Peter > -Ursprüngliche Nachricht- > Von: users-requ...@sogo.nu Im Auftrag von > m...@netbsd.org > Gesendet: Dienstag, 13. Juli 2021 17:09 > An: SOGo reporter > Betreff: Re: [SOGo] Timezone bug > > Emmanuel Dreyfus wrote: > > > I have a timezone problem with invitations and Thunderbird > > Erratum: not about invitations but events. But the same problem happens > with events generated from invitations. > > -- > Emmanuel Dreyfus > http://hcpnet.free.fr/pubz > m...@netbsd.org > -- > users@sogo.nu > https://inverse.ca/sogo/lists smime.p7s Description: S/MIME cryptographic signature
Re: [SOGo] Downgrading to SOGo 2
Hello Am 12.07.21 um 17:09 schrieb m...@netbsd.org: > > Is it safe to downgrade from SOGo 4.0.8 to 2.4.1, or would I risk havoc > because of database schema changes? > Don't do it. There are several changes involved. Check the database upgrade scripts in /usr/share/doc/sogo/sql-update-3* for examples. Also some settings respective their values have changed. Kind regards, Christian Mack -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung IT-Dienste Forschung und Lehre 78457 Konstanz +49 7531 88-4416 smime.p7s Description: S/MIME Cryptographic Signature
Re: [SOGo] Downgrading to SOGo 2
On Tue, Jul 13, 2021 at 10:40:34AM +0200, Christian Mack wrote: > Don't do it. Too late :-) > There are several changes involved. > Check the database upgrade scripts in /usr/share/doc/sogo/sql-update-3* > for examples. I did not run them. > Also some settings respective their values have changed. Is there a list somewere? I ran 4.0.1 for 48 hours, a few users have worked on it, but it seems everything is working without a hitch after downgrading to 2.4.1. What damage should I search for? -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Timezone bug
On Tue, Jul 13, 2021 at 03:33:04PM +, "Nagel, Peter" wrote: > what timezone is set on your server and what time does it show? If your > server is set to UTC and the time isn't UTC you will get this offset... Server side, default is Europe/Paris, and date indeed displays Paris time. $ ls -l /etc/localtime lrwxr-xr-x 1 root wheel 32 Oct 13 2011 /etc/localtime -> /usr/share/zoneinfo/Europe/Paris $ echo $TZ $ date Tue Jul 13 18:44:47 CEST 2021 sogod has no TZ in its environment (shown by ps -e), and SOGoTimeZone is set to Paris: # su -l sogo -c 'defaults read sogod SOGoTimeZone' sogod SOGoTimeZone Europe/Paris -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
