Hi all,
I've downloaded v1.5.1 and am configuring nfacctd to collect netflow v9
flows, but it seems that nfacctd is not writing to the correct table,
when setting sql_table_version: 9:
$ nfacctd -V
NetFlow Accounting Daemon, nfacctd 1.5.1 (20150215-01)
--enable-jansson --enable-mysql --enable-64bit --enable-threads
$ cat /etc/pmacctd/nfacctd.conf
pidfile: /var/run/nfacctd.pid
plugins: mysql
sql_db: pmacct
sql_host: localhost
sql_user: pmacct
...snip password...
aggregate: sum_host
nfacctd_port: 5678
sql_refresh_time: 120
sql_history: 10m
sql_history_roundoff: mh
sql_table_version: 9
$ nfacctd -f /etc/pmacctd/nfacctd.conf
sudo nfacctd -f /etc/pmacct/nfacctd.conf
INFO ( default/core ): Reading configuration file
'/etc/pmacct/nfacctd.conf'.
INFO ( default/core ): waiting for NetFlow data on 0.0.0.0:5678
...snip...
^CINFO ( default/mysql ): *** Purging cache - START (PID: 19712) ***
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Table 'pmacct.acct'
doesn't exist
You can see that it is trying to write to the v1 table, pmacct.acct
When I set it to sql_table_version: 8 it correctly tries to write to
pmacct.acct_v8:
$ cat /etc/pmacctd/nfacctd.conf
...snip all kept the same...
sql_table_version: 8
$ sudo nfacctd -f /etc/pmacct/nfacctd.conf
INFO ( default/core ): Reading configuration file
'/etc/pmacct/nfacctd.conf'.
INFO ( default/core ): waiting for NetFlow data on 0.0.0.0:5678
...snip...
^CINFO ( default/mysql ): *** Purging cache - START (PID: 19792) ***
ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble.
ERROR ( default/mysql ): The SQL server says: Table 'pmacct.acct_v8'
doesn't exist
I've also tried 1.5.0 with the same result.
Have I made a configuration/compilation error with pmacct such that it
is not allowing v9 flow?
regards, Yu-Phing
Disclaimer: use of our emails are governed by terms at http://360-jambo.com/emd
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists
