View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0000010||Apache 2.x||public||2006-04-17 11:35||2022-09-24 10:42|
|Status||resolved||Resolution||no change required|
|Summary||0000010: mod_auth_mysql not working|
|Description||Configured mod_auth_mysql module and set up database and table in MySQL and gave permissions for database for the mod_auth_musql user.|
It does not give any error messages about mysql connectivity but appears to be trying to use non mysql auth.
Tried using .htaccess for the configuration as well as putting the config in httpd.conf, neither case worked.
If config stuff in .htaccess the the following error message in apache error_log
[Mon Apr 10 21:14:50 2006] [error] [client 192.168.0.61] client denied by server configuration: D:/gdb_web/gdb_int/.htaccess
If config stuff in httpd.conf the following error messages
cfg_openfile() called with NULL filename
[Wed Apr 12 07:08:15 2006] [error] [client 192.168.0.61] (9)Bad file number: Could not open password file: (null)
See attached .htaccess file for what I tried.
|Additional Information||Config put into httpd.conf|
<Directory "/gdb_web/gdb_int"> #Change this line to match your restricted access dir
Options Indexes FollowSymLinks
Allow from all
AuthName "MySQL Testing"
AuthMySQLHost mysql-srv.com #change the following lines to match your setup
AuthMySQLPasswordField user_passwd #last line of possible changes
|Tags||No tags attached.|
.htaccess (266 bytes)
I think at least half of the problem here is that either I'm doing something wrong, or there's a problem with .htaccess files
I tried something here to restrict access to a section of the site and it didn't work. Must get my Apache2 book out and try and understand if it's a configuration error on my part, or a problem with my port.
Just a note to say that I can confirm this issue.
It seems that ModAuthMySQL is actually never called.
If "AuthUserFile" is not present in the auth-config (.htaccess or in httpd.conf) This error gets logged:
[Tue May 16 20:17:19 2006] [error] [client 10.22.42.253] (9)Bad file number: Could not open password file: (null)
and if "AuthUserFile" IS present, the file stated there gets htpasswd-queried.
I don't believe there's an Apache configuration error (sorry).
The config presented by "rgehrig" should be correct. - It's more or less straight out of the ModAuthMysql documentation.
I used a very similar conf in my setup.
||I don't believe this is relevant anymore given we've moved to apache 2.4.x|
|2006-04-17 11:35||rgehrig||New Issue|
|2006-04-17 11:35||rgehrig||File Added: .htaccess|
|2006-04-20 20:11||psmedley||Note Added: 0000020|
|2006-04-22 13:11||psmedley||Status||new => assigned|
|2006-04-22 13:11||psmedley||Assigned To||=> psmedley|
|2006-05-17 05:24||mikkle||Note Added: 0000080|
|2022-09-24 10:42||psmedley||Status||assigned => resolved|
|2022-09-24 10:42||psmedley||Resolution||open => no change required|
|2022-09-24 10:42||psmedley||Note Added: 0004573|