[pmacct-discussion] nfacctd_renormalize and sql_preprocess: usrf=10 not working

[Slava Dubrovskiy]

Hi.

Use nfacct-0.12.0rc1

I trying use nfacctd_renormalize option and use sql_preprocess: usrf=10

Make config:

debug: true
daemonize: true
pidfile: /var/run/nfacctd.pid
syslog: daemon
nfacctd_port: 8818
plugin_buffer_size: 10240
plugin_pipe_size: 1024000

aggregate: src_host, dst_host, src_port, dst_port, proto
aggregate[min]: src_host, dst_host, src_port, dst_port, proto
aggregate[hourly]: src_host, dst_host
plugins: mysql[min], mysql[hourly]
sql_table[min]: acct
sql_table[hourly]: acct_base

networks_file: /etc/pmacct/networks.list
ports_file: /etc/pmacct/ports.list

sql_host: 91.0.0.0
sql_passwd: xxxxx
sql_table_version: 1

nfacctd_time_new: true
sql_dont_try_update: true
sql_multi_values: 1000000
sql_locking_style: row
sql_history_roundoff[min]: m
sql_history[min]: 15m
sql_refresh_time[min]: 900

sql_history_roundoff[hourly]: h
sql_history[hourly]: 1h
sql_refresh_time[hourly]: 3600

sql_recovery_logfile[min]: /var/lib/pmacct/recovery_log
sql_recovery_logfile[hourly]: /var/lib/pmacct/recovery_log_base

sql_preprocess: usrf=10
nfacctd_renormalize: true


And after as I add "sql_preprocess: usrf=10" it stop write to database.
If I comment sql_preprocess: usrf=10 - working, but not renormalize traffic.

What is wrong? Is it necessary set sql_preprocess: usrf=10 or
nfacctd_renormalize: true enough?

-- 
WBR,
Dubrovskiy Vyacheslav

smime.p7s
Description: S/MIME Cryptographic Signature

_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists