Freeradius can't connect to MySQL 8.0 from Debian Buster

[Mark Antony]

Great news. I managed to overcome this by installing the latest MariaDB:

apt install apt-transport-https
wget https://downloads.mariadb.com/MariaDB/mariadb_repo_setup
chmod +x mariadb_repo_setup
./mariadb_repo_setup --mariadb-server-version="mariadb-10.5"
apt update
apt install mariadb-server
apt install mariadb-client

They both can be purged afterwards. The file is now available at /usr/lib/x86_64-linux-gnu/libmariadb3/plugin/caching_sha2_password.so


Thanks,




‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Sunday, 14 March 2021 09:53, Mark Antony via Freeradius-Users <freeradius-users at lists.freeradius.org> wrote:

> Thank you, Bjorn. Yes, this is it.
>
> I'm already using the latest Debian 10.8, but the patch still isn't released.
>
> That's really a bummer. So for now I have to compile MariaDB manually and place that file in the path then?
>
> Mark
>
> ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
> On Sunday, 14 March 2021 09:24, Bjørn Mork bjorn at mork.no wrote:
>
> > Mark Antony via Freeradius-Users freeradius-users at lists.freeradius.org
> > writes:
> >
> > > rlm_sql_mysql: MySQL error: Plugin caching_sha2_password could not be loaded: /usr/lib/x86_64-linux-gnu/mariadb19/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
> >
> > I believe this is a Debian bug. It's fixed in sid, but apparently not
> > in stable: https://bugs.debian.org/962597
> > Bjørn
>
> --
>
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html