Hello, You probably have a problem in the database schema version number. Check that the version number you are using (looks like it is 8) matches the file you used to create the database schema. Check in the directory sql/ you will find several files with version number. Make sure you use the file: sql/pmacct-create-db-v8.mysql
On Jul 25, 2012, at 2:26 PM, Leonardo Sápiras wrote: > 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 _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
