[Mod_log_sql] scoreboard

[Thomas Goirand]

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