Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.13, 10.2.14
-
None
-
Debian 9.4 install from MariaDB repository
Description
FOUND : the problem come from --defaults-file with : (look it's not loaded in particular order or combined with an other option).
First I tried to upgrade my galera cluster from 10.2.12 to 10.2.13, i stopped one node to upgrade and put back, but the node fail to IST and then fail to SST. (I pushed a bug about this : https://jira.mariadb.org/browse/MDEV-15453?filter=-2)
Then when we tried to deploy a new cluster :
At begining we asked ourself why the upgrade of password failed with SALT (https://docs.saltstack.com/en/latest/ref/states/all/salt.states.mysql_user.html). in fact I think this trouble and the sst is exactly the same the cannot connect to mysql (particular sign, you can see : ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
(or whatever you put in /root/.my.cnf)
It's mean that all stuff witch use salt are falling also. I don't know where it is in the code but i know it's linked with : "libmariadbclient18" and special options of client to connect to MySQL/MariaDB
Work :
ii libmariadbclient18:amd64 10.1.26-0+deb9u1 amd64 MariaDB database client library |
(i don't know why Debian installed this version for mariadb 10.2.13)
Not Work :
(with apt-get upgrade)
ii libmariadbclient18 10.2.13+maria~stretch amd64 Virtual package to satisfy external depends |
Full listing :
Work :
dpkg -l | grep -E "mysql|maria" |
ii libdbd-mysql-perl 4.041-2 amd64 Perl5 database interface to the MariaDB/MySQL database |
ii libmariadbclient18:amd64 10.1.26-0+deb9u1 amd64 MariaDB database client library |
ii mariadb-backup-10.2 10.2.13+maria~stretch amd64 Backup tool for MariaDB server |
ii mariadb-client-10.2 10.2.13+maria~stretch amd64 MariaDB database client binaries |
ii mariadb-client-core-10.2 10.2.13+maria~stretch amd64 MariaDB database core client binaries |
ii mariadb-common 10.2.13+maria~stretch all MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf) |
ii mariadb-server-10.2 10.2.13+maria~stretch amd64 MariaDB database server binaries |
ii mariadb-server-core-10.2 10.2.13+maria~stretch amd64 MariaDB database core server files |
ii mysql-common 10.2.13+maria~stretch all MariaDB database common files (e.g. /etc/mysql/my.cnf) |
ii python-mysqldb 1.3.7-1.1 amd64 Python interface to MySQL |
not work :
ii libdbd-mysql-perl 4.041-2 amd64 Perl5 database interface to the MariaDB/MySQL database |
ii libmariadb3 10.2.13+maria~stretch amd64 MariaDB database client library |
ii libmariadbclient18 10.2.13+maria~stretch amd64 Virtual package to satisfy external depends |
ii mariadb-backup-10.2 10.2.13+maria~stretch amd64 Backup tool for MariaDB server |
ii mariadb-client-10.2 10.2.13+maria~stretch amd64 MariaDB database client binaries |
ii mariadb-client-core-10.2 10.2.13+maria~stretch amd64 MariaDB database core client binaries |
ii mariadb-common 10.2.13+maria~stretch all MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf) |
ii mariadb-server-10.2 10.2.13+maria~stretch amd64 MariaDB database server binaries |
ii mariadb-server-core-10.2 10.2.13+maria~stretch amd64 MariaDB database core server files |
ii mysql-common 10.2.13+maria~stretch all MariaDB database common files (e.g. /etc/mysql/my.cnf) |
ii python-mysqldb 1.3.7-1.1 amd64 Python interface to MySQL |