make_combined_log2(1) [debian man page]

make_combined_log.pl(1) 				      General Commands Manual					   make_combined_log.pl(1)

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)

FAXCRON(8)						      System Manager's Manual							FAXCRON(8)

NAME

       faxcron - HylaFAX routine maintenance script

SYNOPSIS

       /usr/sbin/faxcron [ -n ] [ -l lastrun ]

DESCRIPTION

       faxcron	is  a  command	script	that  does  routine upkeep tasks in a HylaFAX spooling directory hierarchy.  This script is intended to be
       invoked from cron(8) on behalf of the fax user (often the ``fax'' user is uucp) once a day, with the standard output sent by  mail  to  the
       HylaFAX administrator.  For example, the following crontab might be set up for the fax user:
	 25   23    *	 *    *   sh /usr/sbin/faxcron | mail FaxMaster

       The faxcron script does the following work:

       o  report statistics for facsimile transmitted since the last time faxcron was run.

       o  report statistics for facsimile transmitted in the past week.

       o  report statistics for facsimile received since the last time faxcron was run.

       o  report statistics for facsimile received in the past week.

       o  report any recent calls that failed suspiciously and return the associated trace log;

       o  purge data that is 30 days or older from the remote machine information directory;

       o  delete information that is 30 days or older from session trace log files;

       o  remove files from the tmp directory that are older than 1 day;

       o  remove files in the received facsimile queue that are 7 days or older;

       o  report sites that are currently having jobs rejected; and

       o  force all session log files to be owned by the fax user and kept with protection mode 644.

OPTIONS

       -n	 Forces faxcron to run without updating any files.

       -l lastrun
		 Forces  the  notion  of  the last time that faxcron was run to be lastrun.  The value of lastrun is a date and time string of the
		 form ``MM/DD/YY HH:MM'' (the date(1) format string ``%D %H:%M'').

       -info n	 Set the expiration time for data in the info database to be n days.

       -log n	 Set the expiration time for session log data to be n days.

       -rcv n	 Set the expiration time for files in the received facsimile queue to be n days.

       -tmp n	 Set the expiration time for files in the tmp directory to be n days.

       -mode m	 Set the file protection mode for session logs to m (a command line argument to chmod(1)).

NOTES

       This script requires nawk(1) or gawk(1) and a date (1) program that supports the ``+format'' option.

       If session logs are to be kept private this script must be modified to filter out sensitive information such as calling card numbers.   (It
       should also be run with ``-mode 0600'' so that session log files are not publicly readable.)

FILES

       /var/spool/hylafax		      spooling area
       /var/spool/hylafax/status/lastrun      timestamp of last run
       /usr/sbin/xferfaxstats		      for generating transmit statistics
       /usr/sbin/recvstats		      for generating receive statistics
       /var/spool/hylafax/tmp/faxcronXXXX     temporary file for truncating session logs
       /var/spool/hylafax/tmp/faxlogXXXX      temporary file for logs of failed calls

SEE ALSO

       cron(8), faxq(8), faxgetty(8), faxsend(8), xferfaxstats(8), recvstats(8), hylafax-server(5)

								   May 12, 1996 							FAXCRON(8)