Difference between revisions of "IP Accounting"

From Alpine Linux
Jump to: navigation, search
(Undo revision 4657 by Jbilyk (talk) fprobe will be used instead of softflowd)
(config settings fix)
Line 14: Line 14:
  
 
  postgres$ psql -d template1 -f pmacct-create-db.pgsql
 
  postgres$ psql -d template1 -f pmacct-create-db.pgsql
  postgres$ psql -d pmacct -f pmacct-create-table_v7.pgsql
+
  postgres$ psql -d pmacct -f pmacct-create-table_v1.pgsql
  
 
=== NetFlow Collector Daemon ===
 
=== NetFlow Collector Daemon ===
Line 26: Line 26:
 
  sql_host: <HOSTNAME>
 
  sql_host: <HOSTNAME>
 
  sql_passwd: <PASSWORD>
 
  sql_passwd: <PASSWORD>
  sql_table_version: 7
+
  sql_table_version: 1
  
 
  plugins: pgsql
 
  plugins: pgsql
  
 
  sql_optimize_clauses: true
 
  sql_optimize_clauses: true
sql_recovery_logfile: /var/log/nfacct_recovery_log
+
  sql_history: 1m
  sql_history: 5m
+
  sql_history_roundoff: m
  sql_history_roundoff: mhd
 
 
  sql_dont_try_update: true
 
  sql_dont_try_update: true
  
 
  aggregate: src_host,dst_host,src_port,dst_port,proto
 
  aggregate: src_host,dst_host,src_port,dst_port,proto
 +
 +
nfacctd_sql_log: true
  
 
A full list of options supported by pmacct can be found [http://wiki.pmacct.net/OfficialConfigKeys here].
 
A full list of options supported by pmacct can be found [http://wiki.pmacct.net/OfficialConfigKeys here].

Revision as of 10:23, 29 December 2010

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 29 Dec 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.

The following software have been used at the time of writing of this document:

* pmacct-0.12.4-r3
* postgresql 8.4

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_v1.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: 1
plugins: pgsql
sql_optimize_clauses: true
sql_history: 1m
sql_history_roundoff: m
sql_dont_try_update: true
aggregate: src_host,dst_host,src_port,dst_port,proto
nfacctd_sql_log: true

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