diff options
| -rw-r--r-- | contrib/Makefile.in | 5 | ||||
| -rw-r--r-- | contrib/README | 39 |
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. |
| 4 | SUBDIRS = | 4 | SUBDIRS = |
| 5 | 5 | ||
| 6 | EXTRA_DIST = README create_tables.sql make_combined_log.pl | 6 | EXTRA_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 @@ | |||
| 1 | This directory contains contributed scripts/programs/utilites related to mod_log_sql. | 1 | This directory contains contributed scripts/programs/utilites for mod_log_sql. |
| 2 | |||
| 3 | * create_tables.sql | ||
| 4 | |||
| 5 | This is the create table SQL commands to create the access, headers_in, | ||
| 6 | headers_out, cookies, and notes tables in the MySQL database. | ||
| 7 | Use it like this. | ||
| 8 | mysql -u user -h host -p apachelogdatabase < create_tables.sql | ||
| 9 | Where: | ||
| 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 | |||
| 17 | This perl script will extract the data from mod_log_sql's tables in the | ||
| 18 | database and export a standard Apache combined log file. Use this to run | ||
| 19 | logs through a program like webalizer. | ||
| 20 | |||
| 21 | You must edit the perl script to configure variables before you run it. | ||
| 22 | Usage: | ||
| 23 | ./make_combined_log.pl days virtualhost | ||
| 24 | Where: | ||
| 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 | |||
| 29 | Example: | ||
| 30 | ./make_combined_log.pl 2 example.com | ||
| 31 | |||
| 32 | *mysql_import_combined_log.pl | ||
| 33 | |||
| 34 | This is a perl script written by Aaron Jenson that imports a combined log file | ||
| 35 | from apache into a SQL database table.. You can use this script to import logs | ||
| 36 | from a webserver you are converting over from the standard Apache log system to | ||
| 37 | mod_log_sql. A Usage statement can be fetch by running the program with no | ||
| 38 | parameters or with --help or -?. | ||
