Hi Matt, It looks like the MySQL plugin is dying for whatever reason (which we should drill down). By looking at your config, the only thing which might smell as a possible cause is the sql_multi_values directive. Can you please try stripping it from your config and let me know if you manage to see data thrown at the MySQL database? If that's the case, we can take it from there.
Cheers, Paolo On Tue, Mar 24, 2009 at 01:15:02PM -0700, Matt Lawson wrote: > > Hi, > > When I leave nfacctd running, it works for a few minutes but then dies with > this: > > INFO: connection lost to 'default-mysql'; closing connection. > INFO: no more plugins active. Shutting down. > > Config is below (nfacctd_ip is sanitized) > > debug: true > daemonize: true > plugins: mysql > aggregate: dst_host, dst_port, src_host, src_port, vlan, src_as, dst_as, > tcpflags, tag, proto, flows > pre_tag_map: /home/matt/tagmap.txt > plugin_pipe_size: 10240000 > plugin_buffer_size: 10240 > interface: eth0 > nfacctd_ip: w.x.y.z > nfacctd_port: 5000 > nfacctd_time_secs: false > nfacctd_time_new: true > sql_refresh_time: 120 > sql_history: 5m > sql_history_roundoff: mh > sql_table_version: 7 > sql_db: pmacct > sql_host: 127.0.0.1 > sql_user: pmacct > sql_passwd: arealsmartpwd > sql_table: acct_v7 > sql_multi_values: 256000 > pidfile: /var/run/nfacctd > logfile: /var/log/nfacctd.log > > Any ideas? TIA. > > - matt _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
