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 @@
+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 0
+
+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 "&;"
+