summaryrefslogtreecommitdiffstatsabout
path: root/utility/mod_log_sql.conf
blob: 97309834469c6fc4837eda10565c3ec7316f6b08 (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
InputDirectory ./logs
ErrorLog ./error_log
DBDDriver mysql
DBDParams "host=localhost;user=root;dbname=apache_log"
DBParam socketfile /tmp/mysql.sock
Table access_log
MachineID 7of9
UseTransactions on
LogLevel notice
DryRun on
Summary on

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

# not yet implemented
Linefilter - "BAD"
PreFilter request - "GET \/images"
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_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        regexmatch ".+" "[$0]"
#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