[debian-mysql] Bug#879099: mariadb-client-10.1: mysqlbinlog: unknown variable 'default-character-set=utf8mb4'

[Stefanos Boglou]

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.