[Maria-developers] Is it soon 'end of this year'?
![](https://secure.gravatar.com/avatar/6856a1f0f722fbef5eef6f496fc6fab3.jpg?s=120&d=mm&r=g)
Around ½ year ago I discussed with some people here (Sergei G and/or Georg and/or Wlad) about support for Oracle-style plugins in the MariaDB C-API. The plugins include 1 Windows authentication plugin 2) Clear text plugin. At that time I was told that it could be considered 'by end end of this year'. 1) Windows authentication plugin. Not very important, but Sergei told that he had been playing wiht it and it could probably be done in ~1 day. 2) This is used by Oracle for setting up LDAP.authentication. I am very well aware that there is criticism of Oracle's implementation. But this does not change the fact hat people use it with servers from Oracle and expect clients to work with it. We get request(s) for it almost every week. So this is most important (for us). Any chance that those can soon be prioritized? (if you feel your self mis-quoted then I apologize).. -- Peter --Webyog
![](https://secure.gravatar.com/avatar/39b623a1559cf9c69ac3d9d4fb44e7fe.jpg?s=120&d=mm&r=g)
Hi, Peter! On Sep 17, Peter Laursen wrote:
Around ½ year ago I discussed with some people here (Sergei G and/or Georg and/or Wlad) about support for Oracle-style plugins in the MariaDB C-API. The plugins include
1 Windows authentication plugin 2) Clear text plugin.
At that time I was told that it could be considered 'by end end of this year'.
1) Windows authentication plugin. Not very important, but Sergei told that he had been playing wiht it and it could probably be done in ~1 day.
Yes. Unfortunately because of "not very important" part it gets postponed over and over.
2) This is used by Oracle for setting up LDAP.authentication. I am very well aware that there is criticism of Oracle's implementation. But this does not change the fact hat people use it with servers from Oracle and expect clients to work with it. We get request(s) for it almost every week. So this is most important (for us).
What about clear text plugin? It is in 5.5 and in 10.0 and, as far as I remember, always was there. Do you mean it doesn't work for you for some reason? Regards, Sergei
![](https://secure.gravatar.com/avatar/6856a1f0f722fbef5eef6f496fc6fab3.jpg?s=120&d=mm&r=g)
Well .. where will I find it documented how to use it with Oracle-MySQL
configured for their LDAP authenticaton setup? The same code that worked
with oracles API does not work with the MariaDB API.
- Peter
On Mon, Oct 13, 2014 at 5:04 PM, Sergei Golubchik
Hi, Peter!
Around ˝ year ago I discussed with some people here (Sergei G and/or Georg and/or Wlad) about support for Oracle-style plugins in the MariaDB C-API. The plugins include
1 Windows authentication plugin 2) Clear text plugin.
At that time I was told that it could be considered 'by end end of this year'.
1) Windows authentication plugin. Not very important, but Sergei told
On Sep 17, Peter Laursen wrote: that
he had been playing wiht it and it could probably be done in ~1 day.
Yes. Unfortunately because of "not very important" part it gets postponed over and over.
2) This is used by Oracle for setting up LDAP.authentication. I am very well aware that there is criticism of Oracle's implementation. But this does not change the fact hat people use it with servers from Oracle and expect clients to work with it. We get request(s) for it almost every week. So this is most important (for us).
What about clear text plugin? It is in 5.5 and in 10.0 and, as far as I remember, always was there. Do you mean it doesn't work for you for some reason?
Regards, Sergei
![](https://secure.gravatar.com/avatar/33fb5c08359d9d82c9358b7775aab4b9.jpg?s=120&d=mm&r=g)
do you have the source of oracle plaintext auth plugin? i want read it
2014-10-13 12:09 GMT-03:00 Peter Laursen
Well .. where will I find it documented how to use it with Oracle-MySQL configured for their LDAP authenticaton setup? The same code that worked with oracles API does not work with the MariaDB API.
- Peter
On Mon, Oct 13, 2014 at 5:04 PM, Sergei Golubchik
wrote: Hi, Peter!
Around ˝ year ago I discussed with some people here (Sergei G and/or Georg and/or Wlad) about support for Oracle-style plugins in the MariaDB C-API. The plugins include
1 Windows authentication plugin 2) Clear text plugin.
At that time I was told that it could be considered 'by end end of this year'.
1) Windows authentication plugin. Not very important, but Sergei told
On Sep 17, Peter Laursen wrote: that
he had been playing wiht it and it could probably be done in ~1 day.
Yes. Unfortunately because of "not very important" part it gets postponed over and over.
2) This is used by Oracle for setting up LDAP.authentication. I am very well aware that there is criticism of Oracle's implementation. But this does not change the fact hat people use it with servers from Oracle and expect clients to work with it. We get request(s) for it almost every week. So this is most important (for us).
What about clear text plugin? It is in 5.5 and in 10.0 and, as far as I remember, always was there. Do you mean it doesn't work for you for some reason?
Regards, Sergei
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
![](https://secure.gravatar.com/avatar/6856a1f0f722fbef5eef6f496fc6fab3.jpg?s=120&d=mm&r=g)
I will ask here what we have. But it may never have been released,and it
that case we not have it anymore (if not committed to version control).
Including Georg Richter. Just in case if he remembers something.
-- Peter
On Mon, Oct 13, 2014 at 5:10 PM, Roberto Spadim
do you have the source of oracle plaintext auth plugin? i want read it
2014-10-13 12:09 GMT-03:00 Peter Laursen
: Well .. where will I find it documented how to use it with Oracle-MySQL configured for their LDAP authenticaton setup? The same code that worked with oracles API does not work with the MariaDB API.
- Peter
On Mon, Oct 13, 2014 at 5:04 PM, Sergei Golubchik
wrote: Hi, Peter!
Around ˝ year ago I discussed with some people here (Sergei G and/or Georg and/or Wlad) about support for Oracle-style plugins in the MariaDB C-API. The plugins include
1 Windows authentication plugin 2) Clear text plugin.
At that time I was told that it could be considered 'by end end of this year'.
1) Windows authentication plugin. Not very important, but Sergei told
On Sep 17, Peter Laursen wrote: that
he had been playing wiht it and it could probably be done in ~1 day.
Yes. Unfortunately because of "not very important" part it gets postponed over and over.
2) This is used by Oracle for setting up LDAP.authentication. I am very well aware that there is criticism of Oracle's implementation. But this does not change the fact hat people use it with servers from Oracle and expect clients to work with it. We get request(s) for it almost every week. So this is most important (for us).
What about clear text plugin? It is in 5.5 and in 10.0 and, as far as I remember, always was there. Do you mean it doesn't work for you for some reason?
Regards, Sergei
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
![](https://secure.gravatar.com/avatar/33fb5c08359d9d82c9358b7775aab4b9.jpg?s=120&d=mm&r=g)
is this one?
http://dev.mysql.com/doc/refman/5.5/en/cleartext-authentication-plugin.html
2014-10-13 12:21 GMT-03:00 Peter Laursen
I will ask here what we have. But it may never have been released,and it that case we not have it anymore (if not committed to version control).
Including Georg Richter. Just in case if he remembers something.
-- Peter
On Mon, Oct 13, 2014 at 5:10 PM, Roberto Spadim
wrote: do you have the source of oracle plaintext auth plugin? i want read it
2014-10-13 12:09 GMT-03:00 Peter Laursen
: Well .. where will I find it documented how to use it with Oracle-MySQL configured for their LDAP authenticaton setup? The same code that worked with oracles API does not work with the MariaDB API.
- Peter
On Mon, Oct 13, 2014 at 5:04 PM, Sergei Golubchik
wrote: Hi, Peter!
Around ˝ year ago I discussed with some people here (Sergei G and/or Georg and/or Wlad) about support for Oracle-style plugins in the MariaDB C-API. The plugins include
1 Windows authentication plugin 2) Clear text plugin.
At that time I was told that it could be considered 'by end end of
year'.
1) Windows authentication plugin. Not very important, but Sergei told
On Sep 17, Peter Laursen wrote: this that
he had been playing wiht it and it could probably be done in ~1 day.
Yes. Unfortunately because of "not very important" part it gets postponed over and over.
2) This is used by Oracle for setting up LDAP.authentication. I am very well aware that there is criticism of Oracle's implementation. But this does not change the fact hat people use it with servers from Oracle and expect clients to work with it. We get request(s) for it almost every week. So this is most important (for us).
What about clear text plugin? It is in 5.5 and in 10.0 and, as far as I remember, always was there. Do you mean it doesn't work for you for some reason?
Regards, Sergei
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
![](https://secure.gravatar.com/avatar/33fb5c08359d9d82c9358b7775aab4b9.jpg?s=120&d=mm&r=g)
And this one?
https://nafiux.com/blog/2012/08/11/mysql-ldap-authentication-plugin/
2014-10-13 12:37 GMT-03:00 Roberto Spadim
is this one? http://dev.mysql.com/doc/refman/5.5/en/cleartext-authentication-plugin.html
2014-10-13 12:21 GMT-03:00 Peter Laursen
: I will ask here what we have. But it may never have been released,and it
that case we not have it anymore (if not committed to version control).
Including Georg Richter. Just in case if he remembers something.
-- Peter
On Mon, Oct 13, 2014 at 5:10 PM, Roberto Spadim
wrote: do you have the source of oracle plaintext auth plugin? i want read it
2014-10-13 12:09 GMT-03:00 Peter Laursen
: Well .. where will I find it documented how to use it with Oracle-MySQL configured for their LDAP authenticaton setup? The same code that worked with oracles API does not work with the MariaDB API.
- Peter
On Mon, Oct 13, 2014 at 5:04 PM, Sergei Golubchik
wrote: Hi, Peter!
Around ˝ year ago I discussed with some people here (Sergei G and/or Georg and/or Wlad) about support for Oracle-style plugins in the MariaDB C-API. The plugins include
1 Windows authentication plugin 2) Clear text plugin.
At that time I was told that it could be considered 'by end end of
On Sep 17, Peter Laursen wrote: this
year'.
1) Windows authentication plugin. Not very important, but Sergei told that he had been playing wiht it and it could probably be done in ~1 day.
Yes. Unfortunately because of "not very important" part it gets postponed over and over.
2) This is used by Oracle for setting up LDAP.authentication. I am very well aware that there is criticism of Oracle's implementation. But this does not change the fact hat people use it with servers from Oracle and expect clients to work with it. We get request(s) for it almost every week. So this is most important (for us).
What about clear text plugin? It is in 5.5 and in 10.0 and, as far as I remember, always was there. Do you mean it doesn't work for you for some reason?
Regards, Sergei
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
![](https://secure.gravatar.com/avatar/39b623a1559cf9c69ac3d9d4fb44e7fe.jpg?s=120&d=mm&r=g)
Hi, Roberto! On Oct 13, Roberto Spadim wrote:
do you have the source of oracle plaintext auth plugin? i want read it
Sure, here: http://bazaar.launchpad.net/~mysql/mysql-server/5.5/view/head:/sql-common/cl... Regards, Sergei
![](https://secure.gravatar.com/avatar/39b623a1559cf9c69ac3d9d4fb44e7fe.jpg?s=120&d=mm&r=g)
Hi, Peter! On Oct 13, Peter Laursen wrote:
Well .. where will I find it documented how to use it with Oracle-MySQL configured for their LDAP authenticaton setup? The same code that worked with oracles API does not work with the MariaDB API.
There's only one difference that comes to my mind. Oracle-MySQL cleartext plugin is integral part of the client library, it's statically compiled into it. In MariaDB it's a separate plugin - which is loaded automatically on demand, but you still need to make sure you set the plugin-dir path correctly. There's nothing else I can think of, our test suite verifies that cleartext plugin exists and that it actually works, so I don't think we've broken it somehow. Regards, Sergei
![](https://secure.gravatar.com/avatar/6856a1f0f722fbef5eef6f496fc6fab3.jpg?s=120&d=mm&r=g)
OK .. we will check this again.
But in principle we want (always) not to have any external dependencies in
our prorams/apllications at at all. We link statically everything to the
extend possible. People should download and install SQlyog with a single
click and it will just work. PERIOD! :-) That is what Windows users expect
from an installer. How do we accomplish this with the MariaDB API? Compile
it as a .lib/.dll and bundle it with our installer and let the installer
copy it into the installation directory? Or should what you describe here
happen at compile-time (linking statically)? Also please remember that
SQLyog is a Windows program and our compiler is Visual Studio (2010
version, currently).
Maybe you can provide *Windowssand Visual Studio pecific* guidelines?.
Also (BTW) 1- 1½ years ago I asked similar questions and the only reply I
had was (very abstractly) that MariaDB's mplementation was far superior to
Oracle's. I was actually *despearately* asking for help at that time. The
reply ("we are the best") was very little helpful and we have already lost
significant business due to this.
Anyway, I wili ask our developer team to recover as much information as
possible due to this.
-- Peter
On Mon, Oct 13, 2014 at 7:49 PM, Sergei Golubchik
Hi, Peter!
On Oct 13, Peter Laursen wrote:
Well .. where will I find it documented how to use it with Oracle-MySQL configured for their LDAP authenticaton setup? The same code that worked with oracles API does not work with the MariaDB API.
There's only one difference that comes to my mind.
Oracle-MySQL cleartext plugin is integral part of the client library, it's statically compiled into it. In MariaDB it's a separate plugin - which is loaded automatically on demand, but you still need to make sure you set the plugin-dir path correctly.
There's nothing else I can think of, our test suite verifies that cleartext plugin exists and that it actually works, so I don't think we've broken it somehow.
Regards, Sergei
![](https://secure.gravatar.com/avatar/6856a1f0f722fbef5eef6f496fc6fab3.jpg?s=120&d=mm&r=g)
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.
-- Peter
On Mon, Oct 13, 2014 at 8:29 PM, Peter Laursen
OK .. we will check this again.
But in principle we want (always) not to have any external dependencies in our prorams/apllications at at all. We link statically everything to the extend possible. People should download and install SQlyog with a single click and it will just work. PERIOD! :-) That is what Windows users expect from an installer. How do we accomplish this with the MariaDB API? Compile it as a .lib/.dll and bundle it with our installer and let the installer copy it into the installation directory? Or should what you describe here happen at compile-time (linking statically)? Also please remember that SQLyog is a Windows program and our compiler is Visual Studio (2010 version, currently).
Maybe you can provide *Windowssand Visual Studio pecific* guidelines?.
Also (BTW) 1- 1½ years ago I asked similar questions and the only reply I had was (very abstractly) that MariaDB's mplementation was far superior to Oracle's. I was actually *despearately* asking for help at that time. The reply ("we are the best") was very little helpful and we have already lost significant business due to this.
Anyway, I wili ask our developer team to recover as much information as possible due to this.
-- Peter
On Mon, Oct 13, 2014 at 7:49 PM, Sergei Golubchik
wrote: Hi, Peter!
On Oct 13, Peter Laursen wrote:
Well .. where will I find it documented how to use it with Oracle-MySQL configured for their LDAP authenticaton setup? The same code that worked with oracles API does not work with the MariaDB API.
There's only one difference that comes to my mind.
Oracle-MySQL cleartext plugin is integral part of the client library, it's statically compiled into it. In MariaDB it's a separate plugin - which is loaded automatically on demand, but you still need to make sure you set the plugin-dir path correctly.
There's nothing else I can think of, our test suite verifies that cleartext plugin exists and that it actually works, so I don't think we've broken it somehow.
Regards, Sergei
![](https://secure.gravatar.com/avatar/39b623a1559cf9c69ac3d9d4fb44e7fe.jpg?s=120&d=mm&r=g)
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
![](https://secure.gravatar.com/avatar/6856a1f0f722fbef5eef6f496fc6fab3.jpg?s=120&d=mm&r=g)
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
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
participants (3)
-
Peter Laursen
-
Roberto Spadim
-
Sergei Golubchik