[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