1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

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

Discussion in 'Plesk for Linux - 8.x and Older' started by billsutton, Nov 19, 2005.

  1. billsutton

    billsutton Guest

    0
     
    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
     
  2. billsutton

    billsutton Guest

    0
     
    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
     
Loading...