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: | 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 )
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)
Change History (5)
Changed 8 years ago by
Attachment: | mythtv-setup.log added |
---|
Changed 8 years ago by
Attachment: | mythbackend.version.info added |
---|
comment:3 Changed 4 years ago by
Resolution: | → Unverified |
---|---|
Status: | infoneeded_new → closed |
No reply in 4 years. Sounds like a configuration problem as pointed out by Bill.
Note: See
TracTickets for help on using
tickets.
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.