AnyData::Format::Weblog - tiedhash & DBI/SQL access to HTTPD Logs |
AnyData::Format::Weblog - tiedhash & DBI/SQL access to HTTPD Logs
use AnyData; my $weblog = adTie( 'Weblog', $filename ); while (my $hit = each %$weblog) { print $hit->{remotehost},"\n" if $hit->{request} =~ /mypage.html/; } # ... other tied hash operations
OR
use DBI my $dbh = DBI->connect('dbi:AnyData:'); $dbh->func('hits','Weblog','access_log','ad_catalog'); my $hits = $dbh->selectall_arrayref( qq{ SELECT remotehost FROM hits WHERE request LIKE '%mypage.html%' }); # ... other DBI/SQL operations
This is a plug-in format parser for the AnyData and DBD::AnyData modules. You can gain access to Common Log Format files web server log files (e.g. NCSA or Apache) either through tied hashes or arrays or through SQL database queries.
Fieldnames are taken from the W3 definitions found at
http://www.w3.org/Daemon/User/Config/Logging.html#common-logfile-format
remotehost usernname authuser date request status bytes
In addition, two extra fields that may be present in extended format logfiles are:
referer client
Please refer to the documentation for AnyData.pm and DBD::AnyData.pm for further details.
copyright 2000, Jeff Zucker <jeff@vpservices.com> all rights reserved
AnyData::Format::Weblog - tiedhash & DBI/SQL access to HTTPD Logs |