Re: A Few Questions...

James Higginbotham wrote:
> I just installed mod_log_sql onto Apache 1.3.27 + MySQL 4.1 Alpha and
> I'm loving it! I have 3 questions:
>  
> 1. Is there a definitive guide as to what options are available for the
> "WhichNotes" option? I see the example listing 2 gzip fields, but where
> are they coming from? Is it some Apache fields I don't know about or ??

Hello, James.  I am not certain if such a guide exists; as far as I can 
tell, the 'notes' field is one of those things that "you'll know about 
if you need to know."  Speaking from personal experience, my first 
exposure to 'notes' was by utilizing the mod_gzip module, hence its 
prominent mentioning.  I can only assume that other modules that utilize 
this field will make that fact known to the user.

> 2. Has anyone built any precanned reports on top of the current DB
> structure already? If so, can you point me to some links? I don't want
> to reinvent the wheel if someone has something they are sharing. 

I'm not sure that I fully understand 'precanned reports,' but if you 
mean a way to suck the data out of the database and into a format useful 
to human eyes, I can share what I do:  a cron job in /etc/cron.hourly 
extracts the data and runs Webalizer on it:

#!/bin/sh
/usr/local/sbin/make_combined_log.pl 1 www.grubbybaby.com > \
     /var/log/httpd/mysql-grubbybaby
/usr/local/bin/webalizer -Q -c /etc/webalizer.conf
rm -f /var/log/httpd/mysql-grubbybaby

> 3. Is there an archive for this mailing list via the web? I checked MARC
> but didn't see the list registered. 

Yes, and I will place a link to this archive on the website.
http://news.gmane.org/thread.php?group=gmane.comp.apache.mod-log-sql

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/
The list archives are here:
http://news.gmane.org/thread.php?group=gmane.comp.apache.mod-log-sql