Re: [pmacct-discussion] pmacct count only 5% of SYN packets.

2010-02-12 Thread Paolo Lucente
Hi Yuriy, Which version of pmacct you are using? Indeed the syntax for those SQL queries is wrong - but i've never seen that happening so i'm a bit puzzled. Are these issues related to a specific plugin or you can see such weird behaviour across all of them? Finally, can you post privately some of

Re: [pmacct-discussion] Pmacct data inconsistencies between tables.

2010-02-12 Thread Paolo Lucente
Hi Daniel, Unfortunately the configuration doesn't make evident where the issue can be. The 'sql_dont_try_update' very well protects against duplicate tuples - so i'm rather inclined to exclude that reason. Which version are you using? How you did discover the issue - ie. did you upgrade recentl

[pmacct-discussion] Pmacct data inconsistencies between tables.

2010-02-12 Thread Daniel Levy
Hi, I'm using pmacct to store data in two tables, one containing data recorded on a per minute basis, the other containing data recorded on an hourly basis. When I get data for the first table over a period of three hours, the download traffic (calculated by adding up the bytes field for traffic w