[debian-mysql] Bug#800009: mariadb-server-10.0: Assumes root has no password without ensuring this is true

[Matijs van Zuijlen]

Package: mariadb-server-10.0
Version: 10.0.21-3
Severity: normal

I upgraded to mariadb from mysql. My mysql root user had a password, but
mariadb assumes it does not and now I get errors in my log like so, :

    Sep 24 09:22:40 walnut mysqld: Version: '10.0.21-MariaDB-3'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Debian unstable
    Sep 24 09:22:41 walnut mysql[1384]: Starting MariaDB database server: mysqld ..
    Sep 24 09:22:41 walnut /etc/mysql/debian-start[2256]: Upgrading MySQL tables if necessary.
    Sep 24 09:22:41 walnut systemd[1]: Started LSB: Start and stop the mysql database server daemon.
    Sep 24 09:22:41 walnut /etc/mysql/debian-start[2262]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
    Sep 24 09:22:41 walnut /etc/mysql/debian-start[2262]: Looking for 'mysql' as: /usr/bin/mysql
    Sep 24 09:22:41 walnut /etc/mysql/debian-start[2262]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
    Sep 24 09:22:41 walnut /etc/mysql/debian-start[2262]: Version check failed. Got the following error when calling the 'mysql' command line client
    Sep 24 09:22:41 walnut /etc/mysql/debian-start[2262]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
    Sep 24 09:22:41 walnut /etc/mysql/debian-start[2262]: FATAL ERROR: Upgrade failed
    Sep 24 09:22:41 walnut /etc/mysql/debian-start[2324]: Checking for insecure root accounts.
    Sep 24 09:22:41 walnut mysql[1384]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

I could possibly tell these scripts about the password in
/etc/mysql/debian.cnf, but that file has a big warning not to modify it.

Regards,
Matijs

-- System Information:
Debian Release: stretch/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)

Kernel: Linux 4.1.0-2-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_IE.utf8, LC_CTYPE=en_IE.utf8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages mariadb-server-10.0 depends on:
ii  adduser                   3.113+nmu3
ii  debconf [debconf-2.0]     1.5.57
ii  libaio1                   0.3.110-1
ii  libc6                     2.19-22
ii  libdbi-perl               1.633-1
ii  libpam0g                  1.1.8-3.1
ii  libstdc++6                5.2.1-17
ii  lsb-base                  9.20150917
ii  mariadb-client-10.0       10.0.21-3
ii  mariadb-common            10.0.21-3
ii  mariadb-server-core-10.0  10.0.21-3
ii  passwd                    1:4.2-3
ii  perl                      5.20.2-6
ii  psmisc                    22.21-2.1
ii  zlib1g                    1:1.2.8.dfsg-2+b1

Versions of packages mariadb-server-10.0 recommends:
ii  libhtml-template-perl  2.95-2

Versions of packages mariadb-server-10.0 suggests:
ii  bsd-mailx [mailx]       8.1.2-0.20150408cvs-1
ii  heirloom-mailx [mailx]  12.5-5
pn  mariadb-test            <none>
pn  tinyca                  <none>

-- Configuration Files:
/etc/logcheck/ignore.d.paranoid/mariadb-server-10_0 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.paranoid/mariadb-server-10_0'
/etc/logcheck/ignore.d.server/mariadb-server-10_0 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.server/mariadb-server-10_0'
/etc/logcheck/ignore.d.workstation/mariadb-server-10_0 [Errno 13] Permission denied: u'/etc/logcheck/ignore.d.workstation/mariadb-server-10_0'

-- debconf information:
  mariadb-server-10.0/nis_warning:
* mariadb-server/oneway_migration: true
  mariadb-server-10.0/really_downgrade: false
  mariadb-server/error_setting_password:
  mariadb-server-10.0/postrm_remove_databases: false