[MDEV-19942] Default installation of mariadb-server doesn't allow clients to use client plugins - Jira

Some deb-based systems, e.g. Stretch, have a pre-installed libmariadbclient18 of Debian's packaging:

ii  libmariadbclient18:amd64      10.1.23-9+deb9u1               amd64        MariaDB database client library

It installs plugins into a very special folder:

$ ls -l /usr/lib/x86_64-linux-gnu/mariadb18/plugin/

total 108

-rw-r--r-- 1 root root 86048 Jun  7  2017 client_ed25519.so

-rw-r--r-- 1 root root 10200 Jun  7  2017 dialog.so

-rw-r--r-- 1 root root  6104 Jun  7  2017 mysql_clear_password.so

When mariadb-server of version 10.2+ is installed, it does not enforce upgrade of libmariadbclient18:

ii  libmariadbclient18:amd64      10.1.23-9+deb9u1               amd64        MariaDB database client library

ii  mariadb-client-10.2           10.2.25+maria~stretch          amd64        MariaDB database client binaries

ii  mariadb-client-core-10.2      10.2.25+maria~stretch          amd64        MariaDB database core client binaries

ii  mariadb-common                10.2.25+maria~stretch          all          MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)

ii  mariadb-server                10.2.25+maria~stretch          all          MariaDB database server (metapackage depending on the latest version)

ii  mariadb-server-10.2           10.2.25+maria~stretch          amd64        MariaDB database server binaries

ii  mariadb-server-core-10.2      10.2.25+maria~stretch          amd64        MariaDB database core server files

So, the client plugins remain in the folder which MariaDB clients have nothing about, which later causes problems like

ERROR 1045 (28000): Plugin dialog could not be loaded: /usr/lib/mysql/plugin//dialog.so: cannot open shared object file: No such file or directory

relates to

MDEV-20569 Plugin dialog could not be loaded (wrong path)

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server