Hi Jonas, On Tue, 9 Feb 2010, Jonas Nylund wrote:
> In logfile i see this > > Feb 9 16:47:46 oam02 sfacctd[14477]: DEBUG ( default/mysql ): INSERT INTO > `acct_v5_06` (stamp_updated, stamp_inserted, vlan, src_port, dst_port, tos, > ip_proto, agent_id, class_id, mac_src, mac_dst, ip_src, ip_dst, packets, > bytes, flows) VALUES (FROM_UNIXTIME(1265730466), FROM_UNIXTIME(1265730300), > 200, 6007, 54654, 104, 'ip', 0, 'unknown', '0:0:0:0:0:0', '0:0:0:0:0:0', > '0.0.0.0', '0.0.0.0', 1, 242, 0) > > As you can see a lot of fields are inserted with null values. This is how the aggregate setting is supposed to work. The fields not listed in "aggregate" have different values for all the aggregated packets, so there is no sensible value to set them to, so pmacct zeroes them. I'm surprised that src_port and dst_port have values given your configuration: > aggregate: vlan,tos 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