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

COMMENTS

       This man page was written using xml2man (1) by the same author.