Re: Connector/Net will not install. Problem with WebProvider
Hi, first let me show you a workaround:
1. From
http://dev.mysql.com/downloads/connector/net/, pick ".NET & Mono" and get the zip
2. Install the MySql.Web.dll manually into GAC with "gacutil -l MySql.Web.dll" from a Visual Studio prompt (with admin rights).
3. Edit your machine.config to include the providers like this.
<system.web>
<processModel autoConfig="true" />
<httpHandlers />
<membership>
<providers>
<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="LocalSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression="" />
<add name="AspNetMySqlMembershipProvider" type="Devart.Data.MySql.Web.Providers.MySqlMembershipProvider, Devart.Data.MySql.Web, Version=7.6.257.0, Culture=neutral, PublicKeyToken=09af7300eec23701" description="dotConnect for MySQL membership provider" connectionStringName="MySqlServices" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" requiresUniqueEmail="false" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" />
<add name="MySqlExtendedMembershipProvider" type="Devart.Data.MySql.Web.Providers.MySqlExtendedMembershipProvider, Devart.Data.MySql.Web, Version=7.6.257.4, Culture=neutral, PublicKeyToken=09af7300eec23701" description="dotConnect for MySQL extended membership provider" connectionStringName="MySqlServices" useridcolumn="UserId" usernamecolumn="UserName" usertablename="UserProfile" />
<add name="MySQLMembershipProvider" type="MySql.Web.Security.MySQLMembershipProvider, MySql.Web, Version=6.8.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="false" passwordFormat="Clear" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression="" />
</providers>
</membership>
<profile>
<providers>
<add name="AspNetSqlProfileProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Profile.SqlProfileProvider, System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add name="AspNetMySqlProfileProvider" type="Devart.Data.MySql.Web.Providers.MySqlProfileProvider, Devart.Data.MySql.Web, Version=7.6.257.0, Culture=neutral, PublicKeyToken=09af7300eec23701" description="dotConnect for MySQL profile provider" connectionStringName="MySqlServices" />
<add name="MySQLProfileProvider" type="MySql.Web.Profile.MySQLProfileProvider, MySql.Web, Version=6.8.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" applicationName="/" />
</providers>
</profile>
<roleManager>
<providers>
<add name="AspNetSqlRoleProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Security.SqlRoleProvider, System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add name="AspNetWindowsTokenRoleProvider" applicationName="/" type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add name="AspNetMySqlRoleProvider" type="Devart.Data.MySql.Web.Providers.MySqlRoleProvider, Devart.Data.MySql.Web, Version=7.6.257.0, Culture=neutral, PublicKeyToken=09af7300eec23701" description="dotConnect for MySQL role provider" connectionStringName="MySqlServices" />
<add name="MySqlExtendedRoleProvider" type="Devart.Data.MySql.Web.Providers.MySqlExtendedRoleProvider, Devart.Data.MySql.Web, Version=7.6.257.4, Culture=neutral, PublicKeyToken=09af7300eec23701" description="dotConnect for MySQL extended role provider" connectionStringName="MySqlServices" useridcolumn="UserId" usernamecolumn="UserName" usertablename="UserProfile" />
<add name="MySQLRoleProvider" type="MySql.Web.Security.MySQLRoleProvider, MySql.Web, Version=6.8.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" applicationName="/" />
</providers>
</roleManager>
<siteMap>
<providers>
</providers>
</siteMap>
<webParts>
<personalization>
<providers>
</providers>
</personalization>
</webParts>
</system.web>
*** My opinions do not necessarily reflect the opinions of my employeer ***
Fernando Gonzalez Sanchez
Sr. Software Engineer
MySql Connector/NET Team
Oracle Corporation