Myth-setup stops with error message regarding time zones

[grotepass@…]

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.

[Raymond Wagner <rwagner@…>]

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

[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.

[andrew.berridge@…]

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:

http://www.mythtv.org/wiki/MySQL_Time_Zone_Tables

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?

[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.

[paulh]

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

​http://code.mythtv.org/cgit/mythtv/tree/mythtv/libs/libmythbase/dbutil.cpp#n879

[Raymond Wagner <rwagner@…>]

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