[mythtv-users] Latest bugfixes break timezone in 0.27
Michael T. Dean
mtdean at thirdcontact.com
Mon Nov 18 05:33:06 UTC 2013
On 11/16/2013 05:32 PM, Steve Greene wrote:
> On Sat, 2013-11-16 at 16:04 -0600, Bill Meek wrote:
>> On 11/16/2013 03:52 PM, Steve Greene wrote:
>> ...
>>> This problem did materialize with today's 0.27-fixes.
>>> From mysql command line:
>>> mysql> SELECT CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC');
>>> +----------------------------------------+
>>> | CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC') |
>>> +----------------------------------------+
>>> | NULL |
>>> +----------------------------------------+
>>> 1 row in set (0.00 sec.)
>>>
>>> Last two lines of mythbackend.log:
>>> Nov 16 15:19:07 bilbo mythbackend: mythbackend[3334]: N CoreContext
>>> mythlocale.cpp:121 (LoadDefaultsFromXML) Reading locale defaults
>>> from /usr/share/mythtv//locales/en_us.xml
>>> Nov 16 15:19:07 bilbo mythbackend: mythbackend[3334]: E CoreContext
>>> main_helpers.cpp:547 (run_backend) MySQL time zone support is missing.
>>> Please install it and try again. See 'mysql_tzinfo_to_sql' for
>>> assistance.
>>>
>>> Full mythbackend.log at http://pastebin.com/nGN1B5MN.
>>>
>> You're right, this did it.
>>
>> commit c6836330ca9b3242af58b247e8a2d28bf6c9da51
>> Date: Sun Jul 28 17:36:23 2013 -0400
>>
>> code.mythtv.org/trac/changeset/c68363
>>
>> The 'fix' is at the end of the Wiki (although you have to change
>> the 2 instances of 'UTC' to 'Etc/UTC' because it's for 0.26.)
> Thanks, Bill.
>
> That did it!
That's an ugly fix. Much better would be:
sudo ln -s Etc/UTC /usr/share/zoneinfo/UTC
or
sudo ln -s ../UTC /usr/share/zoneinfo/Etc/UTC
(or, even better, don't make it a symlink and use a hard link like a
vanilla Olson DB install does) followed by reloading the time zone data
with mysql_tzinfo_to_sql .
Gotta love when distros change around the software they package. I'm
sure the inode wasted by the maintainers of the Olson DB was just too
much to bear or something, so they decided to delete one of them to save
the resources. Probably sped up the system immeasurably.
Mike
More information about the mythtv-users
mailing list