Opened 6 years ago

Closed 5 years ago

#10906 closed Bug Report - General (fixed)

Myth-setup stops with error message regarding time zones

Reported by: grotepass@… Owned by: wagnerrp
Priority: minor Milestone: 0.27
Component: MythTV - General Version: Master Head
Severity: medium Keywords:
Cc: Ticket locked: no


Myth-setup stops with a message regarding time zones. The problem is easily fixed by issuing mysql_tzinfo_to_sql using the time zone directory (on my gentoo system /usr/share/zoneinfo) eg "mysql_tzinfo_to_sql /usr/share/zoneinfo |mysql -u root -p<rootpw>" Adding this output to mythtv-setup can help solving the issue faster.

Attachments (0)

Change History (8)

comment:1 Changed 6 years ago by Raymond Wagner <rwagner@…>

  • Owner set to Raymond Wagner <rwagner@…>
  • Resolution set to fixed
  • Status changed from new to closed

In 451cd30c6a64c7231482cbc506ed0a8680e4379b/mythtv:

Add hint for MySQL timezone error.

This adds a comment to the logs about mysql_tzinfo_to_sql for how to
apply the necessary time zone information to MySQL during startup.

Fixes #10906

comment:2 Changed 6 years ago by wagnerrp

  • Milestone set to 0.26

comment:3 Changed 6 years ago by grotepass@…

Groovy, will help alot. The shoddy documentation of mysql_tzinfo_to_sql took some time to point one that one should load the whole directory instead of just one's own time zone. That is not the responsibility of Myth, though. I also saw that the entire time zone set should be loaded, since UTC is tld. for zone info, so loading only a subsection, say americas is not good enough.

comment:4 Changed 5 years ago by andrew.berridge@…

  • Resolution fixed deleted
  • Status changed from closed to new

This error was still occurring even after I added the tzinfo to mysql. The cause is that the distribution I am using (FreeBSD, well, FreeNAS) does not have a timezone called UTC. It has something called Etc/UTC, and it appears that mythtv checks for the existence of UTC (quite reasonably). Can we have it also check for Etc/UTC?

I have added info to the wiki here:

Think this error message also needs better info - it's not immediately obvious to the user/admin to go to the wiki and search for the page. Maybe a link to the wiki page could be given in the error message?

comment:5 Changed 5 years ago by gary.buhrmaster@…

My BSD system is currently unreachable, but one could try to copy /usr/share/zoneinfo/Etc/UTC to /usr/share/zoneinfo/UTC as a bypass.

comment:6 Changed 5 years ago by paulh

  • Milestone changed from 0.26 to 0.27
  • Owner changed from Raymond Wagner <rwagner@…> to wagnerrp
  • Status changed from new to assigned

So we just need to add a check for Etc/UTC if the check for UTC fails in DBUtil::CheckTimeZoneSupport?()?

comment:7 Changed 5 years ago by wagnerrp

  • Status changed from assigned to accepted

comment:8 Changed 5 years ago by Raymond Wagner <rwagner@…>

  • Resolution set to fixed
  • Status changed from accepted to closed

In c6836330ca9b3242af58b247e8a2d28bf6c9da51/mythtv:

Replace all uses of UTC timezone with more standard Etc/UTC

This replaces all use of the UTC Olson timezone with the Etc/UTC
timezone. I'm uncertain which is more proper, but there are systems that
lack the UTC timezone, but I've not found any lacking the Etc/UTC
timezone. This resolves an issue where users were not able to update and
run even after importing their timezone database into MySQL.

There may still be some lingering instances I've missed, but those
should only affect systems that were already unable to function due to
lack of the UTC timezone.

Fixes #10906

Add Comment

Modify Ticket

as closed The owner will remain wagnerrp.
The resolution will be deleted. Next status will be 'new'.

E-mail address and user name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.