Web lists-archives.com

mariadb ldap auth




Hi,

I have installed mariadb and configured pam authentication, and configured a mysql pam module like this:

/etc/pam.d/mysql
auth      required       pam_winbind.so
account   required       pam_winbind.so

which basically gives my samba winbind users access to mysql with their windows credentials:

root@mysqlserver:~# mysql -udomain_username -p
Enter password: <windows_domain_password>
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 6
Server version: 10.1.26-MariaDB-0+deb9u1 Debian 9.1

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

So I was happy.

But this seems to work only from the localhost mariadb is running on. Trying this from a remote mysql client gives:

user@e7470 ~ $ mysql -udomain_user -p -h mysqlserver.full.address
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

and searching for /usr/lib/mysql/plugin/dialog.so gives no results:

user@e7470 ~ $ dpkg --search /usr/lib/mysql/plugin/dialog.so
dpkg-query: no path found matching pattern /usr/lib/mysql/plugin/dialog.so
user@e7470 ~ $

Anyone here with a good suggestion how to achieve this from a remote mysql client?

MJ