[Mod_log_sql] Logging environment variables

[Mike Cardwell]

Hi Guys,

I have a setup whereby there is a single virtual host that serves many
sites. Rewrite rules are used to map a hostname to a path for the
document root. I set the environment variable VHOST to be a slightly
modified copy of HTTP_HOST.

Example:

If an incoming request comes in for foo.com or anything.foo.com
or anything.anything.foo.com I want to only log foo.com. The VHOST
variable is set to the correct value. I can log this to disk with:

LogFormat "%{VHOST}e %h %l %u %t \"%r\" %>s %b \"%{Referer}i\"
\"%{User-Agent}i\"" vhost
CustomLog /var/log/httpd/vhost-access.log vhost

But how the hell do I get mod_log_sql to use the value of VHOST rather
than HTTP_HOST for the virtual_host column? I understand this may
require patching mod_log_sql. if that's the case, can someone give me
some pointers as I'm not a C programmer.

I'm using mod_log_sql-1.100 with Apache2.0.51.

Thanks guys,
Mike

-- 
Digital photo printing: http://www.fotoserve.com/