PS Client istallation is missing /usr/lib/mysql/plugin/dialog.so
General
Escalation
General
Escalation
Description
Install PS Server 8.x on maschine 1 and PS Client on maschine 2
create user user1@'%' identified with auth_pam;
maschine1 : mysql -u user1 -p → works
maschine2 : mysql - u user1 -h maschine1 -p → does not work
ERROR 2059 (HY000): Authentication plugin 'dialog' cannot be loaded: /usr/lib/mysql/plugin/dialog.so: cannot open shared object file: No such file or directory
on ubuntu I used apt-file to see where dialog.so comes from:
Please add this to the PS client package. Or change the documentation to “auth_pam is only usable on PS Server locallly” not remote. (I tested it be copying the dialog.so to the remote machine, which worked, so option 2 is not the valid one)
Medium
Install PS Server 8.x on maschine 1 and PS Client on maschine 2
create user user1@'%' identified with auth_pam;
maschine1 : mysql -u user1 -p → works
maschine2 : mysql - u user1 -h maschine1 -p → does not work
ERROR 2059 (HY000): Authentication plugin 'dialog' cannot be loaded: /usr/lib/mysql/plugin/dialog.so: cannot open shared object file: No such file or directory
on ubuntu I used apt-file to see where dialog.so comes from:
percona-server-server: /usr/lib/mysql/plugin/debug/dialog.so
percona-server-server: /usr/lib/mysql/plugin/dialog.so
so either I install the server packeage on all my clients
or I manually copy the dialog.so from a server to each client.
And it seems this is fairly old: https://perconadev.atlassian.net/browse/PS-3407 2016?2019? was closed “because no one ist working on it”
Please add this to the PS client package.
Or change the documentation to “auth_pam is only usable on PS Server locallly” not remote.
(I tested it be copying the dialog.so to the remote machine, which worked, so option 2 is not the valid one)