Re: [pmacct-discussion] pmacct mysql setup

2016-03-09 Thread fboehm
Am 09.03.2016 um 20:39 schrieb Robert Juric: I think this is because I only ran the v9 MySQL script. I was just a little confused, should I run all the scripts, just v1, or which? Robert, please run the v4 SQL scripts and set "sql_table_version: 4" in your configuration. Maybe you anyway

[pmacct-discussion] 回覆: pmacct mysql setup

2016-03-09 Thread itriA30110
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

Re: [pmacct-discussion] pmacct mysql setup

2016-03-09 Thread Robert Juric
I turned on the debug command by running "nfacctd -d true -P mysql" and I saw this after capturing some flow records: ERROR ( default/mysql ): PRIMARY 'mysql' backend trouble. ERROR ( default/mysql ): The SQL server says: Table 'pmacct.acct' doesn't exist I looked in MySQL and found: mysql> show

Re: [pmacct-discussion] pmacct mysql setup

2016-03-09 Thread fboehm
Am 09.03.2016 um 17:06 schrieb Robert Juric: 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

[pmacct-discussion] pmacct mysql setup

2016-03-09 Thread Robert Juric
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