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. Regards, Fanen. From: Paolo Lucente Sent: 12 May 2018 14:35 To: [email protected] 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: https://github.com/pmacct/pmacct/blob/master/QUICKSTART Paolo 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 > http://wiki.pmacct.net/OfficialConfigKeys. 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 > http://www.pmacct.net/#mailinglists _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
