maria-developers team mailing list archive
-
maria-developers team
-
Mailing list archive
-
Message #08191
Re: passwordless mariadb root login with auht_socket in Debian
I partly got started on the weekend but didn't get far.
I'll continue looking this afternoon.
----- Original Message -----
> Daniel, anybody..?
>
> 2015-02-20 22:52 GMT+02:00 Otto Kekäläinen <otto@xxxxxxxxx>:
> > Hello Daniel!
> >
> > It seems there are some issues with the passwordless login patch you
> > sent me some weeks ago (https://github.com/ottok/mariadb-10.0/pull/3)
> >
> > Can you help me debug the failing postinst script?
> >
> >
> > I added 'set -x' to the mariadb-server-10.0.postinst script and when
> > it is run during the configure phase it will exit with code 1 and make
> > dpkg abort the installation.
> >
> > Last lines of execution:
> > 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'\'';'
> > + logger -p daemon.err -t mysqld_safe -i
> > + /usr/sbin/mysqld --bootstrap --user=mysql --skip-grant-tables
> > --default-storage-engine=myisam --plugin-load-add=auth_socket
> > + set -e
> > + echo 'SET sql_log_bin=0; USE mysql; DELIMITER //; CREATE PROCEDURE
> > debian_plugin_install(IN plugin_name CHAR(50), IN soname CHAR(50))
> > BEGIN DECLARE CONTINUE HANDLER FOR NOT FOUND EXECUTE
> > inst_plug; set @plugin_name=plugin_name; set @soname=soname ;set
> > @install_plugin=CONCAT("INSTALL PLUGIN ",@plugin_name," SONAME '\''",
> > @soname, "'\''");PREPARE inst_plug FROM @install_plugin ;
> > select PLUGIN_NAME INTO @a from information_schema.plugins where
> > PLUGIN_NAME=@plugin_name AND PLUGIN_STATUS='\''ACTIVE'\'' AND
> > PLUGIN_TYPE='\''AUTHENTICATION'\'' AND PLUGIN_LIBRARY LIKE
> > concat(@soname,'\''%'\''
> > ); DEALLOCATE PREPARE inst_plug; END// CALL
> > debian_plugin_install('\''unix_socket'\'', '\''auth_socket'\'') //
> > DROP PROCEDURE debian_plugin_install//'
> > + logger -p daemon.err -t mysqld_safe -i
> > + /usr/sbin/mysqld --bootstrap --user=mysql --skip-grant-tables
> > --default-storage-engine=myisam --plugin-load-add=auth_socket
> > timo@debunstable:~$ echo $?
> > 1
> > timo@debunstable:~$ echo $?
> > 0
> >
> > This implies that the exit code from the line '/usr/sbin/mysqld
> > --bootstrap --user=mysql --skip-grant-tables
> > --default-storage-engine=myisam --plugin-load-add=auth_socket' is 1.
> >
> >
> > Any ideas why?
> >
> >
> > If you want to test it yourself, add to you apt sources the test repo
> >
> > deb http://labs.seravo.fi/~otto/mariadb-repo/ mariabd-10.0-sid-amd64/
>
>
>
> --
> Check out our blog at http://seravo.fi/blog
> and follow @ottokekalainen
>
--
--
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise & maintenance for MySQL/MariaDB server environments.
References