[mythtv-users] MythWeb timezone incorrect and a possible fix?

[Stephen Worthington]

On Sun, 9 Feb 2020 09:46:10 +0530, you wrote:

>On Sun, 9 Feb 2020 at 09:42, Rajil Saraswat <rajil.s at gmail.com> wrote:
>
>>
>>
>> On Sun, 9 Feb 2020 at 09:38, Mike Holden <mikeholden99+mythtv at gmail.com>
>> wrote:
>>
>>>
>>> In /etc/php.ini:
>>>
>>> ; Local Variables:
>>> max_input_vars = 8000
>>> date.timezone = "Australia/Sydney"
>>>
>>> The max_input_vars setting is useful in some MythWeb pages, especially
>>> the channel editor.
>>>
>>>
>>> I do have that setup correctly,
>>
>> # grep timezone /etc/php/7.2/apache2/php.ini
>> date.timezone = "Asia/Kolkata"
>>
>
>Further more the backend is an Ubuntu LXD container running the mythtv PPA.
>The timezone on the backend is set correctly as well,
># timedatectl
>                      Local time: Sun 2020-02-09 09:44:06 IST
>                  Universal time: Sun 2020-02-09 04:14:06 UTC
>                        RTC time: n/a
>                       Time zone: Asia/Kolkata (IST, +0530)
>       System clock synchronized: yes
>systemd-timesyncd.service active: yes
>                 RTC in local TZ: no

All the timestamps in the database are in UTC, so MythWeb must be
getting bad timezone data.  Have you done this to check if the
timezones are in MySQL/MariaDB and install them if necessary:

https://www.mythtv.org/wiki/MySQL_Time_Zone_Tables

Also, have you updated the timezone packages in your container to the
latest versions?