MySQL Bugs: #34495: MySQL MembershipProvider , RoleProvider, ProfileProvider

Bug #34495	MySQL MembershipProvider , RoleProvider, ProfileProvider
Submitted:	12 Feb 2008 16:22	Modified:	1 Mar 2008 11:12
Reporter:	Max Win	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / NET	Severity:	S3 (Non-critical)
Version:	5.2.0.0	OS:	Any
Assigned to:		CPU Architecture:	Any

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

Provider sources and sql script

Attachment: MySqlProviders.zip (application/x-zip-compressed, text), 28.48 KiB.

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.

Full working vs2008 solution demonstrating use of mysql providers

Attachment: MySqlProviderDemo.zip (application/x-zip-compressed, text), 35.31 KiB.

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.

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.

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

fixed in 5.2.1

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.

It can happen. And thank you for the reply - it is appreciated.
Regards, Max.

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.