← Back to team overview

maria-developers team mailing list archive

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

 


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


References