Re: mariadb ldap auth

[Selim T. Erdoğan <selim@alumni.cs.utexas.edu>]

On Thu, Sep 06, 2018 at 12:20:22PM +0200, mj wrote:
> 
> 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?

I tried apt-file (on Debian 9.5 Stretch):

$ apt-file search dialog.so
...
libmariadb2: /usr/lib/x86_64-linux-gnu/mariadb/plugin/dialog.so
libmariadbclient18: /usr/lib/x86_64-linux-gnu/mariadb18/plugin/dialog.so
...

(No mysql in that list.)

If you don't have those two packages installed on your remote client, 
try to install them.  (You probably only need the client one, but I 
don't really know.)

If they're already installed, you should try to figure out why your 
system is trying to find the mysql version of the plugin, but as a 
temporary solution, you can try to create a symlink from 
/usr/lib/mysql/plugin/dialog.so to one of those files and see if it works.