Re: apache_queries.sql

On Wednesday, March 19, 2003 15:41, Christopher Powell wrote:
> On Tuesday, March 11, 2003 12:16, Bert Rapp wrote:
> > 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,
> >
> > 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
>
> Hmm.  Looking into this, it seems that the problem is probably based in the
> lack of "UseCanonicalName On" in your Apache conf.  Check out section 4.4.1
> of the docs, it explains further.  I strongly suspect that if you make that
> change and restart Apache, this problem will disappear.

Following up my own message, I'd like to also recommend that you upgrade to 
mod_log_sql 1.18.  (The error messages indicate you're using an older one.)  
1.18 has far more robust and intelligent table-making procedures and is 
really the best version yet available.

Regards,
Chris
__________________________________________________________________
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/