htaccess -- Apache can't find account exactly in htpasswd -- please help

b:z · 05-06-2005, 04:02 AM

Here is my .htaccess:

Quote:

#
AuthName "Protect Area."
AuthType Basic
AuthUserFile /etc/configure/apache/.htpasswd
AuthGroupFile /dev/null
<Limit GET POST>
require valid-user
</Limit>
#

Here is my .htpasswd

Quote:

admin:6gAcccxq8K/0s

I have put ".htaccess" file to my folder in webserver." /var/www/html/protect/"
When i have access to "http://www.abc.com/protect", a login form appear. Type user name and password which exist in ".htpassword", but nothing occur, exclude only login form, it still apear athough typing exactly more times.

And this is error log:

Quote:

[Fri May 06 15:47:34 2005] [error] [client 192.168.1.1] MySQL ERROR: Table 'test.user_info' doesn't exist: /protect/
[Fri May 06 15:47:34 2005] [error] [client 192.168.1.1] MySQL user admin not found: /protect

I really don't understand about "MySQL ERROR" ??? is .htaccess or .htpasswd relative to MySQL?
Please help me solve the problem. Thank you very much.

trickykid · 05-06-2005, 08:49 PM

And you did place your actual .htpasswd file in /etc/configure/apache/.htpasswd ?

And why do you have AuthGrpFile as /dev/null? Just leave it out if your not going to use it. And what command are you using to add the admin account to your .htpasswd file?

b:z · 05-06-2005, 11:29 PM

Quote:

And you did place your actual .htpasswd file in /etc/configure/apache/.htpasswd ?

Yes, that's right. i have been placed .htpasswd in "/etc/configure/apache/.htpasswd"

Quote:

And why do you have AuthGrpFile as /dev/null? Just leave it out if your not going to use it

The first time, i have left /dev/null, however when i have met that problem, i think i have got wrong configuration, so i have searched on Internet and seen some configuration of someone. And in thier configuration, they recommended use AuthGrpFile. But, Use or Not still got the same problem

Quote:

And what command are you using to add the admin account to your .htpasswd file?

#htpasswd -c /etc/configure/apache/.htpasswd admin
{then i type same password 2 times} --> succeed.

I have aslo stop MYSQL daemon running on my server, however nothing is better.
Please help me. Thank you very much.

DaHammer · 05-07-2005, 12:34 AM

Looks to me like you have another auth type setup somewhere else, probably in your http.conf file, that is conflicting with what you are trying to do here. Looks like someone has setup mod-auth-mysql which would explain the MySQL errors you're seeing.

b:z · 05-08-2005, 12:32 AM

Thanks for your reply,

Quote:

ks to me like you have another auth type setup somewhere else, probably in your http.conf file, that is conflicting with what you are trying to do here. Looks like someone has setup mod-auth-mysql which would explain the MySQL errors you're seeing.

Can you give me a detail about your mean? I really don't know where can fix it?

Thank you very much.

b:z · 05-09-2005, 12:46 AM

Any help, any suggestion ??? Please...

hughesjr · 05-16-2005, 05:46 AM

It seems if you have mod_auth_mysql installed, it becomes the default AuthType

remove the rpm mod_auth_mysql ... or remark out all the open lines in:

/etc/httpd/conf.d/mod_auth_mysql

b:z · 05-16-2005, 05:47 AM

Quote:

It seems if you have mod_auth_mysql installed, it becomes the default AuthType

remove the rpm mod_auth_mysql ... or remark out all the open lines in:

/etc/httpd/conf.d/mod_auth_mysql

Well, thank for your help. I had already fixed it, however special thanks. You are right !