[mythtv-users] MySQL problem on a fresh 0.26.0 install

JCA 1.41421 at gmail.com
Thu Nov 14 00:19:49 UTC 2013


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:

    MySQL time zone support is missing.  Please install it and try again.
 See 'mysql_tzinfo_to_sql' for assistance.

I found out that this a new thing in 0.26, and the way around consists of
loading the timezone tables with

    mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql

This seems to work, although it spits out a number of diagnostics like the
following:

Warning: Unable to load '/usr/share/zoneinfo/Asia/Riyadh87' as time zone.
Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/Asia/Riyadh88' as time zone.
Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/Asia/Riyadh89' as time zone.
Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/Mideast/Riyadh87' as time
zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/Mideast/Riyadh88' as time
zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/Mideast/Riyadh89' as time
zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone.
Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/posix/Asia/Riyadh87' as time
zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/posix/Asia/Riyadh88' as time
zone. Skipping it.

However, the timezones seem to have been loaded all right:

$ mysql

mysql> SELECT CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'America/New_York');
+--------------------------------------------------------------+
| CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'America/New_York') |
+--------------------------------------------------------------+
| 2012-06-07 08:00:00                                          |
+--------------------------------------------------------------+
1 row in set (0.00 sec)

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.

Any suggestions on how to fix this problem?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20131113/e6b0599d/attachment.html>


More information about the mythtv-users mailing list