<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/4.6.4">
</HEAD>
<BODY>
On Sat, 2013-11-16 at 15:26 -0600, Bill Meek wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
On 11/16/2013 03:10 PM, Steve Greene wrote:
<FONT COLOR="#737373">></FONT><edited for brevity>
<FONT COLOR="#737373">></FONT>
<FONT COLOR="#737373">> The timezone fixes won't load, and neither will my backend, after weeks</FONT>
<FONT COLOR="#737373">> of working continuously. Any ideas where to go next?</FONT>
Hi;
Did mythbackend crash (e.g. segfault) or fail to start? Could you
pastebin a recent backend log from start to the error?
If I run: mysql_tzinfo_to_sql /usr/share/zoneinfo 1>/dev/null,
I see the errors you're probably seeing and don't think that's
a problem.
master had a fix to change the time zone tested. I updated the
Wiki: <A HREF="http://www.mythtv.org/wiki/MySQL_Time_Zone_Tables">http://www.mythtv.org/wiki/MySQL_Time_Zone_Tables</A> , but
didn't see that fix go into 0.27.
</PRE>
</BLOCKQUOTE>
<BR>
This problem did materialize with today's 0.27-fixes. <BR>
<BR>
>From mysql command line:<BR>
mysql> SELECT CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC');<BR>
+----------------------------------------+<BR>
| CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC') |<BR>
+----------------------------------------+<BR>
| NULL |<BR>
+----------------------------------------+<BR>
1 row in set (0.00 sec.)<BR>
<BR>
Last two lines of mythbackend.log:<BR>
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<BR>
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.<BR>
<BR>
Full mythbackend.log at <A HREF="http://pastebin.com/nGN1B5MN.">http://pastebin.com/nGN1B5MN.</A><BR>
<BR>
Thanks!<BR>
Steve<BR>
<BR>
</BODY>
</HTML>