Bug #28251 mysql_usersinroles not found
Submitted: 4 May 2007 18:53 Modified: 20 May 2007 8:18
Reporter: Darlington Adibe
Status: Closed
Category:Connector/Net Severity:S3 (Non-critical)
Version:5.1 OS:Microsoft Windows (XP MCE)
Assigned to: Target Version:

[4 May 2007 18: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 16: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 17: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 17:19] Reggie Burnett 
Fixed in 5.1.1
[20 May 2007 8:18] MC Brown 
A note has been added to the 5.1.1 changelog.