Thanks Paolo.

I didn’t understand it because I skipped the section about Custom SQL tables 
because I *assumed* since I did not intend to use custom sql tables, I didn’t 
need any of the information contained there. 

Seems like you always use a custom table (even when you use the example SQL 
files in the distribution), and aggregation is how you specify the columns 
you’re interested in.


From: Paolo Lucente
Sent: 12 May 2018 14:35
Subject: Re: [pmacct-discussion] Aggregation

Hi Fanen,

Simplest would be to give you a try, even on your laptop with an active
internet connection. Do a:

shell> pmacctd -i <interface> -c src_host,dst_host,src_port,dst_port,proto

Query it in another terminal window with:

shell> pmacct -s

Then stop the first pmacctd instance and re-do as: 

shell> pmacctd -i <interface> -c src_host,dst_host

Query it in the other terminal window with:

shell> pmacct -s

Granted -c sets the aggregation method and not specifying any plugins it
defaults to the memory table one, this should already answer several of
your questions. You can also read:


On Fri, May 11, 2018 at 10:47:45AM +0100, Fanen Ahua wrote:
> Hi,
> I’m quite new to pmacct, and I’m using the pcap interface to try to do some 
> accounting on my homebrew router based on ubuntu 18.04. 
> I’m struggling to understand the meaning of some of configuration, even 
> though there is a relatively good reference at 
> I feel like it’s perhaps the lack 
> of examples.
> Anyway, I’m wondering:
> •  what aggregation does. 
> • When does it happen? 
> • Should I expect to see new tables created when it has run?
> I’m trying to understand this so I can customise or develop a UI to enable me 
> visualise the accounting data. 
> Thanks in advance,
> Fanen.  

> _______________________________________________
> pmacct-discussion mailing list

pmacct-discussion mailing list

pmacct-discussion mailing list

Reply via email to