2012/8/3 Paolo Lucente <[email protected]>

> Hi Leonardo,
>
> Add in_iface primitive to aggregate. If using an SQL plugin then read
> sql/README.iface for advices on how to modify the SQL table schema.
>
>
Thanks Paolo, I added this primitive to aggregate, and the in_iface (I am
using sql_optimize_clauses: true) column in my database. But, it's only
saving '0' as value.

Do you know what is missing?

Below my pmacctd.config

interface: eth0
daemonize: true
post_tag: 1
aggregate: src_host, dst_host, src_port, dst_port, class, src_mac, dst_mac,
tcpflags, proto, tos, flows, peer_src_ip, in_iface
classifiers: /etc/pmacct/classifiers/
plugins: mysql, memory
sql_db: pmacct
sql_table: acct_v8_%H00
sql_table_schema: <path to schema>/schema.sql
sql_user: xxx
sql_passwd: yyy
sql_refresh_time: 30
sql_dont_try_update: true
nfacctd_time_new: true
sql_use_copy: true
sql_optimize_clauses: true
sql_history: 5m
sql_history_roundoff: h
sql_locking_style: row
logfile: /var/log/pmacctd.log
nfacctd_port: 5678


--
Atenciosamente
Leonardo Augusto Sápiras
[http://www.leonardosapiras.com.br]
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists

Reply via email to