Package: mariadb-server-10.1
Severity: wishlist
Tags: patch
Dear Maintainer,
* What led up to the situation?
$ sudo apt-get install mariadb-server-10.1
* What exactly did you do (or not do) that was effective (or
ineffective)?
mysql> SELECT COUNT(*) FROM mysql.time_zone;
* What was the outcome of this action?
0
* What outcome did you expect instead?
1820 or so
This was unexpected because of
#388491 - mysql-server-5.0: setup time_zone* tables upon installation?
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=388491
Apparently this change was lost somewhere between MySQL 5.0 and 5.1.
I couldn't determine if this was accidental or intentional.
Anyway, I propose the attached patch to the postinst script.
Thank you!
Dan
--- mariadb-server-10.1.postinst.orig 2016-12-20 14:58:40.000000000 -0600
+++ mariadb-server-10.1.postinst 2017-01-12 00:00:00.000000000 -0600
@@ -157,6 +157,9 @@
# NOTE: $MYSQL_BOOTSTRAP requires one SQL statement per line, semicolon at the end.
echo "$password_column_fix_query" | $MYSQL_BOOTSTRAP 2>&1 | $ERR_LOGGER
+ # Update timezone tables
+ mysql_tzinfo_to_sql /usr/share/zoneinfo 2>/dev/null | $MYSQL_BOOTSTRAP 2>&1 | $ERR_LOGGER
+
;;
abort-upgrade|abort-remove|abort-configure)
--- mariadb-server-10.1.postinst.orig 2016-12-20 14:58:40.000000000 -0600
+++ mariadb-server-10.1.postinst 2017-01-12 00:00:00.000000000 -0600
@@ -157,6 +157,9 @@
# NOTE: $MYSQL_BOOTSTRAP requires one SQL statement per line, semicolon at the end.
echo "$password_column_fix_query" | $MYSQL_BOOTSTRAP 2>&1 | $ERR_LOGGER
+ # Update timezone tables
+ mysql_tzinfo_to_sql /usr/share/zoneinfo 2>/dev/null | $MYSQL_BOOTSTRAP 2>&1 | $ERR_LOGGER
+
;;
abort-upgrade|abort-remove|abort-configure)
