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

2015-04-06 Thread 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 o...@seravo.fi wrote:

 2015-04-06 13:32 GMT+03:00 Otto Kekäläinen o...@seravo.fi:
  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..

2015-04-06 Thread Otto Kekäläinen 
2015-04-06 13:32 GMT+03:00 Otto Kekäläinen o...@seravo.fi:
 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?

___
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..

2015-04-06 Thread 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..

2015-04-06 Thread Otto Kekäläinen 
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)?

___
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..

2015-04-06 Thread 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 o...@seravo.fi wrote:

 2015-03-29 21:59 GMT+03:00 Otto Kekäläinen o...@seravo.fi:
  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..

2015-04-06 Thread 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 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)?


___
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..

2015-04-06 Thread 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 daniel.bl...@openquery.com
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..

2015-04-06 Thread 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 o...@seravo.fi 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**´¯).**´¯)
---
___
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..

2015-04-03 Thread Otto Kekäläinen 
2015-03-29 21:59 GMT+03:00 Otto Kekäläinen o...@seravo.fi:
 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..

2015-03-29 Thread Otto Kekäläinen 
2015-03-14 20:48 GMT+02:00 Otto Kekäläinen o...@seravo.fi:
 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..

2015-03-24 Thread 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 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.





 --

 ---
 (¯`**.(¯`**. 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..

2015-03-14 Thread 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..

2015-03-14 Thread 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