/ 
Apache-DBILogger-0.01
River stage zero No dependents
/ Apache::DBILogger

NAME

Apache::DBILogger - Tracks what's being transferred in a DBI database

SYNOPSIS

# Place this in your Apache's httpd.conf file
PerlLogHandler Apache::DBILogger

PerlSetVar DBILogger_data_source    DBI:mysql:httpdlog
PerlSetVar DBILogger_username       httpduser
PerlSetVar DBILogger_password       secret

Create a database with a table named requests like this:

CREATE TABLE requests ( id mediumint(9) DEFAULT '0' NOT NULL auto_increment, server varchar(127) DEFAULT '' NOT NULL, bytes mediumint(9) DEFAULT '0' NOT NULL, user varchar(15), filename varchar(200), remotehost varchar(150), remoteip varchar(15) DEFAULT '' NOT NULL, status smallint(6) DEFAULT '0' NOT NULL, timeserved datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, urlpath varchar(200) DEFAULT '' NOT NULL, referer varchar(250), useragent varchar(250), PRIMARY KEY (id), KEY server_idx (server) );

Its recommended that you include

use Apache::DBI; use DBI; use Apache::DBILogger;

in your startup.pl script. Please read the Apache::DBI documentation for further information.

DESCRIPTION

This module tracks what's being transfered by the Apache web server in a SQL database (everything with a DBI/DBD driver). This allows for real-time statistics (of almost everything) without having to parse the log files (like the Apache::Traffic module, just in a "real" database).

After installation, follow the instructions in the synopsis and restart the server.

The statistics are then available in the database. See the section VIEWING STATISTICS for more details.

PREREQUISITES

You need to have compiled mod_perl with the LogHandler hook in order to use this module. Additionally, the following modules are required:

o DBI
o Date::Format

INSTALLATION

To install this module, move into the directory where this file is located and type the following:

perl Makefile.PL
make
make test
make install

This will install the module into the Perl library directory.

Once installed, you will need to modify your web server's configuration file so it knows to use Apache::DBILogger during the logging phase.

VIEWING STATISTICS

I haven't made any pretty scripts og web interfaces to the log-database yet, so you're on your own. :-)

For a start try:

# hit count and total bytes transfered from the virtual server www.company.com select count(id),sum(bytes) from requests where server="www.company.com";

# hit count and total bytes from all servers, ordered by number of hits select server,count(id) as hits,sum(bytes) from requests group by server order by hits desc;

# count of hits from macintosh users select count(id) from requests where useragent like "%Mac%" ;

# hits and total bytes in the last 30 days from www.company.com select count(id),sum(bytes) from requests where server="www.company.com" and TO_DAYS(NOW()) - TO_DAYS(timeserved) <= 30 ;

# hits and total bytes from www.company.com on mondays. select count(id),sum(bytes) from requests where server="www.company.com" and dayofweek(timeserved) = 2;

See your sql server documentation of more examples. I'm a happy mySQL user, so I would continue on

http://www.tcx.se/Manual_chapter/manual_toc.html

AUTHOR

Copyright (C) 1998, Ask Bjoern Hansen <ask@netcetera.dk>. All rights reserved.

This module is free software; you may redistribute it and/or modify it under the same terms as Perl itself.

SEE ALSO

perl(1), mod_perl(3)