auth mysql

auth_mysql user not found

[EdGy28376]

I am trying to secure a part of my site using the auth_mysql mod. I get the login window enter my userid and hit enter. Then the login window reappears. The error log shows user not found.

Here is my directive in apache2.conf
# MySql Authentication
Auth_MySQL_Info localhost <user> <password>
Auth_MySQL_General_DB auth
<Directory /var/www/ModemResults/auth>
Auth_MySQL on
Auth_MySQL_DB auth
Auth_MySQL_user <username>
Auth_MySQL_password <password>
Auth_MySQL_Password_Table clients
Auth_MySQL_Username_Field username
Auth_MySQL_Password_Field passwd
Auth_MySQL_Authoritative On
Auth_MySQL_Encryption_Types Plaintext
AuthUserFile /dev/null
Options +Indexes FollowSymLinks MultiViews
AllowOverride AuthConfig Options FileInfo Limit
Order allow,deny
Allow from all
</Directory>

Here is my .htaccess
AuthName "Your Login is Required"
AuthType Basic

<Limit GET POST>
Auth_MySQL_DB auth
Auth_MySQL_Encrypted_Passwords off
require valid-user
</Limit>

I am using;
Ubuntu Server 9.10
Apache 2.2.12
MySql 5.1.37

I did not need to compile the mod.