DokuWiki

It's better when it's simple

User Tools

Site Tools


plugin:authpdo:phpbb3

authPDO

phpBB3

Configuration for authPDO plugin to authenticate with open-source bulletin-board system phpBB.

Scenario

In this scenario, the intention is to permit the same users who are registered on the forum to make edits in the Wiki. The wiki is not open to all. Users must first register on the forum, after which they can log into the wiki as well using the same credentials.

In this example, the phpBB release is version 3.2, running on MySQL.

The Access Control List feature in DokuWiki can be used to restrict what users can do. The @ALL group can be given read access, while @<PHPBB-GROUPNAME> can be used to permit write access for example.

Note that this does not give a 'single sign-on' experience, but simply enables a user to have the same username/password on both phpBB and the DokuWiki installation.

Plugin Configuration

I could insert screenshots here, but do not have sufficient rights

In the AuthPDO section, configure the following:

plugin>authpdo>debug Checkbox – enable this for testing, otherwise disable
plugin>authpdo>dsn mysql:host=localhost;dbname=<DBNAME>;charset=utf8;
plugin>authpdo>user <DB-USERNAME>
plugin>authpdo>pass <DB-PASSWORD>
plugin>authpdo>select-user SELECT user_password AS hash, username AS name, username_clean AS user, user_email AS mail FROM phpbb_users WHERE username = :user
plugin>authpdo>check-pass SELECT group_name AS "group" FROM phpbb_groups, phpbb_users WHERE phpbb_groups.group_id = phpbb_users.group_id AND username = :name
plugin>authpdo>select-user-groups SELECT group_name AS "group" FROM phpbb_groups, phpbb_users WHERE phpbb_groups.group_id = phpbb_users.group_id AND username = :name
Other fields Leave empty

In the Authentication section:

authtype authpdo
passcrypt hmd5
defaultgroup users
superuser @ADMINISTRATORS
manager @ADMINISTRATORS
disableactions Uncheck everything to prevent users registering in DokuWiki
plugin/authpdo/phpbb3.txt · Last modified: 2018-04-30 14:22 by Aleksandr