Version 8 (modified by carlgt1, 10 years ago) (diff)

modded the WordPress? external_db_auth plugin

WordPress CMS Integration with BOINC

WordPress is a popular Content Management System (CMS) for easily creating robust and feature-rich websites. It is ideal to use for a main website with or without integrating BOINC pages. It can be useful to have a basic WordPress website with no logins, but if a user logins they get more features from the website. Rather than having a separate WordPress user table, it is possible to authenticate using an external database table, such as the mysql database table 'users' in BOINC.

  • To setup WordPress to authenticate with your BOINC mysql 'user' table, install the external database authentication plugin
  • You will then want to 'Activate' this plug-in in your WordPress Plugins admin screen
  • In the Settings bar on the left side of your WordPress Dashboard screen, choose the 'External DB Settings' link
  • You will want to select the MySQL support, fill in your appropriate names for the database host, TCP port (if not the mysql default of 3306), username, password, and of course the BOINC mysql table name 'user'
  • in the External Database Source fields, you will want to make username "email_addr" (mapping the BOINC user table email_addr to the wordpress username - a record will be created in WordPress? to match these defaults).
  • for Password, put in "passwd_hash", and Password Encryption Method is "Other"
  • the Hash Code field should be "$password2 = md5($password . $username)". This is how WordPress? can create a password hash that the BOINC mysql 'user' table can authenticate.
  • Then for Homepage you can put the user's boinc "url" and Email is of course the BOINC user field "email_addr"
  • You may want to put in a special login message (not shown on the screenshot, but the last entry on the page) such as:
    Please use your BOINC account to sign in.  <BR>
    If you dont have one, please <a href="" target="blank" class="fancy_button">register!</a>

Screenshot: Screenshot of WordPress External DB Authentication

There is a modified version of this plugin attached to this page. It will allow you to add an authenticator field which will set a cookie named 'auth' for your website - so that it effectively will have an 'auto-login' via BOINC when coming to your site's BOINC pages from your WordPress? pages. The screenshot below shows how the plug-in screen looks with this mod (it just adds the authenticator field and sets the cookie upon a successful login).

Screenshot: screenshot of WordPress mod of ext_db_auth

Next will be how to port your WordPress? theme stylesheet to the BOINC stylesheets so the different sites look similar!

Attachments (3)

Download all attachments as: .zip