summaryrefslogtreecommitdiffstats
path: root/contrib
diff options
context:
space:
mode:
Diffstat (limited to 'contrib')
-rw-r--r--contrib/Makefile.in5
-rw-r--r--contrib/README39
2 files changed, 42 insertions, 2 deletions
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 @@
3# Modify these top variables. 3# Modify these top variables.
4SUBDIRS = 4SUBDIRS =
5 5
6EXTRA_DIST = README create_tables.sql make_combined_log.pl 6EXTRA_DIST = README \
7 create_tables.sql \
8 make_combined_log.pl \
9 mysql_import_combined_log.pl
7 10
8#Don't modify anything below here 11#Don't modify anything below here
9 12
diff --git a/contrib/README b/contrib/README
index 7dac946..bf0e65f 100644
--- a/contrib/README
+++ b/contrib/README
@@ -1 +1,38 @@
1This directory contains contributed scripts/programs/utilites related to mod_log_sql. 1This directory contains contributed scripts/programs/utilites for mod_log_sql.
2
3* create_tables.sql
4
5This is the create table SQL commands to create the access, headers_in,
6headers_out, cookies, and notes tables in the MySQL database.
7Use it like this.
8mysql -u user -h host -p apachelogdatabase < create_tables.sql
9Where:
10 user is the username to log in as,
11 host is the hostname the server is on,
12 apachelogdatabase is the database to put the tables into
13 -p will have mysql ask you for a password for the user
14
15*make_combined_log.pl
16
17This perl script will extract the data from mod_log_sql's tables in the
18database and export a standard Apache combined log file. Use this to run
19logs through a program like webalizer.
20
21You must edit the perl script to configure variables before you run it.
22Usage:
23./make_combined_log.pl days virtualhost
24Where:
25 days is the number of days to fetch (starting from now and going back
26 in time)
27 virtualhost is the name of the virtualhost to retrieve
28
29Example:
30 ./make_combined_log.pl 2 example.com
31
32*mysql_import_combined_log.pl
33
34This is a perl script written by Aaron Jenson that imports a combined log file
35from apache into a SQL database table.. You can use this script to import logs
36from a webserver you are converting over from the standard Apache log system to
37mod_log_sql. A Usage statement can be fetch by running the program with no
38parameters or with --help or -?.