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