apache_queries.sql

Bert Rapp <[email protected]>
Newsgroups gmane.comp.apache.mod-log-sql
Message-ID <[email protected]>
I've noticed my apache_queries.sql file growing recently and upon 
further inspection I noticed that when someone requests a page without 
using the FQDN m_l_s puts an entry in apache_queries.sql.  For example, 
if I request a page from intranet.northtrailrv.com m_l_s puts an entry 
in the table access_intranet_northtrailrv_com.  But if I request a page 
from intranet, which with my internal DNS resolves correctly, then m_l_s 
puts an entry in apache_queries.sql and does not create the table 
access_intranet.  

My config for m_l_s is as follows:
MySQLLoginInfo                  localhost apache XXXX
MySQLSocketFile                 /var/lib/mysql/mysql.sock
MySQLDatabase                   apache
MySQLCreateTables               On
MySQLMassVirtualHosting         On
MySQLPreserveFile               apache_queries.sql


in my error_log I see this:
[Tue Mar 11 14:30:21 2003] [error] attempting reconnect because API 
said: Table 'apache.access_intranet' doesn't exist
[Tue Mar 11 14:30:21 2003] [error] reconnect successful.
[Tue Mar 11 14:30:21 2003] [error] delayed insert attempt failed, API 
said: Table 'apache.access_intranet' doesn't exist
[Tue Mar 11 14:30:21 2003] [error] entry preserved in 
/tmp/apache_queries.sql


It seems to be able to create tables for the FQDN requests.  Does this 
make any sense?


Thanks,
Bert Rapp

__________________________________________________________________
Reminder: to unsubscribe, send email to <[email protected]>
with the words "unsubscribe mod_log_sql" in the body (w/o quotes).
The module homepage is http://www.grubbybaby.com/mod_log_sql/
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.