It's better when it's simple

User Tools

Site Tools


Translations of this page?:

Learn about DokuWiki

Advanced Use

Corporate Use

Our Community

Follow us on Facebook, Twitter and other social networks.

Our Privacy Policy


« MySQL Authentification Backend


This configuration worked for me with MySQL version 5 and Nucleus 3.24. Andreas Mischinski 2007-01-07 18:50

$conf['auth']['mysql']['checkPass']= "SELECT mpassword AS login
                                        FROM nucleus_member
                                        WHERE mname='%{user}'
                                        AND mpassword=MD5('%{pass}')";
$conf['auth']['mysql']['getUserInfo'] = "SELECT mpassword AS pass, mname AS name, memail AS mail
                                        FROM nucleus_member
                                        WHERE mname='%{user}'";
$conf['auth']['mysql']['getGroups']   = "SELECT bname as `group`
                                        FROM nucleus_blog a, nucleus_member b, nucleus_team c
                                        WHERE b.mnumber = c.tnumber
                                        AND a.bnumber = c.tblog
                                        AND b.mname='%{user}'";
auth/mysql_nucleus.txt · Last modified: 2011-03-22 17:28 by Aleksandr