NAME¶
make_combined_log.pl - make combined logfile from SQL database
SYNOPSIS¶
make_combined_log.pl <days> <virtual
host>
DESCRIPTION¶
This perl script extracts the httpd access data from a MySQL database and
formats it properly for parsing by 3rd-party log analysis tools.
The script is intended to be run out by cron. Its commandline arguments tell it
how many days' worth of access records to extract, and which virtual_host you
are interested in (because many people log several virthosts to one MySQL db.)
This permits you to run it daily, weekly, every 9 days -- whatever you decide.
NOTE¶
By "days" I mean "chunks of 24 hours prior to the moment this
script is run." So if you run it at 4:34 p.m. on the 12th, it will go
back through 4:34 p.m. on the 11th.
KNOWN ISSUES¶
Because GET and POST are not discriminated in the MySQL log, we'll just assume
that all requests are GETs. This should have negligible effect on any analysis
software. This could be remedied IF you stored the full HTTP request in your
database instead of just the URI, but that's going to cost you a LOT of space
really quickly...
Because this is somewhat of a quick hack it doesn't do the most robust error
checking in the world. Run it by hand to confirm your usage before putting it
in crontab.
AUTHOR¶
Edward Rudd <eddie@omegaware.com>
MAN PAGE CREATED BY¶
Michael A. Toth <lirul.lists@gmail.com> - based on comments of script
This man page was written using
xml2man (1) by the same author.