diff options
Diffstat (limited to 'utility/mod_log_sql.conf')
-rw-r--r-- | utility/mod_log_sql.conf | 32 |
1 files changed, 17 insertions, 15 deletions
diff --git a/utility/mod_log_sql.conf b/utility/mod_log_sql.conf index 72f0205..9730983 100644 --- a/utility/mod_log_sql.conf +++ b/utility/mod_log_sql.conf | |||
@@ -1,8 +1,9 @@ | |||
1 | InputDirectory ./logs | 1 | InputDirectory ./logs |
2 | ErrorLog ./error_log | 2 | ErrorLog ./error_log |
3 | DBConnect mysql://username:host@server/database | 3 | DBDDriver mysql |
4 | DBDParams "host=localhost;user=root;dbname=apache_log" | ||
4 | DBParam socketfile /tmp/mysql.sock | 5 | DBParam socketfile /tmp/mysql.sock |
5 | Table apache_logs | 6 | Table access_log |
6 | MachineID 7of9 | 7 | MachineID 7of9 |
7 | UseTransactions on | 8 | UseTransactions on |
8 | LogLevel notice | 9 | LogLevel notice |
@@ -34,17 +35,18 @@ Linefilter - "BAD" | |||
34 | PreFilter request - "GET \/images" | 35 | PreFilter request - "GET \/images" |
35 | PostFilter request_method "GET" | 36 | PostFilter request_method "GET" |
36 | 37 | ||
37 | # Usage field datatype(size) source [function [param]...] | 38 | # Usage field datatype(size) default source [function [param]...] |
38 | OutputField bytes_sent int bytes_sent | 39 | OutputField bytes_sent int 0 bytes_sent |
39 | OutputField request_protocol varchar(10) request regexmatch "(HTTP\/[\d\.]+)$" | 40 | OutputField request_protocol varchar(10) "" request regexmatch "(HTTP/[\\d\\.]+)$" |
40 | OutputField remote_host varchar(50) remhost | 41 | OutputField remote_host varchar(50) "" remhost |
41 | OutputField request_method varchar(25) request regexmatch "^(\w+)" | 42 | OutputField request_method varchar(25) "" request regexmatch "^(\\w+)" |
42 | OutputField time_stamp int date totimestamp | 43 | OutputField time_stamp int 0 date totimestamp |
43 | OutputField status smallint status | 44 | OutputField status smallint 0 status |
44 | OutputField request_uri varchar(255) request regexmatch "^\w+ (.+) \w+\.[\d\.]+$" | 45 | OutputField request_uri varchar(255) "" request regexmatch "^\\w+ (.+) \\w+/[\\d\\.]+$" |
45 | OutputField remote_user varchar(50) user | 46 | OutputField remote_user varchar(50) "" user |
46 | OutputField remote_logname varchar(50) ident | 47 | OutputField remote_logname varchar(50) "" ident |
47 | OutputField remote_time char(28) date | 48 | OutputField request_time char(28) "" date regexmatch ".+" "[$0]" |
48 | #Only used for Combined log input, if standard CLF input, they are ignored | 49 | #Only used for Combined log input, if standard CLF input, they are ignored |
49 | OutputField agent varchar(255) agent | 50 | OutputField agent varchar(255) "" agent |
50 | OutputField referer varchar(255) referer | 51 | OutputField referer varchar(255) "" referer |
52 | OutputField machine_id varchar(25) "" "" machineid | ||