← Back to team overview

maria-developers team mailing list archive

Re: Passwordless MariaDB root login with auth_socket in Debian continues..


----- 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?


bool mysql_install_plugin(THD *thd, const LEX_STRING *name,
                          const LEX_STRING *dl_arg)

  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.

Follow ups