[Mageia-dev] HEADSUP: mariadb available for testing

Fri Nov 18 15:29:51 CET 2011

+On 2011.11.18, at 13:15, Maarten Vanraes wrote:
+
+> Op vrijdag 18 november 2011 12:55:36 schreef Sam Bailey:
+> [...]
+>> I was testing on mga1 with basic rebuild only. I'll be setting up a
+>> cauldron test environment this weekend though to compare.
+> 
+> awesome
+> 
+> meanwhile, i hear from mariadb, that next week they'll be merging the latest 
+> changes from 5.3 branch into it, and that should be the last big push for 5.5 
+> branch.
+
+
+I got the problem in /etc/rc.d/init.d/mysqld, line 329:
+
+    # Check if the system database should be updated and alert the user.
+    NEW_VER="`$libexecdir/mysqld --version | awk '{ print $3}'`"
+    OLD_VER="`cat $datadir/mysql_upgrade_info`"
+
+    get_mysql_id() {
+    MAJOR="`echo $1|cut -d. -f1`"; MINOR="`echo $1|cut -d. -f2`"; PATCH="`echo $1|cut -d. -f3`"
+    expr 10000 \* ${MAJOR} + 100 \* ${MINOR} + ${PATCH}
+    }
+
+Original MySQL gives (tested on CentOS):
+
+nada:~> /usr/libexec/mysqld --version
+/usr/libexec/mysqld  Ver 5.1.52 for unknown-linux-gnu on x86_64 (Source distribution)
+nada:~> /usr/libexec/mysqld --version | awk '{ print $3}'
+5.1.52
+
+MariaDB:
+
+werewolf:~# /usr/sbin/mysqld --version
+/usr/sbin/mysqld  Ver 5.5.15-MariaDB for Linux on x86_64 (Mageia - MariaDB Community Edition (GPL))
+werewolf:~# /usr/sbin/mysqld --version | awk '{ print $3}'
+5.5.15-MariaDB
+werewolf:~# /usr/sbin/mysqld --version | awk '{ print $3}' | cut -d. -f3
+15-MariaDB
+
+See the -MariaDB tail in version ? This makes expr fail because PATCH is
+not a number.
+
+Quick Hack: change awk to:
+
+/usr/sbin/mysqld --version | cut -d' ' -f4 | cut -d- -f 1
+
+Works both in MySQL and MariaDB.
+
+
+
+
+