A plugin that allows the use of an external database (MySQL, PostgreSQL, MSSQL, and more) for authentication into WordPress.
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:
external-db-auth-reloaded
folder to the /wp-content/plugins/
directorySometimes 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);
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.
You could, but they don’t work properly as it’s only checking the external database for login accounts.
No.
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.
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.