Red Hat Bugzilla – Bug 165780
htaccess AuthType Basic breaks when loading mod_auth_mysql.so
Last modified: 2007-11-30 17:11:11 EST
From Bugzilla Helper: User-Agent: Mozilla/5.0 (compatible; Konqueror/3.4; Linux) KHTML/3.4.0 (like Gecko) Description of problem: When mod_auth_mysql.so module is loaded, .htaccess option of 'Auth Type Basic' will no longer use file based password lists. Every auth attempt is forced to use mysql. httpd. From ssl.conf: <Directory "/var/www/cgi-bin"> AllowOverride All SSLOptions +StdEnvVars </Directory> This was working fine under FC3. Maybe this is a planned change in behavior for the new mod_auth_mysql?? This is a problem when you have multiple (apache) virtual hosts using both file based authentication _and_ mysql authentication. Version-Release number of selected component (if applicable): mod_auth_mysql-2.6.1-4 httpd-2.0.54-10 How reproducible: Always Steps to Reproduce: 1. Create .htaccess file, e.g.: AuthName TestSite AuthType Basic require group TestSite AuthUserFile /var/www/auth/.htpasswd AuthGroupFile /var/www/auth/.htgroup 2. Create .htpasswd and .htgroup files with a test user. 3. Make sure mod_auth_mysql RPM is loaded. It drops a conf file into /etc/httpd/conf.d and is enabled as soon as it is installed. 4. Try to auth against test server with browser. 5. Check /var/log/httpd/ssl_error_log if you want to see the error. Actual Results: Unable to login to secured site. Expected Results: AuthType Basic method should still work with mod_auth_mysql module loaded. Additional info: Just fixed it . . . must include additional directive in .htaccess when mod_auth_mysql module is loaded: AuthMySQLEnable Off Maybe mark this as 'not-a-bug' but make it searchable in the history for others. I think it's silly that the _default_ is 'On' and breaks the legacy auth mechanism. What were the mod_auth_mysql authors thinking? One database to rule them all? PostgreSQL is a better database anyway. Thanks. --Matt Olson http://www.oceanconsulting.com/
This report targets the FC3 or FC4 products, which have now been EOL'd. Could you please check that it still applies to a current Fedora release, and either update the target product or close it ? Thanks.
Re-tested (minimally) on FC6 and it seems to be working as desired. mod_auth_mysql no longer acts as the default auth mechanism when loaded. I had discovered a while back that this is an upstream problem as I was seeing on Debian as well. --Matt
Closing with CURRENTRELEASE. This bug may have actually been fixed in a prior release of mod_auth_mysql. 'Fixed in version' referenced is the version tested.