Title: External Database Authentication Reloaded Author: Joshua Parker Published: 5 de noviembre de 2012 Last modified: 31 de mayo de 2015 --- Buscar plugins Este plugin **no se ha probado con las últimas 3 versiones mayores de WordPress**. Puede que ya no tenga soporte ni lo mantenga nadie, o puede que tenga problemas de compatibilidad cuando se usa con las versiones más recientes de WordPress. ![](https://s.w.org/plugins/geopattern-icon/external-db-auth-reloaded.svg) # External Database Authentication Reloaded Por [Joshua Parker](https://profiles.wordpress.org/parkerj/) [Descargar](https://downloads.wordpress.org/plugin/external-db-auth-reloaded.1.2.3.zip) * [Detalles](https://es.wordpress.org/plugins/external-db-auth-reloaded/#description) * [Valoraciones](https://es.wordpress.org/plugins/external-db-auth-reloaded/#reviews) * [Instalación](https://es.wordpress.org/plugins/external-db-auth-reloaded/#installation) * [Desarrollo](https://es.wordpress.org/plugins/external-db-auth-reloaded/#developers) [Soporte](https://wordpress.org/support/plugin/external-db-auth-reloaded/) ## Descripción _Please Note: When you update to version 1.2.1, you will need to re-enter the details on the settings page._ This External DB Authentication plugin allows the use of an external MySQL, PostgreSQL, MSSQL, Sybase, Oracle, or SQLite database for authentication into WordPress. It is required that you know the encryption method for the passwords stored in the external database. Password encryption methods include MD5, SHA1, plaintext, PHPass, or enter a custom hash/salt method. It disables password reset/retrieval and account creation within the WordPress system on the user-end, and it doesn’t allow updating from the WordPress end back into the external authentication source. In addition to authentication, the plugin allows you to: * Choose additional fields, such as first name/last name and website, to be imported into WordPress. * Enter a custom message for users concerning logins. * Do user role checks from the external database: you can set the plugin to check from a specific role field and compare to a value to allow login to WordPress. ## Capturas [⌊Plugin config screen⌉⌊Plugin config screen⌉[ Plugin config screen [⌊Example login warning message upon access to wp-login.php⌉⌊Example login warning message upon access to wp-login.php⌉[ Example login warning message upon access to wp-login.php [⌊Example "Lost my password" retrieval attempt⌉⌊Example "Lost my password" retrieval attempt⌉[ Example «Lost my password» retrieval attempt ## Instalación * Prepare your WP admin account on your external database: create an admin account in your external system. * Change «New User Default Role» in Settings->General, if desired, to whatever level of control you wish external authenticated users to have. * Upload `external-db-auth-reloaded` folder to the `/wp-content/plugins/` directory * Activate the plugin through the ‘Plugins’ menu in WordPress * Enter your external database settings in Settings->External DB settings ## FAQ How do I use the «Other» encryption method? Sometimes you will need to use «Other» as an encryption method when all other methods do not meet your specific need. When you find yourself in this situation, you will need to add your own custom code into the «Hash Code» input field. You have access to the following variables: `$password2`, `$username`, `$password`. `$username` and `$password` are the info needed from your external database. Now let’s say for example I am using a system that combines the username and password and then hashes it with `md5`. In the «Hash Code» input field, I would need to enter the following custom code: ``` $password2 = md5($username.$password); ``` My admin account for WP doesn’t work anymore! We’re authenticating externally, right? Make sure the admin account username in the external source, matches the admin username in WordPress. Once it’s in there you’ll be able to log in as admin with no problems. If you can’t do this, delete the plugin and it’ll restore access using your WP admin account. Can I still create accounts within WordPress? You could, but they don’t work properly as it’s only checking the external database for login accounts. Can I update user information within WordPress? No. My external database’s passwords are hashed with a salt/datestamp/phases of the moon/etc Choose «Other» as your encoding method, then enter the method you use in the «Other» textbox as PHP code. If it involves more than the username and password, though, you may need to modify the plugin source code. I’m locked out! Delete or rename the plugin; if it’s a DB connection-related error most likely you have the wrong connection, etc. information for the external database. ## Reseñas ![](https://secure.gravatar.com/avatar/73859b13dc19adb2270f1f0915dcc7f803a79733afb190128c81fd6ce08e5365? s=60&d=retro&r=g) ### 󠀁[This is awesome](https://wordpress.org/support/topic/this-is-awesome-79/)󠁿 [stevendbrady](https://profiles.wordpress.org/stevendbrady/) 10 de abril de 2018 I used this plugin to authenticate my WordPress install (forum, trouble tickets, etc) to Midrub and it works perfectly. [ Leer todas las 2 reseñas ](https://wordpress.org/support/plugin/external-db-auth-reloaded/reviews/) ## Colaboradores y desarrolladores «External Database Authentication Reloaded» es un software de código abierto. Las siguientes personas han colaborado con este plugin. Colaboradores * [ Joshua Parker ](https://profiles.wordpress.org/parkerj/) [Traduce «External Database Authentication Reloaded» a tu idioma.](https://translate.wordpress.org/projects/wp-plugins/external-db-auth-reloaded) ### ¿Interesado en el desarrollo? [Revisa el código](https://plugins.trac.wordpress.org/browser/external-db-auth-reloaded/), echa un vistazo al [repositorio SVN](https://plugins.svn.wordpress.org/external-db-auth-reloaded/) o suscríbete al [registro de desarrollo](https://plugins.trac.wordpress.org/log/external-db-auth-reloaded/) por [RSS](https://plugins.trac.wordpress.org/log/external-db-auth-reloaded/?limit=100&mode=stop_on_copy&format=rss). ## Registro de cambios #### 1.2.3 (2015-05-30) * Fixed existing external user check * Fixed error log path * Added SHA256 encryption method * Added password hash checking based on selected encryption method #### 1.2.2 (2015-05-29) * Updated code to support PHP version lower than 5.4.x * Added example of how to use «Other» encryption method under FAQ’s #### 1.2.1 (2015-05-28) * Added error logging; logs will be located in wp-content directory * You will need to re-enter your settings after you upgrade to this version * Now uses PDO for database connection * Now supports MySQL, MSSQL, PostgreSQL, Sybase, Oracle and SQLite databases out of the box * Plugin can now be translated into other languages #### 1.2.0 (2015-05-14) * Fixed mysqli database connection #### 1.1 (2013-01-15) * One setting wasn’t registered * Fixed issues with «Other» option encryption type * Added SQL query for «Other» option encryption type * Should now work with plaintext passwords #### 1.0 (2012-10-31) * Bug Fixes * Updated Code * Added the option to use PHPass as an encryption type ## Meta * Versión **1.2.3** * Última actualización **hace 11 años** * Instalaciones activas **30+** * Versión de WordPress ** 3.1 o superior ** * Probado hasta **4.2.39** * Idioma * [English (US)](https://wordpress.org/plugins/external-db-auth-reloaded/) * Etiquetas: * [authentication](https://es.wordpress.org/plugins/tags/authentication/)[database](https://es.wordpress.org/plugins/tags/database/) [login](https://es.wordpress.org/plugins/tags/login/)[MSSQL](https://es.wordpress.org/plugins/tags/mssql/) [mysql](https://es.wordpress.org/plugins/tags/mysql/) * [Vista avanzada](https://es.wordpress.org/plugins/external-db-auth-reloaded/advanced/) ## Valoraciones 5 de 5 estrellas. * [ 2 valoraciones de 5 estrellas ](https://wordpress.org/support/plugin/external-db-auth-reloaded/reviews/?filter=5) * [ 0 valoraciones de 4 estrellas ](https://wordpress.org/support/plugin/external-db-auth-reloaded/reviews/?filter=4) * [ 0 valoraciones de 3 estrellas ](https://wordpress.org/support/plugin/external-db-auth-reloaded/reviews/?filter=3) * [ 0 valoraciones de 2 estrellas ](https://wordpress.org/support/plugin/external-db-auth-reloaded/reviews/?filter=2) * [ 0 valoraciones de 1 estrellas ](https://wordpress.org/support/plugin/external-db-auth-reloaded/reviews/?filter=1) [Tu valoración](https://wordpress.org/support/plugin/external-db-auth-reloaded/reviews/#new-post) [Ver todas las reseñas](https://wordpress.org/support/plugin/external-db-auth-reloaded/reviews/) ## Colaboradores * [ Joshua Parker ](https://profiles.wordpress.org/parkerj/) ## Soporte ¿Tienes algo que decir? ¿Necesitas ayuda? [Ver el foro de soporte](https://wordpress.org/support/plugin/external-db-auth-reloaded/) ## Donar ¿Te gustaría apoyar el progreso de este plugin? [ Dona a este plugin ](http://none)