mod_auth_mysql on debian etch

Has anyone got mod_auth_mysql working on debian etch ?

It seems the the debian guys missed it out when they built etch, so I
have found a deb at:

http://packages.kirya.net/debian/pool/main/m/mod-auth-mysql/

and installed that, and setup apache to use it.

However, when I try to access the protected directory, I get refused
access, and the apache logs show a name not found error.

I've checked the mysql logs (I have general logging switched on for
debugging, so I can see any access) and it appears that it is not even
attempting to access the database.

Does anyone have any ideas ?

On Thu, 26 Mar 2009 08:34:01 +0000, John Taylor wrote:

> Has anyone got mod_auth_mysql working on debian etch ?
>
> It seems the the debian guys missed it out when they built etch, so I
> have found a deb at:
>
> http://packages.kirya.net/debian/pool/main/m/mod-auth-mysql/
>
> and installed that, and setup apache to use it.
>
> However, when I try to access the protected directory, I get refused
> access, and the apache logs show a name not found error.
>
> I've checked the mysql logs (I have general logging switched on for
> debugging, so I can see any access) and it appears that it is not even
> attempting to access the database.
>
> Does anyone have any ideas ?

Figured it out myself needed to add an extra line to apache config

AuthBasicAuthoritative Off

Now have:


<Location /protected>
AuthName "xxxxx"
AuthBasicAuthoritative Off
AuthMySQL on
AuthType Basic
AuthUserFile /dev/null

AuthMySQL_Authoritative on
AuthMySQL_Host localhost
AuthMySQL_User xxxxxxx
AuthMySQL_Password xxxxxxxxx
AuthMySQL_DB xxxxxxx
AuthMySQL_Password_Table xxxxxxx
AuthMySQL_Group_Table xxxxxxx
AuthMySQL_Username_Field xxxxxxx
AuthMySQL_Password_Field xxxxxxxxx
AuthMySQL_Group_Field xxxxxxxx
AuthMySQL_Group_User_Field xxxxxxx
AuthMySQL_Empty_Passwords Off
AuthMySQL_Encryption_Types PHP_MD5
AuthMySQL_Persistent on
#AuthMySQL_Allow_Override off
require group xxxxxxxxxx
</Location>