跳至主要內容
WordPress.org

Taiwan 正體中文

  • 佈景主題目錄
  • 外掛目錄
  • 最新消息
  • 技術支援
  • 關於我們
  • 團隊
  • 取得 WordPress
取得 WordPress
WordPress.org

Plugin Directory

External Database Authentication Reloaded

  • 提交外掛
  • 我的最愛
  • 登入
  • 提交外掛
  • 我的最愛
  • 登入

這個外掛並未在最新的 3 個 WordPress 主要版本上進行測試。開發者可能不再對這個外掛進行維護或提供技術支援,並可能會與更新版本的 WordPress 產生使用上的相容性問題。

External Database Authentication Reloaded

由 Joshua Parker 開發
下載
  • 詳細資料
  • 使用者評論
  • 安裝方式
  • 開發資訊
技術支援

外掛說明

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.

螢幕擷圖

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 "Lost my password" retrieval attempt
Example “Lost my password” retrieval attempt

安裝方式

  • 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

常見問題集

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.

使用者評論

This is awesome

stevendbrady 2018 年 4 月 10 日
I used this plugin to authenticate my WordPress install (forum, trouble tickets, etc) to Midrub and it works perfectly.
閱讀全部 2 則使用者評論

參與者及開發者

以下人員參與了開源軟體〈External Database Authentication Reloaded〉的開發相關工作。

參與者
  • Joshua Parker

將〈External Database Authentication Reloaded〉外掛本地化為台灣繁體中文版

對開發相關資訊感興趣?

任何人均可瀏覽程式碼、查看 SVN 存放庫,或透過 RSS 訂閱開發記錄。

變更記錄

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

中繼資料

  • 版本 1.2.3
  • 最後更新 11 年前
  • 啟用安裝數 30+
  • WordPress 版本需求 3.1 或更新版本
  • 已測試相容的 WordPress 版本 4.2.39
  • 語言
    English (US)
  • 標籤:
    authenticationdatabaseloginMSSQLmysql
  • 進階檢視

評分

5 星,滿分為 5 星
  • 2 個 5 星使用者評論 5 星 2
  • 0 個 4 星使用者評論 4 星 0
  • 0 個 3 星使用者評論 3 星 0
  • 0 個 2 星使用者評論 2 星 0
  • 0 個 1 星使用者評論 1 星 0

Your review

查看全部使用者評論

參與者

  • Joshua Parker

技術支援

使用者可在技術支援論壇提出意見反應或使用問題。

檢視技術支援論壇

贊助

想要支援這個外掛的發展嗎?

贊助這個外掛

  • 關於我們
  • 最新消息
  • 主機代管
  • 隱私權
  • 展示網站
  • 佈景主題目錄
  • 外掛目錄
  • 區塊版面配置目錄
  • Learn
  • 技術支援
  • 開發者資源
  • WordPress.tv ↗
  • 共同參與
  • 活動
  • 贊助基金會 ↗
  • Five for the Future
  • WordPress.com ↗
  • Matt ↗
  • bbPress ↗
  • BuddyPress ↗
WordPress.org
WordPress.org

Taiwan 正體中文

  • 查看我們的 X (之前的 Twitter) 帳號
  • 造訪我們的 Bluesky 帳號
  • 造訪我們的 Mastodon 帳號
  • 造訪我們的 Threads 帳號
  • 造訪我們的 Facebook 粉絲專頁
  • Visit our Instagram account
  • Visit our LinkedIn account
  • 造訪我們的 TikTok 帳號
  • Visit our YouTube channel
  • 造訪我們的 Tumblr 帳號
程式碼,如詩
The WordPress® trademark is the intellectual property of the WordPress Foundation.