1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    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...