On Mon 28 Aug 2006 19:43, Thomas Stegbauer wrote: > hi ml, > > i am currentliy trying pmacct - cause netflow2mysql doesn't fit my > vision's ;) or at least mysql doesn't run my queries without full > table-locks, even with innodb. > > so first i tried to run the nfacctd from sarge (version 0.7.4) > > but starting the process with; > nfacctd -D -c src_host,dst_host -l 33333 -P pgsql -f > /etc/pmacct/nfacctd.conf > > > daemonize: false > ! aggregate_filter[dummy]: src net 192.168.0.0/16 > ! aggregate[dummy]: src_host, dst_host > ! plugin_buffer_size: 1024 > ! nfacctd_port: 5678 > ! nfacctd_time_secs: true > nfacctd_time_new: true > plugins: pgsql > !plugins: mysql[dummy] > sql_db: netflow2pg > sql_table: acct_v2 > sql_table_version: 2 > sql_passwd: xxxx > sql_user: pmacct > sql_refresh_time: 90 > sql_host: 192.168.0.3 > ! sql_optimize_clauses: true > sql_history: 10m > sql_history_roundoff: mh > ! sql_preprocess: qnum=1000, minp=5 > ! networks_file: ./networks.example > ! ports_file: ./ports.example > > doesn't open the port, nor get data written the table. > > question: > > is it possible to run nfacctd and postgresql on different host's?
The following works fine for me: sql_host: x.x.x.x sql_db: db sql_table_version: 4 sql_passwd: pass sql_user: pmacct sql_optimize_clauses: true > so i downloaded version 0.11.0rc2 > and tried to compile with > configure --enable-pgsql > but this stopps with: > > checking whether to enable PostgreSQL support... yes > checking default locations for libpq... found in /usr/lib > checking default locations for libpq-fe.h... not found > checking for libpq-fe.h... no > configure: error: ERROR: missing PostgreSQL headers Either fix your build environment or pass --with-pgsql-includes= to configure. -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc
pgpLjZ8D4BT12.pgp
Description: PGP signature
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
