Hi Vitaliy, On Wed, 14 Oct 2009, Vitaliy Vladimirovich wrote:
> 1. I use ng_netflow + nfacctd + bwstat on my firewall box (FreeBSD). How > can I specify nfacctd to use UNIX-socket instead inet for communicate > with MySQL. I'm not sure if it's possible at the monent. I would have suggested removing the sql_host configuration key, but I guess you don't have one anyway. > 2. Main purpose of nfacctd is collect information about quantity of > downloaded and uploaded informations per IP per days. Below my > nfacct.conf... But in my situation, I am not using such fields as > mac_src, mac_dst, src_port, etc. So I wished to customize MySQL table > for performance. When I have removed this fields, the error was occur: > > === Start logging: 2009-10-12 17:49:14 === > > INFO ( outbound/mysql ): Pipe size obtained: 2048 / 4000. > INFO ( default/core ): waiting for data on UDP port '2001' > ERROR ( inbound/mysql ): Unknown column 'packets' in 'field list' > ERROR ( inbound/mysql ): Unknown column 'packets' in 'field list' > ERROR ( inbound/mysql ): Unknown column 'packets' in 'field list' > ERROR ( inbound/mysql ): Unknown column 'packets' in 'field list' > ..... How to solve this problem? Did you actually remove mac_src or packets? It looks like you removed the packets field. I'm afraid that's unsupported. You should be able to remove mac_src, mac_dst and other flow key fields, but not packets, bytes, stamp_inserted or stamp_updated. Cheers, Chris. -- Aptivate | http://www.aptivate.org | Phone: +44 1223 760887 The Humanitarian Centre, Fenner's, Gresham Road, Cambridge CB1 2ES Aptivate is a not-for-profit company registered in England and Wales with company number 04980791. _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
