From 13d8c6b35b58325941ab9118d6c24684188ea9eb Mon Sep 17 00:00:00 2001 From: "/C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org" Date: Sun, 3 Feb 2008 10:59:16 +0000 Subject: From: Eric leblond This patch adds new SQL schema for MySQL and PGsql. The goal is to improve the one line per entry format. There is no more a big table with all fields because this sort of storage is causing bad performance (databases don't like to have a lot of NULL fields to store). Main changes are : * Add new schema for MySQL and PGsql * Use call to configurable procedure in SQL OUTPUT modules * Arguments of a procedure are given by the list of fields of a selected table --- ulogd.conf.in | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'ulogd.conf.in') diff --git a/ulogd.conf.in b/ulogd.conf.in index 16d3d1a..d43f1fd 100644 --- a/ulogd.conf.in +++ b/ulogd.conf.in @@ -70,3 +70,10 @@ sync=1 file="/var/log/ulogd_oprint.log" sync=1 +[mysql1] +db="nulog" +host="localhost" +user="nupik" +table="ulog" +pass="changeme" +procedure="INSERT_PACKET_FULL" -- cgit v1.2.3