summaryrefslogtreecommitdiffstats
path: root/doc/mysql-ulogd2.sql
Commit message (Collapse)AuthorAgeFilesLines
* Add SCTP support to MySQL and PGSQL output.Eric Leblond2008-12-091-3/+40
| | | | | | | | This patch adds support for SCTP in the MySQL and PGSQL output plugins. It adds a dedicated SCTP table and modifies the insert_packet_full procedure. Signed-off-by: Eric Leblond <eric@inl.fr>
* DB: update schemas to integrate the link layer informationEric Leblond2008-07-291-17/+51
| | | | | | | | | | | | This patch adds support for logging the destination mac address and raw header in the SQL databases. In case of an ethernet header, a tuple (mac_saddr,mac_daddr,mac_proto) is logged only once. Signed-off-by: Pierre Chifflier <chifflier@inl.fr> Signed-off-by: Eric Leblond <eric@inl.fr> Signed-off-by: Pablo Neira Ayuso <pablo@netfilter.org>
* Store MAC in SQL databases only oncePierre Chifflier2008-06-121-13/+19
| | | | | | | | | This patch modifies the SQL schema for MySQL and PostgreSQL to store the mac address only once (instead of duplicating the mac address for each packet). This is done by using a shared reference to the entry containing the tuple (mac_address,mac_protocol). Signed-off-by: Pierre Chifflier <chifflier@inl.fr>
* This patchset adds support for the "numeric_label" option. For instance, it/C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org2008-04-291-6/+10
| | | | | | | can be used to determine if the packet has been dropped, rejected or accepted. The meaning of label is completely user-defined. Signed-off-by: Eric Leblond <eric@inl.fr>
* Introduce function to convert binary data to printable strings./C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org2008-04-271-2/+37
| | | | | | Update view_tcp_quad and view_udp_quad. Signed-off-by: Pierre Chifflier <chifflier@inl.fr>
* Add function INSERT_CT for conntrack/C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org2008-04-271-27/+29
|
* Fix an inconsistency of field naming among the different tables and/C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org2008-04-091-2/+2
| | | | | | | accross the stack NFCT IP2BIN MYSQL.In fact IP2BIN out .bin suffixed fields. Signed-off-by: Eric Leblond <eric@inl.fr>
* This patch adds MAC address handling to the postgresql output plugin. This/C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org2008-04-051-18/+13
| | | | | | | patch also removes mac_daddr which does not provide any interesting logging information. Signed-off-by: Eric Leblond <eric@inl.fr>
* This patch adds oob.hook to the list of fields export to the databases. This/C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org2008-03-251-6/+11
| | | | | | | adds the capability to know where the packet has been logged and will be used to make a link between connection and logged packets. Signed-off-by: Eric Leblond <eric@inl.fr>
* From: Pierre Chifflier <chifflier@inl.fr> and Eric Leblond <eric@inl.fr>/C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org2008-02-091-6/+61
| | | | Add Icmpv6 support to SQL schema.
* From: Eric leblond <eric@inl.fr>/C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org2008-02-031-0/+28
| | | | | This patch adds an state extension to SQL schema. This can be used to store the information about the packet being dropped or accepted.
* From: Pierre Chifflier <chifflier@inl.fr>/C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org2008-02-031-4/+4
| | | | | SQL standard says a function has to be called with SELECT and not CALL. This patch modify code accordingly.
* From: Eric leblond <eric@inl.fr>/C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org2008-02-031-2/+2
| | | | This patch fixes some small typo in MySQL schema.
* From: Pierre Chifflier <chifflier@inl.fr>/C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org2008-02-031-65/+114
| | | | This patch adds oob_family to the schema. Thus it is now possible to easily select IPv4 or IPv6 entries in the database. This patch also explicitly selects fields to create view.
* From: Pierre Chifflier <p.chifflier@inl.fr>/C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org2008-02-031-18/+0
| | | | Add insert functions for the PostgreSQL version
* From: Eric leblond <eric@inl.fr>/C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org2008-02-031-0/+745
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