maria-developers team mailing list archive

[Peter Laursen <peter_laursen@xxxxxxxxxx>]

Thanks .. you probabaly know that I am not a developer rmyself (I basically
stopped being so when ALGOL died 35 years ago!). I have shared all
information with SQLyog developer team and we will look into this again.


-- Peter

On Mon, Oct 13, 2014 at 9:17 PM, Sergei Golubchik <serg@xxxxxxxxxxx> wrote:

> Hi, Peter!
>
> On Oct 13, Peter Laursen wrote:
> > To make it clear: it is not acceptable/not a usable solution for us if it
> > is a requirement that a MariaDB server is installed on user's system. The
> > client (in case SQLyog - but it could be any client) should work for
> > connection to remote servers with no server at all installed on client
> > machine.
>
> Yes, I understand (and agree!).
>
> MariaDB server is not needed. You only need mysql_clear_password.dll
> that is put in the location where the client library expects it to. And
> you can set this location with
>
>   mysql_options(..., MYSQL_PLUGIN_DIR, "path");
>
> Another option would be to compile the plugin into SQLyog. It's doable
> too, but you need the source for the plugin (because it's not part of
> the libmysqlclient). Luckily, the whole source of the plugin is:
>
> =========================================================
> static int clear_password_auth_client(MYSQL_PLUGIN_VIO *vio, MYSQL *mysql)
> {
>   int res= vio->write_packet(vio, (const unsigned char *) mysql->passwd,
>                              strlen(mysql->passwd) + 1);
>   return res ? CR_ERROR : CR_OK;
> }
>
> mysql_declare_client_plugin(AUTHENTICATION)
>   "mysql_clear_password", "Georgi Kodinov",
>   "Clear password authentication plugin",
>   {0,1,0}, "GPL", NULL, NULL, NULL, NULL,
>   clear_password_auth_client
> mysql_end_client_plugin;
> =========================================================
>
> If you want it to be part of SQLyog, you put this code somewhere and call
>
>   mysql_client_register_plugin(MYSQL*, _mysql_client_plugin_declaration_);
>
> Then you won't need a separate mysql_clear_password.dll
>
> Regards,
> Sergei
>