Simon, On Thu, Mar 30, 2017 at 5:36 PM, Simon Bell <s.b...@node4.co.uk> wrote:
> Hi All, > > > > Running version > > *Version* > > 2.4.170215 > <https://github.com/ntop/ntopng/commit/2d9a5131d5fd1107e27c0f7c13acf98ad6fa4680> > - Pro Small Business Edition > > > > ntopng --user "root" --pid "/var/run/ntopng.pid" --http-port "80" > --interface "tcp://127.0.0.1:5000,tcp://127.0.0.1:5001,tcp://127.0.0.1: > 5002,tcp://127.0.0.1:5003" --interface "tcp://127.0.0.1:5000" --interface > "tcp://127.0.0.1:5001" --interface "tcp://127.0.0.1:5002" --interface > "tcp://127.0.0.1:5003" --interface "tcp://127.0.0.1:5004" --interface > "tcp://127.0.0.1:5005" --max-num-flows "800000" --max-num-hosts "750000" > --dump-flows "mysql;localhost;ntopng;flows;xxxx;xxxx > > > > Can see addition to sql database and can see query’s: > > > > sudo tail /home/mysql/mysql-bin.000691 > > #ntopngINSERT INTO `flowsv4` (VLAN_ID,L7_PROTO,IP_SRC_ADDR, > L4_SRC_PORT,IP_DST_ADDR,L4_DST_PORT,PROTOCOL,IN_BYTES, > OUT_BYTES,PACKETS,FIRST_SWITCHED,LAST_SWITCHED,INFO, > JSON,NTOPNG_INSTANCE_NAME,INTERFACE_ID,PROFILE) VALUES > ('0','7','1571720224','80','1367824450','49547','6',' > 165400','0','8320','0','0','',COMPRESS('{ "8": "93.174.140.32", "12": > "81.135.88.66", "7": 80, "11": 49547, "4": 6, "57590": 7, "57591": "HTTP", > "6": 16, "2": 8320, "1": 165400, "24": 0, "23": 0, "22": 0, "21": 0, > "json": "{ \"15\": \"195.66.224.69\", \"10\": \"559\", \"14\": \"561\", > \"152\": \"1490881913000\", \"153\": \"1490881913000\", \"5\": \"0\", > \"16\": \"65001\", \"17\": \"2856\", \"9\": \"25\", \"13\": \"12\", \"42\": > \"1289839\" }", "57595": 0.000000, "57596": 0.000000, "SRC_IP_COUNTRY": > "GB", "SRC_IP_LOCATION": [ -0.600000, 51.483299 ], "DST_IP_COUNTRY": "GB", > "DST_IP_LOCATION": [ -0.122400, 51.496399 ], > > > > However GUI refuses to show any data and behaves like a database isn’t > connected. Flows doesn’t show under the interface (it disappears on page > load) > > > > Running mariadb with innodb engine. > > > > Have been all the way up to the nightly builds, which then breaks other > and doesn’t fix historical, > We have fixed several issues related to the historical in the nightly builds. You should move to those versions as we can't support you on the stable as this is not a security issue. Saying "breaks other and doesn't fix historical" doesn't help much. Please explain. We should also see error logs, exceptions, etc. Use our github issue tracker to report any issue and the steps to reproduce. this version shows everything we need, I just need some guidance on the > historical data as, as far as I can see this should work. > > > > MariaDB [ntopng]> show tables; > > +------------------+ > > | Tables_in_ntopng | > > +------------------+ > > | flowsv4 | > > | flowsv6 | > > > > > > Ntopng created the tables once pointed at mysql. Mariadb data has been > shifted from default location to a different drive. > > > > Cheers > > > > Simon > > > > > Simon Bell > ------------------------------ > Core Network Architect > > ddi. *0845 123 2229* > t. *0845 123 2222* > e. *s.b...@node4.co.uk <s.b...@node4.co.uk>* *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 > ab...@node4.co.uk 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 > Ntop@listgateway.unipi.it > http://listgateway.unipi.it/mailman/listinfo/ntop >
_______________________________________________ Ntop mailing list Ntop@listgateway.unipi.it http://listgateway.unipi.it/mailman/listinfo/ntop