[MDEV-19807] MariaDB client plugin path is wrong Created: 2019-06-19  Updated: 2019-09-24  Resolved: 2019-06-20

Status: Closed
Project: MariaDB Server
Component/s: Plugins
Affects Version/s: 10.4.6
Fix Version/s: 10.2.26, 10.3.17, 10.4.7

Type: Bug Priority: Critical
Reporter: Anders Karlsson Assignee: Georg Richter
Resolution: Fixed Votes: 0
Labels: None
Environment:

Linux Centos 7.6


Issue Links:
Problem/Incident
is caused by CONC-383 Plugin auth_gssapi_client could not ... Closed
Relates
relates to CONC-376 missing prefix for searching mysql_cl... Open
relates to MDEV-19876 pam v2: auth_pam_tool_dir and auth_pa... Closed
relates to MDEV-20569 Plugin dialog could not be loaded (wr... Closed

 Description   

When connecting using ed25519, the client has the default plugin path wrong. If using a specific plugin path, in the config file or on the command line, it works, even if this is set in to the same value as the default.
Extract from /etc/my.cnf.d/server.cnf

[mysqld]
plugin_load_add = auth_ed25519

Create and grant access to a user:

create user root2@'192.168.142.210' IDENTIFIED VIA ed25519 USING PASSWORD('root2');
grant all on *.* to  root2@'192.168.142.210';

Connect to MariaDB using ed25519 authentification:

$ mysql -u root2 -proot2 -h 192.168.142.210
ERROR 1045 (28000): Plugin client_ed25519 could not be loaded: /usr//usr/lib64/mysql/plugin/client_ed25519.so: cannot open shared object file: No such file or directory

Note the path to the plugin, there is an extra leading "/usr" there. Setting the path to the correct one works fine:

$ mysql -u root2 -proot2 -h 192.168.142.210 --plugin-dir=/usr/lib64/mysql/plugin
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 21
Server version: 10.4.6-MariaDB MariaDB Server
 
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
MariaDB [(none)]>

The above also work when setting the correct path in /etc/my.cnf.c/client.cnf or some other appropriate config file.



 Comments   
Comment by Geoff Montee (Inactive) [ 2019-06-19 ]

Maybe this was caused by the fix for CONC-383?

Comment by Georg Richter [ 2019-06-20 ]

Fixed in C/C 3.1.3
rev. 690f74a16f89e7176021231b595a179f6a2e93c4

Comment by Manuel Schulze [ 2019-09-24 ]

I'm seeing the same bug with 10.4.8 but with /usr/lib/mysql/plugin:

ERROR 1156 (08S01): Plugin client_ed25519 could not be loaded: /usr//usr/lib/mysql/plugin/client_ed25519.so: cannot open shared object file: No such file or directory

running mysql --plugin-dir=/usr/lib/mysql/plugin works

Generated at Thu Feb 08 08:54:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.