mythtv 0.26 needs timezones in sql

[Mario Limonciello]

as I describe http://www.gossamer-threads.com/lists/mythtv/dev/519725#519725 ... It's actually as simple as: mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -uroot -p mysql

Needed for 0.26. Should be implemented at dpkg trigger.

 <superm1> SpamapS: curious on your thoughts. what about adding a dpkg trigger when new tzdata packages get installed to load the time zone data into mysql? eg http://dev.mysql.com/doc/refman/4.1/en/mysql-tzinfo-to-sql.html
 <SpamapS> superm1: seems like a pretty cool idea
<SpamapS> superm1: Will have to think of what the ramifications might be, but all in all I think it would be a nice feature

[Thomas Mashos (tgm4883)]

Setting to High, as the backend fails to start without this. There also doesn't appear to be anything written to our logs indicating this is why the backend isn't starting (although it is written to the terminal if you manually run /usr/bin/mythbackend)

[Thomas Mashos (tgm4883)]

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

[Mario Limonciello (superm1)]

https://github.com/MythTV/packaging/commit/a7d0a637d371101f128e945bff31bce62d43eb22

[Mario Limonciello (superm1)]

I've added it to the postinst for mythtv database which should be harmless, but it would be better if we could get this in the mysql postinst.