[TriLUG] mod_auth_mysql is mis_be_having

[Brian Henning]

Hi Guys,
   I'm sure it's my fault, but I can't figure out what I'm doing wrong. 
  Here's the relevant part from my httpd.conf, using the latest 
mod_auth_mysql version.

  AuthName "Strutmasters Internal Web"
  AuthType Basic
  AuthMySQLEnable On
  AuthMySQLHost localhost
  AuthMySQLUser *******
  AuthMySQLPassword *******
  AuthMySQLDB internal
  AuthMySQLUserTable auth
  AuthMySQLGroupTable groups
  AuthMySQLNameField username
  AuthMySQLPasswordField passwd
  AuthMySQLGroupField group
  AuthMySQLNoPasswd Off
  AuthMySQLPwEncryption md5
# AuthMySQLMD5Passwords On
# AuthMySQLUserCondition "locked = 'N'"
  AuthMySQLAuthoritative Off
  require group strutmasters
  AuthUserFile /var/www/.htpasswd
  AuthGroupFile /var/www/.htgroups

I've kept the AuthUserFile and AuthGroupFile directives in place because 
I want them for failover while I get mod_auth_mysql working/populated 
properly.

I've followed the CONFIGURE file pretty closely, so I'm really not sure 
what i'm doing wrong, but apache/mod_auth_mysql is not connecting to / 
querying mysql at all, as evidenced by watching the mysqld log file 
during auth attempts.

The error I'm seeing in httpd/error_log is "user fooby not found"..

Thanks, as always, for all the help.
Cheers,
~Brian