1

Question: How can I tell MySQL Workbench from where it should load plugins for a connection?

I'm trying to connect my MySQL Workbench on Windows to a MariaDB where the user is connected to an IPA with PAM.

When I try to open the connection, I'm receiving following error message: ERROR 2059 (HY000): Authentication plugin 'dialog' cannot be loaded.

When I save this dialog.dll from MariaDB in a folder and call mysql.exe with the option --plugin-dir "C:\MySQL\Workbench\modules" I can successfully open a connection.

The dll-File cannot be loaded with "Scripting" -> "Install Plugin/Module".

Lesrac
  • 65
  • 2
  • 14

1 Answers1

1

With the help of "Procmon.exe" (process of MySQL Workbench) I found out, that the dialog.dll is looked for in the following path: C:\Program Files\MySQL\MySQL Server 5.7\lib\plugin

Procmon Screenshot

I'm using MySQL Workbench 6.3 and try to connect to MariaDB 10.1.24, so it's a little confusing, that it's looking for in the shown directory.

But with the dialog.dll placed in this directory, the connection is now working.

Mike Lischke
  • 48,925
  • 16
  • 119
  • 181
Lesrac
  • 65
  • 2
  • 14
  • Hmm, which part is loading this lib? The MySQL server, MySQL Workbnech, MariaDB? – Mike Lischke Jun 24 '17 at 13:25
  • The MySQL Workbench is loading this lib. – Lesrac Jun 27 '17 at 15:30
  • I see. This is actually a client auth plugin as described on the [MariaDB](https://mariadb.com/kb/en/mariadb/development-pluggable-authentication/) site, which refers to the [pluggable authentication chapter](https://dev.mysql.com/doc/refman/5.6/en/pluggable-authentication.html) in the MySQL documentation. – Mike Lischke Jun 27 '17 at 16:01
  • Where did you find the dll? – alexs Aug 21 '20 at 10:12