Bug #28251 mysql_usersinroles not found
Submitted: 4 May 2007 16:53 Modified: 20 May 2007 6:18
Reporter: Darlington Adibe Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:5.1 OS:Windows (XP MCE)
Assigned to: CPU Architecture:Any

[4 May 2007 16:53] Darlington Adibe 
Description:
After installing the MySQL Connector/NET 5.1 with .NET 2.0 Membership and Role Provider.

The table mysql_usersinroles was created in my database, but when I tried to excuted User.IsRole() an Error that myql.usersinroles is not found.

The IsUserinRole() is looking for a table "myql_usersinroles" rather than "mysql_usersinroles" which it actualy created.

How to repeat:
Just install MySQL Connector/NET 5.1 setup the necessary web.config settings and try to excute "User.IsInRole("rolename")" from any page

Suggested fix:
The IsInRole() function should be looking for "mysql_usersinroles".

A quick work around is to rename the "mysql_usersinroles" created by the MySqlRoleProvider to "myql_usersinroles"

Note: this quick fix will create error in other functions referencing the same table with the correct name "mysql_usersinroles" but for so far I have not seen any
[7 May 2007 14:52] Darlington Adibe 
It will be lovely to also have MySqlProfileProvider for ASP.NET 2.0 integrated into the MySQL Connector/NET
[8 May 2007 15:19] 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/26307
[8 May 2007 15:19] Reggie Burnett 
Fixed in 5.1.1
[20 May 2007 6:18] MC Brown 
A note has been added to the 5.1.1 changelog.