Usando MySQL Membership con VisualStudio 2010 framework 4
Normalmente usamos el Membership Provider en nuestro proyectos con MsSQL, y de hecho es realmente facil hacerlo. Pero que pasa si nuestro proyecto va a usar una base de datos como MySQL?. En este lio me meti yo y pues aqui espero ilustra como lo solucione. Lo primero que tenemos que hacer es descargar la última versión del driver de MySQL http://bit.ly/LSftdo Nos toparemos con esta ventana
Una vez descargado, procedemos a instalar.
Al terminar el proceso, si entramos a Windows/assembly y encontramos lo siguiente:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 |
<span style="font-family: Consolas, Monaco, Courier, monospace; font-size: 11px; line-height: 16px; white-space: normal;">[php] <pre><connectionStrings> <remove name="LocalMySqlServer" /> <add name="LocalMySqlServer" connectionString="server=localhost;User Id=root;Password=*****;Persist Security Info=True;database=dbejemplonet" providerName="MySql.Data.MySqlClient" /> connectionStrings></pre> [/php] <span style="font-family: Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif; font-size: 13px; line-height: 19px;"> Luego agregamos el código del Membership Provider, Profile Provider y Role Provider. Recuerda verificar bien el string de conexión.</span> [php] <membership defaultProvider="MySqlMembershipProvider"><providers><clear /> <add name="MySqlMembershipProvider" type="MySql.Web.Security.MySQLMembershipProvider, MySql.Web,Version=6.5.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="true" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" applicationName="/" autogenerateschema="true" /> </providers> </membership> <profile> <providers> <clear /> <add type="MySql.Web.Security.MySQLProfileProvider,MySql.Web,Version=6.5.4.0,Culture=neutral,PublicKeyToken=c5687fc88969c44d" name="MySqlProfileProvider" applicationName="/" connectionStringName="LocalMySqlServer" autogenerateschema="true" /> </providers> </profile> <roleManager enabled="true" defaultProvider="MySqlRoleProvider"> <providers> <clear /> <add connectionStringName="LocalMySqlServer" applicationName="/" name="MySqlRoleProvider" type="MySql.Web.Security.MySQLRoleProvider,MySql.Web,Version=6.5.4.0,Culture=neutral,PublicKeyToken=c5687fc88969c44d" autogenerateschema="true" /> </providers> </roleManager> [/php] <span style="font-family: Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif; font-size: 13px; line-height: 19px;"> Recuerda verificar la versión del controlador de MySql sea igual a la instalada, para mi caso es la 6.5.4.</span> </span> <span style="font-family: Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif; font-size: x-small;"><span style="line-height: 19px; white-space: normal;">Ahora debemos abrir el archivo machine.config como administrador (para tener permiso de modifcarlo) </span></span><em><span style="font-size: 10pt; line-height: 115%; font-family: Verdana, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: white; background-position: initial initial; background-repeat: initial initial;">C:WINDOWSMicrosoft.NETFrameworkv4.0.30319CONFIG</span></em><span style="font-size: 10pt; line-height: 115%; font-family: Verdana, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: white;">". En la parte de conexión (connection string) agregamos el siguiente código</span> <span style="font-size: 10pt; line-height: 115%; font-family: Verdana, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: white;"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><span style="line-height: 115%;"> </span></span><span style="font-family: Verdana, sans-serif; font-size: x-small;"><span style="line-height: 115%;"> </span></span> <pre style="font-family: Verdana, sans-serif; font-size: 10pt; line-height: 115%;"> <pre style="font-family: Verdana, sans-serif; font-size: 10pt; line-height: 115%;"> <pre style="font-family: Verdana, sans-serif; font-size: 10pt; line-height: 115%;">[php]</pre> <add name="LocalMySqlServer" connectionString="Datasource=localhost; uid=root; Pwd=******; Database=dbejemplonet;"/> </span> <pre>[/php] <span style="line-height: 115%; font-family: Verdana, sans-serif; font-size: x-small;"><span style="line-height: 115%;"> </span></span><span style="font-family: Verdana, sans-serif; font-size: x-small;"><span style="line-height: 115%;"> </span></span><span style="font-family: Consolas, Monaco, Courier, monospace; font-size: 11px; line-height: 16px; white-space: normal;"><span style="font-family: Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif; font-size: 13px; line-height: 19px;"><span style="font-family: Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif; font-size: x-small;"><span style="line-height: 19px; white-space: normal;">En el mismo archivo machine.config verificamos que este apuntando al mismo connectionStringName, no elimines los otros que ya puedan existir. Esto quedaría mas o menos así:</span></span></span></span><span style="line-height: 115%; font-family: Verdana, sans-serif; font-size: x-small;"><span style="line-height: 115%;"> </span></span><span style="font-size: 10pt; line-height: 115%; font-family: Verdana, sans-serif; background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: white;"><span style="font-family: Consolas, Monaco, Courier, monospace; font-size: 11px; line-height: 16px; white-space: normal;"><span style="font-family: Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif; font-size: 13px; line-height: 19px;"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><span style="line-height: 115%;"> </span></span> <pre style="font-family: Verdana, sans-serif; font-size: 10pt; line-height: 14px;"> <pre style="font-family: Verdana, sans-serif; font-size: 10pt; line-height: 14px; white-space: normal;">[php]</pre> 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="MySQLMembershipProvider" autogenerateschema="true" type="MySql.Web.Security.MySQLMembershipProvider, MySql.Web, Version=6.5.4.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="MySQLProfileProvider" type="MySql.Web.Profile.MySQLProfileProvider, MySql.Web, Version=6.5.4.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="MySQLRoleProvider" type="MySql.Web.Security.MySQLRoleProvider, MySql.Web, Version=6.5.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" applicationName="/"/> </providers> </roleManager> <pre>[/php] <span style="font-family: Verdana, sans-serif; font-size: x-small;"><span style="line-height: 14px; white-space: normal;">Una vez terminada esta tarea, vamos a nuestro proyecto, e ingresamos al ASP.NET Configuration (en la barra del </span><span style="line-height: 14px;">menú</span><span style="line-height: 14px; white-space: normal;"> como lo muestra la imagen siguiente) </span></span> |

1 2 |
<span style="font-size: 11.0pt; line-height: 115%; font-family: &amp;amp; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: &amp;amp; mso-bidi-theme-font: minor-bidi; mso-ansi-language: ES; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;">El abrirá una pagina como la siguiente donde si todo quedo bien, se podrán agregar los usuarios, roles y reglas de acceso</span><span style="color: #0000ee;"><span style="text-decoration: underline;"> </span></span> |
1 2 3 |
<a style="font-family: Verdana, sans-serif; font-size: 10pt; line-height: 115%;" href="https://smartrabbit.co/wp-content/uploads/2012/05/administrator.png"><img class="aligncenter size-large wp-image-487" title="administrator" src="https://smartrabbit.co/wp-content/uploads/2012/05/administrator-1024x551.png" alt="" width="614" height="331" /></a><span style="font-family: Verdana, sans-serif; font-size: x-small;"><span style="line-height: 115%;"> </span></span> <pre style="font-family: Verdana, sans-serif; font-size: 10pt; line-height: 14px;"><span style="font-size: 11.0pt; line-height: 115%; font-family: &amp;amp; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: &amp;amp; mso-bidi-theme-font: minor-bidi; mso-ansi-language: ES; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;"><span style="font-family: Calibri, sans-serif;"><span style="font-size: 11pt; line-height: 17px;">Si </span><span style="font-size: 15px; line-height: 17px;">revisamos</span><span style="font-size: 11pt; line-height: 17px;"> nuestra base de datos </span><span style="font-size: 15px; line-height: 17px;">encontraremos</span><span style="font-size: 11pt; line-height: 17px;"> todas las tablas creadas por la plataforma de forma </span><span style="font-size: 15px; line-height: 17px;">automática</span></span></span> |
1 2 |
<span style="font-family: Calibri, sans-serif;"><span style="font-size: 15px; line-height: 17px;"> </span></span><span style="font-size: 11.0pt; line-height: 115%; font-family: &amp;amp; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: &amp;amp; mso-bidi-theme-font: minor-bidi; mso-ansi-language: ES; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;"><span style="font-family: Calibri, sans-serif;"><span style="font-size: 15px; line-height: 17px;"><a href="https://smartrabbit.co/wp-content/uploads/2012/05/tablas.png"><img class="aligncenter size-full wp-image-488" title="tablas" src="https://smartrabbit.co/wp-content/uploads/2012/05/tablas.png" alt="" width="191" height="242" /></a></span><span style="font-size: 11pt; line-height: 17px;">.</span></span></span> |
1 |
<span style="font-size: 11.0pt; line-height: 115%; font-family: &amp;amp; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: &amp;amp; mso-bidi-theme-font: minor-bidi; mso-ansi-language: ES; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;"><span style="font-family: Calibri, sans-serif;"><span style="font-size: 11pt; line-height: 17px;">Espero que este post les sea de utilidad :-)</span></span></span> |
Etiquetas:.net, asp.net, configurar mysql, framework4, membership provider, microsoft, visual studio, vs2010, web.config, windows
"Trackback" Enlace desde tu web.
-
TerAnonimo