CentOS - May 2005 - 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

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 at centos.org
Sent: Monday, May 16, 2005 11:40 AM
Subject: [CentOS] 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 at centos.org
http://lists.centos.org/mailman/listinfo/centos