<div dir="ltr"><div>I found the following on <a href="http://wiki.qnap.com/wiki/How_to_install_MythTV">http://wiki.qnap.com/wiki/How_to_install_MythTV</a><br><br></div>Not sure if it will help...<br><br><div><div><h4> <span class="" id="Missing_timezone_support.C2.A0"> Missing timezone support </span></h4>
<p>Starting with firmware 3.7.1, mythtv (I tested with 0.26pre)
complains about missing timezone support. In case you hit this problem,
install timezones into mysql:
</p>
<pre>> mysql_tzinfo_to_sql /usr/share/zoneinfo | /usr/local/mysql/bin/mysql -u root -p mysql</pre>
<p>This installs timezone info from the NAS (which is located in
/usr/share/timezone) to mysql. <i><u><b>Unfortunately, the information for UTC is
missing on the NAS, leaving mythtv still unstartable.
</b></u></i></p><p>As I could not figure out a clean way how to generate the UTC
timezone information, I simply executed the mysql script for the UTC
timezone on my linux box and pasted the insert statements into the mysql
on the NAS:
</p>
<pre>> mysql -u root -p mysql
INSERT INTO time_zone (Use_leap_seconds) VALUES ('N');
SET @time_zone_id= LAST_INSERT_ID();
INSERT INTO time_zone_name (Name, Time_zone_id) VALUES ('UTC', @time_zone_id);
INSERT INTO time_zone_transition_type (Time_zone_id, Transition_type_id, Offset, Is_DST, Abbreviation) VALUES
(@time_zone_id, 0, 0, 0, 'UTC');
ALTER TABLE time_zone_transition ORDER BY Time_zone_id, Transition_time;
ALTER TABLE time_zone_transition_type ORDER BY Time_zone_id, Transition_type_id;
</pre>
<p>I am not sure if this is the recommended way but it seems to work, as mythtv starts thereafter.
</p><br></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Nov 13, 2013 at 7:19 PM, JCA <span dir="ltr"><<a href="mailto:1.41421@gmail.com" target="_blank">1.41421@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">I am in the process of installing MythTV 0.26.0 on a Slackware 14.0 system. After initializing MySQL as described in the MythTV documentation, on starting mythtv-setup I am getting the following:<div>
<br></div>
<div> MySQL time zone support is missing. Please install it and try again. See 'mysql_tzinfo_to_sql' for assistance.<br></div><div><br></div><div>I found out that this a new thing in 0.26, and the way around consists of loading the timezone tables with</div>
<div><br></div><div> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql </div><div><br></div><div>This seems to work, although it spits out a number of diagnostics like the following:</div>
<div><br></div><div><div>Warning: Unable to load '/usr/share/zoneinfo/Asia/Riyadh87' as time zone. Skipping it.</div><div>Warning: Unable to load '/usr/share/zoneinfo/Asia/Riyadh88' as time zone. Skipping it.</div>
<div>Warning: Unable to load '/usr/share/zoneinfo/Asia/Riyadh89' as time zone. Skipping it.</div><div>Warning: Unable to load '/usr/share/zoneinfo/Mideast/Riyadh87' as time zone. Skipping it.</div><div>Warning: Unable to load '/usr/share/zoneinfo/Mideast/Riyadh88' as time zone. Skipping it.</div>
<div>Warning: Unable to load '/usr/share/zoneinfo/Mideast/Riyadh89' as time zone. Skipping it.</div><div>Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.</div><div>Warning: Unable to load '/usr/share/zoneinfo/posix/Asia/Riyadh87' as time zone. Skipping it.</div>
<div>Warning: Unable to load '/usr/share/zoneinfo/posix/Asia/Riyadh88' as time zone. Skipping it.</div><div><br></div><div>However, the timezones seem to have been loaded all right:</div><div><br></div>
<div>$ mysql</div><div><br></div><div><div>mysql> SELECT CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'America/New_York');</div><div>+--------------------------------------------------------------+</div>
<div>| CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'America/New_York') |</div><div>+--------------------------------------------------------------+</div><div>| 2012-06-07 08:00:00 |</div>
<div>+--------------------------------------------------------------+</div><div>1 row in set (0.00 sec)</div><div><br></div><div>However, launching mythtv-setup again elicits exactly the same "MySQL time zone support is missing." diagnostic as before. I have tried stopping and starting MySQL several times, but the diagnostic remains.</div>
<div><br></div><div>Any suggestions on how to fix this problem?</div><div><br></div><div><br></div></div></div></div>
<br>_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<br></blockquote></div><br></div>