Opened 13 years ago
Closed 12 years ago
#10906 closed Bug Report - General (fixed)
Myth-setup stops with error message regarding time zones
| Reported by: | Owned by: | Raymond Wagner | |
|---|---|---|---|
| Priority: | minor | Milestone: | 0.27 |
| Component: | MythTV - General | Version: | Master Head |
| Severity: | medium | Keywords: | |
| Cc: | Ticket locked: | no |
Description
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.
Change History (8)
comment:1 Changed 13 years ago by
| Owner: | set to Raymond Wagner <rwagner@…> |
|---|---|
| Resolution: | → fixed |
| Status: | new → closed |
comment:2 Changed 13 years ago by
| Milestone: | → 0.26 |
|---|
comment:3 Changed 13 years ago by
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 13 years ago by
| Resolution: | fixed |
|---|---|
| Status: | closed → 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:
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?
comment:5 Changed 13 years ago by
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 12 years ago by
| Milestone: | 0.26 → 0.27 |
|---|---|
| Owner: | changed from Raymond Wagner <rwagner@…> to Raymond Wagner |
| Status: | new → assigned |
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
comment:7 Changed 12 years ago by
| Status: | assigned → accepted |
|---|
comment:8 Changed 12 years ago by
| Resolution: | → fixed |
|---|---|
| Status: | accepted → closed |
In 451cd30c6a64c7231482cbc506ed0a8680e4379b/mythtv: