IP Accounting

From Alpine Linux
Revision as of 01:41, 15 October 2010 by Larena (talk | contribs) (draft)
Jump to: navigation, search
Underconstruction clock icon gray.svg
This material is work-in-progress ...

Do not follow instructions here until this notice is removed.
(Last edited by Larena on 15 Oct 2010.)

This document will show how to configure pmacct for IP accounting. Pmacct will be configured as NetFlow and sFlow collector using PostgreSQL as DB backend.

Install and Configure pmacct

apk add pmacct pmacct-doc

On postgreSQL server launch the following scripts found in /usr/share/doc/pmacct/sql (make sure to change the default password for user "pmacct" in pmacct-create-db.pgsql):

postgres$ psql -d template1 -f pmacct-create-db.pgsql
postgres$ psql -d pmacct -f pmacct-create-table_v7.pgsql

NetFlow Collector Daemon

Edit /etc/nfmacctd.conf, changing "<HOSTNAME>" and "<PASSWORD>" to correct values:

daemonize: true
pidfile: /var/run/nfacctd.pid
syslog: daemon
sql_host: <HOSTNAME>
sql_passwd: <PASSWORD>
sql_table_version: 7
plugins: pgsql
sql_optimize_clauses: true
sql_recovery_logfile: /var/log/nfacct_recovery_log
sql_history: 5m
sql_history_roundoff: mhd
sql_dont_try_update: true
aggregate: src_host,dst_host,src_port,dst_port,proto

A full list of options supported by pmacct can be found here.