Package: mariadb-server-10.3 Version: 1:10.3.13-2 Followup-For: Bug #926231
I'm not sure what the "MariaDB error log" is but I have found the following entries in syslog: Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: Installation of system tables failed! Examine the logs in Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: /var/lib/mysql for more information. Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: The problem could be conflicting information in an external Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: my.cnf files. You can ignore these by doing: Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: shell> /usr/bin/mysql_install_db --defaults-file=~/.my.cnf Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: You can also try to start the mysqld daemon with: Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: shell> /usr/sbin/mysqld --skip-grant-tables --general-log & Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: and use the command line tool /usr/bin/mysql Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: to connect to the mysql database and look at the grant tables: Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: shell> /usr/bin/mysql -u root mysql Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: mysql> show tables; Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: Try 'mysqld --help' if you have problems with paths. Using Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: --general-log gives you a log in /var/lib/mysql that may be helpful. Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: The latest information about mysql_install_db is available at Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: https://mariadb.com/kb/en/installing-system-tables-mysql_install_db Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: You can find the latest source at https://downloads.mariadb.org and Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: the maria-discuss email list at https://launchpad.net/~maria-discuss Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: Please check all of the above before submitting a bug report Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: at http://mariadb.org/jira Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8418]: Apr 3 20:31:00 novatech mariadb-server-10.3.postinst[8489]: 2019-04-03 20:31:00 0 [Note] /usr/sbin/mysqld (mysqld 10.3.13-MariaDB-2) starting as p Reading those entries, I tried the following: 1) Looked for logs in /var/lib/mysql. I couldn't find anything that looked like an error log. 2) I tried starting the mysqld daemon but it exited after a couple of seconds. It did write a log file in /var/lib/mysql containing: /usr/sbin/mysqld, Version: 10.3.13-MariaDB-2-log (Debian buildd-unstable). started with: Tcp port: 0 Unix socket: /run/mysqld/mysqld.sock Time Id Command Argument 3) I searched for my.cnf files and found only: /etc/mysql/my.cnf.fallback /etc/mysql/my.cnf /etc/alternatives/my.cnf (softlink to /etc/mysql/mariadb.cnf) 4) I notice that /etc/alternatives/my.cnf imports files from /etc/mysql/conf.d/ and /etc/mysql/mariadb.conf.d/ Those directories contain... /etc/mysql/conf.d/ mysql.cnf mysqld_safe_syslog.cnf mysqldump.cnf /etc/mysql/mariadb.conf.d/ 50-client.cnf 50-mysql-clients.cnf 50-mysqld_safe.cnf 50-server.cnf -- System Information: Debian Release: buster/sid APT prefers testing APT policy: (900, 'testing') Architecture: amd64 (x86_64) Foreign Architectures: i386 Kernel: Linux 4.19.0-2-amd64 (SMP w/8 CPU cores) Locale: LANG=en_IE.utf8, LC_CTYPE=en_IE.utf8 (charmap=UTF-8) (ignored: LC_ALL set to en_IE.utf8), LANGUAGE=en_GB (charmap=UTF-8) (ignored: LC_ALL set to en_IE.utf8) Shell: /bin/sh linked to /bin/bash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages mariadb-server-10.3 depends on: ii adduser 3.118 ii debconf [debconf-2.0] 1.5.71 ii galera-3 25.3.25-1 ii gawk 1:4.2.1+dfsg-1 ii iproute2 4.20.0-2 ii libc6 2.28-8 ii libdbi-perl 1.642-1+b1 ii libgnutls30 3.6.6-2 ii libpam0g 1.3.1-5 ii libstdc++6 8.3.0-4 ii lsb-base 10.2019031300 ii lsof 4.91+dfsg-1 ii mariadb-client-10.3 1:10.3.13-2 ii mariadb-common 1:10.3.13-2 ii mariadb-server-core-10.3 1:10.3.13-2 ii passwd 1:4.5-1.1 ii perl 5.28.1-5 ii psmisc 23.2-1 ii rsync 3.1.3-6 ii socat 1.7.3.2-2 ii zlib1g 1:1.2.11.dfsg-1 Versions of packages mariadb-server-10.3 recommends: ii libhtml-template-perl 2.97-1 Versions of packages mariadb-server-10.3 suggests: ii bsd-mailx [mailx] 8.1.2-0.20180807cvs-1 ii mailutils [mailx] 1:3.5-3 ii mailx 1:20081101-2 pn mariadb-test <none> ii netcat-openbsd 1.195-2 ii tinyca 0.7.5-6 -- debconf information: mariadb-server-10.3/postrm_remove_databases: false mariadb-server-10.3/nis_warning: mariadb-server-10.3/old_data_directory_saved:
