maria-developers team mailing list archive
-
maria-developers team
-
Mailing list archive
-
Message #08316
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