[Mod_log_sql] How to use the Log Format

Edward Rudd urkle at outoforder.cc
Thu Jun 17 21:34:00 EST 2004


Chris,

On Thu, 2004-06-17 at 20:48, Christopher Chua wrote: 
> I wish to use the LogSQLTransferLogFormat with non-canonical virtualhost
> names because I am using the mass virtualhosting feature in apache but i
> want every virtualhost to be specified in a single table.

Are you using IP based hosting instead of Namebasedhosting then?

> I tried using V to replace v but it stopped logging the virtualhost.
> 
> And what if i needed to add other information from the header other than
> those mentioned in the manual? Is Referrer a valid header?

To log the Referrer specify R. And there is no capitol V, only a
lowercase v which logs the virtualhost. You can't use the documentation
from mod_log_config for logformat, as mod_log_sql does not use those
logformat names.. you need to use the table in the mod_log_sql manual.

http://www.outoforder.cc/projects/apache/mod_log_sql/docs/node4.html#SECTION000461700000000000000

And currently there is no format letter to log the canonical hostname. I
can add it in the next release I make, though. As I know this is an
issue that has been brought up to me before about the massvirtualhosting
flag and multiple aliases for a single website, I will work on finding a
solution soon.

-- 
Edward Rudd <urkle at outoforder.cc>
Website http://www.outoforder.cc/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.outoforder.cc/pipermail/mod_log_sql/attachments/20040617/c67ec151/attachment.bin 


More information about the Mod_log_sql mailing list