[REQ] Client compatibility with auth_pam.so

[GoogleCodeExporter]

We would like to be able to switch clients over to pam based auth on our mysql 
servers and we have started to do some testing and we have hit a wall. The 
error we get with Sequel Pro is as follows

"MySQL said: Authentication plugin 'dialog' cannot be loaded: 
dlopen(/usr/local/mysql/lib/plugin/dialog.so, 2): image not found"

I did some digging around on how to fix this and it seems as though this might 
be a client side feature request.

https://bugs.launchpad.net/percona-server/+bug/1166938
http://www.percona.com/doc/percona-server/5.5/management/pam_plugin.html

Is this something that can be put on the roadmap? Giving users a unified system 
password via pam would help reduce authentication fatigue as well as creating a 
unified authentication story to streamline security process.

Thanks!

Original issue reported on code.google.com by jle...@squareup.com on 24 Oct 2013 at 11:41

[GoogleCodeExporter]

Looking at the MariaDB source the dialog plugin supports a custom callback 
function.
So technically we would have to implement that function to provide the UI and 
compile the plugin with our mysql client lib.

I'm not quite sure how to handle the dialog between SPMySQL/Sequel Pro, though.

Original comment by schlabbe...@gmail.com on 25 Oct 2013 at 12:50