Re: [pmacct-discussion] Newbie

2014-04-05 Thread Mike Hammett
I did run across the 2010 version and pulled bits out of it. I'll review the 
updated version and see what I can find. 

I have been able to get a ton of data into MySQL, but turning raw data into 
something useful has been challenging. I did setup pmGraph, but that seems 
rather limited in what it does. 




- 
Mike Hammett 
Intelligent Computing Solutions 
http://www.ics-il.com 



- Original Message -

From: "Chris Wilson"  
To: pmacct-discussion@pmacct.net 
Sent: Saturday, April 5, 2014 2:39:39 PM 
Subject: Re: [pmacct-discussion] Newbie 

Hi Mike, 

On Sat, 5 Apr 2014, Mike Hammett wrote: 

> The OfficialConfigKeys is very verbose and no doubt holds the key (no 
> pun intended) to every possible configuration, but all config examples 
> I've found seem drastically simplistic or seemingly incomplete. 

Try this one: 

daemonize: false 
debug: true 
pidfile: /var/run/nfacctd.pid 
! logfile: /var/log/nfacctd.log 
! syslog: daemon 
nfacctd_port: 4096 
plugins: mysql 
aggregate: src_host, src_port, dst_host, dst_port, proto 
sql_db: pmacct 
sql_table: acct_v8 
sql_history: 1m 
sql_history_roundoff: m 
sql_table_version: 8 
sql_host: 127.0.0.1 
sql_user: pmacct 
sql_passwd: X 
sql_refresh_time: 60 
sql_dont_try_update: true 
sql_optimize_clauses: true 
sql_preprocess: minb = 1 

>From page 47 of: 
http://www.ws.afnog.org/afnog2013/tutorials/bmo/afnog-bmo-presentation.odp 

Cheers, Chris. 
-- 
Aptivate | http://www.aptivate.org | Phone: +44 1223 967 838 
Citylife House, Sturton Street, Cambridge, CB1 2QF, UK 

Aptivate is a not-for-profit company registered in England and Wales 
with company number 04980791. 


___ 
pmacct-discussion mailing list 
http://www.pmacct.net/#mailinglists 

___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists

Re: [pmacct-discussion] Newbie

2014-04-05 Thread Chris Wilson

Hi Mike,

On Sat, 5 Apr 2014, Mike Hammett wrote:

The OfficialConfigKeys is very verbose and no doubt holds the key (no 
pun intended) to every possible configuration, but all config examples 
I've found seem drastically simplistic or seemingly incomplete.


Try this one:

daemonize: false
debug: true
pidfile: /var/run/nfacctd.pid
! logfile: /var/log/nfacctd.log
! syslog: daemon
nfacctd_port: 4096
plugins: mysql
aggregate: src_host, src_port, dst_host, dst_port, proto
sql_db: pmacct
sql_table: acct_v8
sql_history: 1m
sql_history_roundoff: m
sql_table_version: 8
sql_host: 127.0.0.1
sql_user: pmacct
sql_passwd: X
sql_refresh_time: 60
sql_dont_try_update: true
sql_optimize_clauses: true
sql_preprocess: minb = 1


From page 47 of:

http://www.ws.afnog.org/afnog2013/tutorials/bmo/afnog-bmo-presentation.odp

Cheers, Chris.
--
Aptivate | http://www.aptivate.org | Phone: +44 1223 967 838
Citylife House, Sturton Street, Cambridge, CB1 2QF, UK

Aptivate is a not-for-profit company registered in England and Wales
with company number 04980791.


___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists


[pmacct-discussion] Newbie

2014-04-05 Thread Mike Hammett
The OfficialConfigKeys is very verbose and no doubt holds the key (no pun 
intended) to every possible configuration, but all config examples I've found 
seem drastically simplistic or seemingly incomplete. 

I am an ISP looking to keep a historical record of interface usage and be 
analyze how protocol, AS, etc. behaviors change over time. There is currently 
no desire to use this for accounting purposes, just network 
planning\engineering. 

I'm presuming I need the BGP table and the v8 table. 

I would be using netflow from Mikrotik routers, not pcap. 




- 
Mike Hammett 
Intelligent Computing Solutions 
http://www.ics-il.com 



___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists