1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
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 -?.
|
