From f8a7d14c946632c1bea98db0f8bfbcb35f69760e Mon Sep 17 00:00:00 2001
From: Edward Rudd
Date: Thu, 12 Feb 2004 23:35:48 +0000
Subject: Added mysql_import_combined_log.pl to distribution with permission
 from Aaron Jenson http://www.visualprose.com/software.php (Original Source)
 Updated documentation in README for usage of contrib files/scripts

---
 contrib/Makefile.in |  5 ++++-
 contrib/README      | 39 ++++++++++++++++++++++++++++++++++++++-
 2 files changed, 42 insertions(+), 2 deletions(-)

(limited to 'contrib')

diff --git a/contrib/Makefile.in b/contrib/Makefile.in
index 7a020d9..b384fd0 100644
--- a/contrib/Makefile.in
+++ b/contrib/Makefile.in
@@ -3,7 +3,10 @@
 # Modify these top variables.
 SUBDIRS = 
 
-EXTRA_DIST = README create_tables.sql make_combined_log.pl
+EXTRA_DIST = README \
+		create_tables.sql \
+		make_combined_log.pl \
+		mysql_import_combined_log.pl
 
 #Don't modify anything below here
 
diff --git a/contrib/README b/contrib/README
index 7dac946..bf0e65f 100644
--- a/contrib/README
+++ b/contrib/README
@@ -1 +1,38 @@
-This directory contains contributed scripts/programs/utilites related to mod_log_sql.
+This directory contains contributed scripts/programs/utilites for mod_log_sql.
+
+* create_tables.sql
+
+This is the create table SQL commands to create the access, headers_in, 
+headers_out, cookies, and notes tables in the MySQL database.
+Use it like this.
+mysql -u user -h host -p apachelogdatabase < create_tables.sql
+Where:
+	user is the username to log in as,
+	host is the hostname the server is on, 
+	apachelogdatabase is the database to put the tables into
+	-p will have mysql ask you for a password for the user
+
+*make_combined_log.pl
+
+This perl script will extract the data from mod_log_sql's tables in the 
+database and export a standard Apache combined log file. Use this to run
+logs through a program like webalizer.
+
+You must edit the perl script to configure variables before you run it.
+Usage:
+./make_combined_log.pl days virtualhost
+Where:
+	days is the number of days to fetch (starting from now and going back 
+		in time)
+	virtualhost is the name of the virtualhost to retrieve
+
+Example:
+	./make_combined_log.pl 2 example.com
+
+*mysql_import_combined_log.pl
+
+This is a perl script written by Aaron Jenson that imports a combined log file
+from apache into a SQL database table.. You can use this script to import logs
+from a webserver you are converting over from the standard Apache log system to
+mod_log_sql.  A Usage statement can be fetch by running the program with no 
+parameters or with --help or -?.
-- 
cgit