[dokuwiki] Authenticating vs MySQL - bad credentials?

I'm having trouble authenticating against a MySQL database.
Been through the forum and the lists (and the wiki) and there's remarkably little here, so.... /sigh/ 

1. Added the users, groups, usergroup tables to a local MySQL database
2. Added one record to each of the tables. username and password are both 'al'. group name is 'admin'. I've checked to make sure the PKs and FKs are all matching (uid=1, gid= 1001) 

3. Added the require_once line to local.php.protected

4. Added the MySQL access credentials to mysql.conf.php

5. Set up MySQL to be clear passwords in mysql.conf.php:

$conf['auth']['mysql']['forwardClearPass'] = 1;
6. Logged into DW, switched authtype to MySQl, logged out, logged back in with 'al', 'al'. 

"Sorry, username or password are wrong."

Uh, just how much simpler could I have made it. :)
I've tried various permutations, like no password, or setting forwardClearPass to 0, but same results each time. 

7. I've also set MySQL debug up, via:

$conf['auth']['mysql']['debug'] = 1;

but I don't know where to look for the resulting (if any) error messages.

8. The only thing I can imagine that is wrong is that the call
SELECT pass FROM usergroup AS ug JOIN users AS u ON u.uid=ug.uid JOIN groups AS g ON g.gid=ug.gid 
WHERE login='%{user}' AND name='%{dgroup}'";
is incorrect. When I try it (substituting live data), I get an empty result set. 

Whil
--
DokuWiki mailing list - more info at
http://wiki.splitbrain.org/wiki:mailinglist

Other related posts: