summaryrefslogtreecommitdiffstatsabout
path: root/utility/mod_log_sql.conf
blob: 92d567ce3e18489874d942e5a1b1e1250c7b2840 (plain)
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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
InputDirectory ./logs
ErrorLog ./error_log

DBDDriver mysql
DBDParams "host=localhost;user=root;dbname=apache_log"
Table access_log
MachineID 7of9
UseTransactions on
LogLevel notice
DryRun off
Summary on

SplitInput on
#SplitCount 4
SplitMinLines 0
SplitMaxLines 50000
SplitDirectory ./split_temp

#ThreadCount 1

BadLineFile ./badlines.log
BadLineMax 10

LogFormatConfig CLF remhost String
LogFormatConfig CLF ident String
LogFormatConfig CLF user String
LogFormatConfig CLF date Date
LogFormatConfig CLF request String
LogFormatConfig CLF status Number
LogFormatConfig CLF bytes_sent Number

LogFormatConfig Combined remhost String
LogFormatConfig Combined ident String
LogFormatConfig Combined user String
LogFormatConfig Combined date Date
LogFormatConfig Combined request String
LogFormatConfig Combined status Number
LogFormatConfig Combined bytes_sent Number
LogFormatConfig Combined referer String
LogFormatConfig Combined agent String

LogFormat Combined

#Linefilter - "BAD"
#LineFilter "GOOD"
#LineFilter + "BETTER"
# the next filter ignores ALL lines
#LineFilter -
#PreFilter request - "Rebuild"
#PostFilter request_method "GET"

# Usage     field            datatype(size) default source      [function [param]...]
OutputField bytes_sent       int 0                  bytes_sent
OutputField request_protocol varchar(10) ""         request     regexmatch "(HTTP/[\\d\\.]+)$"
OutputField remote_host      varchar(50) ""         remhost
OutputField request_method   varchar(25) ""         request     regexmatch "^(\\w+)"
OutputField time_stamp       int 0                  date        totimestamp
OutputField status           smallint 0             status
OutputField request_line     varchar(255) ""        request
#OutputField request_uri      varchar(255) ""        request     regexmatch "^\\w+ (.+) \\w+/[\\d\\.]+$"
OutputField remote_user      varchar(50) ""         user
OutputField remote_logname   varchar(50) ""         ident
OutputField request_time     char(28) ""            date        wrap "[" "]"
#Only used for Combined log input, if standard CLF input, they are ignored
OutputField agent            varchar(255) ""        agent
OutputField referer          varchar(255) ""        referer
OutputField machine_id       varchar(25) ""         ""          machineid
#VIZU Fields
OutputField poll_id          int 0                  request     queryarg n "&;"