Hi Robert,
Though I was using psql , but some experience of debugging here. Would you check the sql log? You might see access error, write error in sql log , or nothing. Either way it points to unsuccessfully write or something else. ________________________________ 從: pmacct-discussion <pmacct-discussion-boun...@pmacct.net> 代表 Robert Juric <robert.ju...@gmail.com> 寄件日期: 2016年03月10日 00:06 至: pmacct-discussion@pmacct.net 主旨: [pmacct-discussion] pmacct mysql setup 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
