It's better when it's simple

User Tools

Site Tools



Configuration for authMySQL Auth plugin to connect to Nucleus, which let's do:

  • Only basic authentication
  • No user modification/adding.

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


Use the Config Manager or add it to the conf/local.protected.php to store the config protected.

 * Nuclues configuration for MySQL Auth Plugin
 * See for details and explanation
// Activate MySQL auth plugin
$conf['authtype'] = "mysql";
$conf['plugin']['authmysql']['checkPass']   = "SELECT mpassword AS login
                                               FROM nucleus_member
                                               WHERE mname='%{user}'
                                                 AND mpassword=MD5('%{pass}')";
$conf['plugin']['authmysql']['getUserInfo'] = "SELECT mpassword AS pass, mname AS name, memail AS mail
                                               FROM nucleus_member
                                               WHERE mname='%{user}'";
$conf['plugin']['authmysql']['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}'";
plugin/authmysql/nucleus.txt · Last modified: 2013-02-10 15:11 by Klap-in

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