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? 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 is for this version a newer postgresql needed than in sarge included (version 7.4.7?) greetings thomas -- # Thomas Stegbauer # https://keyserver1.pgp.com/vkd/DownloadKey.event?keyid=0x9A3F1866FC68E91D # Key fingerprint = 5A2D FEDC 8A50 F1BB 25FB 967B 9A3F 1866 FC68 E91D _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
