We're seeing a number of these errors in our apache error.log:
[Thu Aug 19 09:55:25 1999] [error] MySQL query failed: select passwd from
Users where username='topher'
[Thu Aug 19 09:55:25 1999] [error] MySQL failure reason: Table
'Mall.Users' doesn't exist
The problem is that the 'Mall' database isn't supposed to be used for this
query. The .htaccess file:
----------------------------------
AuthName "Gospelcom Member's Only"
AuthType Basic
Auth_MySQL_DB gospelcom
Auth_MySQL_Password_Table Users
Auth_MySQL_Group_Table Groups
require group members
# don't allow directory listings
Options -Indexes
----------------------------------
There are other pages that are authenticating against the 'Mall' database,
but they are unrelated, on other parts of the machine. These errors don't
happen all the time; it is as if the database is being switched out from
under one mod_auth_mysql process by another.
We've tried turning persistent connections on and off, with no change.
I've hacked away at the mod_auth_mysql.c source to use mysql_real_connect
instead of mysql_connect, with no change.
System: RH Linux w/ 2.0.3[67] kernel, apache_1.3.6, mod_auth_mysql-2.20.
Authenticating against a machine w/ RH Linux, 2.0.36 kernel, mysql-3.22.14
(binary .tar.gz installed).
Any thoughts? Thanks for any help anyone can provide!
/pg
--
Peter Green
Gospel Communications Network, SysAdmin
pcg@stripped
