InputDirectory ./logs ErrorLog ./error_log DBDDriver mysql DBDParams "host=localhost;user=root;dbname=apache_log" Table access_log MachineID 7of9 UseTransactions on LogLevel debug DryRun off Summary on 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 "&;"