[Cialug] Apache 2.2

[Dave J. Hala Jr.]

I'm migrating a web site from RHEL 3 to RHEL 5.  RHEL 5 runs apache 

version httpd-2.2.3-6.el5 and rhel 3 runs httpd-2.0.46-61.ent .

I've password protected the site and authenticate against a mysql
database. I use an .htaccess file to do this. It works on fine on RHEL
3, but doesn't work on RHEL 5. 

Here's what the apache error log tells me:

[Sat Mar 24 07:56:22 2007] [error] [client 192.168.0.19] access to /
failed, reason: verification of user id                                
'xxxx' not configured


Here's what my .htacess looks like:

AuthName "Prototype "
Authtype Basic
Require valid-user
php_value include_path
".:/var/www/html/xxx:/var/www/cgi-bin/xxx:/usr/share/pear"


#AuthGroupFile                  /dev/null
#AuthMySQLCryptedPasswords      Off
AuthMySQLHost                  xxx.xxx.xxx.xxx
AuthMySQLDB                    user_db
AuthMySQLUserTable            users
AuthMySQLUser                  web_auth
AuthMySQLPassword              password
AuthMySQLNameField             username
AuthMySQLPasswordField         passwd
AuthMySQLAuthoritative         On



 I did install the redhat mod_auth_mysql rpm.  I can comment out all the
"Auth" lines in the .htaccess file and still get the same error message.
I'm assuming that means that I don't have mysql authentication
configured properly.  I'm still looking for what's missing.

Anyone else run into this problem? Seen any sample http.conf and
.htaccess file for apache 2.2