• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

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

B

billsutton

Guest
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
 
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
 
Back
Top