Hello, I'll get this kind of error: Apr 13 15:27:15 server pmacctd[1341]: ERROR ( default/mysql ): Duplicate entry '0-00:1c:c0:74:5b:e9-00:00:0c:07:ac:6a-0-84.38.64.216-79.221.203.' for key 1 Apr 13 15:27:15 server kernel: pmacctd[1341]: segfault at f7002991 ip 00000000f7bfa9ca sp 00000000ffb88334 error 4 in libpthread-2.3.6.so[f7bf2000+e000]
Only when using sql_dont_try_update: true (without the databaseserver is stressed too much): But I think the configuration is so, this shoudn't happen: ! pmacctd configuration ! ! ! daemonize: true pidfile: /var/run/pmacctd.pid syslog: daemon ! ! interested in in and outbound traffic !aggregate: src_host,dst_host aggregate: src_host,dst_host,dst_port,src_port,flows,dst_mac,proto,src_mac,vlan ! on this interface interface: eth0 ! post_tag: 1 ! storage methods plugins: mysql sql_db: pmacct sql_table: acct_v4 sql_table_version: 4 sql_passwd: verySecret ;) sql_user: pmacct ! refresh the db every 5 minute sql_refresh_time: 300 ! reduce the size of the insert/update clause sql_optimize_clauses: true ! accumulate values in each row for up to 5 minutes sql_history: 5m ! create new rows on the minute, hour, day boundaries sql_history_roundoff: mhd ! Multivalue-Support, bei mysql schneller sql_multi_values: 1024000 ! nur interessante Ports, reduktion der Datenmenge ports_file: /etc/pmacct/ports ! nur inserts !sql_dont_try_update: true ! intern puffern plugin_buffer_size: 2048 plugin_pipe_size: 2048000 Any hints? regards Johannes _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists