[Tickets #15070] Timezone information of event is lost after sync. This causes problems with Android client.

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: https://bugs.horde.org/ticket/15070
------------------------------------------------------------------------------
  Ticket             | 15070
  Created By         | andreas443 at t-online.de
  Summary            | Timezone information of event is lost after sync. This
                     | causes problems with Android
                     | client.
  Queue              | Kronolith
  Version            | 4.2.29
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


andreas443 at t-online.de (2021-05-17 18:27) wrote:

I'm experiencing the problem that events have no timezone information  
when exported or synchronized over CalDAV. This leads to the problem  
that the calendar under Android shows wrong time if
  the event should be moved.

Exports of over CalDAV missing the TZ* attributes. Other CalDAV  
implementations provide something like this for each event:

TZOFFSETFROM:+0200
TZOFFSETTO:+0100
TZNAME:CET

Setting a timezone to a new event in calendar web app has no influence  
to the behaviour.

Creating a new event on Android working properly. The event has the  
correct timezone until the first sync is done. After the sync the  
timezone information is lost also.

After two days of experimenting I'm running out of ideas.

On Andorid DAVx5 Version 3.3.10-ose is in use. Server side is Debian  
Bullseye's version of horde is installed. The PHP version 7.4.15 is  
used. A more detailed list with selected configs is attached.

Special setup: User which is executing apache, php and horde has no  
internet access.

Timezone was set by user in  
https://.../services/prefs.php?app=horde&group=language to Europe/Berlin

Timezone was set in /etc/php/7.4/apache2/php.ini:date.timezone = Europe/Berlin

It was verified with phpinfo() in the horde php shell, that PHP  
version 7.4.15 is used and that the timezone is set to Europe/Berlin.

In horde/kronolith/config/conf.php $conf[calendar][params][utc] was  
tested with true and false, which leads to a movement of events  
(expected) but no timezone infos in exports/sync.

In horde/conf.php: $conf['timezone']['location'] =  
'file:///etc/horde/tzcode-latest.tar.gz';

It was tried to download the tzcode-latest.tar.gz to a local file  
because the user executing php has no internet access. Restart of  
apache. No effect.

With horde/conf.php:$conf['timezone']['location'] =  
'ftp://ftp.iana.org/tz/tzdata-latest.tar.gz';

Internet access was allowed temporarily for ftp.iana.org with the  
initial config. Restart of apache. No effect.

Horde Tasks NAG app is installed and activated and can be opened  
without errors in web front end.

The solution mentioned in  
http://horde.690.n7.nabble.com/timezone-problem-in-Calendar-Views-td124088.html is unclear to me. I did not found any  
use_system_timezone.patch.

Database creation was done with webmail-install provided by  
php-horde-webmail debian package.

Thanks for the nice groupware and for consideration!




andreas443 at t-online.de (2021-05-17 18:27) uploaded: horde-ticket-attach.txt

https://bugs.horde.org/h/services/download/?app=whups&actionID=download_file&file=horde-ticket-attach.txt&ticket=15070&fn=%2Fhorde-ticket-attach.txt