Hello again.
I just found out a work-around to this problem. We have to remove the
mod_auth_mysql module with 'rpm -e mod_auth_mysql' and then it works again.
However, I think that the choice of going through file or database should
not be done by installing or uninstalling an rpm, but merely by choosing
that option from a tag in a file, and turning this on or off.
Maybe I'm wrong, but that would be much better to my point of view. Also,
it's strange to suddenly change the default behaviour of Apache and I'm
quite surprised that so few of you seem to have had this problem.
Here is another thread about it:
http://www.redhatforums.org/ftopic4079.html
Maybe should be add this in the bug list, or is it a RedHat issue ?
Thanks,
Daniel
----- Original Message -----
From: dan1
To: centos@xxxxxxxxxx
Sent: Monday, May 16, 2005 11:40 AM
Subject: htaccess authentication asks for MySQL table
test.user_info
Hello.
I tried to create an access file with 'htpasswd -c
/etc/httpd/conf/myfile.htaccess testuser'.
In the SSL directory I have put a .htaccess file containing the followings:
AuthUserFile /etc/httpd/conf/myfile.htaccess
AuthName "Mydomain"
AuthType Basic
require valid-user
This worked with CentOS 3.
Now with CentOS 4, apache version 2.0.52, the access to the page is
forbidden.
The ssl_error_log indicates this error:
[Mon May 16 10:03:21 2005] [error] [client 192.168.0.1] MySQL ERROR: Table
'test
.user_info' doesn't exist: /myurl_to_ssl_address
[Mon May 16 10:03:21 2005] [error] [client 192.168.0.1] MySQL user testuser
not fou
nd: /myurl_to_ssl_address
It's like if apache would make a MySQL query to find the user I specified,
but in fact I expected apache to look into the
/etc/httpd/conf/myfile.htaccess for that, and not in MySQL.
Another person had the same problem lately. Here is the post:
http://groups.google.ch/group/alt.apache.configuration/browse_frm/thread/9e72a6f834fa38e0/1309ed14100875ee?tvc=1&q=%22MySQL+ERROR:+Table+%27test.user_info%27+doesn%27t+exist%22&hl=fr#1309ed14100875ee
Does anybody have an idea of what happens there ?
Thanks for any help provided.
Daniel
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
