percona-pam-for-mysql

  1. Bug #1166938
  2. Comment #3

Comment 3 for bug 1166938

Revision history for this message
Joshua Prunier (joshua-prunier) wrote :

I tested MySQL Workbench on Windows and Mac. Sequel Pro is Mac only. HeidiSQL is Win only. The databases exist on CentOS/Redhat servers.

Using auth_pam_compat works from local Linux command line with --enable-cleartext-plugin.
Sequel Pro also works.
HeidiSQL fails with "SQL Error (2058): Authentication plugin 'mysql_clear_password' can not be loaded:"
MySQL workbench on Windows test connection works but then when attempting to really connect it fails with an error similar to if the user account does not exist or the wrong password is supplied.
MySQL Workbench on Mac works.

I'm pretty sure the clients do not have the dialog plugin. Also I do not define the plugin_dir variable so Percona Server is using the default of /usr/lib64/mysql/plugin/ on the Red Hat 6.3 server. I will try upgrading the server to the latest 5.5.30 and see if that makes a difference.