I am curious if the time change in November didn't cause us a problem. The server did not have ntp time synchronization on it, and the router sending netflow data did. This has now been corrected so this server syncs with the router.
Restarting the nfacctd service did create the new tables so all is good now, will watch this at the end of this month. From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] On Behalf Of Brent Van Dussen Sent: December-01-14 1:32 PM To: pmacct-discussion@pmacct.net Subject: Re: [pmacct-discussion] nfacctd did not create new db table Hi Terry, Did time change by an hour for you recently and does your server follow? It looks like your stamp_inserted shows up for 11-30 so that's definitely why it's going into the November table instead of December. Recommendation would be to lock server to GMT so it doesn't try to offset time, guessing pmacct isn't taking notice internally. Cheers, -Brent From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] On Behalf Of Terry Duchcherer Sent: Monday, December 1, 2014 9:24 AM To: pmacct-discussion@pmacct.net<mailto:pmacct-discussion@pmacct.net> Subject: [pmacct-discussion] nfacctd did not create new db table We have been running nfacctd for several months now, but last night it did not create new database files for December. Here is our config: daemonize: true pidfile: /var/run/nfacctd.pid plugins: mysql[inbound],mysql[outbound] sql_db: pmacct sql_host: ********** sql_user: ********** sql_passwd: ******** aggregate[inbound]: dst_host aggregate[outbound]: src_host nfacctd_port: 9996 sql_refresh_time: 120 sql_history: 1M sql_history_roundoff: mhM sql_table_version: 1 sql_table[inbound]: nfacctdown_%m sql_table[outbound]: nfacctup_%m sql_table_schema[inbound]: /etc/nfacctdown.schema sql_table_schema[outbound]: /etc/nfacctup.schema networks_file: /etc/nfacctd.networks networks_file_filter: true Instead of creating the new database tables, nfacctdown_12 and nfacctup_12, it just created a new row for the new months data. IE: Nov Data: stamp_inserted 2014-11-01 00:00:00 stamp_updated 2014-11-30 22:16:07 Dec Data: stamp_inserted 2014-11-30 23:00:00 stamp_updated 2014-12-01 09:43:40 This has worked properly in the past, just not this month. How can I get this to start using the correct table? How can I prevent this in the future? Terry
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists