← Back to team overview

maria-developers team mailing list archive

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

 

Ok.today I tested some of our databases (schemas) recovering them in the
mariadb server.
All looks right. Tomorrow I will test with data and querys.



On Mon, Apr 6, 2015 at 10:29 PM, Otto Kekäläinen <otto@xxxxxxxxx> wrote:

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



-- 
---------------------------------------------------------------------------------------
(¯`**.(¯`**. From my TI 99 4/a - sorry for the delay     **´¯).**´¯)
(¯`**.(¯`**. Sent using Secure communications GPG **´¯).**´¯)
(¯`**.(¯`**. During delivery no animals were harmed    **´¯).**´¯)
---------------------------------------------------------------------------------------

References