[Mod_log_sql] LogSQLMassVirtualHosting and mod_vhost_alias

[Dice R. Random]

On 1/21/06, Dave Steinberg <dave at redterror.net> wrote:
> Just from glancing at the patch, it seems like it won't work well with
> domains like foobar.co.uk (since it only looks for 2 dots).
>
> Perhaps there's a way to specify a regular expression instead, and have
> it strip off whatever matches?
>
> LogSQLStripRegex ^www\.
>
> Just a suggestion.  :)

Ooh, you're right, I didn't think of that.  We don't have any .co.uk
customers ;)

I think the problem with the regex approach is that we need to be able
to strip off a wide variety of different subdomains.  For instance one
of our customers has a subdomain hername.herdomain.com which is her
personal site in addition to www.herdomain.com which is her business
site; we'd like to be able to log both sites under a single table.

Maybe if we had a list of TLDs and the various government run
subdomains under the ccTLDs that we could check against?