Re: [pmacct-discussion] Duplicate entry for key 1 (primary key violations)

2012-07-18 Thread Chris Wilson
Hi Paolo, On Fri, 29 Jun 2012, Paolo Lucente wrote: On Tue, Jun 26, 2012 at 10:13:30AM +0100, Chris Wilson wrote: OK, testing now. Would it be possible for pmacctd to log a warning if it exceeds any of these thresholds, to help with tuning without wasting memory? In a way you reckon things

Re: [pmacct-discussion] Errors in compilation

2012-07-18 Thread Paolo Lucente
Hi Slava, On Mon, Jul 16, 2012 at 10:13:30PM +0300, Viacheslav Dubrovskyi wrote: I still can not upgrade a package due to this error. The error occurs when enable --enable-ipv6. I do not want to disable ipv6. Maybe help me find the problem? Reproduced on various versions of the compiler.

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

2012-07-18 Thread Paolo Lucente
Hi Leonardo, Solution to not get the error is to set sql_optimize_clauses to true so to flag you are going to provide a custom table (which you do as you provide a sql_table_schema) and disable versioning checks. It can be an idea for the future (simple enough to code after all) to assume

Re: [pmacct-discussion] Closing connection with client messages

2012-07-18 Thread Paolo Lucente
Hi Chunsing, On Tue, Jul 17, 2012 at 05:59:21PM +0800, Kerk Chun Sing wrote: I'm exporting flows to pmacct (using memory plugin) and have Cacti plot the data. There are regular gaps in the plotted graph. Can you comment on the overall setup? How the memory table is being queried by Cacti -

Re: [pmacct-discussion] Duplicate entry for key 1 (primary key violations)

2012-07-18 Thread Paolo Lucente
Hi Chris, On Wed, Jul 18, 2012 at 12:45:34PM +0100, Chris Wilson wrote: Thanks for doing that :) I'm testing the latest CVS now. OK, keep me posted. I did notice that restarting the daemon generates these duplicate key errors. Restarting isn't completely compatible with an always insert

Re: [pmacct-discussion] Duplicate entry for key 1 (primary key violations)

2012-07-18 Thread Chris Wilson
Hi Paolo, On Wed, 18 Jul 2012, Paolo Lucente wrote: On an unrelated note, how hard would it be to get the log message from ULOG stored in the database, for example in the classification field? I had a look through the code but I couldn't see any way to store this field from the received

Re: [pmacct-discussion] Closing connection with client messages

2012-07-18 Thread Kerk Chun Sing
HI Paolo, I have configured Cisco Nexus to export L2 netfow. Pmacct is matching and counting the bytes for IPv4 and IPv6 based on ethertype. plugins: memory aggregate: src_mac,dst_mac,etype,vlan,flows From Cacti, there