← Back to team overview

maria-developers team mailing list archive

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

 

2015-04-06 13:32 GMT+03:00 Otto Kekäläinen <otto@xxxxxxxxx>:
> 2015-04-06 13:12 GMT+03:00 Daniel Cialdella Converti <dcialdella@xxxxxxxxx>:
>> root@d7:/etc/mysql# ll -lailR
>> .:
>> total 48
>> 1055141 drwxr-xr-x   4 root root  4096 Apr  6 12:10 .
>> 1044481 drwxr-xr-x 141 root root 12288 Apr  6 11:04 ..
>> 1055175 drwxr-xr-x   2 root root  4096 Apr  6 11:03 conf.d
>> 1044616 -rw-------   1 root root   277 Mar 26 11:57 debian.cnf
>> 1045134 -rw-------   1 root root   333 Feb 23 09:07 debian_old_config.fsDTDb
>> 1055184 -rwxr-xr-x   1 root root  1312 Feb  3 04:34 debian-start
>> 1055178 -rw-r--r--   1 root root   744 Feb  9 20:21 mariadb.cnf
>> 1055147 drwxr-xr-x   2 root root  4096 Mar 24 10:03 mariadb.conf.d
>> 1055143 -rw-r--r--   1 root root  3540 Apr  6 11:09 my.cnf
>> 1055174 -rw-r--r--   1 root root  3506 Feb 16 11:49 my.cnf.dpkg-old
>
>
> The mariadb-common postinstall script was supposed to run:
>
> mv -f /etc/mysql/my.cnf /etc/mysql/my.cnf.old
> ln -sf mariadb.cnf /etc/mysql/my.cnf
>
> It does not seem to have happened for some reason..
>
> What if you Daniel C run those two lines manually (as root)?


The passwordless option is defined in
/etc/mysql/mariadb.conf.d/mysqld.cnf (line plugin-load-add         =
auth_socket.so). This configuration layout is what Canonical staff
wanted to have in a packaging sprint in December and it's implemented
in MySQL, Percona and MariaDB packaging - though nobody has uploaded a
new version of MySQL to Debian, thus the mysql-common package does not
provide the facility to register configs properly and thus I made the
manual version that simply links my.cnf -> mariadb.cnf.

For some reason this mariadb-common postinst didn't fire on your
install Daniel C, but running the same commands manually worked as
expected.

I just tested with a Debian unstable machine by installing
mysql-5.5.41 first, and then upgrading to mariadb-10.0.17, and it
worked just fine. Maybe what you Daniel C saw was some special case of
upgrading?


Follow ups

References