It's better when it's simple

User Tools

Site Tools


« MySQL Authentification Backend


User authentication with Phorum.

Tested on Phorum version 5.1.24b and DokuWiki version 2007-06-26b.
Update on 2008/12/07: works fine with Phorum 5.2.8 and DokuWiki 2008-05-05.

This assumes that all user accounts will be created and maintained through Phorum.

Do not forget to either create a “user” group in Phorum, or to add the name of the Phorum user group in the conf/acl.auth.php file.

Eventually, change the table prefix in the queries below (here it is phorum5).

$conf['auth']['mysql']['checkPass'] =
    "SELECT password AS pass
    FROM phorum5_users
    WHERE username='%{user}'
    AND password=MD5('%{pass}')";
$conf['auth']['mysql']['getUserInfo'] =
    "SELECT password AS pass, username AS name, email AS mail
    FROM phorum5_users
    WHERE username='%{user}'";
$conf['auth']['mysql']['getGroups'] =
    "SELECT name AS `group`
    FROM phorum5_groups g, phorum5_users u, phorum5_user_group_xref ug
    WHERE u.user_id = ug.user_id
    AND g.group_id = ug.group_id
    AND u.username='%{user}'
    AND ug.status='1'";

Yann Cochard 2007-11-22 22:22

auth/mysql_phorum.txt · Last modified: 2013-01-27 18:13 by ach

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki