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: [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 _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
