[debian-mysql] dbconfig autopkgtests fail: Plugin caching_sha2_password could not be loaded: /usr/lib/aarch64-linux-gnu/mariadb19/plugin/caching_sha2_password.so

[Otto Kekäläinen]

Hello!

Thanks for debugging this. So indeed it is triggered by the MySQL 8.0
server now requiring that in the wire protocol, and it failed because
libmariadb3 as packaging in Debian unstable did not ship that plugin.
It exists, and I can start including it.

Likely fix: https://salsa.debian.org/mariadb-team/mariadb-10.3/-/commit/fdcf61986ba7f8b8a6ced739f237ee172444fcfa

Paul: Not directly related to this, but please note that there also
exists libdbd-mariadb-perl and it can be used like this:

$ apt install libdbd-mariadb-perl
$ cat test.pl
#!/usr/bin/perl
use DBI;
my $dbh = DBI->connect("DBI:MariaDB:database=testdatabase;host=localhost",
"testuser", "testpassword");

libdbd-mariadb-perl is maintained in Debian by Xavier Guimard. I am
not sure how exactly it differs from MySQL, but if you have Perl
stuff, you might want to consider switching to it.