Dear list,
I've been using mod_auth_mysql for a couple of years with Apache 1.3 and 2.0 and it has been a great help for me ever since.
Now I've had to change to SuSE 10.1 which is shipped with Apache 2.2 and this is where the trouble starts:
Whenever I try to access a part of the site that is mod_auth_mysql protected through a .htaccess configuration, Apache throws a 500 Internal Server Error, complaining:
[Sat Jul 15 17:20:02 2006] [error] Internal error: pcfg_openfile() called with NULL
filename
[Sat Jul 15 17:20:02 2006] [error] [client 84.190.46.89] (9)Bad file descriptor: Could
not open password file: (null)
I then tried to add a
AuthUserFile /dev/null
which stopped Apache to complain but wouldn't let a single user pass through (probably
because /dev/null doesn't contain any users ;) ).
I then read that Apache 2.2 requires the AuthBasicProvider directive in order to work,
but neither options like "mysql", "dbi" or "dbd" worked.
Furthermore, I cannot (and don't want to) switch to mod_authn_dbd because it doesn't come with MySQL support precompiled with SuSE 10.1. It's DBDriver directive throws an error saying that "mysql" is unknown :(, same goes for pgsql etc.
So if you have any hint how I could get MySQL authentification working again under Apache 2.2, your help your be highly appreciated!
Regards,
Frederik.
Here's my .htaccess configuration that used to work under Apache 2.0:
AuthName Sicherheitsbereich
AuthUserFile /dev/null
AuthType Basic
AuthMySQLAuthoritative on
AuthMySQLPwEncryption crypt
AuthMySQLHost localhost
AuthMySQLUser vfb
AuthMySQLPassword ***********
AuthMySQLDB vfb
AuthMySQLUserTable Ansprechpartner
AuthMySQLNameField Username
AuthMySQLPasswordField Password
require valid-user
