[pmacct-discussion] pmacct mysql setup

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

Re: [pmacct-discussion] pmacct mysql setup

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

Re: [pmacct-discussion] pmacct mysql setup

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

[pmacct-discussion] NFv9 Unknown Template

2016-03-10 Thread Robert Juric
I correct the mysql configuration and when I went to change and I restarted the service to change the table version I'm now seeing NFv9 packets received and discarded for Unknown Template. I've not been able to find much information regarding this. I'm using a Juniper SRX router with inline-jflow.

Re: [pmacct-discussion] NFv9 Unknown Template

2016-03-10 Thread Robert Juric
RX ? > > > > Best > > Adam > > > > *Od: *Robert Juric > *Wysłano: *czwartek, 10 marca 2016 18:13 > *Do: *pmacct-discussion@pmacct.net > *Temat: *[pmacct-discussion] NFv9 Unknown Template > > > > I correct the mysql configuration and when I went to ch

Re: [pmacct-discussion] Getting nfacctd to NOT aggregate ?

2016-04-19 Thread Robert Juric
I found you have to build the tables with timestamps and then when you aggregate with timestamp_start and timestamp_end you can get the individual flow records as opposed to aggregating the records. Robert Juric On Tue, Apr 19, 2016 at 9:00 AM, Dariush Marsh-Mossadeghi < dari...@gravitas.co

Re: [pmacct-discussion] Getting nfacctd to NOT aggregate ?

2016-04-19 Thread Robert Juric
No problem! If you feel like RTFM :), check out the official examples http://wiki.pmacct.net/OfficialExamples under Section XVII - Using pmacct as traffic/event logger; they have some initial information that can be used. It took me a little trial and error to figure it out. Robert Juric On Tue

Re: [pmacct-discussion] Looking for a fresh pmacct UI

2016-07-26 Thread Robert Juric
I had started to work with HighCharts to put a front-end together for my small deployment. I also wouldn't mind contributing to a project in any way I could. Robert Juric On Tue, Jul 26, 2016 at 9:58 AM, Davide Principi < davide.princ...@nethesis.it> wrote: > Thanks for the promp

Re: [pmacct-discussion] Looking for a fresh pmacct UI

2016-07-26 Thread Robert Juric
n Tue, Jul 26, 2016 at 10:52 AM, Davide Principi < davide.princ...@nethesis.it> wrote: > Thanks for chiming in! > > On Tue, 2016-07-26 at 10:23 -0500, Robert Juric wrote: > > I had started to work with HighCharts to put a front-end together for > > my small deployment. I

Re: [pmacct-discussion] Looking for a fresh pmacct UI

2016-08-02 Thread Robert Juric
Well would anyone else be interested in developing a dedicated front-end utilizing the existingpmacct database? Or is it the general consensus that everyone exports the pmacct data to other systems for graphical representation? On Tue, Aug 2, 2016 at 8:40 AM, Davide Principi wrote: > On Tue, 2

[pmacct-discussion] Nfacctd Unknown Templates

2016-11-08 Thread Robert Juric
I had nfacctd up and running, recording everything to a MySQL database. I just tried to swap it over to using the Memory plug-in so I can pull the data out to an rrd based graphing solution. However now I'm getting a debug message that the Netflow packet was discarded due to unknown template. Can

[pmacct-discussion] Graphing Options

2016-11-09 Thread Robert Juric
After fiddling around for a few days I'm still at a loss for finding a good graphing option. I've been working today trying to use the memory plugin and cacti to graph some data, but I realized that it won't be good for dynamic type graphs. I could easily graph total tcp/udp traffic since those do

Re: [pmacct-discussion] Graphing Options

2016-11-09 Thread Robert Juric
mp; curl will work. > > r. > > On 11/09/2016 11:01 PM, Robert Juric wrote: > > After fiddling around for a few days I'm still at a loss for finding a > > good graphing option. > > > > I've been working today trying to use the memory plugin and cacti to >

Re: [pmacct-discussion] Graphing Options

2016-11-24 Thread Robert Juric
FROM "dbname" WHERE $timeFilter and > "src" =~ /$src$/ GROUP BY timestamp > > $timeFilter is time window selected in Grafana to show (15 minutes, 30 > days) > > It is possible that i do not fully understand your use case, but i hope > this will help you

Re: [pmacct-discussion] How to get raw netflow data out of pmacct

2016-12-05 Thread Robert Juric
So its my understanding that the use of pmacctd/nfacctd as an accounting tool came later in the original design. Though I'd love to hear the story behind that. I assume the timestamp primitives were added later to differentiate flow records, but he didn't want to change the aggregate config key. S