[pmacct-discussion] The accounting of flows requires SQL table v4?

2010-02-08 Thread Zenon Mousmoulas
Hi, plugins: mysql[sqltest] sql_optimize_clauses[sqltest]: true sql_table[sqltest]: acct ... aggregate: src_as, [...] flows, tag I also tried aggregate[sqltest]: src_as, [...] flows, tag It is also in my schema: create table acct ( id INT(4) UNSIGNED NOT NULL AUTO_INCREMENT,

[pmacct-discussion] pre_tag_map issue + questions

2010-02-08 Thread Zenon Mousmoulas
Hi, I have a netflow v9 feed to nfacctd from a juniper router (JUNOS 9.6R2.11), using a service pic. According to a packet capture, records include ingress and egress interface and they seem to be properly defined in the corresponding template. I've tried to use the snmp ifindex numbers

Re: [pmacct-discussion] The accounting of flows requires SQL table v4?

2010-02-08 Thread Paolo Lucente
Hi Zenon, Good to see you around again. Please add to your config: sql_table_version[sqltest]: 4 Reason being most of the primitives are still connected to the SQL table versioning concept (in essence: pmacct expects you to make explicit which SQL schema you are running). This is in the

Re: [pmacct-discussion] pre_tag_map issue + questions

2010-02-08 Thread Paolo Lucente
Hi Zenon, On Mon, Feb 08, 2010 at 10:37:54AM +0200, Zenon Mousmoulas wrote: I have a netflow v9 feed to nfacctd from a juniper router (JUNOS 9.6R2.11), using a service pic. According to a packet capture, records include ingress and egress interface and they seem to be properly defined

Re: [pmacct-discussion] pre_tag_map issue + questions

2010-02-08 Thread Zenon Mousmoulas
Hi Paolo, On 08 Φεβ 2010, at 12:28 ΜΜ, Paolo Lucente wrote: On Mon, Feb 08, 2010 at 10:37:54AM +0200, Zenon Mousmoulas wrote: I have a netflow v9 feed to nfacctd from a juniper router (JUNOS 9.6R2.11), using a service pic. According to a packet capture, records include ingress and egress

Re: [pmacct-discussion] The accounting of flows requires SQL table v4?

2010-02-08 Thread Paolo Lucente
HI Zenon, It turned to be a bug. It's now fixed and change is already committed to the CVS. Please give it a try and let me know. Cheers, Paolo On Mon, Feb 08, 2010 at 02:22:41PM +0200, Zenon Mousmoulas wrote: Hi Paolo, it's nice to be back :) I had already tried adding this directive (and