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: 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
http://www.pmacct.net/#mailinglists

Reply via email to