Hi,
we are using nfacctd to collect NAT events (event types 4 and 5,
https://www.iana.org/assignments/ipfix/ipfix.xml#ipfix-nat-event-type) into a
MySQL instance. We also want to rotate the table on a daily basis:
sql_table[natev]: natev_%Y_%m_%d
sql_table_schema[natev]: /path/to/schema.sql
schema.sql looks like this:
create table natev_%Y_%m_%d (
...
);
Currently, the generated table name is somehow named like "natev_1970_01_01",
allthough the timestamp_start and timestart_end fields of the collected NAT
events are correctly set.
I toyed around with the table-creation code in src/sql_common.c to enforce a
table-name with the right name, but the events are not stored in that created
table: "natev_1970_01_01" is used all the time.
Can you point me into the right direction on how to configure nfacctd to store
the NAT events into the right tables?
Thank you in advance,
--
Mathias Gumz
Email: [email protected]
Phone: +49-391-819099-228
----------------------- enabling your networks ----------------------
Travelping GmbH Phone: +49-391-81 90 99 0
Roentgenstr. 13 Fax: +49-391-81 90 99 299
39108 Magdeburg Email: [email protected]
GERMANY Web: http://www.travelping.com
Company Registration: Amtsgericht Stendal Reg No.: HRB 10578
Geschaeftsfuehrer: Holger Winkelmann VAT ID No.: DE236673780
---------------------------------------------------------------------
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
