Yes, removing that line seems to have stopped it from dying. Thanks, Matt
--- On Tue, 3/24/09, Paolo Lucente <[email protected]> wrote: > From: Paolo Lucente <[email protected]> > Subject: Re: [pmacct-discussion] connection lost to 'default-mysql' > To: [email protected] > Date: Tuesday, March 24, 2009, 2:44 PM > > -----Inline Attachment Follows----- > > 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 > _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
