diff options
author | /C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org </C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org> | 2008-02-03 10:59:16 +0000 |
---|---|---|
committer | /C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org </C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org> | 2008-02-03 10:59:16 +0000 |
commit | 13d8c6b35b58325941ab9118d6c24684188ea9eb (patch) | |
tree | 114a87f26eb27a879c1e9f8562cba3c6af843e29 /ulogd.conf.in | |
parent | a532e3ec873e74bf3837e3e62ba7208efd1c78db (diff) |
From: Eric leblond <eric@inl.fr>
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
Diffstat (limited to 'ulogd.conf.in')
-rw-r--r-- | ulogd.conf.in | 7 |
1 files changed, 7 insertions, 0 deletions
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" |