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, 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
Node4 Ltd. Pope Street, Normanton, Wakefield, WF6 2TA.
ddi. 0845 123 2229 | t. 0845 123 2222
e. S.Bell@node4.co.uk
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 abuse@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 inbound by Node4's Email Security System.
This email message has been delivered safely and archived online by Mimecast.
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, 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
Node4 Ltd. Pope Street, Normanton, Wakefield, WF6 2TA.
ddi. 0845 123 2229 | t. 0845 123 2222
e. S.Bell@node4.co.uk
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 abuse@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 inbound by Node4's Email Security System.
This email message has been delivered safely and archived online by Mimecast.