summaryrefslogtreecommitdiffstatsabout
path: root/utility/mod_log_sql.conf
blob: 72f02050f61a11cd7400e181b9287222ccf97ef9 (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
InputDirectory ./logs
ErrorLog ./error_log
DBConnect mysql://username:host@server/database
DBParam socketfile /tmp/mysql.sock
Table apache_logs
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)            source      [function [param]...]
OutputField bytes_sent int                  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                  date        totimestamp
OutputField status smallint                 status
OutputField request_uri varchar(255)        request     regexmatch "^\w+ (.+) \w+\.[\d\.]+$"
OutputField remote_user varchar(50)         user
OutputField remote_logname varchar(50)      ident
OutputField remote_time char(28)            date
#Only used for Combined log input, if standard CLF input, they are ignored
OutputField agent varchar(255)              agent
OutputField referer varchar(255)            referer