[CentOS] htaccess authentication asks for MySQL table test.user_info

Thu Jul 14 17:44:19 UTC 2005
dan1 <dan1 at edenpics.com>

Hello.

For users interested in the MySQL authentication problem for SSL pages, 
there is another way
to prevent mod_auth_mysql to do this mySQL authentication. This has been 
reported by Brent:

In the /etc/httpd/conf/httpd.conf file, add the directive:

<Directory xxxxxx/
    AuthMySQLEnable off
    AllowOverride All
</Directory>

You can also add it to your .htaccess file.

Thanks Brent !

Daniel


----- Original Message ----- 
From: dan1
To: centos at centos.org
Subject: [CentOS] htaccess authentication asks for MySQL table
test.user_info

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