[[mysql|« MySQL Authentification Backend]]

====== Nucleus ======

This configuration worked for me with MySQL version 5 and Nucleus 3.24. //[[mischins@imi.uni-luebeck.de|Andreas Mischinski]] 2007-01-07 18:50//

<code php>
$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}'";
</code>