AUTHENTICATION with mod_auth_mysql

[Kiran Kumar M]

Hi,

I am trying to authenticate the user through mod_auth_mysql in apache, It
is called the mysql, but it is generating the following messages in apache
log file.

[error] MySQL query failed:  select passwd from siteusers where
id='root'

[error] MySQL failure reason:  Access denied for user: '@localhost' to
database 'vsdadmsite'

and the configuration at httpd.conf is :

<Location /vsdadm>
        AllowOverRide AuthConfig
        Auth_MYSQL On
        Auth_MySQL_DB vsdadmsite
        Auth_MySQL_Password_Table siteusers
        Auth_MySQL_Username_Field id
        Auth_MySQL_Password_Field passwd
        Auth_MySQL_Empty_Passwords Off
        Auth_MySQL_Encrypted_Passwords Off
        Auth_MySQL_Encryption_Types Plaintext
        AuthName "root center"
        AuthType Basic
        require valid-user
</Location>

I installed DBI-1.14

Thanks,
Kiran