Bug #34495 MySQL MembershipProvider , RoleProvider, ProfileProvider
Submitted: 12 Feb 17:22 Modified: 1 Mar 12:12
Reporter: Max
Status: Closed
Category:Connector/Net Severity:S3 (Non-critical)
Version:5.2.0.0 OS:Any
Assigned to: Target Version:

[12 Feb 17:22] Max 
Description:
Will not work with VS2008 and latest schema.

Many bugs including capitalization and spelling mistakes, missing conn.open()'s, missing
integer casts, incorrect field names in SQL statements. The schema also would not upgrade
as the script fails, and the connector could never detect v.3 schema anyhow as the COMMENT
attribute never set to 3 in the Membership table.

Attached are re-worked files which address all the issues, except one:

I _cannot_ create new users with the asp.net config tool.

However, I can do everything else with the asp.net config tool (such as create roles,
modify exisiting roles and users, etc..). I can also create users using the api from my
webpage.

I am not convinced that the problem does not lay with some other code outside the
connector, given the nature of the error- and would be good to know if other users
experience the same error or not.

 

How to repeat:
The files are simply full of bugs - it is impossible to use them.

Suggested fix:
Attached are working src files, and a working schema.sql file
[12 Feb 17:28] Max 
Provider sources and sql script

Attachment: MySqlProviders.zip (application/x-zip-compressed, text), 28.48 KiB.
[12 Feb 17:48] Max 
At the end of the "using" statements block, within the ProfileProvider.cs file, the
following 4 "usings" can be removed:

//using System.Runtime.Serialization;
//using System.Runtime.Serialization.Formatters.Binary;
//using System.Xml.Serialization;
//using System.ComponentModel;

They are not relevant for this implementation.
[12 Feb 23:21] Max 
Full working vs2008 solution demonstrating use of mysql providers

Attachment: MySqlProviderDemo.zip (application/x-zip-compressed, text), 35.31 KiB.
[12 Feb 23:24] Max 
The above attachment includes INSTRUCTIONS.txt file. 

It represents a complete VS2008 solution, so easy to see everything working.

It is probably the better one to use than the previously uploaded files, as I also
resolved a couple of dependencies in the sources.
[13 Feb 20:11] Reggie Burnett 
Thanks for your submission.  We had already discovered and fixed these issues.  We'll be
releasing 5.2.1 as soon as we can check a few more things and package it up.
[13 Feb 20:17] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/42237
[13 Feb 20:17] Reggie Burnett 
fixed in 5.2.1
[13 Feb 21:33] Reggie Burnett 
Yes you are right. We did not discover the bugs until a bit later and my comments were
obviously wrong.  We strongly encourage cooperation with the community and highly value
everyone's involvement.  Again, sorry for the buggy first release and the
misunderstanding.
[13 Feb 21:38] Max 
It can happen. And thank you for the reply - it is appreciated.
Regards, Max.
[1 Mar 12:12] MC Brown 
A note has been added to the 5.2.1 changelog:

A number issues were identified in the case, connection and scema areas of the code for
MembershipProvider, RoleProvider, ProfileProvider.