DBI supporting ed25519 ?

Andy16 has asked for the wisdom of the Perl Monks concerning the following question:

Hi out there

I need to connect to a MariaDB using ed25519

I fail in "Authentication plugin 'client_ed25519' cannot be loaded: Incompatible client plugin interface" using DBI and connecting to "DBI:MariaDB:database=..."

Anyone succeeded in that? Is it possible? What do I miss?

installed are:
DBI
DBD::mysql
DBD::MariaDB
(among others)

thanks so much!

Comment on DBI supporting ed25519 ?

Replies are listed 'Best First'.
Re: DBI supporting ed25519 ? by Corion (Patriarch) on Jan 28, 2025 at 14:24 UTC
The authentication itself is delegated by DBI to DBD::MariaDB, which (I guess) in turn delegates that to the MariaDB database drivers. Two issues I find on the interwebs suggest that the MariaDB client packages do not necessarily include the appropriate client authentication plugin library ( Askubuntu, Github ). So maybe explicitly installing the mariadb client (instead of only `DBD::MariaDB`) via your OS package manager helps provide the appropriate plugin?	[reply] [d/l]
Re^2: DBI supporting ed25519 ? by Andy16 (Acolyte) on Jan 28, 2025 at 16:59 UTC
we do have installed (RHEL): mariadb-connector-c.x86_64 mariadb-connector-c-config.noarch what would be your recommendation? mariadb-connector-c.x86_64 mariadb-connector-c-config.noarch holland-mariabackup.noarch mariadb.x86_64 mariadb-backup.x86_64 mariadb-common.x86_64 mariadb-connector-c.i686 mariadb-connector-c-devel.i686 mariadb-connector-c-devel.x86_64 mariadb-connector-odbc.x86_64 mariadb-devel.x86_64 mariadb-embedded.x86_64 mariadb-embedded-devel.x86_64 mariadb-errmsg.x86_64 mariadb-gssapi-server.x86_64 mariadb-java-client.noarch mariadb-oqgraph-engine.x86_64 mariadb-server.x86_64 mariadb-server-galera.x86_64 mariadb-server-utils.x86_64 mariadb-test.x86_64	[reply]
Re^3: DBI supporting ed25519 ? by Corion (Patriarch) on Jan 28, 2025 at 17:16 UTC
I don't have much experience with RHEL, but based on this Redhat blog entry, where they claim that `dnf mariadb` installs the client, I would go with `mariadb.x86_64`, which seems to be the closest to that.	[reply] [d/l] [select]