Hi all, I am collecting flows with nfacctd (pmacct 0.14), and I have found this message in the pmacctd.log:
Jul 25 09:20:05 ERROR ( default/mysql ): Unknown column 'src_port' in 'where clause' Jul 25 09:20:05 ERROR ( default/mysql ): Unknown column 'src_port' in 'where clause' Jul 25 09:20:05 ERROR ( default/mysql ): Unknown column 'src_port' in 'where clause' Jul 25 09:20:05 ERROR ( default/mysql ): Unknown column 'src_port' in 'where clause' Jul 25 09:20:05 ERROR ( default/mysql ): Unknown column 'src_port' in 'where clause' My pmacctd.conf is: debug: false 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 classifiers: /etc/pmacct/classifiers/ plugins: mysql, memory sql_db: pmacct sql_table: acct_v8_%H%M sql_table_version: 8 sql_user: xxx sql_passwd: yyy sql_refresh_time: 300 sql_optimize_clauses: true sql_history: 1h sql_history_roundoff: mh sql_locking_style: row logfile: /var/log/pmacctd.log nfacctd_port: 5678 Does anybody know why this happen? Thanks! -- Atenciosamente Leonardo Augusto Sápiras
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists