mod-auth-mysql problems on Plesk7.5.4 & RHEL 4

[billsutton]

I cannot get mod_auth_mysql to authenticate on Plesk 7.5.4 RHEL4 MySQL4. It just gives "access to /member/Members_Area.html failed, reason: user myuser not allowed access". This is working ok on another server in Plesk 7.5.2 (RHEL3 MySQL3). I added mod_auth_mysql as follows:

Downloaded
httpd-devel-2.0.52-12.2.ent.i386.rpm
apr-devel-0.9.4-24.1.i386.rpm
apr-util-devel-0.9.4-17.i386.rpm
pcre-devel-4.5-3.2.RHEL4.i386.rpm
db4-devel-4.2.52-7.1.i386.rpm
expat-devel-1.95.7-4.i386.rpm
openldap-devel-2.2.13-2.i386.rpm
cyrus-sasl-devel-2.1.19-5.EL4.i386.rpm

rpm -i httpd-devel-2.0.52-12.2.ent.i386.rpm apr-devel-0.9.4-24.1.i386.rpm apr-util-devel-0.9.4-17.i386.rpm

pcre-devel-4.5-3.2.RHEL4.i386.rpm db4-devel-4.2.52-7.1.i386.rpm expat-devel-1.95.7-4.i386.rpm openldap-devel-2.2.13-2.i386.rpm

cyrus-sasl-devel-2.1.19-5.EL4.i386.rpm

Downloaded
zlib-devel-1.2.1.2-1.2.i386.rpm
rpm -i zlib-devel-1.2.1.2-1.2.i386.rpm

Downloaded
mod_auth_mysql-3.0.0.tar.gz from http://sourceforge.net/projects/modauthmysql/
tar xvzf mod_auth_mysql-3.0.0.tar.gz
/usr/sbin/apxs -c -L/usr/lib/mysql -I/usr/include/mysql -lmysqlclient -lm -lz mod_auth_mysql.c

/usr/sbin/apxs -i mod_auth_mysql.la

Added it to /etc/httpd/conf/httpd.conf:
LoadModule mysql_auth_module modules/mod_auth_mysql.so

There are no log errors that I can find.

The .htaccess is like:
AuthName "Member Area"
AuthType Basic
AuthGroupFile /dev/null
AuthMySQLEnable On
AuthMySQLAuthoritative On
AuthMySQLHost localhost
AuthMySQLDB (mydatabase)
AuthMySQLUser (dbuser)
AuthMySQLPassword (dbpasswd)
AuthMySQLUserTable (dbtable)
AuthMySQLGroupField groups
AuthMySQLNameField username
AuthMySQLPasswordField passwd
require group member

If I enter an invalid user I get the error on the log:
MySQL user xxxx not found: /member/Members_Area.html, referer: http://mydomain.com/

Any ideas ?

Bill

 

[billsutton]

Found the problem !!

I removed the "AuthGroupFile /dev/null".
It doesn't bother my plesk 7.5.2 server but doesn't allow the "require group" to work on my plesk 7.5.4 server.

Bill