MySQL Membership, Role, Sitemap, Personalization Provider for ASP.Net 2.0

• Download ccmMyProvClass.zip - 165.0 KB

Introduction

This is the implementation of Membership,Role,Sitemap,Personalization provider of ASP.Net using MySQL as backend database. This class uses the native net MySQL connector version 5.1.2

Background

This code is based on the work of J Snyman, he uses odbc to connect to MySQL, I modified it to use the native net MySQL connector version 5.1.2

Using the code

INSTRUCTION:

This is actually a C# class project, you only need to reference the compiled dll output from this project in your Web project, you can use this even if your language in your web app is vb. The provided compiled dll can be used right out of the box, but if you prefer you can compile your own.

Using the providers is really easy.

1. Create a new database on your MySQL server eg. SimpleProviders
2. Execute the following SQL statement on the newly created database

<code lang=sql>

CREATE TABLE `personalization` (
`username` varchar(255) default NULL,
`path` varchar(255) default NULL,
`applicationname` varchar(255) default NULL,
`personalizationblob` blob
);

CREATE TABLE `profiles` (
`UniqueID` int(8) NOT NULL auto_increment,
`Username` varchar(255) NOT NULL default '',
`ApplicationName` varchar(255) NOT NULL default '',
`IsAnonymous` tinyint(1) default '0',
`LastActivityDate` datetime default NULL,
`LastUpdatedDate` datetime default NULL,
PRIMARY KEY (`UniqueID`),
UNIQUE KEY `PKProfiles` (`Username`,`ApplicationName`),
UNIQUE KEY `PKID` (`UniqueID`)
);

CREATE TABLE `roles` (
`Rolename` varchar(255) NOT NULL default '',
`ApplicationName` varchar(255) NOT NULL default '',
PRIMARY KEY (`Rolename`,`ApplicationName`)
);

CREATE TABLE `sitemap` (
`ID` int(11) NOT NULL auto_increment,
`ApplicationName` varchar(255) NOT NULL default '',
`Title` varchar(255) default NULL,
`Description` text,
`Url` text,
`Roles` text,
`Parent` int(11) default NULL,
PRIMARY KEY (`ID`)
);

CREATE TABLE `users` (
`PKID` varchar(255) NOT NULL default '',
`Username` varchar(255) NOT NULL default '',
`ApplicationName` varchar(255) NOT NULL default '',
`Email` varchar(128) default NULL,
`Comment` varchar(255) default NULL,
`Password` varchar(128) NOT NULL default '',
`FailedPasswordAttemptWindowStart` datetime default NULL,
`PasswordQuestion` varchar(255) default NULL,
`IsLockedOut` tinyint(1) default '0',
`PasswordAnswer` varchar(255) default NULL,
`FailedPasswordAnswerAttemptCount` int(8) default '0',
`FailedPasswordAttemptCount` int(8) default '0',
`IsApproved` tinyint(1) NOT NULL default '0',
`FailedPasswordAnswerAttemptWindowStart` datetime default NULL,
`LastActivityDate` datetime default NULL,
`IsOnLine` tinyint(1) default '0',
`CreationDate` datetime default NULL,
`LastPasswordChangedDate` datetime default NULL,
`LastLockedOutDate` datetime default NULL,
`LastLoginDate` datetime default NULL,
PRIMARY KEY (`PKID`),
UNIQUE KEY `PKID` (`PKID`),
KEY `PKID_2` (`PKID`),
KEY `usr` (`Username`)
);

CREATE TABLE `usersinroles` (
`Username` varchar(255) NOT NULL default '',
`Rolename` varchar(255) NOT NULL default '',
`ApplicationName` varchar(255) NOT NULL default '',
PRIMARY KEY (`Username`,`Rolename`,`ApplicationName`)
);

</code>


There is an SQL file named DBStructure.sql included with the source code zip file that contains the code above
3. Open Visual Studio and create a new Website Project
4. Add a reference to the Simple.Providers.MySQL.dll
5. Make the following changes to your web.config file

1. Add the connection string to your newly created database to the connectionStrings section
eg. <add connectionString="server=localhost;database=simpleproviders;user id=<put user>;pwd=<put password>" name="SimpleProviderconnectionstring" providerName="MySql.Data.MySqlClient"/>

* Please replace the {Your username} and {Your password} entries in the connection string with your own values.


2. Under the <system.web> section add the following:
Collapse

<siteMap defaultProvider="siteMapProvider" enabled="true">
<providers>
<clear />
<add name="siteMapProvider"
type="Simple.Providers.MySQL.MysqlSiteMapProvider"
connectionStringName="SimpleProviderConnectionString"
applicationName="{Your App Name}"
description="MySQL site map provider"
securityTrimmingEnabled="true"/>
</providers>
</siteMap>
<roleManager defaultProvider="roleProvider" enabled="true"
cacheRolesInCookie="false" cookieName=".ASPROLES"
cookieTimeout="7200" cookiePath="/" cookieRequireSSL="false"
cookieSlidingExpiration="true" cookieProtection="All">
<providers>
<clear />
<add name="roleProvider"
type="Simple.Providers.MySQL.MysqlRoleProvider"
connectionStringName="SimpleProviderConnectionString"
applicationName="{Your App Name}"
description="MySQL role provider"/>
</providers>
</roleManager>
<membership defaultProvider="membershipProvider"
userIsOnlineTimeWindow="15">
<providers>
<clear />
<add name="membershipProvider"
type="Simple.Providers.MySQL.MysqlMembershipProvider"
connectionStringName="SimpleProviderConnectionString"
applicationName="{Your App Name}"
enablePasswordRetrieval="true" enablePasswordReset="true"
requiresQuestionAndAnswer="true"
requiresUniqueEmail="true" passwordFormat="Encrypted"
minRequiredPasswordLength="6"
minRequiredNonalphanumericCharacters="0"
description="MySQL membership provider"/>
</providers>
</membership>
<profile defaultProvider="profileProvider"
automaticSaveEnabled="true">
<providers>
<clear />
<add name="profileProvider"
type="Simple.Providers.MySQL.MysqlProfileProvider"
connectionStringName="SimpleProviderConnectionString"
applicationName="{Your App Name}"
description="MySQL Profile Provider"/>
</providers>
<properties>
<clear />
<!--
Add any needed attributes for profiles here.
eg. <add name="Theme" type="System.String"
defaultValue="Default"/>
-->
</properties>
</profile>
<webParts>
<personalization defaultProvider="personalizationProvider">
<providers>
<clear />
<add name="personalizationProvider"
type="Simple.Providers.MySQL.
MysqlPersonalizationProvider" connectionStringName=
"{Your Connection String Name}" applicationName="
{Your App Name}"
description="MySQL Personalization Provider/>
</providers>
</personalization>
</webParts>

/* !!! Please replace the {Your App Name} instances with a valid
application name. The application name should not contain any spaces
or special characters. !!! */

6. Everything should be set up correctly now.

Continue with the rest of your project and make sure to make use of the features provided by the above mentioned providers.

Blocks of code should be set as style "Formatted" like this:

//

// Any source code blocks look like this

//

Remember to set the Language of your code snippet using the Language dropdown.

Use the "var" button to to wrap Variable or class names in <code> tags like this.

Points of Interest

Did you learn anything interesting/fun/annoying while writing the code? Did you do anything particularly clever or wild or zany?

History

9/7/2007 - Using mysql net connector 5.1.2 instead of ODBC.

You must Sign In to use this message board.

FAQ    Noise Tolerance Very HighHighMediumLowVery Low   Layout Expand Posts & RepliesThread ViewNo JavascriptNo JS + Preview   Per page 102550

Msgs 1 to 25 of 25 (Total in Forum: 25) (Refresh) FirstPrevNext

How do the Simple Providers recognize the current version of MySQL Connector Driver LuizItatiba 18:34 8 Sep '09   How do I recognize the Simple.Providers.MySql Connector MySqlConnector version 6.1.2 as the latest one is this link that has tried to remove the reference to MySql.Data version and place it now and do rebuild the DLL to generate it gives error The error it gives is Error     1     The type 'System.Xml.Serialization.IXmlSerializable' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.     C:\ComponentesDLL\MySqlSiteMapProvider\Simple.Providers.MySQL_Source\Simple.Providers.MySQL\RawDBQuery.cs     9     31     Simple.Providers.MySQL Here the link of the current version of the connector <a href="http://dev.mysql.com/downloads/connector/net/6.1.html" target="blank">MySqlConnector 6.1.2</a> I'm using VS2005 to try to rebuild but not working there would be some link with the SimpleProvider because of MySqlSiteMap with the new version of the connector? I am in the look and I thank you LADEF Sign In·View Thread·PermaLink Re: Webparts Member 4115604 14:27 2 Apr '09   This works fine, as long as you only want to move one part around the screen. Let me explain I set up two columns with more than one webpart on the right hand side column, and moved webparts from the right to the left. When I move the first webpart, it moves fine, however when I move a second, the first webpart is replaced by the webpart I am moving. Before, It's my code is uttered I ran the same code with the SQL form authentication and the web parts move find. If you can help I would appreciate your comments. Regards, Martin Sign In·View Thread·PermaLink How CurrentNodes and accented with spaces in SiteMapPath? For example São Paulo-SP. LuizItatiba 10:25 22 Oct '08   Onrac you could you explain why when I use a control-type sitemappath in currentnode, I explain what's happening well let me explain you better then My SiteMapProvider comes from below as MySqlSiteMapProvider &lt;!-- INÖCIO CONFIGS MYSQLSITEMAPPROVIDER --&gt; &lt;siteMap defaultProvider="siteMapProvider" enabled="true"&gt; &lt;providers&gt; &lt;clear /&gt; &lt;add name="siteMapProvider" type="Simple.Providers.MySQL.MysqlSiteMapProvider" connectionStringName="SimpleProviderConnectionString" applicationName="myapp" description="MySQL site map provider" securityTrimmingEnabled="true"/&gt; &lt;/providers&gt; &lt;/siteMap&gt; &lt;!-- FIM CONFIGS MYSQL SITEMAPPROVIDER --&gt; When the url it in my database in the field url MySqlSiteMapProvider is like this id, myapp, 'Atibaia-SP.', 'shops - Atibaia-SP.', 'shops.aspx?subsessao=books&amp;cidade=atibaia&amp;uf=sp', '', parentid it shows SiteMapPath in control of my application correctly or Home :shops : books : Atibaia-SP. Now when the data comes from my database of mysqlsitemapprovider that way id, myapp, 'São Paulo-SP.', 'shops - São Paulo-SP.', 'shops.aspx?subsessao=books&amp;cidade=são paulo&amp;uf=sp', '', parentid or id, myapp, 'Jundiaí-SP.', 'shops - Jundia-SP.', 'shops.aspx?subsessao=books&amp;cidade=´jundiaí&amp;uf=sp', '', parentid it just shows me this result in the control mode of execution in SiteMapPath Home : shops if you can help me now because I need to thank the currentnode, finally on all nodes that the accented characters with spaces and mapped by MySqlSiteMapProvider appear with accents and spaces in control sitemappath LADEF Sign In·View Thread·PermaLink How to correctly set the standard MemberShipProvider Provider of the SqlServer2005 to work together with the MySqlSiteMapProvider? LuizItatiba 7:26 8 Oct '08   Hello onrac as can be seen in the web.config of my asp.net 2.0 application that I am doing in VisualStudio2005 I have a 2 providers SqlSiteMapProvider which is the standard for use with authentication and security based on MemberShipProvider and another to use only the MySqlSiteMapProvider who also uses Roles of the MemberShipProvider the standard SQLServer as can be seen below in web.config <appSettings/> <connectionStrings> <add name="MembershipConnection" connectionString="Data Source=mydatasource;Initial Catalog=mydb;User ID=sa;Password=mypass" providerName="System.Data.SqlClient"/> <add connectionString="server=mysqlserver;database=mybd;user id=myid;pwd=mypass" name="SimpleProviderConnectionString" providerName="MySql.Data.MySqlClient"/> </connectionStrings> <system.web> <membership defaultProvider="SqlProvider" userIsOnlineTimeWindow="15"> <providers> <clear/> <add name="SqlProvider" type="System.Web.Security.SqlMemberShipProvider" connectionStringName="MembershipConnection"/> </providers> </membership> <!-- INÍCIO CONFIGS MYSQLSITEMAPPROVIDER --> <siteMap defaultProvider="siteMapProvider" enabled="true"> <providers> <clear /> <add name="siteMapProvider" type="Simple.Providers.MySQL.MysqlSiteMapProvider" connectionStringName="SimpleProviderConnectionString" applicationName="myapp" description="MySQL site map provider" securityTrimmingEnabled="true"/> </providers> </siteMap> <authentication mode="Forms"> </authentication> What you need to know is how to properly configure so that the two providers one for each state are recognized and work properly in my webapplication Project and how to ensure that the roles created Membership in the SQL are recognized in MySqlSiteMapProvider too. If you can help me now thank you Translated from Portuguese to English by Google LADEF Sign In·View Thread·PermaLink 1.00/5 (1 vote) How can I use same database for more than one application? Umut TURER 7:39 2 Sep '08   I am using MySQL membership provider for my web applications. And I want to use same membership database for more than one application. It works fine when storing information. Created users in each application is stored related to that application's name. However when logging in, any valid user from any application can log in even that username does not belong to that application. My question arise at this point. Is there a way that mysql membership provider can handle this situation by its own? Any help is appreciated.. Oncel Umut TURER Sign In·View Thread·PermaLink 5.00/5 (1 vote) Can someone provide the same example with some aspx pages..... Member 3586580 0:20 16 Jul '08   It is nice article No Doubt. but anyone can help me how i integrate this to the actual asp website files. Sign In·View Thread·PermaLink 1.00/5 (2 votes) good Didier Stmedar 4:33 4 Jul '08   good attempt for custom providers maybe you could have normalise your database first. Didier Sign In·View Thread·PermaLink Fail to test to the provider in the Asp.net Configuration CGARRIGOS 2:54 20 May '08   I have changed the names of the following tables table users by aspnet_Users table roles by aspnet_Roles table usersinroles by aspnet_UsersInRolesñ Actually run the management of roles and users, but I don't get to test the provider after the new names of table. If somebody knows the answer I agree his answer. Thanks Sign In·View Thread·PermaLink 3.25/5 (4 votes) How to Order Alphabetically by the children MySqlSiteMapProvider us LuizItatiba 17:30 1 Apr '08   As the Order Alphabetically by MySqlSiteMapProvider us children, or qdo I add an item on the menu I would like the Parent Title him he was Sorted Alphabetically or is not you can help me now thank you LADEF Sign In·View Thread·PermaLink 2.00/5 (1 vote) As Custom Menus of MYSQLSITEMAPPROVIDER, based on profiles or roles LuizItatiba 10:24 1 Apr '08   Hello ONRAC at least managed to put the already My Menu with MySQLSITEMAPPROVIDER using MYSQLCONNECTOR 5.0 in the air, now I would like to know if there any article or link that based on his or Article code of example that nôs teaches itself as customize the menus based on user profiles, or would be accessible to each user a menu or menus for it if there is any link please ask if I could pass. Sincerely and now thank LADEF Sign In·View Thread·PermaLink 1.00/5 (1 vote) Error Tool Administration of Site or ASP.NET Configuration LuizItatiba 9:57 1 Apr '08   Based on your article and did correct the webconfig below for my application which is now working properly but the Tool Administration of Site, in the error happens Safety Guide There is a problem with data storage selected. You may be caused by credential or Filename invalid, or by inadequate level of permission. He may also is occurring because the resource management functions are not allowed. Click on the button below to be redirected to the page where you can choose a new data storage. The message below can help diagnose the problem: Hashed or Encrypted passwords are not supported with self-generated keys. (C: \ Inetpub \ wwwroot \ TesteMySqlSiteMapProvider \ TesteMySqlSiteMapProvider \ web.config line 56) As the line 56 of webconfig being as Type = "Simple.Providers.MySQL.MysqlMembershipProvider" Below the full WebConfig to better analyse and I look forward to your response in my doubts will be possible at. Luiz - Brazil-SP. My WebConfig <?xml version="1.0"?> <configuration> <configSections> <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"> <sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"> <section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication"/> <sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"> <section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="Everywhere" /> <section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication" /> <section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false" allowDefinition="MachineToApplication" /> </sectionGroup> </sectionGroup> </sectionGroup> </configSections> <connectionStrings> <add connectionString="server=myserver;database=mydatabase;user id=myid;pwd=mypass" name="SimpleProviderConnectionString" providerName="MySql.Data.MySqlClient"/> </connectionStrings> <system.web> <customErrors mode="Off"/> <!-- INÍCIO CONFIGS MYSQLSITEMAPPROVIDER --> <siteMap defaultProvider="siteMapProvider" enabled="true"> <providers> <clear /> <add name="siteMapProvider" type="Simple.Providers.MySQL.MysqlSiteMapProvider" connectionStringName="SimpleProviderConnectionString" applicationName="TesteMySqlSiteMapProvider" description="MySQL site map provider" securityTrimmingEnabled="true"/> </providers> </siteMap> <roleManager defaultProvider="roleProvider" enabled="true" cacheRolesInCookie="false" cookieName=".ASPROLES" cookieTimeout="7200" cookiePath="/" cookieRequireSSL="false" cookieSlidingExpiration="true" cookieProtection="All"> <providers> <clear /> <add name="roleProvider" type="Simple.Providers.MySQL.MysqlRoleProvider" connectionStringName="SimpleProviderConnectionString" applicationName="TesteMySqlSiteMapProvider" description="MySQL role provider"/> </providers> </roleManager> <membership defaultProvider="membershipProvider" userIsOnlineTimeWindow="15"> <providers> <clear /> <add name="membershipProvider" type="Simple.Providers.MySQL.MysqlMembershipProvider" connectionStringName="SimpleProviderConnectionString" applicationName="TesteMySqlSiteMapProvider" enablePasswordRetrieval="true" enablePasswordReset="true" requiresQuestionAndAnswer="true" requiresUniqueEmail="true" passwordFormat="Encrypted" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" description="MySQL membership provider"/> </providers> </membership> <profile defaultProvider="profileProvider" automaticSaveEnabled="true"> <providers> <clear /> <add name="profileProvider" type="Simple.Providers.MySQL.MysqlProfileProvider" connectionStringName="SimpleProviderConnectionString" applicationName="TesteMySqlSiteMapProvider" description="MySQL Profile Provider"/> </providers> <properties> <clear /> <!-- Add any needed attributes for profiles here. eg. <add name="Theme" type="System.String" defaultValue="Default"/> --> </properties> </profile> <webParts> <personalization defaultProvider="personalizationProvider"> <providers> <clear/> <add name="personalizationProvider" type="Simple.Providers.MySQL. MysqlPersonalizationProvider" connectionStringName="SimpleProviderConnectionString" applicationName="TesteMySqlSiteMapProvider" description="MySQL Personalization Provider" /> </providers> </personalization> </webParts> <!-- FIM CONFIGS MYSQL SITEMAPPROVIDER --> <pages> <controls> <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> </controls> </pages> <!-- Set compilation debug="true" to insert debugging symbols into the compiled page. Because this affects performance, set this value to true only during development. --> <compilation debug="false"> <assemblies> <add assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> </assemblies> </compilation> <httpHandlers> <remove verb="*" path="*.asmx"/> <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"/> </httpHandlers> <httpModules> <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> </httpModules> </system.web> <system.web.extensions> <scripting> <webServices> <!-- Uncomment this line to customize maxJsonLength and add a custom converter --> <!-- <jsonSerialization maxJsonLength="500"> <converters> <add name="ConvertMe" type="Acme.SubAcme.ConvertMeTypeConverter"/> </converters> </jsonSerialization> --> <!-- Uncomment this line to enable the authentication service. Include requireSSL="true" if appropriate. --> <!-- <authenticationService enabled="true" requireSSL = "true|false"/> --> <!-- Uncomment these lines to enable the profile service. To allow profile properties to be retrieved and modified in ASP.NET AJAX applications, you need to add each property name to the readAccessProperties and writeAccessProperties attributes. --> <!-- <profileService enabled="true" readAccessProperties="propertyname1,propertyname2" writeAccessProperties="propertyname1,propertyname2" /> --> </webServices> <!-- <scriptResourceHandler enableCompression="true" enableCaching="true" /> --> </scripting> </system.web.extensions> <system.webServer> <validation validateIntegratedModeConfiguration="false"/> <modules> <add name="ScriptModule" preCondition="integratedMode" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> </modules> <handlers> <remove name="WebServiceHandlerFactory-Integrated" /> <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> <add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> <add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /> </handlers> </system.webServer> </configuration> LADEF Sign In·View Thread·PermaLink 3.50/5 (2 votes) Error WebConfig LuizItatiba 11:18 31 Mar '08   In WebConfig between the lines of Article 85 and 95 as below <personalization defaultProvider="personalizationProvider"> <providers> <clear /> <add name="personalizationProvider" type="Simple.Providers.MySQL. MysqlPersonalizationProvider" connectionStringName= "{Your Connection String Name}" applicationName=" {Your App Name}" description="MySQL Personalization Provider/> </providers> </personalization> In my project apparently think that the correct way below only that I would like to know if you correct the way in which fix <personalization defaultProvider="personalizationProvider"> <providers> <clear/> <add name="personalizationProvider" type="Simple.Providers.MySQL.MysqlPersonalizationProvider" connectionStringName="SimpleProviderConnectionString" applicationName="TesteMySqlSiteMapProvider" description="MySQL Personalization Provider" /> </providers> </personalization> If he can guide me now thank you LADEF Sign In·View Thread·PermaLink 3.33/5 (3 votes) Using the driver MySqlConnector 5.0 instead of 5.1.2 LuizItatiba 13:44 26 Mar '08   As in the place of MySqlConnector 5.1.2 I could use MySqlConnector 5.0 The reason my hosting provider has only installed the drivers of MySQLCONNECTOR 5.0 LADEF Sign In·View Thread·PermaLink General Comments John Simmons / outlaw programmer 5:33 19 Jan '08   Thanks for doing this, but... 1) Your code formatting is, for lack of a better term, CRAP. If you're going to essentially duplicate someone else's code, at least go through it to the point that it looks decent. 2) You need to update the code to eliminate the deprecated MySqlDataType.Datetime references. 3) Both your version and the original contain an error in the web.config stuff. The very last item has the ending quote in the wrong place. It seems to me that one of you guys (you or the guy that posted the original article) would have picked up on it by now. 4) You need to go back through all the source code and add proper intellisense-compatible comments to all of the classes, properties and functions. "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001 Sign In·View Thread·PermaLink ODBC still present in the MysqlPersonalizationProvider.cs Lisburn Lad 5:01 8 Jan '08   Thanks very much for some extremely useful code – for all the standard membership stuff everything is working perfectly. However I’ve just started looking at WebParts and it appears that the personalization code is still using ODBC. Do you have a newer version that has been converted to use the MySQLConnection instead? Sign In·View Thread·PermaLink 2.00/5 (1 vote) Implementation Example CreativeGolf 6:54 19 Oct '07   It would be nice to see some .aspx examples of how you integrate this to the actual asp website files. Sign In·View Thread·PermaLink just Note ibyasmo 11:45 30 Sep '07   The tables names should be Like this Personalization Profiles Roles Sitemap Users UsersInRoles Casesensitive ibyasmo Sign In·View Thread·PermaLink ERROR MESSAGE - SECURITY Kanedogg 8:48 17 Sep '07   Hey man nice Tutorial, i have one question though please >!? well maybe 2 i'm relatively new to ASP 2 and have used your tutorial to setup my sites security / provider. i followed it to a T yet when ever i try to login i get the server error as below: **************************************************************************** Server Error in '/' Application. Security Exception Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file. Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SecurityException: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.] System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet) +0 System.Security.CodeAccessPermission.Demand() +59 System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) +678 System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share) +114 System.Configuration.Internal.InternalConfigHost.StaticOpenStreamForRead(String streamName) +80 System.Configuration.Internal.InternalConfigHost.System.Configuration.Internal.IInternalConfigHost.OpenStreamForRead(String streamName, Boolean assertPermissions) +115 System.Configuration.Internal.InternalConfigHost.System.Configuration.Internal.IInternalConfigHost.OpenStreamForRead(String streamName) +7 System.Configuration.Internal.DelegatingConfigHost.OpenStreamForRead(String streamName) +10 System.Configuration.UpdateConfigHost.OpenStreamForRead(String streamName) +42 System.Configuration.BaseConfigurationRecord.InitConfigFromFile() +443 ******************************************************************************* so i'm guessing i need to set my app some security in the web.config ?? can you help please ? it's externally hosted the site i have setup the ASP 2 feature on my host & i connect to mysql server also hosted by same provider. connection string is this: and my membership string: userIsOnlineTimeWindow="15"> type="Simple.Providers.MySQL.MysqlMembershipProvider" connectionStringName="SimpleProviderConnectionString" applicationName="site registry" requiresQuestionAndAnswer="true" requiresUniqueEmail="false" passwordFormat="Encrypted" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" description="MySQL membership provider"/> any help appreciated regards Kane " i'm mediocre on ASP & .NET but i'll help if & where i can." Sign In·View Thread·PermaLink Re: ERROR MESSAGE - SECURITY [modified] onrac 18:18 17 Sep '07   I think there is a security configuration : <machineKey> tag;   this is my web.config (part): <!-- partial web config <machineKey validationKey="60D041931C3DB23072745CD298DCADD2906F0EADEBE7F0E9E28CFA7176F7FD685540A5501292D046940A5F6351C7185849F38441897C10BD59536C3C8991E9B9" decryptionKey="C342DA197897E627C58D98D825F09063943B208EB988B1D3" validation="SHA1"/>           <siteMap defaultProvider="siteMapProvider" enabled="true">                <providers>                     <clear/>                     <add name="siteMapProvider" type="Simple.Providers.MySQL.MysqlSiteMapProvider" connectionStringName="SimpleProviderConnectionString" applicationName="OnracMembership" description="MySQL site map provider" securityTrimmingEnabled="true"/>                </providers>           </siteMap>           <roleManager defaultProvider="roleProvider" enabled="true" cacheRolesInCookie="false" cookieName=".ASPROLES" cookieTimeout="7200" cookiePath="/" cookieRequireSSL="false" cookieSlidingExpiration="true" cookieProtection="All">                <providers>                     <clear/>                     <add name="roleProvider" type="Simple.Providers.MySQL.MysqlRoleProvider" connectionStringName="SimpleProviderConnectionString" applicationName="OnracMembership" description="MySQL role provider"/>                </providers>           </roleManager> Copy the <machineKey /> and incorporate with your own. --> -- modified at 23:30 Monday 17th September, 2007<pre></pre> Sign In·View Thread·PermaLink Re: ERROR MESSAGE - SECURITY Kanedogg 1:47 18 Sep '07   Man the machine key worked greatbut that gave me another total error.. Anyhow i have totally rebuilt a new project as i worried about the whole project. I now have re-installed my connector.msi and with the new project i get : ********************************************************* Error in application: Configuration Error Parser Error Message: Could not load file or assembly 'MySql.Data, Version=5.0.8.1, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. The system cannot find the file specified. Source Error: Line 88: Line 89: Line 90: Line 92: ******************************************************** i think it's because the HOST itself is not have installed the connector .NET drivers or application ?!?! please advise cheers " i'm mediocre on ASP & .NET but i'll help if & where i can." Sign In·View Thread·PermaLink Re: MySQL Membership, Role Provider [modified] Fuzziebrain 16:23 13 Sep '07   Great effort, but I am confused. Aren't membership and role providers already incorporated into the the latest connectors version 5.1.2 (see http://dev.mysql.com/downloads/connector/net/5.1.html)? I appreciate any clarifications. Cheers, Adrian Host your ASP.NET 2.0, .NET 3.0 and Ajax 1.0 applications. Sign In·View Thread·PermaLink 2.00/5 (1 vote) Re: MySQL Membership, Role Provider onrac 18:20 17 Sep '07   Yup; but this one includes sitemap and personalization provider. Sign In·View Thread·PermaLink good effort lxwde 15:52 10 Sep '07   but need to reformat the article ): Sign In·View Thread·PermaLink 3.00/5 (2 votes) nice mascix 14:46 10 Sep '07   good sum up there are already some articles for this situation. Sign In·View Thread·PermaLink 2.00/5 (1 vote) SubSonic Zachary Owens 4:04 8 Sep '07   Using SubSonic's MySQL provider would be MUCH easier. Sign In·View Thread·PermaLink 2.33/5 (6 votes)

Last Visit: 9:52 23 Nov '09     Last Update: 9:52 23 Nov '09 1