Mysql pluggable authentication and membership provider

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
KW
Posts: 135
Joined: Tue 19 Feb 2008 19:12

Mysql pluggable authentication and membership provider

Post by KW » Wed 25 May 2011 17:02

I was curious if devarts asp.net membership provider can be incorporated into mysql's pluggable authentication? If so, would you consider blogging about how to accomplish this task?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 31 May 2011 09:52

It should be possible to use pluggable authentication when connecting with the "Direct=false;" connection string parameter via dotConnect for MySQL (the corresponding libmysql.dll should support pluggable authentication): http://dev.mysql.com/doc/refman/5.5/en/ ... ation.html.
We will investigate the possibility of implementing the pluggable authentication support in the "Direct=true;" mode and notify you about the results as soon as possible.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 09 Jun 2011 13:51

We have investigated the issue.

Pluggable Authentication via MySQL client library (Direct=false;) will be supported starting from the next build of dotConnect for MySQL. We have implemented two additional parameters to support this feature:
1) "PluginDir" - the directory where the plugin is located. This connection parameter is used to set MYSQL_PLUGIN_DIR option of MySQL client library.
2) "DefaultAuthPlugin" - the name of the authentication plugin to use. This connection parameter is used to set MYSQL_DEFAULT_AUTH option of MySQL client library. Usage of this option is not necessary because client finds out the name of the authentication plugin to use from server during handshake. This option allows to reduce the client/server negotiation and avoid a round trip in the protocol.

I will post here when the corresponding build of dotConnect for MySQL is available for download.

We do not have a technical possibility to support Pluggable Authentication in the direct mode at the moment.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 16 Jun 2011 14:01

New build of dotConnect for MySQL 6.30.172 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/mysql/download.html (trial version) or from Registered Users' Area (for users with valid subscription only): http://secure.devart.com/ .

For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=21278 .

Post Reply