Hi Mathias,

Can you please post your config? Gut feeling says you may be missing the
sql_history directive (essentially indicate what is the time-binning
period). 

Paolo
 
On Mon, Aug 28, 2017 at 03:36:02PM +0200, Mathias Gumz wrote:
> 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

_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists

Reply via email to