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

Bill Meek keemllib at gmail.com
Thu Nov 14 14:14:52 UTC 2013


On 11/14/2013 01:25 AM, Jan Ceuleers wrote:
> On 11/14/2013 01:19 AM, JCA wrote:
>> 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?

The test query used by mythbackend/mythtv-setup is:

     SELECT CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC');

returning something like:

     +----------------------------------------+
     | CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC') |
     +----------------------------------------+
     | 2013-11-14 14:07:58                    |
     +----------------------------------------+

So, you could check to see if that exists in your distribution's
tables.

     SELECT * FROM time_zone_name WHERE Name = 'Etc/UTC';

Or, maybe see if /usr/share/zoneinfo/Etc/UTC exists if you loaded
them yourself.

-- 
Bill


More information about the mythtv-users mailing list