OK - I think I've found the problem. It looks like it requires the professional license to view historical flow information.
For example, if I restart ntopng so I have a 10-minute license, I can then see the top flows but after the 10-minute license expires, it says "No results found." Is this intended? Sent from my iPad > On Feb 9, 2016, at 7:07 AM, Simone Mainardi <[email protected]> wrote: > > Please, find method getInterfaceTopFlows in file > scripts/lua/modules/db_utils.lua and change the line > > if(db_debug == true) then io.write(sql.."\n") end > > to > > if(1) then io.write(sql.."\n") end > > Then, look at ntopng console output, you'll see an SQL query. Put that query > directly into MySQL and see if you can get any results. Also please send that > query so we can see if it's ok. > > > Simone > > > >> On Sat, Feb 6, 2016 at 3:27 PM, Luca Deri <[email protected]> wrote: >> John >> can you please do some debugging in lua to see if we create a bad SQL query >> perhaps? >> >> Luca >> >>> On 06 Feb 2016, at 15:26, John Klimek <[email protected]> wrote: >>> >>> I've just checked and the flowsv4 table has lots and lots of data in it... >>> >>> It seems like it is storing something, because the traffic graph shows >>> total throughput and I can go back for several days. However, it's just >>> the 'Flows' section under the graph that doesn't show the specific flow >>> information. >>> >>>> On Sat, Feb 6, 2016 at 9:16 AM, Joseph Jackson <[email protected]> >>>> wrote: >>>> Can you access the database directly and check to see if the data is being >>>> stored? Any errors in syslog about unable to connect to the db instance? >>>> >>>> >>>> >>>> From: [email protected] >>>> [mailto:[email protected]] On Behalf Of John Klimek >>>> Sent: Saturday, February 06, 2016 8:15 AM >>>> To: [email protected] >>>> Subject: [Ntop] Enabled SQL history but not saving flows? >>>> >>>> >>>> >>>> I'm using the latest version of ntopng and I've enabled the SQL server >>>> connection (using -F), but it doesn't seem to be saving the flow >>>> information. >>>> >>>> >>>> >>>> For example, if I select my interface and then select 'Historical' it >>>> shows me the traffic graph, but on the bottom section under 'IPv4' and >>>> 'IPV6', it says 'No results found.' >>>> >>>> >>>> >>>> What am I doing wrong? >>>> >>>> >>>> _______________________________________________ >>>> Ntop mailing list >>>> [email protected] >>>> http://listgateway.unipi.it/mailman/listinfo/ntop >>> >>> _______________________________________________ >>> Ntop mailing list >>> [email protected] >>> http://listgateway.unipi.it/mailman/listinfo/ntop >> >> >> _______________________________________________ >> Ntop mailing list >> [email protected] >> http://listgateway.unipi.it/mailman/listinfo/ntop > > _______________________________________________ > Ntop mailing list > [email protected] > http://listgateway.unipi.it/mailman/listinfo/ntop
_______________________________________________ Ntop mailing list [email protected] http://listgateway.unipi.it/mailman/listinfo/ntop
