[Mod_log_sql] LogSQLMassVirtualHosting and mod_vhost_alias

[Dice R. Random]

On 1/21/06, Bob Apthorpe <apthorpe+sa at cynistar.net> wrote:
> Basically, if you match an xLD (top, second, third, fourth-level
> domain), /(([^.]+\.)(xLD))$/ should match the base domain where you'd
> store the log entry. www.example.co.uk and example.co.uk would match the
> 2LD '.co.uk' giving a base domain of example.co.uk for both. Similarly,
> www.example.austin.ci.tx.us and example.austin.ci.tx.us would end up
> under austin.ci.tx.us.

The current version of my patch will work as you specified under both
these situations, any two character (or less) entries will be treated
as part of the xLD.  It doesn't do any checking to see if the xLDs are
valid, but I don't see any problem with that as any FQDNs being hosted
would presumably be registered somewhere.  We don't need to be quite
as strict with our checks as a SPAM filtration or e-mail address
verification program, we just need to be able to distinguish xLDs from
the rest of the FQDN.