RE: [SOGo] Wrong time in WEB SOGo (5.5.1)
Hello
Old messages do not need to be recoded. But new ones are created all the same
with UTC timezone
maybe I did something wrong?
I just replaced the file in /usr/share/zoneinfo/Europe/Moscow
Best regards, Taras
27.07.2022, 14:55, < mailto:users@sogo.nu users@sogo.nu >
On Thu, Jul 21, 2022 at 08:50:45PM +, "? ???" wrote: > But it
didn't help me That will only impact event you create after installing the TZv1
file. Do youi still have the bug for newly created events? If you want to fix
the older events created while you had the TZv2 file, you will need to edit the
database. Below is the script I wrote to do that. You will need to adjust at
least the time zone (Europe/Paris in my case) and the date after which event
should be fixed, which is the day you updated the system and got the TZv2 file
(1587001800 in case). You probably also need to adjust the charset. I advise
you to work on a copy of your SOGo installation. Make a backup, run the script,
check for bugs, fix, restore backup and start over. Unfortunately there is no
way to spot events that users moved back to the appropriate time within the web
interface. The script will fix their time as if they were incorrect, relulting
in an icorrect time. --- cut here --- #!/bin/sh # create an ic() helper
function mysql << EOT DELIMITER // CREATE FUNCTION ics(haystack mediumtext,
field varchar(64)) RETURNS varchar(256) CHARACTER SET 'latin1' COLLATE
'latin1_swedish_ci' DETERMINISTIC BEGIN RETURN substr(haystack, instr(haystack,
field) + length(field), instr(substr(haystack, instr(haystack, field) +
length(field)),'\r') - 1); END // DELIMITER ; EOT for i in `echo " select
substr(c_location, instr(c_location, '/sogo/')+ 6) from sogo_folder_info where
c_folder_type='Appointment';" | mysql -ABN sogo` ; do echo " update ${i} set
c_content = replace( c_content, concat('DTSTART;TZID=Europe/Paris:',
ics(c_content, 'DTSTART;TZID=Europe/Paris:') ),
concat('DTSTART;TZID=Europe/Paris:', date_format( convert_tz( str_to_date(
ics(c_content, 'DTSTART;TZID=Europe/Paris:'),'%Y%m%dT%H%i%S'
),'Europe/Paris','UTC' ),'%Y%m%dT%H%i%S' ) ) ) where ics(c_content, 'PRODID:')
like '-//Inverse inc./SOGo%' and c_creationdate > 1587001800 and c_content like
'%DTSTART;TZID=Europe/Paris:%'; update ${i} set c_content = replace( c_content,
concat('DTEND;TZID=Europe/Paris:', ics(c_content, 'DTEND;TZID=Europe/Paris:')
), concat('DTEND;TZID=Europe/Paris:', date_format( convert_tz( str_to_date(
ics(c_content, 'DTEND;TZID=Europe/Paris:'),'%Y%m%dT%H%i%S'
),'Europe/Paris','UTC' ),'%Y%m%dT%H%i%S' ) ) ) where ics(c_content, 'PRODID:')
like '-//Inverse inc./SOGo%' and c_creationdate > 1587001800 and c_content like
'%DTEND;TZID=Europe/Paris:%'; update ${i}_quick q, ${i} c set q.c_startdate =
unix_timestamp( convert_tz( from_unixtime(q.c_startdate),'Europe/Paris','UTC' )
), q.c_enddate = unix_timestamp( convert_tz(
from_unixtime(q.c_enddate),'Europe/Paris','UTC' ) ), q.c_cycleenddate =
unix_timestamp( convert_tz(
from_unixtime(q.c_cycleenddate),'Europe/Paris','UTC' ) ) where q.c_name =
c.c_name and ics(c.c_content, 'PRODID:') like '-//Inverse inc./SOGo%' and
c.c_creationdate > 1587001800 and c.c_content like
'%DTSTART;TZID=Europe/Paris:%'; update ${i}_quick q, ${i} c set q.c_nextalarm =
unix_timestamp( convert_tz( from_unixtime(q.c_nextalarm),'Europe/Paris','UTC' )
) where q.c_name = c.c_name and q.c_nextalarm != 0 and ics(c.c_content,
'PRODID:') like '-//Inverse inc./SOGo%' and c.c_creationdate > 1587001800 and
c.c_content like '%DTSTART;TZID=Europe/Paris:%';" done --- cut here --- --
Emmanuel Dreyfus /compose/ m...@netbsd.org -- /compose/ users@sogo.nu
https://inverse.ca/sogo/lists https://inverse.ca/sogo/lists
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] Wrong time in WEB SOGo (5.5.1)
On Thu, Jul 21, 2022 at 08:50:45PM +, "? ???" wrote:
> But it didn't help me
That will only impact event you create after installing the TZv1 file.
Do youi still have the bug for newly created events?
If you want to fix the older events created while you had the TZv2 file,
you will need to edit the database. Below is the script I wrote to do
that. You will need to adjust at least the time zone (Europe/Paris in
my case) and the date after which event should be fixed, which is the
day you updated the system and got the TZv2 file (1587001800 in case).
You probably also need to adjust the charset.
I advise you to work on a copy of your SOGo installation. Make a backup,
run the script, check for bugs, fix, restore backup and start over.
Unfortunately there is no way to spot events that users moved back to
the appropriate time within the web interface. The script will
fix their time as if they were incorrect, relulting in an icorrect
time.
--- cut here ---
#!/bin/sh
# create an ic() helper function
mysql << EOT
DELIMITER //
CREATE FUNCTION ics(haystack mediumtext, field varchar(64))
RETURNS varchar(256) CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci'
DETERMINISTIC
BEGIN
RETURN substr(haystack,
instr(haystack, field) + length(field),
instr(substr(haystack,
instr(haystack, field) + length(field)),
'\r') - 1);
END //
DELIMITER ;
EOT
for i in `echo "
select substr(c_location, instr(c_location, '/sogo/')+ 6)
from sogo_folder_info
where c_folder_type='Appointment';" | mysql -ABN sogo` ; do
echo "
update ${i}
set c_content = replace(
c_content,
concat(
'DTSTART;TZID=Europe/Paris:',
ics(c_content, 'DTSTART;TZID=Europe/Paris:')
),
concat('DTSTART;TZID=Europe/Paris:',
date_format(
convert_tz(
str_to_date(
ics(c_content,
'DTSTART;TZID=Europe/Paris:'),
'%Y%m%dT%H%i%S'
),
'Europe/Paris',
'UTC'
),
'%Y%m%dT%H%i%S'
)
)
)
where ics(c_content, 'PRODID:') like '-//Inverse inc./SOGo%'
and c_creationdate > 1587001800
and c_content like '%DTSTART;TZID=Europe/Paris:%';
update ${i}
set c_content = replace(
c_content,
concat(
'DTEND;TZID=Europe/Paris:',
ics(c_content, 'DTEND;TZID=Europe/Paris:')
),
concat('DTEND;TZID=Europe/Paris:',
date_format(
convert_tz(
str_to_date(
ics(c_content,
'DTEND;TZID=Europe/Paris:'),
'%Y%m%dT%H%i%S'
),
'Europe/Paris',
'UTC'
),
'%Y%m%dT%H%i%S'
)
)
)
where ics(c_content, 'PRODID:') like '-//Inverse inc./SOGo%'
and c_creationdate > 1587001800
and c_content like '%DTEND;TZID=Europe/Paris:%';
update ${i}_quick q, ${i} c
set q.c_startdate = unix_timestamp(
convert_tz(
from_unixtime(q.c_startdate),
'Europe/Paris',
'UTC'
)
),
q.c_enddate = unix_timestamp(
convert_tz(
from_unixtime(q.c_enddate),
'Europe/Paris',
'UTC'
)
),
q.c_cycleenddate = unix_timestamp(
convert_tz(
from_unixtime(q.c_cycleenddate),
'Europe/Paris',
'UTC'
)
)
where q.c_name = c.c_name
and ics(c.c_content, 'PRODID:') like '-//Inverse inc./SOGo%'
and c.c_creationdate > 1587001800
and c.c_content like '%DTSTART;TZID=Europe/Paris:%';
update ${i}_quick q, ${i} c
set q.c_nextalarm = unix_timestamp(
convert_tz(
from_unixtime(q.c_nextalarm),
'Europe/Paris',
'UTC'
)
)
where q.c_name = c.c_name
and q.c_nextalarm != 0
and ics(c.c_content, 'PRODID:') like '-//Inverse inc./SOGo%'
and c.c_creationdate > 1587001800
and c.c_content like '%DTSTART;TZID=Europe/Paris:%';
"
done
--- cut here ---
--
Emmanuel Dreyfus
m...@netbsd.org
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] Wrong time in WEB SOGo (5.5.1)
On Thu, Jul 21, 2022 at 03:51:57PM +0200, Christian Mack wrote: > That in turn means, that your local timezone does not work as Emmanuel > Dreyfus suggests. That problem will strike more and more often, as all systems move to TZ v2 or v3. Unfortunately, backporting the code I contributed to GNUstep base so that it works with 1.28.0 is not obvious. We need to start lobbying for a GNUstep base 1.29.0 release! -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Wrong time in WEB SOGo (5.5.1)
Hello
Am 21.07.22 um 09:49 schrieb "Тарас Гуденко" (gtg2...@rambler.ru):
During installation, created a user _sogo ( but not sogo)
[adminncts@SRV-MAIL ~]$ sudo -u _sogo locale
LANG=ru_RU.UTF-8
[...]
LC_TIME="ru_RU.UTF-8"
[...]
LC_ALL=
The actual name doesn't matter, as log as that is the user the SOGo
daemon runs as.
And the above 3 settings mean, that this user uses ru_RU's timezone.
So Europe/Moscow is used there too.
That in turn means, that your local timezone does not work as Emmanuel
Dreyfus suggests.
Kind regards,
Christian Mack
19.07.2022, 10:52, mailto:users@sogo.nu>>
Hello
OK, those settings are alright.
What does the following command give you?
sudo -u sogo locale
Kind regards,
Christian Mack
Am 18.07.22 um 20:32 schrieb "Тарас Гуденко" (gtg2...@rambler.ru):
> Hello,
>
> Attached a screenshot of the user settings
>
>
>
> Best regards, Taras.
>
>
> 18.07.2022, 16:12, mailto:users@sogo.nu>>
> Hello
>
> Am 17.07.22 um 10:04 schrieb gtg2...@rambler.ru:
> > Hello,
> > Where you need to check Settings --> General --> Timezone,
system
> or SOGo ?
>
> That one is in the webinterface of SOGo, while logged in as
the User
> with that problem.
>
> >
> > Settings SOGo:
> > SOGoTimeZone = Europe/Moscow;
> >
>
> That is the standard set Timezone in sogo.conf.
>
> > System :
> > # date
> > Вс 17 июл 2022 10:53:14 MSK
> >
> > #timedatectl
> > Local time: Вс 2022-07-17 10:53:56 MSK
> > Universal time: Вс 2022-07-17 07:53:56 UTC
> > RTC time: Вс 2022-07-17 07:53:56
> > Time zone: Europe/Moscow (MSK, +0300)
> > System clock synchronized: yes
> >NTP service: active
> >RTC in local TZ: yes
> >
> > I also noticed that in sogo.log also shows the wrong time.
> >
> > Best regards, Taras.
> >
>
> What does locale show you for sogo user?
>
>
> Kind regards,
> Christian Mack
>
> > -Original Message-
> > From: users-requ...@sogo.nu On
Behalf Of
> Christian Mack
> > Sent: Thursday, July 14, 2022 2:09 PM
> > To: users@sogo.nu
> > Subject: Re: [SOGo] Wrong time in WEB SOGo (5.5.1)
> >
> > Hello
> >
> > Which timezone has the user set in Preferences --> General -->
> Time Zone ?
> >
> >
> > Kind regards,
> > Christian Mack
> >
> > Am 30.06.22 um 10:23 schrieb gtg2...@rambler.ru:
> >> Hello
> >>
> >> The list of sent and received emails in the web interface
shows
> the wrong
> >> time (UTC), should be (UTC+3)
> >>
> >> The calendar SOGo shows correct time (UTC+3), in
Thunderbird, the
> time of
> >> letters and calendar shows correctly too
> >>
> >>
> >>
> >> installation
> >>
> >> ALTLinux - SOGo (5.5.1) - postfix - dovecot - postgresql
> >>
> >>
> >>
> >> Settings:
> >>
> >> SOGo.conf : SOGoTimeZone = Europe/Moscow;
> >>
> >> ls -l /etc/localtime /etc/localtime ->
> >> /usr/share/zoneinfo/Europe/Moscow
> >>
> >>
> >>
> >> Please write where I could miss the settings or why SOGo shows
> the wrong
> >> time (UTC)
> >>
> >>
> >>
> >> Best regards, Taras
> >>
> >
> >
>--
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung IT-Dienste Forschung, Lehre, Infrastruktur
78457 Konstanz
+49 7531 88-4416
smime.p7s
Description: S/MIME Cryptographic Signature
Re: [SOGo] Wrong time in WEB SOGo (5.5.1)
On Thu, Jul 21, 2022 at 10:15:09AM +0300, gtg2...@rambler.ru wrote: > Unfortunately I couldn't find v1 format You can steal it from antoher OS: http://archive.netbsd.org/pub/NetBSD-archive/NetBSD-5.2.3/i386/binary/sets/base.tgz tar -xzf base.tgz ./usr/share/zoneinfo/Europe/Moscow Of course I assume you can live with a few leap seconds missing. -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
RE: [SOGo] Wrong time in WEB SOGo (5.5.1)
Hello During installation, created a user _sogo ( but not sogo) [adminncts@SRV-MAIL ~]$ sudo -u _sogo locale LANG=ru_RU.UTF-8 LC_CTYPE="ru_RU.UTF-8" LC_NUMERIC="ru_RU.UTF-8" LC_TIME="ru_RU.UTF-8" LC_COLLATE="ru_RU.UTF-8" LC_MONETARY="ru_RU.UTF-8" LC_MESSAGES="ru_RU.UTF-8" LC_PAPER="ru_RU.UTF-8" LC_NAME="ru_RU.UTF-8" LC_ADDRESS="ru_RU.UTF-8" LC_TELEPHONE="ru_RU.UTF-8" LC_MEASUREMENT="ru_RU.UTF-8" LC_IDENTIFICATION="ru_RU.UTF-8" LC_ALL= Best regards, Taras. 19.07.2022, 10:52, < mailto:users@sogo.nu users@sogo.nu > Hello OK, those settings are alright. What does the following command give you? sudo -u sogo locale Kind regards, Christian Mack Am 18.07.22 um 20:32 schrieb "Тарас Гуденко" ( /compose/ gtg2...@rambler.ru ): > Hello, > > Attached a screenshot of the user settings > > > > Best regards, Taras. > > > 18.07.2022, 16:12, < /compose/ users@sogo.nu < /compose/ mailto:users@sogo.nu >> > Hello > > Am 17.07.22 um 10:04 schrieb /compose/ gtg2...@rambler.ru: > > Hello, > > Where you need to check Settings --> General --> Timezone, system > or SOGo ? > > That one is in the webinterface of SOGo, while logged in as the User > with that problem. > > > > > Settings SOGo: > > SOGoTimeZone = Europe/Moscow; > > > > That is the standard set Timezone in sogo.conf. > > > System : > > # date > > Вс 17 июл 2022 10:53:14 MSK > > > > #timedatectl > > Local time: Вс 2022-07-17 10:53:56 MSK > > Universal time: Вс 2022-07-17 07:53:56 UTC > > RTC time: Вс 2022-07-17 07:53:56 > > Time zone: Europe/Moscow (MSK, +0300) > > System clock synchronized: yes > >NTP service: active > >RTC in local TZ: yes > > > > I also noticed that in sogo.log also shows the wrong time. > > > > Best regards, Taras. > > > > What does locale show you for sogo user? > > > Kind regards, > Christian Mack > > > -Original Message- > > From: /compose/ users-requ...@sogo.nu < /compose/ users-requ...@sogo.nu > On Behalf Of > Christian Mack > > Sent: Thursday, July 14, 2022 2:09 PM > > To: /compose/ users@sogo.nu > > Subject: Re: [SOGo] Wrong time in WEB SOGo (5.5.1) > > > > Hello > > > > Which timezone has the user set in Preferences --> General --> > Time Zone ? > > > > > > Kind regards, > > Christian Mack > > > > Am 30.06.22 um 10:23 schrieb /compose/ gtg2...@rambler.ru: > >> Hello > >> > >> The list of sent and received emails in the web interface shows > the wrong > >> time (UTC), should be (UTC+3) > >> > >> The calendar SOGo shows correct time (UTC+3), in Thunderbird, the > time of > >> letters and calendar shows correctly too > >> > >> > >> > >> installation > >> > >> ALTLinux - SOGo (5.5.1) - postfix - dovecot - postgresql > >> > >> > >> > >> Settings: > >> > >> SOGo.conf : SOGoTimeZone = Europe/Moscow; > >> > >> ls -l /etc/localtime /etc/localtime -> > >> /usr/share/zoneinfo/Europe/Moscow > >> > >> > >> > >> Please write where I could miss the settings or why SOGo shows > the wrong > >> time (UTC) > >> > >> > >> > >> Best regards, Taras > >> > > > > > > > -- > Christian Mack > Universität Konstanz > Kommunikations-, Informations-, Medienzentrum (KIM) > Abteilung IT-Dienste Forschung und Lehre > 78457 Konstanz > +49 7531 88-4416 > > -- > /compose/ users@sogo.nu > https://inverse.ca/sogo/lists https://inverse.ca/sogo/lists -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung IT-Dienste Forschung, Lehre, Infrastruktur 78457 Konstanz +49 7531 88-4416 -- users@sogo.nu https://inverse.ca/sogo/lists
RE: [SOGo] Wrong time in WEB SOGo (5.5.1)
You're right TZif2 [root@SRV-MAIL ~]# hexdump -C /usr/share/zoneinfo/Europe/Moscow | head 54 5a 69 66 32 00 00 00 00 00 00 00 00 00 00 00 |TZif2...| 0010 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 || 0020 00 00 00 00 00 00 00 01 00 00 00 01 00 00 00 00 || 0030 00 00 00 54 5a 69 66 32 00 00 00 00 00 00 00 00 |...TZif2| 0040 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 || 0050 00 00 00 00 00 00 4e 00 00 00 0b 00 00 00 26 ff |..N...&.| 0060 ff ff ff 56 b6 c0 c7 ff ff ff ff 9b 5f 1e c7 ff |...V_...| 0070 ff ff ff 9d 3e f2 79 ff ff ff ff 9e 2a ee f9 ff |>.y.*...| 0080 ff ff ff 9e f7 39 69 ff ff ff ff 9f 84 57 f9 ff |.9i..W..| 0090 ff ff ff a0 d8 6c e9 ff ff ff ff a1 00 39 80 ff |.l...9..| Unfortunately I couldn't find v1 format Best regards, Taras. -Original Message- From: users-requ...@sogo.nu On Behalf Of Emmanuel Dreyfus Sent: Tuesday, July 19, 2022 3:49 AM To: "? ???" Subject: Re: [SOGo] Wrong time in WEB SOGo (5.5.1) On Mon, Jul 18, 2022 at 07:34:57PM +, "? ???" wrote: > Here is the command output > [root@SRV-MAIL ~]# file /usr/share/zoneinfo/Europe/Moscow > /usr/share/zoneinfo/Europe/Moscow: timezone data [root@SRV-MAIL ~]# How to understand what version it is? v2 ? Your file(1) is not smart enough. Try hexdump -C /usr/share/zoneinfo/Europe/Moscow | head v1 format start by TZif or just a bunch of nul bytes v2 format start by TZif2 -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists -- Это сообщение проверено на вирусы антивирусом Avast. https://www.avast.com/antivirus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Wrong time in WEB SOGo (5.5.1)
Hello OK, those settings are alright. What does the following command give you? sudo -u sogo locale Kind regards, Christian Mack Am 18.07.22 um 20:32 schrieb "Тарас Гуденко" (gtg2...@rambler.ru): > Hello, > > Attached a screenshot of the user settings > > > > Best regards, Taras. > > > 18.07.2022, 16:12, mailto:users@sogo.nu>> > Hello > > Am 17.07.22 um 10:04 schrieb gtg2...@rambler.ru: > > Hello, > > Where you need to check Settings --> General --> Timezone, system > or SOGo ? > > That one is in the webinterface of SOGo, while logged in as the User > with that problem. > > > > > Settings SOGo: > > SOGoTimeZone = Europe/Moscow; > > > > That is the standard set Timezone in sogo.conf. > > > System : > > # date > > Вс 17 июл 2022 10:53:14 MSK > > > > #timedatectl > > Local time: Вс 2022-07-17 10:53:56 MSK > > Universal time: Вс 2022-07-17 07:53:56 UTC > > RTC time: Вс 2022-07-17 07:53:56 > > Time zone: Europe/Moscow (MSK, +0300) > > System clock synchronized: yes > >NTP service: active > >RTC in local TZ: yes > > > > I also noticed that in sogo.log also shows the wrong time. > > > > Best regards, Taras. > > > > What does locale show you for sogo user? > > > Kind regards, > Christian Mack > > > -Original Message- > > From: users-requ...@sogo.nu On Behalf Of > Christian Mack > > Sent: Thursday, July 14, 2022 2:09 PM > > To: users@sogo.nu > > Subject: Re: [SOGo] Wrong time in WEB SOGo (5.5.1) > > > > Hello > > > > Which timezone has the user set in Preferences --> General --> > Time Zone ? > > > > > > Kind regards, > > Christian Mack > > > > Am 30.06.22 um 10:23 schrieb gtg2...@rambler.ru: > >> Hello > >> > >> The list of sent and received emails in the web interface shows > the wrong > >> time (UTC), should be (UTC+3) > >> > >> The calendar SOGo shows correct time (UTC+3), in Thunderbird, the > time of > >> letters and calendar shows correctly too > >> > >> > >> > >> installation > >> > >> ALTLinux - SOGo (5.5.1) - postfix - dovecot - postgresql > >> > >> > >> > >> Settings: > >> > >> SOGo.conf : SOGoTimeZone = Europe/Moscow; > >> > >> ls -l /etc/localtime /etc/localtime -> > >> /usr/share/zoneinfo/Europe/Moscow > >> > >> > >> > >> Please write where I could miss the settings or why SOGo shows > the wrong > >> time (UTC) > >> > >> > >> > >> Best regards, Taras > >> > > > > > > > -- > Christian Mack > Universität Konstanz > Kommunikations-, Informations-, Medienzentrum (KIM) > Abteilung IT-Dienste Forschung und Lehre > 78457 Konstanz > +49 7531 88-4416 > > -- > users@sogo.nu > https://inverse.ca/sogo/lists -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung IT-Dienste Forschung, Lehre, Infrastruktur 78457 Konstanz +49 7531 88-4416 smime.p7s Description: S/MIME Cryptographic Signature
Re: [SOGo] Wrong time in WEB SOGo (5.5.1)
On Mon, Jul 18, 2022 at 07:34:57PM +, "? ???" wrote: > Here is the command output > [root@SRV-MAIL ~]# file /usr/share/zoneinfo/Europe/Moscow > /usr/share/zoneinfo/Europe/Moscow: timezone data [root@SRV-MAIL ~]# > How to understand what version it is? v2 ? Your file(1) is not smart enough. Try hexdump -C /usr/share/zoneinfo/Europe/Moscow | head v1 format start by TZif or just a bunch of nul bytes v2 format start by TZif2 -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
RE: [SOGo] Wrong time in WEB SOGo (5.5.1)
Hello. Thanks for the answer Here is the command output [root@SRV-MAIL ~]# file /usr/share/zoneinfo/Europe/Moscow /usr/share/zoneinfo/Europe/Moscow: timezone data [root@SRV-MAIL ~]# How to understand what version it is? v2 ? Best regards, Taras. 18.07.2022, 16:30, < mailto:users@sogo.nu users@sogo.nu > On Thu, Jun 30, 2022 at 11:23:46AM +0300, /compose/ gtg2...@rambler.ru wrote: > The list of sent and received emails in the web interface shows the wrong > time (UTC), should be (UTC+3) What version is your timezone file? file(1) can tell: $ file /usr/share/zoneinfo/Europe/Moscow /usr/share/zoneinfo/Europe/Moscow: timezone data, version 2, no gmt time flags, no std time flags, no leap seconds, no transition times, 1 abbreviation char gnustep-base did not support v2+. I contributed the code for that and it was accepted, but there has not been any release wth it yet. If you are hit by the problm, a workaround can be to remplace your timezone file by a v1 copy from an earlier OS release. That will not fix events that have been inserted from the web interface with the v2 file: the wrong data is in database now. -- Emmanuel Dreyfus /compose/ m...@netbsd.org -- /compose/ users@sogo.nu https://inverse.ca/sogo/lists https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
RE: [SOGo] Wrong time in WEB SOGo (5.5.1)
Hello, Attached a screenshot of the user settings Best regards, Taras. 18.07.2022, 16:12, < mailto:users@sogo.nu users@sogo.nu > Hello Am 17.07.22 um 10:04 schrieb /compose/ gtg2...@rambler.ru: > Hello, > Where you need to check Settings --> General --> Timezone, system or SOGo ? That one is in the webinterface of SOGo, while logged in as the User with that problem. > > Settings SOGo: > SOGoTimeZone = Europe/Moscow; > That is the standard set Timezone in sogo.conf. > System : > # date > Вс 17 июл 2022 10:53:14 MSK > > #timedatectl > Local time: Вс 2022-07-17 10:53:56 MSK > Universal time: Вс 2022-07-17 07:53:56 UTC > RTC time: Вс 2022-07-17 07:53:56 > Time zone: Europe/Moscow (MSK, +0300) > System clock synchronized: yes > NTP service: active >RTC in local TZ: yes > > I also noticed that in sogo.log also shows the wrong time. > > Best regards, Taras. > What does locale show you for sogo user? Kind regards, Christian Mack > -Original Message- > From: /compose/ users-requ...@sogo.nu < /compose/ users-requ...@sogo.nu > On Behalf Of Christian Mack > Sent: Thursday, July 14, 2022 2:09 PM > To: /compose/ users@sogo.nu > Subject: Re: [SOGo] Wrong time in WEB SOGo (5.5.1) > > Hello > > Which timezone has the user set in Preferences --> General --> Time Zone ? > > > Kind regards, > Christian Mack > > Am 30.06.22 um 10:23 schrieb /compose/ gtg2...@rambler.ru: >> Hello >> >> The list of sent and received emails in the web interface shows the wrong >> time (UTC), should be (UTC+3) >> >> The calendar SOGo shows correct time (UTC+3), in Thunderbird, the time of >> letters and calendar shows correctly too >> >> >> >> installation >> >> ALTLinux - SOGo (5.5.1) - postfix - dovecot - postgresql >> >> >> >> Settings: >> >> SOGo.conf : SOGoTimeZone = Europe/Moscow; >> >> ls -l /etc/localtime /etc/localtime -> >> /usr/share/zoneinfo/Europe/Moscow >> >> >> >> Please write where I could miss the settings or why SOGo shows the wrong >> time (UTC) >> >> >> >> Best regards, Taras >> > > -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung IT-Dienste Forschung und Lehre 78457 Konstanz +49 7531 88-4416 -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Wrong time in WEB SOGo (5.5.1)
On Thu, Jun 30, 2022 at 11:23:46AM +0300, gtg2...@rambler.ru wrote: > The list of sent and received emails in the web interface shows the wrong > time (UTC), should be (UTC+3) What version is your timezone file? file(1) can tell: $ file /usr/share/zoneinfo/Europe/Moscow /usr/share/zoneinfo/Europe/Moscow: timezone data, version 2, no gmt time flags, no std time flags, no leap seconds, no transition times, 1 abbreviation char gnustep-base did not support v2+. I contributed the code for that and it was accepted, but there has not been any release wth it yet. If you are hit by the problm, a workaround can be to remplace your timezone file by a v1 copy from an earlier OS release. That will not fix events that have been inserted from the web interface with the v2 file: the wrong data is in database now. -- Emmanuel Dreyfus m...@netbsd.org -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Wrong time in WEB SOGo (5.5.1)
Hello Am 17.07.22 um 10:04 schrieb gtg2...@rambler.ru: Hello, Where you need to check Settings --> General --> Timezone, system or SOGo ? That one is in the webinterface of SOGo, while logged in as the User with that problem. Settings SOGo: SOGoTimeZone = Europe/Moscow; That is the standard set Timezone in sogo.conf. System : # date Вс 17 июл 2022 10:53:14 MSK #timedatectl Local time: Вс 2022-07-17 10:53:56 MSK Universal time: Вс 2022-07-17 07:53:56 UTC RTC time: Вс 2022-07-17 07:53:56 Time zone: Europe/Moscow (MSK, +0300) System clock synchronized: yes NTP service: active RTC in local TZ: yes I also noticed that in sogo.log also shows the wrong time. Best regards, Taras. What does locale show you for sogo user? Kind regards, Christian Mack -Original Message- From: users-requ...@sogo.nu On Behalf Of Christian Mack Sent: Thursday, July 14, 2022 2:09 PM To: users@sogo.nu Subject: Re: [SOGo] Wrong time in WEB SOGo (5.5.1) Hello Which timezone has the user set in Preferences --> General --> Time Zone ? Kind regards, Christian Mack Am 30.06.22 um 10:23 schrieb gtg2...@rambler.ru: Hello The list of sent and received emails in the web interface shows the wrong time (UTC), should be (UTC+3) The calendar SOGo shows correct time (UTC+3), in Thunderbird, the time of letters and calendar shows correctly too installation ALTLinux - SOGo (5.5.1) - postfix - dovecot - postgresql Settings: SOGo.conf : SOGoTimeZone = Europe/Moscow; ls -l /etc/localtime /etc/localtime -> /usr/share/zoneinfo/Europe/Moscow Please write where I could miss the settings or why SOGo shows the wrong time (UTC) Best regards, Taras -- 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] Wrong time in WEB SOGo (5.5.1)
Hello, Where you need to check Settings --> General --> Timezone, system or SOGo ? Settings SOGo: SOGoTimeZone = Europe/Moscow; System : # date Вс 17 июл 2022 10:53:14 MSK #timedatectl Local time: Вс 2022-07-17 10:53:56 MSK Universal time: Вс 2022-07-17 07:53:56 UTC RTC time: Вс 2022-07-17 07:53:56 Time zone: Europe/Moscow (MSK, +0300) System clock synchronized: yes NTP service: active RTC in local TZ: yes I also noticed that in sogo.log also shows the wrong time. Best regards, Taras. -Original Message- From: users-requ...@sogo.nu On Behalf Of Christian Mack Sent: Thursday, July 14, 2022 2:09 PM To: users@sogo.nu Subject: Re: [SOGo] Wrong time in WEB SOGo (5.5.1) Hello Which timezone has the user set in Preferences --> General --> Time Zone ? Kind regards, Christian Mack Am 30.06.22 um 10:23 schrieb gtg2...@rambler.ru: > Hello > > The list of sent and received emails in the web interface shows the wrong > time (UTC), should be (UTC+3) > > The calendar SOGo shows correct time (UTC+3), in Thunderbird, the time of > letters and calendar shows correctly too > > > > installation > > ALTLinux - SOGo (5.5.1) - postfix - dovecot - postgresql > > > > Settings: > > SOGo.conf : SOGoTimeZone = Europe/Moscow; > > ls -l /etc/localtime /etc/localtime -> > /usr/share/zoneinfo/Europe/Moscow > > > > Please write where I could miss the settings or why SOGo shows the wrong > time (UTC) > > > > Best regards, Taras > -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung IT-Dienste Forschung und Lehre 78457 Konstanz +49 7531 88-4416 -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Wrong time in WEB SOGo (5.5.1)
Hello Which timezone has the user set in Preferences --> General --> Time Zone ? Kind regards, Christian Mack Am 30.06.22 um 10:23 schrieb gtg2...@rambler.ru: Hello The list of sent and received emails in the web interface shows the wrong time (UTC), should be (UTC+3) The calendar SOGo shows correct time (UTC+3), in Thunderbird, the time of letters and calendar shows correctly too installation ALTLinux - SOGo (5.5.1) - postfix - dovecot - postgresql Settings: SOGo.conf : SOGoTimeZone = Europe/Moscow; ls -l /etc/localtime /etc/localtime -> /usr/share/zoneinfo/Europe/Moscow Please write where I could miss the settings or why SOGo shows the wrong time (UTC) Best regards, Taras -- 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
