Apache::DBILogConfig - Logs access information in a DBI database
# In httpd.conf PerlLogHandler Apache::DBILogConfig PerlSetVar DBILogConfig_data_source DBI:Informix:log_data PerlSetVar DBILogConfig_username informix PerlSetVar DBILogConfig_password informix PerlSetVar DBILogConfig_table mysite_log PerlSetVar DBILogConfig_log_format "%b=bytes_sent %f=filename %h=remote_host %r=request %s=status"
This module replicates the functionality of the standard Apache module, mod_log_config, but logs information in a DBI-compliant database instead of a file. (Some documentation has been borrowed from the mod_log_config documentation.)
A DBI data source with a format of "DBI::driver:database"
Username passed to the database driver when connecting
Password passed to the database driver when connecting
Table in the database for logging
A string consisting of formats separated by white space that define the data to be logged (see FORMAT STRING below)
A format string consists of a string with the following syntax:
%[conditions][{parameter}]format=field
Formats specify the type of data to be logged. The following formats are accepted:
A database column to log the data to
For formats that take a parameter
Example: %{DOCUMENT_ROOT}e
Conditions are a comma-separated list of status codes. If the status of the request being logged equals one of the status codes in the condition the data specified by the format will be logged. By placing a '!' in front of the conditions, data will be logged if the request status does not match any of the conditions.
Example: %!200,304,302s=status will log the status of all requests that did not return some sort of normal status
Debugging statements will be written to the error log if LOGLEVEL is set to 'warn' or higher
mod_perl >= 1.11_01 with PerlLogHandler enabled
DBI
Date::Format
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 as above.
After installing and configuring this module, Apache will continue to log to your regular access log file (if it was previously configured that way). To log accesses only to your database comment out CustomLog or TransferLog or set them to /dev/null.
Copyright (C) 1998, Jason Bodnar <jason@shakabuku.org>. All rights reserved.
This module is free software; you may redistribute it and/or modify it under the same terms as Perl itself.
perl(1), mod_perl(3)
To install Apache::DBILogConfig, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Apache::DBILogConfig
CPAN shell
perl -MCPAN -e shell install Apache::DBILogConfig
For more information on module installation, please visit the detailed CPAN module installation guide.