[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