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: mathias.g...@travelping.com
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:  i...@travelping.com
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

Reply via email to