diff options
Diffstat (limited to 'contrib/README')
| -rw-r--r-- | contrib/README | 39 |
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 @@ | |||
| 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 -?. | ||
