• Halloween is coming! To celebrate the occasion, we dusted off a couple of old skins, and even created a brand new one (Pixel).
    To get into the festive spirit, install the Skins extension.
  • The new Python extension is now available. It allows customers to deploy and manage WSGI-based Python applications on their websites directly from Plesk.
  • The Plesk Mobile apps for iOS and Android and the Plesk Mobile Center extension have been deprecated, and are no longer available for new installations. In Plesk Obsidian 18.0.84, the Plesk Mobile Center extension will be removed from servers during the upgrade, and the Plesk Mobile apps will lose their server management features.
  • The Social Login extension has been deprecated and will be removed in Plesk Obsidian 18.0.84. After that, it will no longer be possible to log in to Plesk with a Google, Facebook, GitHub account, or with a passkey. Plesk usernames and passwords, as well as logging in with a WebPros Account, are not affected.

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
 
You must log in or register to reply here.

Similar threads

P
Problems install mod_security on Centos 4
Replies
0
Views
3K
panaman
P
madsere
Yum update fails
Replies
8
Views
5K
madsere
madsere
Back
Top