diff options
Diffstat (limited to 'utility/mod_log_sql.conf')
-rw-r--r-- | utility/mod_log_sql.conf | 70 |
1 files changed, 70 insertions, 0 deletions
diff --git a/utility/mod_log_sql.conf b/utility/mod_log_sql.conf new file mode 100644 index 0000000..911fc18 --- /dev/null +++ b/utility/mod_log_sql.conf | |||
@@ -0,0 +1,70 @@ | |||
1 | InputDirectory ./logs | ||
2 | ErrorLog ./error_log | ||
3 | |||
4 | DBDDriver mysql | ||
5 | DBDParams "host=localhost;user=root;dbname=apache_log" | ||
6 | Table access_log | ||
7 | MachineID 7of9 | ||
8 | UseTransactions on | ||
9 | LogLevel notice | ||
10 | DryRun off | ||
11 | Summary on | ||
12 | |||
13 | SplitInput on | ||
14 | #SplitCount 4 | ||
15 | SplitMinLines 0 | ||
16 | SplitMaxLines 50000 | ||
17 | SplitDirectory ./split_temp | ||
18 | |||
19 | #ThreadCount 0 | ||
20 | |||
21 | BadLineFile ./badlines.log | ||
22 | BadLineMax 10 | ||
23 | |||
24 | LogFormatConfig CLF remhost String | ||
25 | LogFormatConfig CLF ident String | ||
26 | LogFormatConfig CLF user String | ||
27 | LogFormatConfig CLF date Date | ||
28 | LogFormatConfig CLF request String | ||
29 | LogFormatConfig CLF status Number | ||
30 | LogFormatConfig CLF bytes_sent Number | ||
31 | |||
32 | LogFormatConfig Combined remhost String | ||
33 | LogFormatConfig Combined ident String | ||
34 | LogFormatConfig Combined user String | ||
35 | LogFormatConfig Combined date Date | ||
36 | LogFormatConfig Combined request String | ||
37 | LogFormatConfig Combined status Number | ||
38 | LogFormatConfig Combined bytes_sent Number | ||
39 | LogFormatConfig Combined referer String | ||
40 | LogFormatConfig Combined agent String | ||
41 | |||
42 | LogFormat Combined | ||
43 | |||
44 | #Linefilter - "BAD" | ||
45 | #LineFilter "GOOD" | ||
46 | #LineFilter + "BETTER" | ||
47 | # the next filter ignores ALL lines | ||
48 | #LineFilter - | ||
49 | #PreFilter request - "Rebuild" | ||
50 | #PostFilter request_method "GET" | ||
51 | |||
52 | # Usage field datatype(size) default source [function [param]...] | ||
53 | OutputField bytes_sent int 0 bytes_sent | ||
54 | OutputField request_protocol varchar(10) "" request regexmatch "(HTTP/[\\d\\.]+)$" | ||
55 | OutputField remote_host varchar(50) "" remhost | ||
56 | OutputField request_method varchar(25) "" request regexmatch "^(\\w+)" | ||
57 | OutputField time_stamp int 0 date totimestamp | ||
58 | OutputField status smallint 0 status | ||
59 | OutputField request_line varchar(255) "" request | ||
60 | #OutputField request_uri varchar(255) "" request regexmatch "^\\w+ (.+) \\w+/[\\d\\.]+$" | ||
61 | OutputField remote_user varchar(50) "" user | ||
62 | OutputField remote_logname varchar(50) "" ident | ||
63 | OutputField request_time char(28) "" date wrap "[" "]" | ||
64 | #Only used for Combined log input, if standard CLF input, they are ignored | ||
65 | OutputField agent varchar(255) "" agent | ||
66 | OutputField referer varchar(255) "" referer | ||
67 | OutputField machine_id varchar(25) "" "" machineid | ||
68 | #VIZU Fields | ||
69 | OutputField poll_id int 0 request queryarg n "&;" | ||
70 | |||