Simon, Do you have a valid Pro license? Can you please explain what is the page that doesn't pull in MySQL data?
Simone On Fri, Mar 31, 2017 at 1:36 PM, Simon Bell <[email protected]> wrote: > Hi Simon, > > > > I’ve re-upped to the nightly builds still seeing the same issue, ignore > the other issue’s for now it was just complaining about some scripts not > being able to load. > > > > I have this from the mysql query log > > > > | 2017-03-31 11:36:02.280200 <02%20280200> | root[root] @ localhost [] > | 58 | 0 | Query | select COUNT(*) AS TOT_FLOWS, > SUM(IN_BYTES + OUT_BYTES) AS TOT_BYTES, SUM(PACKETS) AS TOT_PACKETS FROM > flowsv4 where FIRST_SWITCHED <= 1490956559 and FIRST_SWITCHED >= 1490952959 > AND (NTOPNG_INSTANCE_NAME='n4-wkf-netflow-01.node4.co.uk'OR > NTOPNG_INSTANCE_NAME IS NULL) AND (INTERFACE_ID='5') | > > > > > > If I run this query I get: > > > > +-----------+-----------+-------------+ > > | TOT_FLOWS | TOT_BYTES | TOT_PACKETS | > > +-----------+-----------+-------------+ > > | 436 | 3089612 | 96320 | > > > > (minus the first switched as I wasn’t logging traffic so I could just > capture the query ntop sends) > > > > So there is data there, it just seems unable to pull it into ntopng, I > gave it root user in case it was a permissions thing. > > > > Logs within NTOP: > > > > 31/Mar/2017 11:29:11 [MySQLDB.cpp:582] Attempting to connect to MySQL for > interface tcp://127.0.0.1:5000... > 31/Mar/2017 11:29:11 [MySQLDB.cpp:569] Disconnected from MySQL for > interface tcp://127.0.0.1:5000... > 31/Mar/2017 11:29:11 [MySQLDB.cpp:622] Successfully connected to MySQL > [localhost:root] for interface tcp://127.0.0.1:5005 > > > > Could it be because I’m running both individual interfaces, and a singular > combined as I hope to be able to give customers access to the combined, > whilst internally we still need to break down each individual link? > > > > Cheers > > > > Simon > > > > > Simon Bell > ------------------------------ > Core Network Architect > > ddi. *0845 123 2229* > t. *0845 123 2222* > e. *[email protected] <[email protected]>* *Wakefield Office* > Node4 Ltd, Pope Street, > Normanton, Wakefield, WF6 2TA > > > [image: Visit www.node4.co.uk] <http://www.node4.co.uk> > > [image: Visit www.node4.co.uk] <http://www.node4.co.uk> > [image: Visit Node4 on Twitter] <http://www.twitter.co.uk/Node4Ltd> > [image: Visit Node4 on Linkedin] > <https://www.linkedin.com/company/node4-ltd> > [image: Visit Node4 on Facebook] <http://www.facebook.com/Node4> > > > > > <http://www.node4.co.uk/blog/how-a-visit-to-cisco-inspired-the-node4-mobile-solution-centre/> > > > Node4 Limited is registered in England No: 04759927 and has its registered > office at Millennium Way, Pride Park, Derby, DE24 8HZ > The information contained in this email is confidential and is intended > for the exclusive use of the email addressee shown. > If you are not the addressee, any disclosure, reproduction, distribution > or other dissemination or use of this communication is strictly prohibited. > If you have received this mail in error, please notify our mail manager at > [email protected] and delete it from your system. > Opinions expressed in this email are those of the individual not the > company, unless specifically indicated to that effect. > ------------------------------ > This email has been scanned by Node4's Email Security System. > ------------------------------ > This email message has been delivered safely and archived online by > Mimecast. > > _______________________________________________ > Ntop mailing list > [email protected] > http://listgateway.unipi.it/mailman/listinfo/ntop >
_______________________________________________ Ntop mailing list [email protected] http://listgateway.unipi.it/mailman/listinfo/ntop
