Hi Marek,
combining inbound+outbound traffic in one row is not possible; but you can
use two different tables for inbound and outbound traffic; you will be able
to achieve precisely your goal by looking at the following configuration
fragment (which should be quite intuitive):

===
...
daemonize: true
pidfile: /var/run/pmacctd.pid
syslog: daemon
interface: eth1

plugins: mysql[in], mysql[out]

aggregate[in]: dst_host
aggregate_filter[in]: dst net 80.87.0.0/16
sql_table[in]: acct_in

aggregate_filter[out]: src net 80.87.0.0/16
aggregate[out]: src_host
sql_table[out]: acct_out

sql_db : bwstat
sql_table_version : 1
sql_passwd : secretpassword
sql_user : bwstat
sql_refresh_time : 60
sql_history : 1h
sql_history_roundoff : mh
...
===

You will need to create the acct_in, acct_out SQL tables yourself. Remember
that each directive which comes with no [plugin] is applied to ALL plugins.
aggregate_filter has same syntax of pcap_filter but you will be able to bind
it to specific plugins. 

If you notice a load coming from pmacctd rather than from the DB, take also
a look to bufferization. Q4 of FAQS is about this.

Hopint this helps.

Cheers,
Paolo


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

Reply via email to