Failing to start Apache

[Oliver Cole]

I put the:

LoadModule mysql_auth_module modules/mod_auth_mysql.so

line in, and it started warning:

Starting httpd: [Wed Oct 20 16:39:36 2004] [warn] module mysql_auth_module is already loaded, skipping

So we agree that the module is loaded?
OK, when I put "AuthMySQLEnable on" directive in my httpd.conf file I get this error:

Invalid command 'Auth_MySQL_User', perhaps mis-spelled or defined by a module not included in the server configuration

indicating that it isn't loaded... whats going on?

thanks,
Oli

[Oliver Cole]

aha, fixed this... but now Apache breaks on trying to access a protected directory.

I have this in a .htaccess file:

AuthName "MySql Managed Area"
AuthType Basic
require user oli

and when I try to retrieve a file in the directory, I get a 500 (Internal Server Error), and this in the error_log:

configuration error:  couldn't check user.  No user file?: /test/foo.html

How do I fix this?

thanks,
Oli

[Jerry Stuckle]

Oli,

You have two problems.

First of all, the correct statement is "AuthMySQLUser" - no underscores.  Apache is correct in that how you have it defined is incorrect.

The second problem is most probably a configuration error.  Unless you have enabled mod_auth_mysql automatically when you compile it (along with all other necessary parameters),  you must enable it here.

Even then the request will fail if mod_auth_mysql doesn't find the correct user information and you have AuthMySQLAuthoritative set to (or defaulted to) OFF.  In this case, if mod_auth_mysql doesn't find the user, Apache will pass the request on to mod_auth, which is looking for the user file.

Please reread the README file, and if there are areas that are unclear, please let me know so I can update them for the next release.  Writing doc is not my specialty! <G>

Jerry