Also curious about your sql_history_roundoff setting, is that even accepted by pmacct?
"sql_history_roundoff: mhM" I would think from your setup that you would just want 'M' in there for monthly time bins and take the 'm' and 'h' out. Cheers, -Brent From: pmacct-discussion [mailto:[email protected]] On Behalf Of Brent Van Dussen Sent: Monday, December 1, 2014 12:32 PM To: [email protected] 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:[email protected]] On Behalf Of Terry Duchcherer Sent: Monday, December 1, 2014 9:24 AM To: [email protected]<mailto:[email protected]> 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
