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.

conf/local.protected.php

<?php
/**
 * Nuclues configuration for MySQL Auth Plugin
 * See https://www.dokuwiki.org/plugin:authmysql:nucleus 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}'";