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? TIA gwesco
Do you have a line like this: Code: 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.