Re: [Maria-developers] Passwordless MariaDB root login with auth_socket in Debian continues..

[Daniel Cialdella Converti]

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  wrote:

> 2015-04-06 13:32 GMT+03:00 Otto Kekäläinen :
> > 2015-04-06 13:12 GMT+03:00 Daniel Cialdella Converti <
> dcialde...@gmail.com>:
> >> 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**´¯).**´¯)
---
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-developers] Passwordless MariaDB root login with auth_socket in Debian continues..

[Otto Kekäläinen]

2015-04-06 13:32 GMT+03:00 Otto Kekäläinen :
> 2015-04-06 13:12 GMT+03:00 Daniel Cialdella Converti :
>> 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?

___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-developers] Passwordless MariaDB root login with auth_socket in Debian continues..

[Daniel Cialdella Converti]

May be it's not the best place to write this, but

I try to use MySQL Workbench with MariaDB and ca't access to all options in
the engine.
I had read some blogs and people suggest to use SQLyog and other tools
(payed),

I try to use the text interface during all day (we have +150 srvs with
MySQL) but sometimes I prefer the graphic interface,

Ideas ? incompatiblity issues? why ?

thanks

dac

On Mon, Apr 6, 2015 at 12:59 PM, Daniel Cialdella Converti <
dcialde...@gmail.com> wrote:

>
> All perfect. I rename the files.
>
> root@d7:/home/dac# mv -f /etc/mysql/my.cnf /etc/mysql/my.cnf.old
> root@d7:/home/dac# ln -sf mariadb.cnf /etc/mysql/my.cnf
>
>
>
> Reboot server.
>
> And now is working
>
>
> root@d7:/home/dac# mysql
> Welcome to the MariaDB monitor.  Commands end with ; or \g.
> Your MariaDB connection id is 40
> Server version: 10.0.17-MariaDB-1~exp2 (Debian)
>
> Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
>
> MariaDB [(none)]>
>
>
>
>
>
>
>
>
>
> On Mon, Apr 6, 2015 at 12:32 PM, Otto Kekäläinen  wrote:
>
>> Hello!
>>
>> 2015-04-06 13:12 GMT+03:00 Daniel Cialdella Converti <
>> dcialde...@gmail.com>:
>> > 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)?
>>
>
>
>
> --
>
> ---
> (¯`**.(¯`**. From my TI 99 4/a - sorry for the delay **´¯).**´¯)
> (¯`**.(¯`**. Sent using Secure communications GPG **´¯).**´¯)
> (¯`**.(¯`**. During delivery no animals were harmed**´¯).**´¯)
>
> ---
>
>


-- 
---
(¯`**.(¯`**. From my TI 99 4/a - sorry for the delay **´¯).**´¯)
(¯`**.(¯`**. Sent using Secure communications GPG **´¯).**´¯)
(¯`**.(¯`**. During delivery no animals were harmed**´¯).**´¯)
---
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-developers] Passwordless MariaDB root login with auth_socket in Debian continues..

[Daniel Cialdella Converti]

All perfect. I rename the files.

root@d7:/home/dac# mv -f /etc/mysql/my.cnf /etc/mysql/my.cnf.old
root@d7:/home/dac# ln -sf mariadb.cnf /etc/mysql/my.cnf



Reboot server.

And now is working


root@d7:/home/dac# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 40
Server version: 10.0.17-MariaDB-1~exp2 (Debian)

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

MariaDB [(none)]>









On Mon, Apr 6, 2015 at 12:32 PM, Otto Kekäläinen  wrote:

> Hello!
>
> 2015-04-06 13:12 GMT+03:00 Daniel Cialdella Converti  >:
> > 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)?
>



-- 
---
(¯`**.(¯`**. From my TI 99 4/a - sorry for the delay **´¯).**´¯)
(¯`**.(¯`**. Sent using Secure communications GPG **´¯).**´¯)
(¯`**.(¯`**. During delivery no animals were harmed**´¯).**´¯)
---
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-developers] Passwordless MariaDB root login with auth_socket in Debian continues..

[Jean Weisbuch]

This kind of specific configuration should be put on the "conf.d/" 
directory and under a "[mariadb]" tag as its specific to it.
As it should be possible for the install not to fail if the passwordless 
configuration failed (or ideally if there was a choice and the user 
chose not to use it).
Adding this directly on the "my.cnf" will be a real mess for users who 
just re-use generic "my.cnf" from other installs (or from a template) 
that could be cross-compatible between distros and with older versions 
of MariaDB or even with MySQL.
And that way it will be easier to maintain changes to my.cnf and to this 
authentication config file when doing packages upgrade.


Another possibility is to reuse the "debian-start" and "debian.cnf" 
mechanism which was adding "--defaults-file=/etc/mysql/debian.cnf" to 
mysql* commands but it doesnt sounds as clean and portable as to use 
conf.d in case the datadir and /etc/mysql would be ported to a different 
distro (or to a generic "tar" version of MariaDB) without keeping the 
debian init script (its a bit far fetched, i know but i saw that in the 
past).


Le 06/04/2015 12:32, Otto Kekäläinen a écrit :

Hello!

2015-04-06 13:12 GMT+03:00 Daniel Cialdella Converti :

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


___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-developers] Passwordless MariaDB root login with auth_socket in Debian continues..

[Otto Kekäläinen]

Hello!

2015-04-06 13:12 GMT+03:00 Daniel Cialdella Converti :
> 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)?

___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-developers] Passwordless MariaDB root login with auth_socket in Debian continues..

[Daniel Cialdella Converti]

This is what I have in the folder

root@d7:/etc/mysql# ls -ail
total 48
1055141 drwxr-xr-x   4 root root  4096 Apr  6 11:09 .
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


May be I have to rename mariadb.cnf to my.cnf?




What I found is
   two folder with config-add options.
   conf.d
   mariadb.conf.d


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

./conf.d:
total 20
1055175 drwxr-xr-x 2 root root 4096 Apr  6 11:03 .
1055141 drwxr-xr-x 4 root root 4096 Apr  6 12:10 ..
1055176 -rw-r--r-- 1 root root0 Nov 25 19:01 .keepme
1055177 -rw-r--r-- 1 root root  435 Feb  3 04:34 mariadb.cnf
1055186 -rw-r--r-- 1 root root   21 Feb  3 04:33 mysqld_safe_syslog.cnf
1055185 -rw-r--r-- 1 root root  285 Jan 25 16:21 tokudb.cnf

./mariadb.conf.d:
total 20
1055147 drwxr-xr-x 2 root root 4096 Mar 24 10:03 .
1055141 drwxr-xr-x 4 root root 4096 Apr  6 12:10 ..
1055173 -rw-r--r-- 1 root root  111 Feb  8 13:32 client.cnf
1055166 -rw-r--r-- 1 root root 2715 Feb  8 13:32 mysqld.cnf
1055148 -rw-r--r-- 1 root root  306 Feb  8 13:32 mysqld_safe.cnf






On Mon, Apr 6, 2015 at 11:54 AM, Daniel Black 
wrote:

>
>
> - Original Message -
> > Today, I upgraded my server and all finished OK.
> >
> > But can't access to Engine.
> >
> >
> > root@d7:/home/dac# mysql -u root -p
> > Enter password:
> > ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded
>
>
> does /etc/mysql/my.cnf symlink to /etc/mysql/mariadb.cnf?
>
> I suspect this was missed somehow.
>
> Is there a plugin-load-add from the config file?
>
> https://github.com/ottok/mariadb-10.0/blob/2f0dff8afbe13d0c21613a8fb55d4df7d4a6e6f7/debian/additions/mariadb.conf.d/mysqld.cnf#L103
>
>
> An upstream (or distro) merge of this would make it redundant.
>
> https://github.com/MariaDB/server/pull/29
>
>
> --
> --
> Daniel Black, Engineer @ Open Query (http://openquery.com.au)
> Remote expertise & maintenance for MySQL/MariaDB server environments.
>



-- 
---
(¯`**.(¯`**. From my TI 99 4/a - sorry for the delay **´¯).**´¯)
(¯`**.(¯`**. Sent using Secure communications GPG **´¯).**´¯)
(¯`**.(¯`**. During delivery no animals were harmed**´¯).**´¯)
---
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-developers] Passwordless MariaDB root login with auth_socket in Debian continues..

[Daniel Black]

- Original Message -
> Today, I upgraded my server and all finished OK.
> 
> But can't access to Engine.
> 
> 
> root@d7:/home/dac# mysql -u root -p
> Enter password:
> ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded


does /etc/mysql/my.cnf symlink to /etc/mysql/mariadb.cnf?

I suspect this was missed somehow.

Is there a plugin-load-add from the config file?
https://github.com/ottok/mariadb-10.0/blob/2f0dff8afbe13d0c21613a8fb55d4df7d4a6e6f7/debian/additions/mariadb.conf.d/mysqld.cnf#L103


An upstream (or distro) merge of this would make it redundant.

https://github.com/MariaDB/server/pull/29


-- 
-- 
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise & maintenance for MySQL/MariaDB server environments.

___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-developers] Passwordless MariaDB root login with auth_socket in Debian continues..

[Daniel Cialdella Converti]

Today, I upgraded my server and all finished OK.

But can't access to Engine.


root@d7:/home/dac# mysql -u root -p
Enter password:
ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded




On Fri, Apr 3, 2015 at 8:05 PM, Otto Kekäläinen  wrote:

> 2015-03-29 21:59 GMT+03:00 Otto Kekäläinen :
> > Latest version is built and available now at the 'deb
> > http://labs.seravo.fi/~otto/mariadb-repo/ mariadb-10.0-sid-amd64/'
> > repo.
>
> Ok, now it seems everything finally works. A big thanks to Daniel
> Black for his pull requests and the help with fixing all regressions
> etc so the maintainer script should be pretty optimal by now.
>
> Daniel Cialdella: it you still are available to help with testing, now
> there are no known problems and additional testing would be helpful.
>



-- 
---
(¯`**.(¯`**. From my TI 99 4/a - sorry for the delay **´¯).**´¯)
(¯`**.(¯`**. Sent using Secure communications GPG **´¯).**´¯)
(¯`**.(¯`**. During delivery no animals were harmed**´¯).**´¯)
---
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-developers] Passwordless MariaDB root login with auth_socket in Debian continues..

[Otto Kekäläinen]

2015-03-29 21:59 GMT+03:00 Otto Kekäläinen :
> Latest version is built and available now at the 'deb
> http://labs.seravo.fi/~otto/mariadb-repo/ mariadb-10.0-sid-amd64/'
> repo.

Ok, now it seems everything finally works. A big thanks to Daniel
Black for his pull requests and the help with fixing all regressions
etc so the maintainer script should be pretty optimal by now.

Daniel Cialdella: it you still are available to help with testing, now
there are no known problems and additional testing would be helpful.

___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-developers] Passwordless MariaDB root login with auth_socket in Debian continues..

[Otto Kekäläinen]

2015-03-14 20:48 GMT+02:00 Otto Kekäläinen :
> The mariadb-10.0.17-exp1 at the moment in Debian experimental is
> broken due to inclusion of an early version of this change, so I hope
> we could get it completed soon so that I don't have to revert the
> whole passwordless root account feature (which has been requested by
> many).


I started to look that we are going to have to wait for a long time
for the new mysql-common version to be provided by the new MySQL
package in Debian experimental, so I now changed the MariaDB packaging
so that it takes care of generating its own symlink fully
automatically, and it seems that was the only issue with the packaging
at the moment, so now it works.

Latest version is built and available now at the 'deb
http://labs.seravo.fi/~otto/mariadb-repo/ mariadb-10.0-sid-amd64/'
repo.


Daniel Black: does the below look OK to you?

MariaDB [mysql]> select host,user,password,plugin from user;
+---+--+--+-+
| host  | user | password | plugin  |
+---+--+--+-+
| localhost | root |  | unix_socket |
| 127.0.0.1 | root |  | |
| ::1   | root |  | |
+---+--+--+-+

The syslog has a complaint about there being two root accounts that
are both passwordless and pluginless.

___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-developers] Passwordless MariaDB root login with auth_socket in Debian continues..

[Jean Weisbuch]

Hi, could you attach the error log to know why the service start failed?

Le 24/03/2015 11:49, Daniel Cialdella Converti a écrit :


Today, another error

+ invoke-rc.d mysql start
Job for mysql.service failed. See 'systemctl status mysql.service' and 
'journalctl -xn' for details.

invoke-rc.d: initscript mysql, action "start" failed.
+ exit 1
dpkg: error processing package mariadb-server-10.0 (--configure):
 subprocess installed post-installation script returned error exit 
status 1

Errors were encountered while processing:
 mariadb-server-10.0
E: Sub-process /usr/bin/dpkg returned an error code (1)



On Sun, Mar 15, 2015 at 2:30 PM, Daniel Cialdella Converti 
mailto:dcialde...@gmail.com>> wrote:



I will check it today and add more info.
Thanks


On Sun, Mar 15, 2015 at 2:12 PM, John Leach mailto:j...@johnleach.co.uk>> wrote:

On Sat, 2015-03-14 at 20:48 +0200, Otto Kekäläinen wrote:
> 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.
>

it might be worth you noting the issue I found last month -
mariadb and
perconadb (and maybe mysql upstream, I'm unsure) use different
names for
the unix socket plugin, so switching between servers with the
same data
directory using this plugin does not work:

https://lists.launchpad.net/maria-developers/msg08177.html

I'm unsure if Debian uses different data directories for mariadb
than /var/lib/mysql. The percona packages don't, and mariadb's own
packages do not.

There are plenty of other things that make switching mysql
versions
difficult, but the default authentication stopping working
seems like
it's going to affect a lot of people!

John 

___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-developers] Passwordless MariaDB root login with auth_socket in Debian continues..

[Daniel Cialdella Converti]

Today, another error

+ invoke-rc.d mysql start
Job for mysql.service failed. See 'systemctl status mysql.service' and
'journalctl -xn' for details.
invoke-rc.d: initscript mysql, action "start" failed.
+ exit 1
dpkg: error processing package mariadb-server-10.0 (--configure):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 mariadb-server-10.0
E: Sub-process /usr/bin/dpkg returned an error code (1)



On Sun, Mar 15, 2015 at 2:30 PM, Daniel Cialdella Converti <
dcialde...@gmail.com> wrote:

>
> I will check it today and add more info.
> Thanks
>
>
> On Sun, Mar 15, 2015 at 2:12 PM, John Leach  wrote:
>
>> On Sat, 2015-03-14 at 20:48 +0200, Otto Kekäläinen wrote:
>> > 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.
>> >
>>
>> it might be worth you noting the issue I found last month - mariadb and
>> perconadb (and maybe mysql upstream, I'm unsure) use different names for
>> the unix socket plugin, so switching between servers with the same data
>> directory using this plugin does not work:
>>
>> https://lists.launchpad.net/maria-developers/msg08177.html
>>
>> I'm unsure if Debian uses different data directories for mariadb
>> than /var/lib/mysql. The percona packages don't, and mariadb's own
>> packages do not.
>>
>> There are plenty of other things that make switching mysql versions
>> difficult, but the default authentication stopping working seems like
>> it's going to affect a lot of people!
>>
>> John.
>>
>>
>>
>
>
> --
>
> ---
> (¯`**.(¯`**. From my TI 99 4/a - sorry for the delay **´¯).**´¯)
> (¯`**.(¯`**. Sent using Secure communications GPG **´¯).**´¯)
> (¯`**.(¯`**. During delivery no animals were harmed**´¯).**´¯)
>
> ---
>
>


-- 
---
(¯`**.(¯`**. From my TI 99 4/a - sorry for the delay **´¯).**´¯)
(¯`**.(¯`**. Sent using Secure communications GPG **´¯).**´¯)
(¯`**.(¯`**. During delivery no animals were harmed**´¯).**´¯)
---
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-developers] Passwordless MariaDB root login with auth_socket in Debian continues..

[Daniel Cialdella Converti]

I will check it today and add more info.
Thanks


On Sun, Mar 15, 2015 at 2:12 PM, John Leach  wrote:

> On Sat, 2015-03-14 at 20:48 +0200, Otto Kekäläinen wrote:
> > 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.
> >
>
> it might be worth you noting the issue I found last month - mariadb and
> perconadb (and maybe mysql upstream, I'm unsure) use different names for
> the unix socket plugin, so switching between servers with the same data
> directory using this plugin does not work:
>
> https://lists.launchpad.net/maria-developers/msg08177.html
>
> I'm unsure if Debian uses different data directories for mariadb
> than /var/lib/mysql. The percona packages don't, and mariadb's own
> packages do not.
>
> There are plenty of other things that make switching mysql versions
> difficult, but the default authentication stopping working seems like
> it's going to affect a lot of people!
>
> John.
>
>
>


-- 
---
(¯`**.(¯`**. From my TI 99 4/a - sorry for the delay **´¯).**´¯)
(¯`**.(¯`**. Sent using Secure communications GPG **´¯).**´¯)
(¯`**.(¯`**. During delivery no animals were harmed**´¯).**´¯)
---
___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-developers] Passwordless MariaDB root login with auth_socket in Debian continues..

[John Leach]

On Sat, 2015-03-14 at 20:48 +0200, Otto Kekäläinen wrote:
> 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.
> 

it might be worth you noting the issue I found last month - mariadb and
perconadb (and maybe mysql upstream, I'm unsure) use different names for
the unix socket plugin, so switching between servers with the same data
directory using this plugin does not work:

https://lists.launchpad.net/maria-developers/msg08177.html

I'm unsure if Debian uses different data directories for mariadb
than /var/lib/mysql. The percona packages don't, and mariadb's own
packages do not.

There are plenty of other things that make switching mysql versions
difficult, but the default authentication stopping working seems like
it's going to affect a lot of people!

John.



___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-developers] Passwordless MariaDB root login with auth_socket in Debian continues..

[Daniel Black]

- Original Message -
> 
> 
> - Original Message -
> > Its something that i did fix on the patch i sent previously, its the
> > "INSTALL PLUGIN" statement that cannot be executed while "mysqld" has
> > been ran with "--skip-grant-table", it should be replaced by an "INSERT"
> > on the "mysql.plugin" table.
> > 
> > The line 192 :
> >  INSTALL PLUGIN unix_socket SONAME 'auth_socket';
> > 
> > Must be replaced with :
> >  INSERT INTO mysql.plugin (name, dl) VALUES ('unix_socket',
> > 'auth_socket');
> > 
> 
> Ah, I see, seems even removing --skip-grant-tables isn't enough

--skip-grant-tables is implied by --bootstrap

..
> While insert probably works for auth_socket as it has no init function on
> install, devs is there a reason why you can't install a plugin in bootstrap?

https://mariadb.atlassian.net/browse/MDEV-7781

https://github.com/MariaDB/server/pull/28/files

-- 
-- 
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise & maintenance for MySQL/MariaDB server environments.

___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-developers] Passwordless MariaDB root login with auth_socket in Debian continues..

[Daniel Black]

- Original Message -
> Its something that i did fix on the patch i sent previously, its the
> "INSTALL PLUGIN" statement that cannot be executed while "mysqld" has
> been ran with "--skip-grant-table", it should be replaced by an "INSERT"
> on the "mysql.plugin" table.
> 
> The line 192 :
>  INSTALL PLUGIN unix_socket SONAME 'auth_socket';
> 
> Must be replaced with :
>  INSERT INTO mysql.plugin (name, dl) VALUES ('unix_socket',
> 'auth_socket');
> 

Ah, I see, seems even removing --skip-grant-tables isn't enough

./scripts/mysql_install_db  --srcdir=.  --no-defaults  --ldata=/tmp/db

echo "INSTALL PLUGIN unix_socket SONAME 'auth_socket';" | sql/mysqld 
--no-defaults  --socket /tmp/s.sock --datadir=/tmp/db  --lc-messages-dir 
/home/dan/software_projects/mariadb-server/sql/share  --pid-file=/tmp/m.pid 
--log-bin=/tmp/db --skip-networking --bootstrap
150315 10:31:45 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-03-15 10:31:45 7fb800be08c0 InnoDB:  UNIV_DEBUG switched on 
!
2015-03-15 10:31:45 7fb800be08c0 InnoDB:  UNIV_SYNC_DEBUG switched on 
!
150315 10:31:45 [Note] InnoDB: The InnoDB memory heap is disabled
150315 10:31:45 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150315 10:31:45 [Note] InnoDB: Memory barrier is not used
150315 10:31:45 [Note] InnoDB: Compressed tables use zlib 1.2.8
150315 10:31:45 [Note] InnoDB: Using Linux native AIO
150315 10:31:45 [Note] InnoDB: Using CPU crc32 instructions
150315 10:31:45 [Note] InnoDB: Initializing buffer pool, size = 128.0M
150315 10:31:45 [Note] InnoDB: Completed initialization of buffer pool
150315 10:31:45 [Note] InnoDB: Highest supported file format is Barracuda.
150315 10:31:46 [Note] InnoDB: 128 rollback segment(s) are active.
150315 10:31:46 [Note] InnoDB: Waiting for purge to start
150315 10:31:46 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 
5.6.22-72.0 started; log sequence number 1616727
150315 10:31:46 [Note] InnoDB: not started
ERROR: 1290  The MariaDB server is running with the --skip-grant-tables option 
so it cannot execute this statement


While insert probably works for auth_socket as it has no init function on 
install, devs is there a reason why you can't install a plugin in bootstrap?

sql/sql_plugin.cc

bool mysql_install_plugin(THD *thd, const LEX_STRING *name,
  const LEX_STRING *dl_arg)
{
...
  DBUG_ENTER("mysql_install_plugin");

  if (opt_noacl)
  {
my_error(ER_OPTION_PREVENTS_STATEMENT, MYF(0), "--skip-grant-tables");


-- 
-- 
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise & maintenance for MySQL/MariaDB server environments.

___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-developers] Passwordless MariaDB root login with auth_socket in Debian continues..

[Daniel Black]

- 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
2603774 drwxr-xr-x   4 root root 4096 Mar 14 22:40 /etc/mysql/
2605004 -rw-r--r--   1 root root 3533 Feb  9 10:33 
/etc/mysql/my.cnf
2605844 -rw-r--r--   1 root root  744 Feb  9 19:21 
/etc/mysql/mariadb.cnf
2605074 drwxr-xr-x   2 root root 4096 Mar 14 22:39 
/etc/mysql/conf.d
2605150 -rw-r--r--   1 root root0 Feb  9 14:41 
/etc/mysql/conf.d/.keepme
2608684 -rw-r--r--   1 root root  285 Feb 25 15:41 
/etc/mysql/conf.d/tokudb.cnf
2610694 -rwxr-xr-x   1 root root 1312 Feb  8 12:32 
/etc/mysql/debian-start
2605184 drwxr-xr-x   2 root root 4096 Mar 14 22:39 
/etc/mysql/mariadb.conf.d
2605194 -rw-r--r--   1 root root  306 Feb  8 12:32 
/etc/mysql/mariadb.conf.d/mysqld_safe.cnf
2605214 -rw-r--r--   1 root root 2715 Feb  8 12:32 
/etc/mysql/mariadb.conf.d/mysqld.cnf
2605334 -rw-r--r--   1 root root  111 Feb  8 12:32 
/etc/mysql/mariadb.conf.d/client.cnf
2610734 -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.

___
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Re: [Maria-developers] Passwordless MariaDB root login with auth_socket in Debian continues..

[Jean Weisbuch]

Its something that i did fix on the patch i sent previously, its the 
"INSTALL PLUGIN" statement that cannot be executed while "mysqld" has 
been ran with "--skip-grant-table", it should be replaced by an "INSERT" 
on the "mysql.plugin" table.


The line 192 :
INSTALL PLUGIN unix_socket SONAME 'auth_socket';

Must be replaced with :
INSERT INTO mysql.plugin (name, dl) VALUES ('unix_socket', 
'auth_socket');


Le 14/03/2015 19:48, Otto Kekäläinen a écrit :

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'

I have built packages from the latest commit at my Debian packaging
repo https://github.com/ottok/mariadb-10.0/commits/master
(bac031c9796ebf08c651bc863bda97fcf2cce9c4) so that all of your pull
requests regarding this are included.

The dev repo addess is 'deb http://labs.seravo.fi/~otto/mariadb-repo/
mariadb-10.0-sid-amd64/' in case you forgot (see
https://wiki.debian.org/Teams/MySQL/MariaDB)

$ apt-get purge 'mysql-*' 'mariadb-*'; rm -rf /etc/mysql
/var/lib/mysql; apt-get clean; apt-get update
[..]

$ apt-get install mariadb-server
[..]

Fetched 12.6 MB in 1min 34s (133 kB/s)
Preconfiguring packages ...
Selecting previously unselected package mysql-common.
Preparing to unpack .../mysql-common_5.5.42-1_all.deb ...
Unpacking mysql-common (5.5.42-1) ...
Selecting previously unselected package libmysqlclient18:amd64.
Preparing to unpack .../libmysqlclient18_5.5.42-1_amd64.deb ...
Unpacking libmysqlclient18:amd64 (5.5.42-1) ...
Selecting previously unselected package mariadb-common.
Preparing to unpack .../mariadb-common_10.0.17-1~exp2_all.deb ...
Unpacking mariadb-common (10.0.17-1~exp2) ...
Selecting previously unselected package mariadb-client-core-10.0.
Preparing to unpack .../mariadb-client-core-10.0_10.0.17-1~exp2_amd64.deb ...
Unpacking mariadb-client-core-10.0 (10.0.17-1~exp2) ...
Selecting previously unselected package mariadb-client-10.0.
Preparing to unpack .../mariadb-client-10.0_10.0.17-1~exp2_amd64.deb ...
Unpacking mariadb-client-10.0 (10.0.17-1~exp2) ...
Selecting previously unselected package mariadb-server-core-10.0.
Preparing to unpack .../mariadb-server-core-10.0_10.0.17-1~exp2_amd64.deb ...
Unpacking mariadb-server-core-10.0 (10.0.17-1~exp2) ...
Processing triggers for man-db (2.7.0.2-3) ...
Setting up mysql-common (5.5.42-1) ...
Setting up mariadb-common (10.0.17-1~exp2) ...
Notice: configure-symlinks trigger could not be called.
Please manually make /etc/mysql/my.cnf a symlink that points to mariadb.cnf.
Selecting previously unselected package mariadb-server-10.0.
Preparing to unpack .../mariadb-server-10.0_10.0.17-1~exp2_amd64.deb ...
Unpacking mariadb-server-10.0 (10.0.17-1~exp2) ...
Selecting previously unselected package libdbd-mysql-perl.
Preparing to unpack .../libdbd-mysql-perl_4.028-2+b1_amd64.deb ...
Unpacking libdbd-mysql-perl (4.028-2+b1) ...
Selecting previously unselected package mariadb-server.
Preparing to unpack .../mariadb-server_10.0.17-1~exp2_all.deb ...
Unpacking mariadb-server (10.0.17-1~exp2) ...
Processing triggers for man-db (2.7.0.2-3) ...
Setting up libmysqlclient18:amd64 (5.5.42-1) ...
Setting up mariadb-client-core-10.0 (10.0.17-1~exp2) ...
Setting up mariadb-client-10.0 (10.0.17-1~exp2) ...
Setting up mariadb-server-core-10.0 (10.0.17-1~exp2) ...
Setting up mariadb-server-10.0 (10.0.17-1~exp2) ...
+ . /usr/share/debconf/confmodule
++ '[' '!' '' ']'
++ PERL_DL_NONLAZY=1
++ export PERL_DL_NONLAZY
++ '[' '' ']'
++ exec /usr/share/debconf/frontend
/var/lib/dpkg/info/mariadb-server-10.0.postinst configure ''
+ . /usr/share/debconf/confmodule
++ '[' '!' 1 ']'
++ '[' -z '' ']'
++ exec
++ '[' '' ']'
++ exec
++ DEBCONF_REDIR=1
++ export DEBCONF_REDIR
+ '[' -n '' ']'
+ export 
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/sbin:/usr/sbin:/bin:/usr/bin
+ 
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/sbin:/usr/sbin:/bin:/usr/bin
+ ERR_LOGGER='logger -p daemon.err -t mysqld_safe -i'
+ set -o pipefail
+ MYSQL_BOOTSTRAP='/usr/sbin/mysqld --bootstrap --user=mysql
--disable-log-bin --skip-grant-tables --default-storage-engine=myisam
--plugin-load-add=auth_socket'
+ set +e
+ invoke stop
+ '[' -x /usr/sbin/invoke-rc.d ']'
+ invoke-rc.d mysql stop
Stopping MariaDB database server: mysqld.
+ set -e
+ case "$1" in
+ mysql_statedir=/usr/share/mysql
+ mysql_datadir=/var/lib/mysql
+ mysql_logdir=/var/log/mysql
+ mysql_rundir=/var/run/mysqld
+ mysql_cfgdir=/etc/mysql
+ mysql_upgradedir=/var/lib/mysql-upgrade
+ '[' '!' -d /usr/share/mysql -a '!' -L /usr/share/mysql ']'
+ '[' '!' -d /var/lib/mysql -a '!' -L /var/lib/mysql ']'
+ '[' '!' -d /var/log/mysql -a '!' -L /var/log/mysql ']'
+ set +e
+ chown -R 0:0 /usr/share/m

[Maria-developers] Passwordless MariaDB root login with auth_socket in Debian continues..

[Otto Kekäläinen]

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'

I have built packages from the latest commit at my Debian packaging
repo https://github.com/ottok/mariadb-10.0/commits/master
(bac031c9796ebf08c651bc863bda97fcf2cce9c4) so that all of your pull
requests regarding this are included.

The dev repo addess is 'deb http://labs.seravo.fi/~otto/mariadb-repo/
mariadb-10.0-sid-amd64/' in case you forgot (see
https://wiki.debian.org/Teams/MySQL/MariaDB)

$ apt-get purge 'mysql-*' 'mariadb-*'; rm -rf /etc/mysql
/var/lib/mysql; apt-get clean; apt-get update
[..]

$ apt-get install mariadb-server
[..]

Fetched 12.6 MB in 1min 34s (133 kB/s)
Preconfiguring packages ...
Selecting previously unselected package mysql-common.
Preparing to unpack .../mysql-common_5.5.42-1_all.deb ...
Unpacking mysql-common (5.5.42-1) ...
Selecting previously unselected package libmysqlclient18:amd64.
Preparing to unpack .../libmysqlclient18_5.5.42-1_amd64.deb ...
Unpacking libmysqlclient18:amd64 (5.5.42-1) ...
Selecting previously unselected package mariadb-common.
Preparing to unpack .../mariadb-common_10.0.17-1~exp2_all.deb ...
Unpacking mariadb-common (10.0.17-1~exp2) ...
Selecting previously unselected package mariadb-client-core-10.0.
Preparing to unpack .../mariadb-client-core-10.0_10.0.17-1~exp2_amd64.deb ...
Unpacking mariadb-client-core-10.0 (10.0.17-1~exp2) ...
Selecting previously unselected package mariadb-client-10.0.
Preparing to unpack .../mariadb-client-10.0_10.0.17-1~exp2_amd64.deb ...
Unpacking mariadb-client-10.0 (10.0.17-1~exp2) ...
Selecting previously unselected package mariadb-server-core-10.0.
Preparing to unpack .../mariadb-server-core-10.0_10.0.17-1~exp2_amd64.deb ...
Unpacking mariadb-server-core-10.0 (10.0.17-1~exp2) ...
Processing triggers for man-db (2.7.0.2-3) ...
Setting up mysql-common (5.5.42-1) ...
Setting up mariadb-common (10.0.17-1~exp2) ...
Notice: configure-symlinks trigger could not be called.
Please manually make /etc/mysql/my.cnf a symlink that points to mariadb.cnf.
Selecting previously unselected package mariadb-server-10.0.
Preparing to unpack .../mariadb-server-10.0_10.0.17-1~exp2_amd64.deb ...
Unpacking mariadb-server-10.0 (10.0.17-1~exp2) ...
Selecting previously unselected package libdbd-mysql-perl.
Preparing to unpack .../libdbd-mysql-perl_4.028-2+b1_amd64.deb ...
Unpacking libdbd-mysql-perl (4.028-2+b1) ...
Selecting previously unselected package mariadb-server.
Preparing to unpack .../mariadb-server_10.0.17-1~exp2_all.deb ...
Unpacking mariadb-server (10.0.17-1~exp2) ...
Processing triggers for man-db (2.7.0.2-3) ...
Setting up libmysqlclient18:amd64 (5.5.42-1) ...
Setting up mariadb-client-core-10.0 (10.0.17-1~exp2) ...
Setting up mariadb-client-10.0 (10.0.17-1~exp2) ...
Setting up mariadb-server-core-10.0 (10.0.17-1~exp2) ...
Setting up mariadb-server-10.0 (10.0.17-1~exp2) ...
+ . /usr/share/debconf/confmodule
++ '[' '!' '' ']'
++ PERL_DL_NONLAZY=1
++ export PERL_DL_NONLAZY
++ '[' '' ']'
++ exec /usr/share/debconf/frontend
/var/lib/dpkg/info/mariadb-server-10.0.postinst configure ''
+ . /usr/share/debconf/confmodule
++ '[' '!' 1 ']'
++ '[' -z '' ']'
++ exec
++ '[' '' ']'
++ exec
++ DEBCONF_REDIR=1
++ export DEBCONF_REDIR
+ '[' -n '' ']'
+ export 
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/sbin:/usr/sbin:/bin:/usr/bin
+ 
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/sbin:/usr/sbin:/bin:/usr/bin
+ ERR_LOGGER='logger -p daemon.err -t mysqld_safe -i'
+ set -o pipefail
+ MYSQL_BOOTSTRAP='/usr/sbin/mysqld --bootstrap --user=mysql
--disable-log-bin --skip-grant-tables --default-storage-engine=myisam
--plugin-load-add=auth_socket'
+ set +e
+ invoke stop
+ '[' -x /usr/sbin/invoke-rc.d ']'
+ invoke-rc.d mysql stop
Stopping MariaDB database server: mysqld.
+ set -e
+ case "$1" in
+ mysql_statedir=/usr/share/mysql
+ mysql_datadir=/var/lib/mysql
+ mysql_logdir=/var/log/mysql
+ mysql_rundir=/var/run/mysqld
+ mysql_cfgdir=/etc/mysql
+ mysql_upgradedir=/var/lib/mysql-upgrade
+ '[' '!' -d /usr/share/mysql -a '!' -L /usr/share/mysql ']'
+ '[' '!' -d /var/lib/mysql -a '!' -L /var/lib/mysql ']'
+ '[' '!' -d /var/log/mysql -a '!' -L /var/log/mysql ']'
+ set +e
+ chown -R 0:0 /usr/share/mysql
+ chown -R mysql /var/lib/mysql
+ chown -R mysql:adm /var/log/mysql
+ chmod 2750 /var/log/mysql
+ set -e
+ db_set mariadb-server/postrm_remove_database false
+ _db_cmd 'SET mariadb-server/postrm_remove_database' false
+ _db_internal_IFS='
'
+ IFS=' '
+ printf '%s\n' 'SET mariadb-server/postrm_remove_database false'
+ IFS='
'
+ IFS='
'
+ read -r _db_internal_line
+ RET='10 mariadb-server/postrm_remove_database doesn'\''t exist'
+ case ${_db_internal_line%%[ ]*} in
+ re