Re: [pmacct-discussion] pmacct mysql setup

[Robert Juric]

Thank you all for the suggestions. I found 2 issues. Running the debug from
CLI I noticed it was defaulting to the v1 table, when I ran that script it
resolved that. I then noticed it was discarding the NFv9 for unknown
template. I set "aggregate: none" and now I'm having records put into the
v1 table!!

However, I'm confused as to the differences or pros/cons between the table
versions?

On Wed, Mar 9, 2016 at 11:30 PM, fboehm  wrote:

> 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 don't need the additional fields that v9-tables provide.
> In general I'm not sure why it doesn't like the v9 settings.
>
>
> Franz
>
> ___
> pmacct-discussion mailing list
> http://www.pmacct.net/#mailinglists
>
___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists

Re: [pmacct-discussion] pmacct mysql setup

[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 don't need the additional fields that v9-tables 
provide. In general I'm not sure why it doesn't like the v9 settings.


Franz

___
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists

Re: [pmacct-discussion] pmacct mysql setup

[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 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  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

Re: [pmacct-discussion] pmacct mysql setup

[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 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