Thread: mod_auth_mysql?

  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Rep Power
    Where can I get mod_auth_mysql? This address goes no where "File Not Found"

    I need to get this working desperatly. I did find the RPM on rpmfind and it seems to have installed properly in that it doesn't crash my server. But, when I try to go to a directory that I want password protected it gives me an Internal Server error.

    I have the following lines in my httpd.conf:
    LoadModule mysql_auth_module /usr/lib/apache/
    AddModule mod_auth_mysql.c

    The server starts without any errors. My .htaccess file looks like this:

    Auth_MySQL_Info 'localhost' '<user>' '<pass>'
    Auth_MySQL_DB dbEnrolment
    Auth_MySQL_Password_Table tblLecturer
    Auth_MySQL_Username_Field cUserName
    Auth_MySQL_Password_Field cPassword
    AuthType Basic
    AuthName "admin site"
    require valid-user

    The Server error is:
    Invalid command 'Auth_MySQL_Info', perhaps mis-spelled or defined by a module not included in the server configuration

    and that error comes up on every command I put in to do with MySQL_auth not just Info.

    If you can tell me what is wrong then I will be extremly grateful.
  2. #2
  3. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    >>This address goes no where "File Not Found"

    Right, the author disappeared. Try here ->

    >>I did find the RPM on rpmfind and it seems to have installed properly

    Forget about RPM as it's not flexible enough and mod_auth_mysql is highly configurable.

    >>it doesn't crash my server

    That doesn't mean your module is functioning as it should.

    >>My .htaccess file looks like this:
    Auth_MySQL_Info 'localhost' '<user>' '<pass>'

    According to USAGE file enclosed with mod_auth_mysql:

    Auth_MySQL_Info <host> <user> <password>
    This information can *only* be specified in the server's httpd.conf, since it's used server-wide.

    So for debugging purpose, put that in your httpd.conf somewhere in the middle or bottom, NOT inside a <IfModule mod_auth_mysql.c> block. Then restart Apache "apachectl graceful". If it says some error about that line, then too bad, your mod_auth_mysql is not functioning and you have to uninstall it and compile it from source.

    Anyway, you should grab the tarball from sourceforge, extract it and take a look at the USAGE file.

IMN logo majestic logo threadwatch logo seochat tools logo