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

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

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

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

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 connec

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). Addin

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

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.

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 su

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 wrote: > 2015-03-29 21:59 GMT+03:00 Otto Kekäläinen : > >

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

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 : > 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 (whic

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

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

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

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

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

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

2015-03-15 Thread 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 th

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

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

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

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

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

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