Authentication Loop

Greetings,

I am trying to use basic authentication on a directory, but I am
getting an endless authentication loop (the dialogue box pops up over
and over).

Background info:

Running debian-sarge with apache 2.0.54, mod_auth_mysql 4.3.9-2, MySQL
5.1

Turned on logging for MySQL and can see the queries for the passwords
from the www-data user, so auth_mysql is getting the passes.

Use an .htaccess file to trigger the logon:

AuthName "Welcome"
AuthType Basic
Auth_MySQL_Password_Table mysql_auth
Auth_MySQL_Group_Table mysql_auth
Auth_MySQL_Username_Field username
Auth_MySQL_Password_Field passwd
Auth_MySQL_Group_Field groups
Auth_MySQL_Empty_Passwords off
Auth_MySQL_Authoritative on
Auth_MYSQL on
require group std

I believe I have all the db, table and field names defaulted out (db =
http_auth, table = mysql_auth, fields = username;passwd;groups) and
www-auth user is set up in MySQL with no pass and full access to the
db. I don't think hitting the db is the issue.

I have also tried using just plain old mod_auth and flat files
(.htpasswd, etc.) and I get the same issue. I must be overlooking
something simple.

Any help would be appreciated.

Update: Got straight ahead mod_auth to work by fixing the path to the
password file. Still can't get authorization to work using
mod_auth_mysql (after changing the .htaccess file to use AuthMySQL
again).

Oh, correction to the above - user for apache in mysql is www-data

Keep seeing the password queried in the mysql log, but nothing shows in
the apache error log (which is what had tipped me off to the password
file path issue above) yet the authorization loop goes on.

Alright,
Well it turned out to be that I needed to indicate plaintext as the
encrytion type OR insert DES encrypted passes into the db. Works now.