[Mod_log_sql] LogSQLMassVirtualHosting and mod_vhost_alias

Dice R. Random dicerandom at gmail.com
Sat Jan 21 03:31:21 EST 2006

Hello List,

   I'm running a server that hosts a large number of domain names,
we're currently evaluating mod_log_sql on our testbed as a replacement
for mod_log_mysql.  Everything's running smoothly except one issue,
with mod_log_mysql all the logs went into one huge table, we're hoping
to move away from that now so that we can reduce the size of our log
tables and allow users access to their logs in the MySQL database.

   The problem we're having is that with LogSQLMassVirtualHosting
enabled mod_log_sql will treat www.somedomain.com, somedomain.com, and
foo.somedomain.com as if they were all seperate entities, whereas we
would rather that everything under somedomain.com was logged into a
single table.  I believe this is actually related to the fact that
mod_vhost_alias is setting an environment variable (or something...
how's this done?) such that the vhost name is whatever domain was

   Any ideas?  How can I get all the subdomains logging into a single table?

Thanks in advance :)

More information about the Mod_log_sql mailing list