Opened 8 years ago

Closed 4 years ago

#12630 closed Bug Report - General (Unverified)

mythtv-setup reports MySQL time zone support is missing when it is not ubuntu 15.10

Reported by: singogli@… Owned by:
Priority: minor Milestone: unknown
Component: MythTV - General Version: 0.27.5
Severity: medium Keywords: time zone mysql mythbackend
Cc: Ticket locked: no

Description (last modified by Bill Meek)

Running mythbackend -v from terminal yields error:

Feb  1 08:09:24 mythbuntu64-2 mythtv-setup.real: mythtv-setup[11465]: E CoreContext main.cpp:547 (main) MySQL time zone support is missing.  Please install it and try again.  See 'mysql_tzinfo_to_sql' for assistance.

However executing in mysql:

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

yields:
+----------------------------------------+
| CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC') |
+----------------------------------------+
| 2016-02-01 15:38:34                    |
+----------------------------------------+
1 row in set (0.00 sec)

Which from the documentation I can find suggests that in fact mysql is configured correctly.

Version info attached

Attachments (2)

mythtv-setup.log (8.1 KB) - added by singogli@… 8 years ago.
mythbackend.version.info (908 bytes) - added by singogli@… 8 years ago.

Download all attachments as: .zip

Change History (5)

Changed 8 years ago by singogli@…

Attachment: mythtv-setup.log added

Changed 8 years ago by singogli@…

Attachment: mythbackend.version.info added

comment:1 Changed 8 years ago by Bill Meek

Description: modified (diff)
Status: newinfoneeded_new

This may be a configuration issue and should be discussed on the forum or the mythtv-users list. Make sure that user steve and user mythtv have the same information in their config.xml files. Note that the mythtv-setup log is connecting to 192.168.10.129, but is binding to 192.168.10.128. The Local Host being used is mythbuntu64-2. Are you sure you aren't accessing 2 copies of the database.

comment:2 Changed 8 years ago by Stuart Auchterlonie

Is this still an issue for the original reporter?

comment:3 Changed 4 years ago by paul-h

Resolution: Unverified
Status: infoneeded_newclosed

No reply in 4 years. Sounds like a configuration problem as pointed out by Bill.

Note: See TracTickets for help on using tickets.