• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • 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.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

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