Package: mariadb-client-10.1 Version: 10.1.26-0+deb9u1 Severity: normal Tags: upstream
Dear Maintainer, according to MariaDB official recomendations on the following link https://mariadb.com/kb/en/library/setting-character-sets-and-collations/ the default contents of the mariadb.conf.d/50-client.cnf configuration file shipped with this package contain the following [client] section [client] # Default is Latin1, if you need UTF-8 set this (also in server section) default-character-set = utf8mb4 Adding the `default-character-set` option to the [client] section of the config file causes the mysqlbinlog utility shipped with the mariadb-server-10.1 to fail to start with the following message: # mysqlbinlog mysqlbinlog: unknown variable 'default-character-set=utf8mb4' In a similar bug report to MySQL centuries ago (https://bugs.mysql.com/bug.php?id=11673) and it was suggested that the best fix is to prefix the option with `loose-`. This prefix is documented on MariaDB official documentation here https://mariadb.com/kb/en/library/configuring-mariadb-with-mycnf/ and seems to be honored correctly. ex. # mysqlbinlog Warning: mysqlbinlog: unknown variable 'loose-default-character-set=utf8mb4' mysqlbinlog Ver 3.3 for debian-linux-gnu at x86_64 ... Regards Stef -- System Information: Debian Release: buster/sid APT prefers testing APT policy: (900, 'testing'), (500, 'testing-debug') Architecture: amd64 (x86_64) Foreign Architectures: i386 Kernel: Linux 4.9.0-3-amd64 (SMP w/4 CPU cores) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US:en (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) Versions of packages mariadb-client-10.1 depends on: ii debianutils 4.8.2 ii libaio1 0.3.110-4 ii libc6 2.24-17 ii libjemalloc1 3.6.0-11 ii libpcre3 2:8.39-4 ii libstdc++6 7.2.0-8 ii libsystemd0 234-3 pn mariadb-client-core-10.1 <none> ii perl 5.26.0-8 ii zlib1g 1:1.2.8.dfsg-5 Versions of packages mariadb-client-10.1 recommends: ii libdbd-mysql-perl 4.041-2+b1 ii libdbi-perl 1.637-1 ii libterm-readkey-perl 2.37-1+b2 mariadb-client-10.1 suggests no packages.