Hi. At first I want thank to author and othes who develops this project! And now my questions :-). 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. 2. Main purpose of nfacctd is collect information about quantity of downloaded and uploaded informations per IP per days. Below my nfacct.conf daemonize: true logfile: /var/log/nfacctd/nfacctd.log aggregate[inbound]: src_host aggregate[outbound]: dst_host aggregate_filter[inbound]: src net 10.0.29.0/24 and not dst host 10.0.29.254 aggregate_filter[outbound]: dst net 10.0.29.0/24 and not src host 10.0.29.254 ! plugin_pipe_size: 10240000 plugin_buffer_size: 10240 nfacctd_ip: 127.0.0.1 nfacctd_port: 2001 ! nfacctd_time_secs: true nfacctd_time_new: true ! plugins: mysql[inbound], mysql[outbound] sql_db: bwstat sql_table: acct sql_table_version: 1 sql_passwd: bigsecret sql_user: bwstat sql_history: 1d sql_history_roundoff: d sql_refresh_time: 60 sql_optimize_clauses: true sql_max_writers: 30 sql_cache_entries: 32771 sql_multi_values: 512000 ------ mysql> describe acct; +----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | mac_src | char(17) | NO | | NULL | | | mac_dst | char(17) | NO | | NULL | | | ip_src | char(15) | NO | MUL | NULL | | | ip_dst | char(15) | NO | MUL | NULL | | | src_port | int(2) unsigned | NO | | NULL | | | dst_port | int(2) unsigned | NO | | NULL | | | ip_proto | char(6) | NO | | NULL | | | packets | int(10) unsigned | NO | MUL | NULL | | | bytes | bigint(20) unsigned | NO | MUL | NULL | | | stamp_inserted | datetime | NO | MUL | NULL | | | stamp_updated | datetime | YES | MUL | NULL | | +----------------+---------------------+------+-----+---------+-------+ 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? TIA, Vit
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
