Re: Historical Data Issue's

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