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@seravo.fi> wrote:
2015-04-06 13:32 GMT+03:00 Otto Kekäläinen <otto@seravo.fi>:
2015-04-06 13:12 GMT+03:00 Daniel Cialdella Converti < dcialdella@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 **´¯).**´¯) ---------------------------------------------------------------------------------------