PAM auth fails in client without server package

[Alex davies]

If using PAM authentication on a server, and using a client with just the Percona client installed authentication fails:

[root@client sources.list.d]# mysql -u adavies -p -h servername
Enter password:
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

Sure enough, this file is only included with the Server rather than client:

[root@server ~]# dpkg -S /usr/lib/mysql/plugin/dialog.so
percona-server-server-5.5: /usr/lib/mysql/plugin/dialog.so

This isnt an error on the server as when clients with the server package installed connect they work, and strace shows the client attempting to read that file:

[root@client sources.list.d]# strace mysql -u adavies -h server -pxx 2>&1 | grep -i --color dialog
read(3, "\23\0\0\2\376dialog\0\4Password: ", 16384) = 23
open("/usr/lib/mysql/plugin/dialog.so", O_RDONLY) = -1 ENOENT (No such file or directory)
write(2, ": Authentication plugin 'dialog'"..., 142: Authentication plugin 'dialog' cannot be loaded: /usr/lib/mysql/plugin/dialog.so: cannot open shared object file: No such file or directory

This is using the Ubuntu 10.04 packages from the Percona repo.

This appears to be a packaging bug: it seems to me that the plugin dialog.so should be included with the client package (or the common package).

[Valerii Kravchuk (valerii-kravchuk)]

Same applies to RPMs from Percona. On CentOS 6.4 dialog.so is included into Percona-Server-server-55, but not to Percona-Server-client-55 or Percona-Server-shared-55 (I've checked with 5.5.31-rel30.3.520).

[Valerii Kravchuk (valerii-kravchuk)]

Same with 5.6.11 on Debian 7:

openxs@debian7:~$ dpkg -S /usr/lib/mysql/plugin/dialog.so
percona-server-server-5.6: /usr/lib/mysql/plugin/dialog.so

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-679

[Paul White (paulw2u)]

Belatedly invalidating superfluous Ubuntu task.