summaryrefslogtreecommitdiffstats
path: root/contrib/README
diff options
context:
space:
mode:
authorGravatar Edward Rudd 2004-02-12 23:35:48 +0000
committerGravatar Edward Rudd 2004-02-12 23:35:48 +0000
commitf8a7d14c946632c1bea98db0f8bfbcb35f69760e (patch)
treed9cd002a815a11d65dbeb2303f605730cce1e87a /contrib/README
parent8816d3b3de90cd6b1c2f14ea3aaa4827392d9933 (diff)
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
Diffstat (limited to 'contrib/README')
-rw-r--r--contrib/README39
1 files changed, 38 insertions, 1 deletions
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 -?.