[Mod_log_sql] LogSQLMassVirtualHosting and mod_vhost_alias

[Dice R. Random]

On 1/21/06, Edward Rudd <urkle at outoforder.cc> wrote:
> actually it is pulled from the request record of the "requested'
> hostname.  i have a feature  on http://issues.outoforder.cc/ to address
> this exact issue. (issue # 27).  i will be starting development sometime
> this week.

OK, thanks for the clarification :)

I'm rather impatient to get this new configuration up and running for
our clients, so I went ahead and wrote a patch against
mod_log_sql-1.100 that impliments this functionality.  I added on a
configuration directive 'LogSQLTruncateDomains', added a flag to the
global configuration structure, and tacked on some additional logic to
the log_sql_transaction function.  The end result is that if you
enable LogSQLTruncateDomains *and* LogSQLMassVirtualHosting then, for
the purposes of the logging table name, any hostname of the form
foo.bar.etc.domain.tld will be truncated to simply domain.tld.

I've tested this and it works on my system, but I don't claim to have
tested it extensively so there could very well be a bug for some other
configurations.

The patch is attached, of course.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mod_log_sql-truncatedomains.patch
Type: text/x-patch
Size: 1605 bytes
Desc: not available
Url : http://lists.outoforder.cc/pipermail/mod_log_sql/attachments/20060121/787ba35c/attachment.bin