← Back to team overview

maria-developers team mailing list archive

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