[Mod_log_sql] LogSQLMassVirtualHosting and mod_vhost_alias

Edward Rudd urkle at outoforder.cc
Sat Jan 21 13:01:00 EST 2006

Dice R. Random wrote:
> 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
> requested.
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.

>    Any ideas?  How can I get all the subdomains logging into a single table?
> Thanks in advance :)
> _______________________________________________
> Download the latest version at http://www.outoforder.cc/projects/apache/mod_log_sql/
> To unsubscribe send an e-mail to 
> mod_log_sql-unsubscribe at lists.outoforder.cc

More information about the Mod_log_sql mailing list