[Maria-discuss] user map auth plugin
So, I recently wrote an auth plugin with the intent of implementing a simple user map, authenticated against the hashed password that would be retrieved via the normal password entry scheme. I got far too far along before realizing that this scheme basically requires that either the client use a plugin to communicate with the server auth plugin, or I use the old MySQL auth plugin. ...or is there some way to re-initialize secure MySQL auth from the server auth plugin?? It would really shoot my intents in the gut if every client that wants to log in with user mapping needs to be 5.5+ and to have a plugin...:-( -FG Sent from my android device.
Hi, Felipe! On Apr 28, Felipe Gasper wrote:
So, I recently wrote an auth plugin with the intent of implementing a simple user map, authenticated against the hashed password that would be retrieved via the normal password entry scheme.
I got far too far along before realizing that this scheme basically requires that either the client use a plugin to communicate with the server auth plugin, or I use the old MySQL auth plugin.
yes :( the server is hard-coded to use built-in plugins when the standard mysql authentication is used.
...or is there some way to re-initialize secure MySQL auth from the server auth plugin??
I think so, yes. Your plugin should to declare that it needs "mysql_native_password" plugin on the client side. Then the server will notice that the client already uses mysql_native_password plugin and will only reinitialize the server part of the authentication without client noticing anything. Tell me if it'll work :) Regards, Sergei
participants (2)
-
Felipe Gasper
-
Sergei Golubchik