Docker: use current version of DBD::mysql for OTOBO 11.0.x

[bschmalhofer]

Currently DBD::mysql 5.001 can't be installed on Debian that has default-mysql-client installed. The Debian package default-mysql-client is actually a MariaDB client that is compatible with the Mysql 5.7 client. DBD::mysql no longer supports MySQL 5.7 and therefore no longer supports the MariaDB clients. Therefore DBD::mysql 5.001 has been blacklisted in _bin/otobo.CheckModules.pl as this the minimal change. See #2548.

For non-Docker installations using the distribution packages is recommended. Currently no distribution ships DBD::mysql 5.001. So blacklisting that version should be fine.

There has been some discussion over at perl5-dbi/DBD-mysql#361 . @dveeden points out the MySQL and MariaDB are now different databases and suggests:

"Use Debian SID with libmysqlclient-dev (see https://packages.debian.org/sid/libmysqlclient-dev )

Let's try that for rel-11_0.

[dveeden]

To clarify: DBD::mysql v5.x doesn't support building against MySQL 5.7 libraries anymore. However with DBD::mysql built with MySQL 8.x client libraries can connect to MySQL 5.7 servers.

[bschmalhofer]

Thanks @dveeden,

for OTOBO 11 I think I'll go for installing the MySQL 8 client library from Oracle MySQL. Judging from https://bugs.mysql.com/bug.php?id=111398 , it looks like I still have to wait a couple of days for the October release from Oracle MySQL. But that is fine for me.

[dveeden]

@bschmalhofer https://bugs.mysql.com/bug.php?id=111398 has been fixed.

[bschmalhofer]

After some deliberation we decided to not add a dependency on another repository. So OTOBO continues to use the 4.x versions of DBD::mysql. This might change when Debian offers a package for MySQL 8 clients again.

One idea was to install the libdbd-mysql-perl package. But that does not fly because we don't use the system perl in the Docker image.

Just in case there will be a reason to really install the MySQL 8 client, here is how Oracle does it: https://github.com/docker-library/mysql/blob/f4030aebf6a63d640f7085fb3e4601b4e70313c8/8.0/Dockerfile.debian

[bschmalhofer]

A run of the test suite looked fine. Closing this issue.