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.

Manuals                                               User                               make_combined_log.pl(1)