• View
• Edit
• History
• Attach
• Print
• Backlinks

AuthPunBB

Questions answered by this recipe

How do I use a PunBB/FluxBB 1.3 database to authenticate users for PmWiki?

Prior Knowledge

If needed, please review the following topics before attempting to install and use this recipe.

• Passwords
• PasswordsAdmin
• AuthUser
• Security

Limitations

• This recipe does not explain how to coordinate cookies/sessions between PunBB/FluxBB and PmWiki. Users will be asked to log in separately to the forum and wiki.
• This recipe does not coordinate groups between PunBB/FluxBB and PmWiki. It only deals with users.

Testing

• This recipe has been tested with PunBB 1.3.2 and PmWiki 2.2.0-beta68. It is assumed to work with FluxBB 1.3, too, but this has NOT been tested!

Steps

Step 1 - Downloads

1. Download and install PmWiki.
2. Download and install PunBB. (Alternately, FluxBB should also work.)
3. Download ADOdb Lite and unpack into your cookbook folder. (Alternately, you can use the full ADOdb abstraction library, but this is probably overkill.)
4. Download the Database Standard Recipe and place in your cookbook folder.
5. Download the Authuser Database Recipe and place in your cookbook folder.

Step 2 - Config

Edit your config.php file to use all of this stuff! The following can be used as a template:

# optional, but handy for limiting groups
$GroupPattern = '(?:Site|SiteAdmin|PmWiki|Main|Profiles)';

# connection settings for database authentication
$Databases['punbb_db'] = array(
 'driver' => 'mysql', # what type of database?
 'hostname' => 'localhost', # what hostname? ...localhost should work for most people
 'database' => 'punbb_db', # what database?
 'username' => 'punbb_db_user', # what username?
 'password' => 'punbb_db_password'); # what password?

# path to adodb lite database library
$ADOdbLocation = '$FarmD/cookbook/adodb_lite/';

# variables used in authuserdbase
$AuthUserFunctions['mysql'] = 'AuthUserDatabase'; # should match driver from above
$AuthUser['mysql'] = true; # should match driver from above
$AUDBaseTable['database'] = 'punbb_db'; # should match array from above
$AUDBaseTable['user_table'] = 'punbb_users'; # what table for punbb users? (prefix punbb_ needs to match setup)
$AUDBaseTable['user_field'] = 'username'; # should be username for standard setup
$AUDBaseTable['pw_field']   = 'password'; # should be password for standard setup
$AUDBaseTable['salt_field']   = 'salt'; # should be salt for standard setup
$AUDBaseTable['encrypt_f'] = 'punbbpass'; # should match function name below

# function required for authentication using punbb database
function punbbpass($pasw)
{
	global $DB, $AUDBaseTable;
	$dbase = $AUDBaseTable['database'];
	$sf = $AUDBaseTable['salt_field'];
	$ut = $AUDBaseTable['user_table'];
	$uf = $AUDBaseTable['user_field'];
	$id = AUD_Safe($_POST['authid']);
	$out = ADOdbConnect($dbase);
  	if ($out !== TRUE) die($out);
	$result = $DB[$dbase]->Execute("SELECT " . $sf . " FROM " . $ut . " WHERE " . $uf . "=" . $id);
	return sha1($result->fields[$sf] . sha1($pasw));
}

# scripts used for database authentication
include_once ("$FarmD/cookbook/adodb-connect.php");
include_once ("$FarmD/cookbook/authuserdbase.php");
include_once("$FarmD/scripts/authuser.php");

$EnablePostAuthorRequired = 1; # require authors to provide a name
$Author = $AuthId; # force author name to match login name

Step 3 - Apply

Password protect pages. Typical use will involve appending ?action=attr to a page (or group) and using id:*. This will allow any authenticated user to edit, view, or change attributes for a particular page or group.

Limit who can edit pages of the Main group to users registered on your PunBB forum:

• http://www.somewebsite.com/wiki/Main/GroupAttributes?action=attr
• Add id:* to the edit section and save.

Limit who can edit a particular page (SomePage.html) to a particular registered user (Alice) on your PunBB forum:

• http://www.somewebsite.com/wiki/Main/SomePage.html?action=attr
• Add id:Alice to the edit section and save.

See Also

• AuthPhpBB2
• AuthPhpBB3
• Auth-SMF
• AuthPhpBBUsersAndGroups

Contributors

• I hope you find these instructions beneficial. Please email me if you find anything in error and I will try to figure it out. ~Kory December 29, 2008

Comments

• There could be a minor flaw in the recipe with regard to the "salting". I'm just not sure exactly how or when the "salt" database field gets used by PunBB. For my setup, simply setting the salt to '' seems to work. ~Kory December 29, 2008
  • Okay, I think I have the salting working. ~Kory January 30, 2009

* (+) Optional positive comment. Name, date
* (-) Optional negative comment. Name, date