[Mod_log_sql] scoreboard

[peter]

Hello Thomas
My friend installed the mod on my Etch server so he may have back ported
from sid. 

Now that I have the tables all built I have done as you suggested and
turned off LogSQLMassVirtualHosting and used the vhost directives to use
the scoreboard feature more effectively.

I look forward to seeing more done on this mod. The extra logging
features will be really nice.

Regards,
Peter

On Tue, 2007-17-07 at 03:05 +0800, Thomas Goirand wrote:
> Hi,
> 
> I'm the author of the score_board patch.
> 
> peter wrote:
> > Hi list
> > The version of mod-log-sql and mod-log-sql-mysql I'm using requires the
> > use of the scoreboard table. 
> > 
> > Server & OS = Debian Etch amd64
> 
> Did you backport my package from SID?
> 
> > 
> > The scoreboard table seems like a great idea but the data I'm getting is
> > incomplete. I have as example several domains / vhosts which all log to
> > their own access_table_name. The scoreboard table is logging everything
> > to vhost = default-domain.tld and domain = www which seems kind of
> > useless. I'm also not getting any data on these fields.
> 
> To have it working properly, there are few more directives to be set per
> vhost:
> 
> # Defines what domain to log in the score_board table
> LogSQLScoreDomain example.com
> # Defines the name of the subdomain
> LogSQLScoreSubdomain www
> # Defines the name of the database and table to log in
> LogSQLScoreTable dtc.http_accounting
> 
> > count_hosts count_visits count_status_200 count_status_404
> 
> These are unfortunately things that we would like to do in the future.
> Currently, it just doesn't do it yet.
> 
> > Any I missing a setting somewhere to get more complete logging? I have
> > LogSQLMassVirtualHosting On so I cannot set LogSQLScoreDomain or
> > LogSQLScoreSubdomain
> 
> They you will always have something wrong, and there's nothing that can
> be done... I would not recommend to use LogSQLMassVirtualHosting anyway,
> a per vhost configuration is by far better.
> 
> Thomas
> 
> _______________________________________________
> 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
>