I am running httpd 2.0.51 (RHEL 4).I am trying to protect certain directory
using .htaccess.Clients are seeing login Box but they are not able to login.As
with basic authentication,i am using passwd.It seems it is not able to excute
SUEXEC. When i see the error log,it gives error that user not found in MySQL.I configured Basic Authentication using .htaccess referrring file passwd which is bring generated by htpasswd.
Any1 out here to help.

Can you paste the related lines from the error_log ?

suexec + .htaccess should not give you problems as such.

Seems that httpd is using mod_auth_mysql to authenticate, instead of simply mod_auth.
You might want to check that in the httpd.conf too.

I also of the same view that it is authenticating from MySQL.But i have not mentioned it anywhere.is there any place in httpd.conf to set authentication type?I mentioned Basic Authentication in my .htaccess.
As asked by you,i am pasting my error log entries

[Wed Jan 10 12:38:41 2007] [error] [client 172.20.100.64] MySQL ERROR: Access denied for user 'apache'@'localhost' (using password: NO), referer: http://portal.ofb.net/
[Wed Jan 10 12:38:41 2007] [error] [client 172.20.100.64] MySQL user test not found: /kb, referer: http://portal.ofb.net/
[Wed Jan 10 12:58:37 2007] [alert] [client 172.20.100.64] /var/www/html/portal.ofb.net/kb/.htaccess: Invalid command 'AuthUserFile', perhaps mis-spelled or defined by a module not included in the server configuration, referer: http://portal.ofb.net/
[Wed Jan 10 12:58:52 2007] [alert] [client 172.20.100.64] /var/www/html/portal.ofb.net/kb/.htaccess: Invalid command 'AuthUserFile', perhaps mis-spelled or defined by a module not included in the server configuration, referer: http://portal.ofb.net/
[Wed Jan 10 12:59:27 2007] [error] [client 172.20.100.64] MySQL ERROR: Access denied for user 'apache'@'localhost' (using password: NO), referer: http://portal.ofb.net/
[Wed Jan 10 12:59:27 2007] [error] [client 172.20.100.64] MySQL user test not found: /kb, referer: http://portal.ofb.net/
[Wed Jan 10 12:59:31 2007] [error] [client 172.20.100.64] MySQL ERROR: Access denied for user 'apache'@'localhost' (using
We are working in WAN.So it is not actual addresses.

Thanx for taking interest in my thread.

The following lines in the log clearly show that:

1. The .htaccess file directives are not being understood since the apache configuration has not probably either not included mod_auth, or excluded it for the path / virtualhost. ( See the entry at 12:58:37 ).
2. The application (in /var/www/html/portal.ofb.net) is trying to use mysql and failing due to an improper setup. Did you forget to configure the access to the mysql database the application requires?

You will want to check the 'AllowOverride' directive, and its use for the particular virtualhost / directory.

You will also want to look up the documentation for the 'portal.ofb.net' application / check with the developers for any Mysql database connections it needs.

i will just give a try and get back to you."AllowOverride Authconfig" is written inside <directory /var/www/html> which is root for Web Server.Portal.ofb.net is a virtual host with DocumentRoot </var/www/html/portal.ofb.net>.I have not mentioned any <Directory> inside this virtual host.What i think that above setup(Authconfig in web server root) will suffice.Any way i will check all the hints you gave.

Thanks.

Every1 told its going to be very easy but i dont know y it has created so much trouble in my case.There is a directory "conf.d" in which several configuration files are stored which are loaded at runtime.I commented the line in "auth_mysql.conf" which was loading the MySQL module.The README(inside conf.d)says that these modules will be loaded alphabatically(i am not sure what does that really mean?.NOW,MySQL is not authenticating all the user BY DEFAULT.
I added
<Directory "/var/www/html/portal.ofb.net">
AllowOverride AuthConfig
</Directory>
inside <Virtual host> portal.ofb.net </Virtual host>.
keeping AuthConfig inside Virtual Host is a better and more logical way.

Now its working.Thank you osdeals.U are really very helpful.

Glad to be able to help , and you're welcome!