Hello everyone, this is my first post to this mailing list, and well any
mailing list.

I've installed pmacct on Debian and I'm working with nfacctd. I've verified
nfacctd is able to gather data by using the command "nfacctd -l 2055 -P
print -c src_host,dst_host,src_port,dst_port" and I see it captures flow
data.

However when I change it to use a config file and using the mysql plugin
I'm not seeing any records added to the database.

When I compiled, I used ./configure --enable-mysql, and then I ran the
mysql scripts in /sql:
mysql -u root -p < pmacct-create-db_v9.mysql
mysql -u root -p < pmacct-grant-db.mysql

My nfacctd.conf file looks like:
!
daemonize: true
plugins: mysql
aggregate: src_host,dst_host,src_port,dst_port
nfacctd_port: 2055
sql_refresh_time: 120
sql_history: 10m
sql_history_roundoff: mh
sql_table_version: 9
!

MySQL runs fine, I see the pmacct DB and the acct_v9 table, but it is
empty. Other than that I'm not sure where to go next to get MySQL working.
I'm not sure how I would configure credentials or even a remote MySQL
server if I were to deploy it differently. Could anyone provide any insight
or links to documentation?

Thank you,

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

Reply via email to