Problem with Mod Auth MySQL Under Apache 2 and Debian

Discussion in 'HOWTO-Related Questions' started by gwesco, Dec 6, 2006.

  1. gwesco

    gwesco New Member

    I've had a server running for a year now built using the tutorial for the Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAssassin, ClamAV) and it works great.

    Recently I wanted to create a web page that my e-mail users could access using the Mod Auth MySQL Under Apache 2 and Debian howto.

    When I try to access the page, I get the login box, enter email and password and get a 500 error. I'm using the same mysql database that Postfix uses.

    A tail of the apache 2 error log shows this:
    Connection error: Access denied for user: '<mail_admin>@localhost' (Using password: YES)

    I can log in at the user level using the mail_admin user name and password.

    This is the end of my apache2.conf file:
    Auth_MySQL_Info <localhost> <mail_admin> <123456>

    This is my .htaccess file:

    AuthName "Log in Road Warriors"
    AuthType Basic
    AuthMySQL_Host localhost
    AuthMYSQL_DB mail
    AuthMYSQL_Password_Table users
    AuthMYSQL_Username_Field email
    AuthMYSQL_Password_Field password
    AuthMySQL On

    require valid-user

    Can anyone shed some light on why it's not allowing the mail_admin user to access the database?


  2. falko

    falko Super Moderator ISPConfig Developer

    Do you have a line like this:
    Auth_MySQL_Info localhost <auth_user> <password>
    in your Apache configuration? <auth_user> must be replaced with mail_admin and <password> with mail_admin's MySQL password.

Share This Page