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 databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | pmacct | +--------------------+ 4 rows in set (0.00 sec) mysql> use pmacct; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +------------------+ | Tables_in_pmacct | +------------------+ | acct_v9 | +------------------+ 1 row in set (0.00 sec) 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 On Wed, Mar 9, 2016 at 10:34 AM, fboehm <fbo...@aon.at> wrote: > 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 differently. Could anyone provide >> any insight or links to documentation? >> > I used the debug parameter and debugged my SQL configuration this way. It > helped me. But depending on your configuration you might have to wait a few > minutes until the first data is written from pmacct internal buffer into > mysql database. > > Franz > > _______________________________________________ > pmacct-discussion mailing list > http://www.pmacct.net/#mailinglists >
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists