[Maria-developers] Passwordless MariaDB root login with auth_socket in Debian continues..
Hello Daniel B. and others, I decided to write to you via the mailing list so that we are inclusive if somebody wants to join our effort to create a solid passwordless (Debian/Ubuntu) packaging. Thanks Daniel for all the pull requests you've made. Unfortunately there are still some bugs. Now it ends with 'ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded' I have built packages from the latest commit at my Debian packaging repo https://github.com/ottok/mariadb-10.0/commits/master (bac031c9796ebf08c651bc863bda97fcf2cce9c4) so that all of your pull requests regarding this are included. The dev repo addess is 'deb http://labs.seravo.fi/~otto/mariadb-repo/ mariadb-10.0-sid-amd64/' in case you forgot (see https://wiki.debian.org/Teams/MySQL/MariaDB) $ apt-get purge 'mysql-*' 'mariadb-*'; rm -rf /etc/mysql /var/lib/mysql; apt-get clean; apt-get update [..] $ apt-get install mariadb-server [..] Fetched 12.6 MB in 1min 34s (133 kB/s) Preconfiguring packages ... Selecting previously unselected package mysql-common. Preparing to unpack .../mysql-common_5.5.42-1_all.deb ... Unpacking mysql-common (5.5.42-1) ... Selecting previously unselected package libmysqlclient18:amd64. Preparing to unpack .../libmysqlclient18_5.5.42-1_amd64.deb ... Unpacking libmysqlclient18:amd64 (5.5.42-1) ... Selecting previously unselected package mariadb-common. Preparing to unpack .../mariadb-common_10.0.17-1~exp2_all.deb ... Unpacking mariadb-common (10.0.17-1~exp2) ... Selecting previously unselected package mariadb-client-core-10.0. Preparing to unpack .../mariadb-client-core-10.0_10.0.17-1~exp2_amd64.deb ... Unpacking mariadb-client-core-10.0 (10.0.17-1~exp2) ... Selecting previously unselected package mariadb-client-10.0. Preparing to unpack .../mariadb-client-10.0_10.0.17-1~exp2_amd64.deb ... Unpacking mariadb-client-10.0 (10.0.17-1~exp2) ... Selecting previously unselected package mariadb-server-core-10.0. Preparing to unpack .../mariadb-server-core-10.0_10.0.17-1~exp2_amd64.deb ... Unpacking mariadb-server-core-10.0 (10.0.17-1~exp2) ... Processing triggers for man-db (2.7.0.2-3) ... Setting up mysql-common (5.5.42-1) ... Setting up mariadb-common (10.0.17-1~exp2) ... Notice: configure-symlinks trigger could not be called. Please manually make /etc/mysql/my.cnf a symlink that points to mariadb.cnf. Selecting previously unselected package mariadb-server-10.0. Preparing to unpack .../mariadb-server-10.0_10.0.17-1~exp2_amd64.deb ... Unpacking mariadb-server-10.0 (10.0.17-1~exp2) ... Selecting previously unselected package libdbd-mysql-perl. Preparing to unpack .../libdbd-mysql-perl_4.028-2+b1_amd64.deb ... Unpacking libdbd-mysql-perl (4.028-2+b1) ... Selecting previously unselected package mariadb-server. Preparing to unpack .../mariadb-server_10.0.17-1~exp2_all.deb ... Unpacking mariadb-server (10.0.17-1~exp2) ... Processing triggers for man-db (2.7.0.2-3) ... Setting up libmysqlclient18:amd64 (5.5.42-1) ... Setting up mariadb-client-core-10.0 (10.0.17-1~exp2) ... Setting up mariadb-client-10.0 (10.0.17-1~exp2) ... Setting up mariadb-server-core-10.0 (10.0.17-1~exp2) ... Setting up mariadb-server-10.0 (10.0.17-1~exp2) ... + . /usr/share/debconf/confmodule ++ '[' '!' '' ']' ++ PERL_DL_NONLAZY=1 ++ export PERL_DL_NONLAZY ++ '[' '' ']' ++ exec /usr/share/debconf/frontend /var/lib/dpkg/info/mariadb-server-10.0.postinst configure '' + . /usr/share/debconf/confmodule ++ '[' '!' 1 ']' ++ '[' -z '' ']' ++ exec ++ '[' '' ']' ++ exec ++ DEBCONF_REDIR=1 ++ export DEBCONF_REDIR + '[' -n '' ']' + export PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/sbin:/usr/sbin:/bin:/usr/bin + PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/sbin:/usr/sbin:/bin:/usr/bin + ERR_LOGGER='logger -p daemon.err -t mysqld_safe -i' + set -o pipefail + MYSQL_BOOTSTRAP='/usr/sbin/mysqld --bootstrap --user=mysql --disable-log-bin --skip-grant-tables --default-storage-engine=myisam --plugin-load-add=auth_socket' + set +e + invoke stop + '[' -x /usr/sbin/invoke-rc.d ']' + invoke-rc.d mysql stop Stopping MariaDB database server: mysqld. + set -e + case "$1" in + mysql_statedir=/usr/share/mysql + mysql_datadir=/var/lib/mysql + mysql_logdir=/var/log/mysql + mysql_rundir=/var/run/mysqld + mysql_cfgdir=/etc/mysql + mysql_upgradedir=/var/lib/mysql-upgrade + '[' '!' -d /usr/share/mysql -a '!' -L /usr/share/mysql ']' + '[' '!' -d /var/lib/mysql -a '!' -L /var/lib/mysql ']' + '[' '!' -d /var/log/mysql -a '!' -L /var/log/mysql ']' + set +e + chown -R 0:0 /usr/share/mysql + chown -R mysql /var/lib/mysql + chown -R mysql:adm /var/log/mysql + chmod 2750 /var/log/mysql + set -e + db_set mariadb-server/postrm_remove_database false + _db_cmd 'SET mariadb-server/postrm_remove_database' false + _db_internal_IFS=' ' + IFS=' ' + printf '%s\n' 'SET mariadb-server/postrm_remove_database false' + IFS=' ' + IFS=' ' + read -r _db_internal_line + RET='10 mariadb-server/postrm_remove_database doesn'\''t exist' + case ${_db_internal_line%%[ ]*} in + return 10 + true + rm -f '/var/lib/mysql/debian-*.flag' + touch /var/lib/mysql/debian-10.0.flag + set +e + logger -p daemon.err -t mysqld_safe -i + bash /usr/bin/mysql_install_db --rpm --cross-bootstrap --user=mysql --disable-log-bin + set -e + dc=/etc/mysql/debian.cnf + '[' '!' -e /etc/mysql/debian.cnf -o 'grep -sq "^[^#]*user[^#=]*=[^#=]*debian-sys-maint" /etc/mysql/debian.cnf' ']' + '[' '!' -d /etc/mysql ']' + '[' -e /etc/mysql/debian.cnf ']' + oldconf= + umask 066 + cat /dev/null + umask 022 + echo '# Automatically generated for Debian scripts. DO NOT TOUCH!' + echo '[client]' + echo 'host = localhost' + echo 'user = root' + echo 'password = ' + echo 'socket = /var/run/mysqld/mysqld.sock' + echo '[mysql_upgrade]' + echo 'host = localhost' + echo 'user = root' + echo 'password = ' + echo 'socket = /var/run/mysqld/mysqld.sock' + echo 'basedir = /usr' + chown 0:0 /etc/mysql/debian.cnf + chmod 0600 /etc/mysql/debian.cnf ++ /bin/echo -e 'USE mysql;\n' 'SET sql_log_bin=0;\n' 'ALTER TABLE user CHANGE Password Password char(41) character set latin1 collate latin1_bin DEFAULT '\'''\'' NOT NULL;' + password_column_fix_query='USE mysql; SET sql_log_bin=0; ALTER TABLE user CHANGE Password Password char(41) character set latin1 collate latin1_bin DEFAULT '\'''\'' NOT NULL;' + echo 'USE mysql; SET sql_log_bin=0; ALTER TABLE user CHANGE Password Password char(41) character set latin1 collate latin1_bin DEFAULT '\'''\'' NOT NULL;' + logger -p daemon.err -t mysqld_safe -i + /usr/sbin/mysqld --bootstrap --user=mysql --disable-log-bin --skip-grant-tables --default-storage-engine=myisam --plugin-load-add=auth_socket ++ /bin/echo -e 'SET sql_mode='\'''\'', sql_log_bin=0;\n' 'DELETE FROM mysql.user WHERE user='\''debian-sys-maint'\'' AND host='\''localhost'\'';' + replace_query='SET sql_mode='\'''\'', sql_log_bin=0; DELETE FROM mysql.user WHERE user='\''debian-sys-maint'\'' AND host='\''localhost'\'';' ++ /bin/echo -e 'USE mysql;\n' 'SET sql_log_bin=0;\n' 'CREATE TABLE IF NOT EXISTS plugin (name char(64) COLLATE utf8_bin NOT NULL DEFAULT '\'''\'', ' ' dl char(128) COLLATE utf8_bin NOT NULL DEFAULT '\'''\'', ' ' PRIMARY KEY (name)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='\''MySQL plugins'\'';\n' 'INSTALL PLUGIN unix_socket SONAME '\''auth_socket'\'';\n' + install_plugins='USE mysql; SET sql_log_bin=0; CREATE TABLE IF NOT EXISTS plugin (name char(64) COLLATE utf8_bin NOT NULL DEFAULT '\'''\'', dl char(128) COLLATE utf8_bin NOT NULL DEFAULT '\'''\'', PRIMARY KEY (name)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='\''MySQL plugins'\''; INSTALL PLUGIN unix_socket SONAME '\''auth_socket'\'';' + set +e + echo 'USE mysql; SET sql_log_bin=0; CREATE TABLE IF NOT EXISTS plugin (name char(64) COLLATE utf8_bin NOT NULL DEFAULT '\'''\'', dl char(128) COLLATE utf8_bin NOT NULL DEFAULT '\'''\'', PRIMARY KEY (name)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='\''MySQL plugins'\''; INSTALL PLUGIN unix_socket SONAME '\''auth_socket'\'';' + logger -p daemon.err -t mysqld_safe -i + /usr/sbin/mysqld --bootstrap --user=mysql --disable-log-bin --skip-grant-tables --default-storage-engine=myisam --plugin-load-add=auth_socket + set -e + set_mysql_rootpw ++ mktemp + tfile=/tmp/tmp.RyQCYdtKwf + '[' '!' -f /tmp/tmp.RyQCYdtKwf ']' + cat + '[' '' = online ']' + /usr/sbin/mysqld --bootstrap --user=mysql --disable-log-bin --skip-grant-tables --default-storage-engine=myisam --plugin-load-add=auth_socket + retval=0 + rm -f /tmp/tmp.RyQCYdtKwf + return 0 + '[' -e ']' + rm -f + set +e + echo 'SET sql_mode='\'''\'', sql_log_bin=0; DELETE FROM mysql.user WHERE user='\''debian-sys-maint'\'' AND host='\''localhost'\'';' + logger -p daemon.err -t mysqld_safe -i + /usr/sbin/mysqld --bootstrap --user=mysql --disable-log-bin --skip-grant-tables --default-storage-engine=myisam --plugin-load-add=auth_socket + set -e + '[' configure = configure ']' + test_passwordless_root_login + mysql --no-defaults -u root -h localhost + '[' '' = yes ']' + db_stop + echo STOP + '[' -x /etc/init.d/mysql ']' + update-rc.d mysql defaults 19 21 + invoke-rc.d mysql start Starting MariaDB database server: mysqld. + exit 0 ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded Setting up libdbd-mysql-perl (4.028-2+b1) ... Setting up mariadb-server (10.0.17-1~exp2) ... Processing triggers for libc-bin (2.19-13) ... $ mysql -u root ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded /var/log/mysql/error.log is pasted at http://paste.debian.net/161259/ Please figure out what is still missing and open new pull requests to fix it :) The mariadb-10.0.17-exp1 at the moment in Debian experimental is broken due to inclusion of an early version of this change, so I hope we could get it completed soon so that I don't have to revert the whole passwordless root account feature (which has been requested by many). - Otto
Its something that i did fix on the patch i sent previously, its the "INSTALL PLUGIN" statement that cannot be executed while "mysqld" has been ran with "--skip-grant-table", it should be replaced by an "INSERT" on the "mysql.plugin" table. The line 192 : INSTALL PLUGIN unix_socket SONAME 'auth_socket'; Must be replaced with : INSERT INTO mysql.plugin (name, dl) VALUES ('unix_socket', 'auth_socket'); Le 14/03/2015 19:48, Otto Kekäläinen a écrit :
Hello Daniel B. and others,
I decided to write to you via the mailing list so that we are inclusive if somebody wants to join our effort to create a solid passwordless (Debian/Ubuntu) packaging.
Thanks Daniel for all the pull requests you've made. Unfortunately there are still some bugs. Now it ends with 'ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded'
I have built packages from the latest commit at my Debian packaging repo https://github.com/ottok/mariadb-10.0/commits/master (bac031c9796ebf08c651bc863bda97fcf2cce9c4) so that all of your pull requests regarding this are included.
The dev repo addess is 'deb http://labs.seravo.fi/~otto/mariadb-repo/ mariadb-10.0-sid-amd64/' in case you forgot (see https://wiki.debian.org/Teams/MySQL/MariaDB)
$ apt-get purge 'mysql-*' 'mariadb-*'; rm -rf /etc/mysql /var/lib/mysql; apt-get clean; apt-get update [..]
$ apt-get install mariadb-server [..]
Fetched 12.6 MB in 1min 34s (133 kB/s) Preconfiguring packages ... Selecting previously unselected package mysql-common. Preparing to unpack .../mysql-common_5.5.42-1_all.deb ... Unpacking mysql-common (5.5.42-1) ... Selecting previously unselected package libmysqlclient18:amd64. Preparing to unpack .../libmysqlclient18_5.5.42-1_amd64.deb ... Unpacking libmysqlclient18:amd64 (5.5.42-1) ... Selecting previously unselected package mariadb-common. Preparing to unpack .../mariadb-common_10.0.17-1~exp2_all.deb ... Unpacking mariadb-common (10.0.17-1~exp2) ... Selecting previously unselected package mariadb-client-core-10.0. Preparing to unpack .../mariadb-client-core-10.0_10.0.17-1~exp2_amd64.deb ... Unpacking mariadb-client-core-10.0 (10.0.17-1~exp2) ... Selecting previously unselected package mariadb-client-10.0. Preparing to unpack .../mariadb-client-10.0_10.0.17-1~exp2_amd64.deb ... Unpacking mariadb-client-10.0 (10.0.17-1~exp2) ... Selecting previously unselected package mariadb-server-core-10.0. Preparing to unpack .../mariadb-server-core-10.0_10.0.17-1~exp2_amd64.deb ... Unpacking mariadb-server-core-10.0 (10.0.17-1~exp2) ... Processing triggers for man-db (2.7.0.2-3) ... Setting up mysql-common (5.5.42-1) ... Setting up mariadb-common (10.0.17-1~exp2) ... Notice: configure-symlinks trigger could not be called. Please manually make /etc/mysql/my.cnf a symlink that points to mariadb.cnf. Selecting previously unselected package mariadb-server-10.0. Preparing to unpack .../mariadb-server-10.0_10.0.17-1~exp2_amd64.deb ... Unpacking mariadb-server-10.0 (10.0.17-1~exp2) ... Selecting previously unselected package libdbd-mysql-perl. Preparing to unpack .../libdbd-mysql-perl_4.028-2+b1_amd64.deb ... Unpacking libdbd-mysql-perl (4.028-2+b1) ... Selecting previously unselected package mariadb-server. Preparing to unpack .../mariadb-server_10.0.17-1~exp2_all.deb ... Unpacking mariadb-server (10.0.17-1~exp2) ... Processing triggers for man-db (2.7.0.2-3) ... Setting up libmysqlclient18:amd64 (5.5.42-1) ... Setting up mariadb-client-core-10.0 (10.0.17-1~exp2) ... Setting up mariadb-client-10.0 (10.0.17-1~exp2) ... Setting up mariadb-server-core-10.0 (10.0.17-1~exp2) ... Setting up mariadb-server-10.0 (10.0.17-1~exp2) ... + . /usr/share/debconf/confmodule ++ '[' '!' '' ']' ++ PERL_DL_NONLAZY=1 ++ export PERL_DL_NONLAZY ++ '[' '' ']' ++ exec /usr/share/debconf/frontend /var/lib/dpkg/info/mariadb-server-10.0.postinst configure '' + . /usr/share/debconf/confmodule ++ '[' '!' 1 ']' ++ '[' -z '' ']' ++ exec ++ '[' '' ']' ++ exec ++ DEBCONF_REDIR=1 ++ export DEBCONF_REDIR + '[' -n '' ']' + export PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/sbin:/usr/sbin:/bin:/usr/bin + PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/sbin:/usr/sbin:/bin:/usr/bin + ERR_LOGGER='logger -p daemon.err -t mysqld_safe -i' + set -o pipefail + MYSQL_BOOTSTRAP='/usr/sbin/mysqld --bootstrap --user=mysql --disable-log-bin --skip-grant-tables --default-storage-engine=myisam --plugin-load-add=auth_socket' + set +e + invoke stop + '[' -x /usr/sbin/invoke-rc.d ']' + invoke-rc.d mysql stop Stopping MariaDB database server: mysqld. + set -e + case "$1" in + mysql_statedir=/usr/share/mysql + mysql_datadir=/var/lib/mysql + mysql_logdir=/var/log/mysql + mysql_rundir=/var/run/mysqld + mysql_cfgdir=/etc/mysql + mysql_upgradedir=/var/lib/mysql-upgrade + '[' '!' -d /usr/share/mysql -a '!' -L /usr/share/mysql ']' + '[' '!' -d /var/lib/mysql -a '!' -L /var/lib/mysql ']' + '[' '!' -d /var/log/mysql -a '!' -L /var/log/mysql ']' + set +e + chown -R 0:0 /usr/share/mysql + chown -R mysql /var/lib/mysql + chown -R mysql:adm /var/log/mysql + chmod 2750 /var/log/mysql + set -e + db_set mariadb-server/postrm_remove_database false + _db_cmd 'SET mariadb-server/postrm_remove_database' false + _db_internal_IFS=' ' + IFS=' ' + printf '%s\n' 'SET mariadb-server/postrm_remove_database false' + IFS=' ' + IFS=' ' + read -r _db_internal_line + RET='10 mariadb-server/postrm_remove_database doesn'\''t exist' + case ${_db_internal_line%%[ ]*} in + return 10 + true + rm -f '/var/lib/mysql/debian-*.flag' + touch /var/lib/mysql/debian-10.0.flag + set +e + logger -p daemon.err -t mysqld_safe -i + bash /usr/bin/mysql_install_db --rpm --cross-bootstrap --user=mysql --disable-log-bin + set -e + dc=/etc/mysql/debian.cnf + '[' '!' -e /etc/mysql/debian.cnf -o 'grep -sq "^[^#]*user[^#=]*=[^#=]*debian-sys-maint" /etc/mysql/debian.cnf' ']' + '[' '!' -d /etc/mysql ']' + '[' -e /etc/mysql/debian.cnf ']' + oldconf= + umask 066 + cat /dev/null + umask 022 + echo '# Automatically generated for Debian scripts. DO NOT TOUCH!' + echo '[client]' + echo 'host = localhost' + echo 'user = root' + echo 'password = ' + echo 'socket = /var/run/mysqld/mysqld.sock' + echo '[mysql_upgrade]' + echo 'host = localhost' + echo 'user = root' + echo 'password = ' + echo 'socket = /var/run/mysqld/mysqld.sock' + echo 'basedir = /usr' + chown 0:0 /etc/mysql/debian.cnf + chmod 0600 /etc/mysql/debian.cnf ++ /bin/echo -e 'USE mysql;\n' 'SET sql_log_bin=0;\n' 'ALTER TABLE user CHANGE Password Password char(41) character set latin1 collate latin1_bin DEFAULT '\'''\'' NOT NULL;' + password_column_fix_query='USE mysql; SET sql_log_bin=0; ALTER TABLE user CHANGE Password Password char(41) character set latin1 collate latin1_bin DEFAULT '\'''\'' NOT NULL;' + echo 'USE mysql; SET sql_log_bin=0; ALTER TABLE user CHANGE Password Password char(41) character set latin1 collate latin1_bin DEFAULT '\'''\'' NOT NULL;' + logger -p daemon.err -t mysqld_safe -i + /usr/sbin/mysqld --bootstrap --user=mysql --disable-log-bin --skip-grant-tables --default-storage-engine=myisam --plugin-load-add=auth_socket ++ /bin/echo -e 'SET sql_mode='\'''\'', sql_log_bin=0;\n' 'DELETE FROM mysql.user WHERE user='\''debian-sys-maint'\'' AND host='\''localhost'\'';' + replace_query='SET sql_mode='\'''\'', sql_log_bin=0; DELETE FROM mysql.user WHERE user='\''debian-sys-maint'\'' AND host='\''localhost'\'';' ++ /bin/echo -e 'USE mysql;\n' 'SET sql_log_bin=0;\n' 'CREATE TABLE IF NOT EXISTS plugin (name char(64) COLLATE utf8_bin NOT NULL DEFAULT '\'''\'', ' ' dl char(128) COLLATE utf8_bin NOT NULL DEFAULT '\'''\'', ' ' PRIMARY KEY (name)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='\''MySQL plugins'\'';\n' 'INSTALL PLUGIN unix_socket SONAME '\''auth_socket'\'';\n' + install_plugins='USE mysql; SET sql_log_bin=0; CREATE TABLE IF NOT EXISTS plugin (name char(64) COLLATE utf8_bin NOT NULL DEFAULT '\'''\'', dl char(128) COLLATE utf8_bin NOT NULL DEFAULT '\'''\'', PRIMARY KEY (name)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='\''MySQL plugins'\''; INSTALL PLUGIN unix_socket SONAME '\''auth_socket'\'';' + set +e + echo 'USE mysql; SET sql_log_bin=0; CREATE TABLE IF NOT EXISTS plugin (name char(64) COLLATE utf8_bin NOT NULL DEFAULT '\'''\'', dl char(128) COLLATE utf8_bin NOT NULL DEFAULT '\'''\'', PRIMARY KEY (name)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='\''MySQL plugins'\''; INSTALL PLUGIN unix_socket SONAME '\''auth_socket'\'';' + logger -p daemon.err -t mysqld_safe -i + /usr/sbin/mysqld --bootstrap --user=mysql --disable-log-bin --skip-grant-tables --default-storage-engine=myisam --plugin-load-add=auth_socket + set -e + set_mysql_rootpw ++ mktemp + tfile=/tmp/tmp.RyQCYdtKwf + '[' '!' -f /tmp/tmp.RyQCYdtKwf ']' + cat + '[' '' = online ']' + /usr/sbin/mysqld --bootstrap --user=mysql --disable-log-bin --skip-grant-tables --default-storage-engine=myisam --plugin-load-add=auth_socket + retval=0 + rm -f /tmp/tmp.RyQCYdtKwf + return 0 + '[' -e ']' + rm -f + set +e + echo 'SET sql_mode='\'''\'', sql_log_bin=0; DELETE FROM mysql.user WHERE user='\''debian-sys-maint'\'' AND host='\''localhost'\'';' + logger -p daemon.err -t mysqld_safe -i + /usr/sbin/mysqld --bootstrap --user=mysql --disable-log-bin --skip-grant-tables --default-storage-engine=myisam --plugin-load-add=auth_socket + set -e + '[' configure = configure ']' + test_passwordless_root_login + mysql --no-defaults -u root -h localhost + '[' '' = yes ']' + db_stop + echo STOP + '[' -x /etc/init.d/mysql ']' + update-rc.d mysql defaults 19 21 + invoke-rc.d mysql start Starting MariaDB database server: mysqld. + exit 0 ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded Setting up libdbd-mysql-perl (4.028-2+b1) ... Setting up mariadb-server (10.0.17-1~exp2) ... Processing triggers for libc-bin (2.19-13) ...
$ mysql -u root ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded
/var/log/mysql/error.log is pasted at http://paste.debian.net/161259/
Please figure out what is still missing and open new pull requests to fix it :)
The mariadb-10.0.17-exp1 at the moment in Debian experimental is broken due to inclusion of an early version of this change, so I hope we could get it completed soon so that I don't have to revert the whole passwordless root account feature (which has been requested by many).
- Otto
----- Original Message -----
Hello Daniel B. and others,
I decided to write to you via the mailing list so that we are inclusive if somebody wants to join our effort to create a solid passwordless (Debian/Ubuntu) packaging.
Thanks Daniel for all the pull requests you've made. Unfortunately there are still some bugs. Now it ends with 'ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded' .. $ apt-get purge 'mysql-*' 'mariadb-*'; rm -rf /etc/mysql /var/lib/mysql; apt-get clean; apt-get update [..]
$ apt-get install mariadb-server [..]
Ok. I can reproduce this.
Please figure out what is still missing and open new pull requests to fix it :)
after the install here is the conf directories: find /etc/mysql/ -ls 260377 4 drwxr-xr-x 4 root root 4096 Mar 14 22:40 /etc/mysql/ 260500 4 -rw-r--r-- 1 root root 3533 Feb 9 10:33 /etc/mysql/my.cnf 260584 4 -rw-r--r-- 1 root root 744 Feb 9 19:21 /etc/mysql/mariadb.cnf 260507 4 drwxr-xr-x 2 root root 4096 Mar 14 22:39 /etc/mysql/conf.d 260515 0 -rw-r--r-- 1 root root 0 Feb 9 14:41 /etc/mysql/conf.d/.keepme 260868 4 -rw-r--r-- 1 root root 285 Feb 25 15:41 /etc/mysql/conf.d/tokudb.cnf 261069 4 -rwxr-xr-x 1 root root 1312 Feb 8 12:32 /etc/mysql/debian-start 260518 4 drwxr-xr-x 2 root root 4096 Mar 14 22:39 /etc/mysql/mariadb.conf.d 260519 4 -rw-r--r-- 1 root root 306 Feb 8 12:32 /etc/mysql/mariadb.conf.d/mysqld_safe.cnf 260521 4 -rw-r--r-- 1 root root 2715 Feb 8 12:32 /etc/mysql/mariadb.conf.d/mysqld.cnf 260533 4 -rw-r--r-- 1 root root 111 Feb 8 12:32 /etc/mysql/mariadb.conf.d/client.cnf 261073 4 -rw------- 1 root root 277 Mar 14 22:40 /etc/mysql/debian.cnf This fails as the /etc/mysql/my.cnf from mysql-common is used. after doing the obscure instructions in the output: rm /etc/mysql/my.cnf && ln -s mariadb.cnf /etc/mysql/my.cnf Solid packaging should to this without the user. The unix_socket plugin is loaded as this is specified in /etc/mysql/mariadb.cnf This has been raised as an issue https://github.com/ottok/mariadb-10.0/issues/10 Given the contents on mysql-common can it be removed as a dependency (and added as conflicting package), mariadb-common to install /etc/mysql/conf.d (not sure if needed) and add the symlink? These kind of alterations require a deeper understanding of debian policy and practice than I am familiar with. dpkg -L mysql-common /. /usr /usr/share /usr/share/doc /usr/share/doc/mysql-common /usr/share/doc/mysql-common/copyright /usr/share/doc/mysql-common/changelog.Debian.gz /usr/share/doc/mysql-common/changelog.gz /usr/share/doc/mysql-common/NEWS.Debian.gz /etc /etc/mysql /etc/mysql/my.cnf /etc/mysql/conf.d /etc/mysql/conf.d/.keepme # dpkg -L mariadb-common /. /usr /usr/share /usr/share/doc /usr/share/doc/mariadb-common /usr/share/doc/mariadb-common/changelog.Debian.gz /usr/share/doc/mariadb-common/copyright /etc /etc/mysql /etc/mysql/mariadb.conf.d /etc/mysql/mariadb.conf.d/mysqld_safe.cnf /etc/mysql/mariadb.conf.d/mysqld.cnf /etc/mysql/mariadb.conf.d/client.cnf /etc/mysql/mariadb.cnf # more /etc/mysql/mariadb.cnf .... !includedir /etc/mysql/conf.d/ !includedir /etc/mysql/mariadb.conf.d/ -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise & maintenance for MySQL/MariaDB server environments.
----- Original Message -----
Its something that i did fix on the patch i sent previously, its the "INSTALL PLUGIN" statement that cannot be executed while "mysqld" has been ran with "--skip-grant-table", it should be replaced by an "INSERT" on the "mysql.plugin" table.
The line 192 : INSTALL PLUGIN unix_socket SONAME 'auth_socket';
Must be replaced with : INSERT INTO mysql.plugin (name, dl) VALUES ('unix_socket', 'auth_socket');
Ah, I see, seems even removing --skip-grant-tables isn't enough ./scripts/mysql_install_db --srcdir=. --no-defaults --ldata=/tmp/db echo "INSTALL PLUGIN unix_socket SONAME 'auth_socket';" | sql/mysqld --no-defaults --socket /tmp/s.sock --datadir=/tmp/db --lc-messages-dir /home/dan/software_projects/mariadb-server/sql/share --pid-file=/tmp/m.pid --log-bin=/tmp/db --skip-networking --bootstrap 150315 10:31:45 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2015-03-15 10:31:45 7fb800be08c0 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2015-03-15 10:31:45 7fb800be08c0 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 150315 10:31:45 [Note] InnoDB: The InnoDB memory heap is disabled 150315 10:31:45 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150315 10:31:45 [Note] InnoDB: Memory barrier is not used 150315 10:31:45 [Note] InnoDB: Compressed tables use zlib 1.2.8 150315 10:31:45 [Note] InnoDB: Using Linux native AIO 150315 10:31:45 [Note] InnoDB: Using CPU crc32 instructions 150315 10:31:45 [Note] InnoDB: Initializing buffer pool, size = 128.0M 150315 10:31:45 [Note] InnoDB: Completed initialization of buffer pool 150315 10:31:45 [Note] InnoDB: Highest supported file format is Barracuda. 150315 10:31:46 [Note] InnoDB: 128 rollback segment(s) are active. 150315 10:31:46 [Note] InnoDB: Waiting for purge to start 150315 10:31:46 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 1616727 150315 10:31:46 [Note] InnoDB: not started ERROR: 1290 The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement While insert probably works for auth_socket as it has no init function on install, devs is there a reason why you can't install a plugin in bootstrap? sql/sql_plugin.cc bool mysql_install_plugin(THD *thd, const LEX_STRING *name, const LEX_STRING *dl_arg) { ... DBUG_ENTER("mysql_install_plugin"); if (opt_noacl) { my_error(ER_OPTION_PREVENTS_STATEMENT, MYF(0), "--skip-grant-tables"); -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise & maintenance for MySQL/MariaDB server environments.
----- Original Message -----
----- Original Message -----
Its something that i did fix on the patch i sent previously, its the "INSTALL PLUGIN" statement that cannot be executed while "mysqld" has been ran with "--skip-grant-table", it should be replaced by an "INSERT" on the "mysql.plugin" table.
The line 192 : INSTALL PLUGIN unix_socket SONAME 'auth_socket';
Must be replaced with : INSERT INTO mysql.plugin (name, dl) VALUES ('unix_socket', 'auth_socket');
Ah, I see, seems even removing --skip-grant-tables isn't enough
--skip-grant-tables is implied by --bootstrap ..
While insert probably works for auth_socket as it has no init function on install, devs is there a reason why you can't install a plugin in bootstrap?
https://mariadb.atlassian.net/browse/MDEV-7781 https://github.com/MariaDB/server/pull/28/files -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise & maintenance for MySQL/MariaDB server environments.
On Sat, 2015-03-14 at 20:48 +0200, Otto Kekäläinen wrote:
Hello Daniel B. and others,
I decided to write to you via the mailing list so that we are inclusive if somebody wants to join our effort to create a solid passwordless (Debian/Ubuntu) packaging.
it might be worth you noting the issue I found last month - mariadb and perconadb (and maybe mysql upstream, I'm unsure) use different names for the unix socket plugin, so switching between servers with the same data directory using this plugin does not work: https://lists.launchpad.net/maria-developers/msg08177.html I'm unsure if Debian uses different data directories for mariadb than /var/lib/mysql. The percona packages don't, and mariadb's own packages do not. There are plenty of other things that make switching mysql versions difficult, but the default authentication stopping working seems like it's going to affect a lot of people! John.
I will check it today and add more info. Thanks On Sun, Mar 15, 2015 at 2:12 PM, John Leach <john@johnleach.co.uk> wrote:
On Sat, 2015-03-14 at 20:48 +0200, Otto Kekäläinen wrote:
Hello Daniel B. and others,
I decided to write to you via the mailing list so that we are inclusive if somebody wants to join our effort to create a solid passwordless (Debian/Ubuntu) packaging.
it might be worth you noting the issue I found last month - mariadb and perconadb (and maybe mysql upstream, I'm unsure) use different names for the unix socket plugin, so switching between servers with the same data directory using this plugin does not work:
https://lists.launchpad.net/maria-developers/msg08177.html
I'm unsure if Debian uses different data directories for mariadb than /var/lib/mysql. The percona packages don't, and mariadb's own packages do not.
There are plenty of other things that make switching mysql versions difficult, but the default authentication stopping working seems like it's going to affect a lot of people!
John.
-- --------------------------------------------------------------------------------------- (¯`**.(¯`**. From my TI 99 4/a - sorry for the delay **´¯).**´¯) (¯`**.(¯`**. Sent using Secure communications GPG **´¯).**´¯) (¯`**.(¯`**. During delivery no animals were harmed **´¯).**´¯) ---------------------------------------------------------------------------------------
Today, another error + invoke-rc.d mysql start Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details. invoke-rc.d: initscript mysql, action "start" failed. + exit 1 dpkg: error processing package mariadb-server-10.0 (--configure): subprocess installed post-installation script returned error exit status 1 Errors were encountered while processing: mariadb-server-10.0 E: Sub-process /usr/bin/dpkg returned an error code (1) On Sun, Mar 15, 2015 at 2:30 PM, Daniel Cialdella Converti < dcialdella@gmail.com> wrote:
I will check it today and add more info. Thanks
On Sun, Mar 15, 2015 at 2:12 PM, John Leach <john@johnleach.co.uk> wrote:
On Sat, 2015-03-14 at 20:48 +0200, Otto Kekäläinen wrote:
Hello Daniel B. and others,
I decided to write to you via the mailing list so that we are inclusive if somebody wants to join our effort to create a solid passwordless (Debian/Ubuntu) packaging.
it might be worth you noting the issue I found last month - mariadb and perconadb (and maybe mysql upstream, I'm unsure) use different names for the unix socket plugin, so switching between servers with the same data directory using this plugin does not work:
https://lists.launchpad.net/maria-developers/msg08177.html
I'm unsure if Debian uses different data directories for mariadb than /var/lib/mysql. The percona packages don't, and mariadb's own packages do not.
There are plenty of other things that make switching mysql versions difficult, but the default authentication stopping working seems like it's going to affect a lot of people!
John.
--
--------------------------------------------------------------------------------------- (¯`**.(¯`**. From my TI 99 4/a - sorry for the delay **´¯).**´¯) (¯`**.(¯`**. Sent using Secure communications GPG **´¯).**´¯) (¯`**.(¯`**. During delivery no animals were harmed **´¯).**´¯)
---------------------------------------------------------------------------------------
-- --------------------------------------------------------------------------------------- (¯`**.(¯`**. From my TI 99 4/a - sorry for the delay **´¯).**´¯) (¯`**.(¯`**. Sent using Secure communications GPG **´¯).**´¯) (¯`**.(¯`**. During delivery no animals were harmed **´¯).**´¯) ---------------------------------------------------------------------------------------
Hi, could you attach the error log to know why the service start failed? Le 24/03/2015 11:49, Daniel Cialdella Converti a écrit :
Today, another error
+ invoke-rc.d mysql start Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details. invoke-rc.d: initscript mysql, action "start" failed. + exit 1 dpkg: error processing package mariadb-server-10.0 (--configure): subprocess installed post-installation script returned error exit status 1 Errors were encountered while processing: mariadb-server-10.0 E: Sub-process /usr/bin/dpkg returned an error code (1)
On Sun, Mar 15, 2015 at 2:30 PM, Daniel Cialdella Converti <dcialdella@gmail.com <mailto:dcialdella@gmail.com>> wrote:
I will check it today and add more info. Thanks
On Sun, Mar 15, 2015 at 2:12 PM, John Leach <john@johnleach.co.uk <mailto:john@johnleach.co.uk>> wrote:
On Sat, 2015-03-14 at 20:48 +0200, Otto Kekäläinen wrote: > Hello Daniel B. and others, > > I decided to write to you via the mailing list so that we are > inclusive if somebody wants to join our effort to create a solid > passwordless (Debian/Ubuntu) packaging. >
it might be worth you noting the issue I found last month - mariadb and perconadb (and maybe mysql upstream, I'm unsure) use different names for the unix socket plugin, so switching between servers with the same data directory using this plugin does not work:
https://lists.launchpad.net/maria-developers/msg08177.html
I'm unsure if Debian uses different data directories for mariadb than /var/lib/mysql. The percona packages don't, and mariadb's own packages do not.
There are plenty of other things that make switching mysql versions difficult, but the default authentication stopping working seems like it's going to affect a lot of people!
John
2015-03-14 20:48 GMT+02:00 Otto Kekäläinen <otto@seravo.fi>:
The mariadb-10.0.17-exp1 at the moment in Debian experimental is broken due to inclusion of an early version of this change, so I hope we could get it completed soon so that I don't have to revert the whole passwordless root account feature (which has been requested by many).
I started to look that we are going to have to wait for a long time for the new mysql-common version to be provided by the new MySQL package in Debian experimental, so I now changed the MariaDB packaging so that it takes care of generating its own symlink fully automatically, and it seems that was the only issue with the packaging at the moment, so now it works. Latest version is built and available now at the 'deb http://labs.seravo.fi/~otto/mariadb-repo/ mariadb-10.0-sid-amd64/' repo. Daniel Black: does the below look OK to you? MariaDB [mysql]> select host,user,password,plugin from user; +-----------+------+----------+-------------+ | host | user | password | plugin | +-----------+------+----------+-------------+ | localhost | root | | unix_socket | | 127.0.0.1 | root | | | | ::1 | root | | | +-----------+------+----------+-------------+ The syslog has a complaint about there being two root accounts that are both passwordless and pluginless.
2015-03-29 21:59 GMT+03:00 Otto Kekäläinen <otto@seravo.fi>:
Latest version is built and available now at the 'deb http://labs.seravo.fi/~otto/mariadb-repo/ mariadb-10.0-sid-amd64/' repo.
Ok, now it seems everything finally works. A big thanks to Daniel Black for his pull requests and the help with fixing all regressions etc so the maintainer script should be pretty optimal by now. Daniel Cialdella: it you still are available to help with testing, now there are no known problems and additional testing would be helpful.
Today, I upgraded my server and all finished OK. But can't access to Engine. root@d7:/home/dac# mysql -u root -p Enter password: ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded On Fri, Apr 3, 2015 at 8:05 PM, Otto Kekäläinen <otto@seravo.fi> wrote:
2015-03-29 21:59 GMT+03:00 Otto Kekäläinen <otto@seravo.fi>:
Latest version is built and available now at the 'deb http://labs.seravo.fi/~otto/mariadb-repo/ mariadb-10.0-sid-amd64/' repo.
Ok, now it seems everything finally works. A big thanks to Daniel Black for his pull requests and the help with fixing all regressions etc so the maintainer script should be pretty optimal by now.
Daniel Cialdella: it you still are available to help with testing, now there are no known problems and additional testing would be helpful.
-- --------------------------------------------------------------------------------------- (¯`**.(¯`**. From my TI 99 4/a - sorry for the delay **´¯).**´¯) (¯`**.(¯`**. Sent using Secure communications GPG **´¯).**´¯) (¯`**.(¯`**. During delivery no animals were harmed **´¯).**´¯) ---------------------------------------------------------------------------------------
----- Original Message -----
Today, I upgraded my server and all finished OK.
But can't access to Engine.
root@d7:/home/dac# mysql -u root -p Enter password: ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded
does /etc/mysql/my.cnf symlink to /etc/mysql/mariadb.cnf? I suspect this was missed somehow. Is there a plugin-load-add from the config file? https://github.com/ottok/mariadb-10.0/blob/2f0dff8afbe13d0c21613a8fb55d4df7d... An upstream (or distro) merge of this would make it redundant. https://github.com/MariaDB/server/pull/29 -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise & maintenance for MySQL/MariaDB server environments.
This is what I have in the folder root@d7:/etc/mysql# ls -ail total 48 1055141 drwxr-xr-x 4 root root 4096 Apr 6 11:09 . 1044481 drwxr-xr-x 141 root root 12288 Apr 6 11:04 .. 1055175 drwxr-xr-x 2 root root 4096 Apr 6 11:03 conf.d 1044616 -rw------- 1 root root 277 Mar 26 11:57 debian.cnf 1045134 -rw------- 1 root root 333 Feb 23 09:07 debian_old_config.fsDTDb 1055184 -rwxr-xr-x 1 root root 1312 Feb 3 04:34 debian-start 1055178 -rw-r--r-- 1 root root 744 Feb 9 20:21 mariadb.cnf 1055147 drwxr-xr-x 2 root root 4096 Mar 24 10:03 mariadb.conf.d 1055143 -rw-r--r-- 1 root root 3540 Apr 6 11:09 my.cnf 1055174 -rw-r--r-- 1 root root 3506 Feb 16 11:49 my.cnf.dpkg-old May be I have to rename mariadb.cnf to my.cnf? What I found is two folder with config-add options. conf.d mariadb.conf.d root@d7:/etc/mysql# ll -lailR .: total 48 1055141 drwxr-xr-x 4 root root 4096 Apr 6 12:10 . 1044481 drwxr-xr-x 141 root root 12288 Apr 6 11:04 .. 1055175 drwxr-xr-x 2 root root 4096 Apr 6 11:03 conf.d 1044616 -rw------- 1 root root 277 Mar 26 11:57 debian.cnf 1045134 -rw------- 1 root root 333 Feb 23 09:07 debian_old_config.fsDTDb 1055184 -rwxr-xr-x 1 root root 1312 Feb 3 04:34 debian-start 1055178 -rw-r--r-- 1 root root 744 Feb 9 20:21 mariadb.cnf 1055147 drwxr-xr-x 2 root root 4096 Mar 24 10:03 mariadb.conf.d 1055143 -rw-r--r-- 1 root root 3540 Apr 6 11:09 my.cnf 1055174 -rw-r--r-- 1 root root 3506 Feb 16 11:49 my.cnf.dpkg-old ./conf.d: total 20 1055175 drwxr-xr-x 2 root root 4096 Apr 6 11:03 . 1055141 drwxr-xr-x 4 root root 4096 Apr 6 12:10 .. 1055176 -rw-r--r-- 1 root root 0 Nov 25 19:01 .keepme 1055177 -rw-r--r-- 1 root root 435 Feb 3 04:34 mariadb.cnf 1055186 -rw-r--r-- 1 root root 21 Feb 3 04:33 mysqld_safe_syslog.cnf 1055185 -rw-r--r-- 1 root root 285 Jan 25 16:21 tokudb.cnf ./mariadb.conf.d: total 20 1055147 drwxr-xr-x 2 root root 4096 Mar 24 10:03 . 1055141 drwxr-xr-x 4 root root 4096 Apr 6 12:10 .. 1055173 -rw-r--r-- 1 root root 111 Feb 8 13:32 client.cnf 1055166 -rw-r--r-- 1 root root 2715 Feb 8 13:32 mysqld.cnf 1055148 -rw-r--r-- 1 root root 306 Feb 8 13:32 mysqld_safe.cnf On Mon, Apr 6, 2015 at 11:54 AM, Daniel Black <daniel.black@openquery.com> wrote:
----- Original Message -----
Today, I upgraded my server and all finished OK.
But can't access to Engine.
root@d7:/home/dac# mysql -u root -p Enter password: ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded
does /etc/mysql/my.cnf symlink to /etc/mysql/mariadb.cnf?
I suspect this was missed somehow.
Is there a plugin-load-add from the config file?
https://github.com/ottok/mariadb-10.0/blob/2f0dff8afbe13d0c21613a8fb55d4df7d...
An upstream (or distro) merge of this would make it redundant.
https://github.com/MariaDB/server/pull/29
-- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise & maintenance for MySQL/MariaDB server environments.
-- --------------------------------------------------------------------------------------- (¯`**.(¯`**. From my TI 99 4/a - sorry for the delay **´¯).**´¯) (¯`**.(¯`**. Sent using Secure communications GPG **´¯).**´¯) (¯`**.(¯`**. During delivery no animals were harmed **´¯).**´¯) ---------------------------------------------------------------------------------------
Hello! 2015-04-06 13:12 GMT+03:00 Daniel Cialdella Converti <dcialdella@gmail.com>:
root@d7:/etc/mysql# ll -lailR .: total 48 1055141 drwxr-xr-x 4 root root 4096 Apr 6 12:10 . 1044481 drwxr-xr-x 141 root root 12288 Apr 6 11:04 .. 1055175 drwxr-xr-x 2 root root 4096 Apr 6 11:03 conf.d 1044616 -rw------- 1 root root 277 Mar 26 11:57 debian.cnf 1045134 -rw------- 1 root root 333 Feb 23 09:07 debian_old_config.fsDTDb 1055184 -rwxr-xr-x 1 root root 1312 Feb 3 04:34 debian-start 1055178 -rw-r--r-- 1 root root 744 Feb 9 20:21 mariadb.cnf 1055147 drwxr-xr-x 2 root root 4096 Mar 24 10:03 mariadb.conf.d 1055143 -rw-r--r-- 1 root root 3540 Apr 6 11:09 my.cnf 1055174 -rw-r--r-- 1 root root 3506 Feb 16 11:49 my.cnf.dpkg-old
The mariadb-common postinstall script was supposed to run: mv -f /etc/mysql/my.cnf /etc/mysql/my.cnf.old ln -sf mariadb.cnf /etc/mysql/my.cnf It does not seem to have happened for some reason.. What if you Daniel C run those two lines manually (as root)?
This kind of specific configuration should be put on the "conf.d/" directory and under a "[mariadb]" tag as its specific to it. As it should be possible for the install not to fail if the passwordless configuration failed (or ideally if there was a choice and the user chose not to use it). Adding this directly on the "my.cnf" will be a real mess for users who just re-use generic "my.cnf" from other installs (or from a template) that could be cross-compatible between distros and with older versions of MariaDB or even with MySQL. And that way it will be easier to maintain changes to my.cnf and to this authentication config file when doing packages upgrade. Another possibility is to reuse the "debian-start" and "debian.cnf" mechanism which was adding "--defaults-file=/etc/mysql/debian.cnf" to mysql* commands but it doesnt sounds as clean and portable as to use conf.d in case the datadir and /etc/mysql would be ported to a different distro (or to a generic "tar" version of MariaDB) without keeping the debian init script (its a bit far fetched, i know but i saw that in the past). Le 06/04/2015 12:32, Otto Kekäläinen a écrit :
Hello!
2015-04-06 13:12 GMT+03:00 Daniel Cialdella Converti <dcialdella@gmail.com>:
root@d7:/etc/mysql# ll -lailR .: total 48 1055141 drwxr-xr-x 4 root root 4096 Apr 6 12:10 . 1044481 drwxr-xr-x 141 root root 12288 Apr 6 11:04 .. 1055175 drwxr-xr-x 2 root root 4096 Apr 6 11:03 conf.d 1044616 -rw------- 1 root root 277 Mar 26 11:57 debian.cnf 1045134 -rw------- 1 root root 333 Feb 23 09:07 debian_old_config.fsDTDb 1055184 -rwxr-xr-x 1 root root 1312 Feb 3 04:34 debian-start 1055178 -rw-r--r-- 1 root root 744 Feb 9 20:21 mariadb.cnf 1055147 drwxr-xr-x 2 root root 4096 Mar 24 10:03 mariadb.conf.d 1055143 -rw-r--r-- 1 root root 3540 Apr 6 11:09 my.cnf 1055174 -rw-r--r-- 1 root root 3506 Feb 16 11:49 my.cnf.dpkg-old
The mariadb-common postinstall script was supposed to run:
mv -f /etc/mysql/my.cnf /etc/mysql/my.cnf.old ln -sf mariadb.cnf /etc/mysql/my.cnf
It does not seem to have happened for some reason..
What if you Daniel C run those two lines manually (as root)?
All perfect. I rename the files. root@d7:/home/dac# mv -f /etc/mysql/my.cnf /etc/mysql/my.cnf.old root@d7:/home/dac# ln -sf mariadb.cnf /etc/mysql/my.cnf Reboot server. And now is working root@d7:/home/dac# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 40 Server version: 10.0.17-MariaDB-1~exp2 (Debian) Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> On Mon, Apr 6, 2015 at 12:32 PM, Otto Kekäläinen <otto@seravo.fi> wrote:
Hello!
2015-04-06 13:12 GMT+03:00 Daniel Cialdella Converti <dcialdella@gmail.com
: root@d7:/etc/mysql# ll -lailR .: total 48 1055141 drwxr-xr-x 4 root root 4096 Apr 6 12:10 . 1044481 drwxr-xr-x 141 root root 12288 Apr 6 11:04 .. 1055175 drwxr-xr-x 2 root root 4096 Apr 6 11:03 conf.d 1044616 -rw------- 1 root root 277 Mar 26 11:57 debian.cnf 1045134 -rw------- 1 root root 333 Feb 23 09:07 debian_old_config.fsDTDb 1055184 -rwxr-xr-x 1 root root 1312 Feb 3 04:34 debian-start 1055178 -rw-r--r-- 1 root root 744 Feb 9 20:21 mariadb.cnf 1055147 drwxr-xr-x 2 root root 4096 Mar 24 10:03 mariadb.conf.d 1055143 -rw-r--r-- 1 root root 3540 Apr 6 11:09 my.cnf 1055174 -rw-r--r-- 1 root root 3506 Feb 16 11:49 my.cnf.dpkg-old
The mariadb-common postinstall script was supposed to run:
mv -f /etc/mysql/my.cnf /etc/mysql/my.cnf.old ln -sf mariadb.cnf /etc/mysql/my.cnf
It does not seem to have happened for some reason..
What if you Daniel C run those two lines manually (as root)?
-- --------------------------------------------------------------------------------------- (¯`**.(¯`**. From my TI 99 4/a - sorry for the delay **´¯).**´¯) (¯`**.(¯`**. Sent using Secure communications GPG **´¯).**´¯) (¯`**.(¯`**. During delivery no animals were harmed **´¯).**´¯) ---------------------------------------------------------------------------------------
May be it's not the best place to write this, but.... I try to use MySQL Workbench with MariaDB and ca't access to all options in the engine. I had read some blogs and people suggest to use SQLyog and other tools (payed), I try to use the text interface during all day (we have +150 srvs with MySQL) but sometimes I prefer the graphic interface, Ideas ? incompatiblity issues? why ? thanks dac On Mon, Apr 6, 2015 at 12:59 PM, Daniel Cialdella Converti < dcialdella@gmail.com> wrote:
All perfect. I rename the files.
root@d7:/home/dac# mv -f /etc/mysql/my.cnf /etc/mysql/my.cnf.old root@d7:/home/dac# ln -sf mariadb.cnf /etc/mysql/my.cnf
Reboot server.
And now is working
root@d7:/home/dac# mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 40 Server version: 10.0.17-MariaDB-1~exp2 (Debian)
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
On Mon, Apr 6, 2015 at 12:32 PM, Otto Kekäläinen <otto@seravo.fi> wrote:
Hello!
2015-04-06 13:12 GMT+03:00 Daniel Cialdella Converti < dcialdella@gmail.com>:
root@d7:/etc/mysql# ll -lailR .: total 48 1055141 drwxr-xr-x 4 root root 4096 Apr 6 12:10 . 1044481 drwxr-xr-x 141 root root 12288 Apr 6 11:04 .. 1055175 drwxr-xr-x 2 root root 4096 Apr 6 11:03 conf.d 1044616 -rw------- 1 root root 277 Mar 26 11:57 debian.cnf 1045134 -rw------- 1 root root 333 Feb 23 09:07 debian_old_config.fsDTDb 1055184 -rwxr-xr-x 1 root root 1312 Feb 3 04:34 debian-start 1055178 -rw-r--r-- 1 root root 744 Feb 9 20:21 mariadb.cnf 1055147 drwxr-xr-x 2 root root 4096 Mar 24 10:03 mariadb.conf.d 1055143 -rw-r--r-- 1 root root 3540 Apr 6 11:09 my.cnf 1055174 -rw-r--r-- 1 root root 3506 Feb 16 11:49 my.cnf.dpkg-old
The mariadb-common postinstall script was supposed to run:
mv -f /etc/mysql/my.cnf /etc/mysql/my.cnf.old ln -sf mariadb.cnf /etc/mysql/my.cnf
It does not seem to have happened for some reason..
What if you Daniel C run those two lines manually (as root)?
--
--------------------------------------------------------------------------------------- (¯`**.(¯`**. From my TI 99 4/a - sorry for the delay **´¯).**´¯) (¯`**.(¯`**. Sent using Secure communications GPG **´¯).**´¯) (¯`**.(¯`**. During delivery no animals were harmed **´¯).**´¯)
---------------------------------------------------------------------------------------
-- --------------------------------------------------------------------------------------- (¯`**.(¯`**. From my TI 99 4/a - sorry for the delay **´¯).**´¯) (¯`**.(¯`**. Sent using Secure communications GPG **´¯).**´¯) (¯`**.(¯`**. During delivery no animals were harmed **´¯).**´¯) ---------------------------------------------------------------------------------------
2015-04-06 13:32 GMT+03:00 Otto Kekäläinen <otto@seravo.fi>:
2015-04-06 13:12 GMT+03:00 Daniel Cialdella Converti <dcialdella@gmail.com>:
root@d7:/etc/mysql# ll -lailR .: total 48 1055141 drwxr-xr-x 4 root root 4096 Apr 6 12:10 . 1044481 drwxr-xr-x 141 root root 12288 Apr 6 11:04 .. 1055175 drwxr-xr-x 2 root root 4096 Apr 6 11:03 conf.d 1044616 -rw------- 1 root root 277 Mar 26 11:57 debian.cnf 1045134 -rw------- 1 root root 333 Feb 23 09:07 debian_old_config.fsDTDb 1055184 -rwxr-xr-x 1 root root 1312 Feb 3 04:34 debian-start 1055178 -rw-r--r-- 1 root root 744 Feb 9 20:21 mariadb.cnf 1055147 drwxr-xr-x 2 root root 4096 Mar 24 10:03 mariadb.conf.d 1055143 -rw-r--r-- 1 root root 3540 Apr 6 11:09 my.cnf 1055174 -rw-r--r-- 1 root root 3506 Feb 16 11:49 my.cnf.dpkg-old
The mariadb-common postinstall script was supposed to run:
mv -f /etc/mysql/my.cnf /etc/mysql/my.cnf.old ln -sf mariadb.cnf /etc/mysql/my.cnf
It does not seem to have happened for some reason..
What if you Daniel C run those two lines manually (as root)?
The passwordless option is defined in /etc/mysql/mariadb.conf.d/mysqld.cnf (line plugin-load-add = auth_socket.so). This configuration layout is what Canonical staff wanted to have in a packaging sprint in December and it's implemented in MySQL, Percona and MariaDB packaging - though nobody has uploaded a new version of MySQL to Debian, thus the mysql-common package does not provide the facility to register configs properly and thus I made the manual version that simply links my.cnf -> mariadb.cnf. For some reason this mariadb-common postinst didn't fire on your install Daniel C, but running the same commands manually worked as expected. I just tested with a Debian unstable machine by installing mysql-5.5.41 first, and then upgrading to mariadb-10.0.17, and it worked just fine. Maybe what you Daniel C saw was some special case of upgrading?
Ok.today I tested some of our databases (schemas) recovering them in the mariadb server. All looks right. Tomorrow I will test with data and querys. On Mon, Apr 6, 2015 at 10:29 PM, Otto Kekäläinen <otto@seravo.fi> wrote:
2015-04-06 13:32 GMT+03:00 Otto Kekäläinen <otto@seravo.fi>:
2015-04-06 13:12 GMT+03:00 Daniel Cialdella Converti < dcialdella@gmail.com>:
root@d7:/etc/mysql# ll -lailR .: total 48 1055141 drwxr-xr-x 4 root root 4096 Apr 6 12:10 . 1044481 drwxr-xr-x 141 root root 12288 Apr 6 11:04 .. 1055175 drwxr-xr-x 2 root root 4096 Apr 6 11:03 conf.d 1044616 -rw------- 1 root root 277 Mar 26 11:57 debian.cnf 1045134 -rw------- 1 root root 333 Feb 23 09:07 debian_old_config.fsDTDb 1055184 -rwxr-xr-x 1 root root 1312 Feb 3 04:34 debian-start 1055178 -rw-r--r-- 1 root root 744 Feb 9 20:21 mariadb.cnf 1055147 drwxr-xr-x 2 root root 4096 Mar 24 10:03 mariadb.conf.d 1055143 -rw-r--r-- 1 root root 3540 Apr 6 11:09 my.cnf 1055174 -rw-r--r-- 1 root root 3506 Feb 16 11:49 my.cnf.dpkg-old
The mariadb-common postinstall script was supposed to run:
mv -f /etc/mysql/my.cnf /etc/mysql/my.cnf.old ln -sf mariadb.cnf /etc/mysql/my.cnf
It does not seem to have happened for some reason..
What if you Daniel C run those two lines manually (as root)?
The passwordless option is defined in /etc/mysql/mariadb.conf.d/mysqld.cnf (line plugin-load-add = auth_socket.so). This configuration layout is what Canonical staff wanted to have in a packaging sprint in December and it's implemented in MySQL, Percona and MariaDB packaging - though nobody has uploaded a new version of MySQL to Debian, thus the mysql-common package does not provide the facility to register configs properly and thus I made the manual version that simply links my.cnf -> mariadb.cnf.
For some reason this mariadb-common postinst didn't fire on your install Daniel C, but running the same commands manually worked as expected.
I just tested with a Debian unstable machine by installing mysql-5.5.41 first, and then upgrading to mariadb-10.0.17, and it worked just fine. Maybe what you Daniel C saw was some special case of upgrading?
-- --------------------------------------------------------------------------------------- (¯`**.(¯`**. From my TI 99 4/a - sorry for the delay **´¯).**´¯) (¯`**.(¯`**. Sent using Secure communications GPG **´¯).**´¯) (¯`**.(¯`**. During delivery no animals were harmed **´¯).**´¯) ---------------------------------------------------------------------------------------
participants (5)
-
Daniel Black -
Daniel Cialdella Converti -
Jean Weisbuch -
John Leach -
Otto Kekäläinen