Hi Folks,
Today after update ntopng I got his errors on the ntopng log:
18/Oct/2017 09:17:14 [AlertsManager.cpp:814] ERROR: SQL Error: step [INSERT
INTO flows_alerts (alert_tstamp, alert_type, alert_severity, alert_json,
vlan_id, proto, l7_proto, first_switched, last_switched, cli_country,
srv_country, cli_os, srv_os, cli_asn, srv_asn, cli_addr, srv_addr, cli_port,
srv_port, cli2srv_bytes, srv2cli_bytes, cli2srv_packets, srv2cli_packets,
cli2srv_tcpflags, srv2cli_tcpflags, cli_blacklisted, srv_blacklisted,
cli_localhost, srv_localhost) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); ][SQL logic error or missing
database]
A lots of this lines per second…
But if I check the database:
MariaDB [ntop]> show tables;
+----------------+
| Tables_in_ntop |
+----------------+
| aggrflowsv4 |
| aggrflowsv6 |
| flowsv4 |
| flowsv6 |
+----------------+
4 rows in set (0.00 sec)
MariaDB [ntop]>
The table “flows_alerts” isnt there…
Ntopng version:
root@mhost:/var/log/ntopng# ntopng -V
v.3.1.171018 [Enterprise/Professional build]
GIT rev: dev:5809e7500a6d61c2e2caa56440ba8d3f3e160fb6:20171018
Pro rev: r1196
Built on: Debian GNU/Linux 8.2 (jessie)
System Id: {REMOVED}
Platform: x86_64
Edition: Professional
License Type: Permanent
Maintenance: Until Thu Mar 22 12:28:01 2018 [155 days left]
License: {REMOVED}
root@mhost:/var/log/ntopng#
Can you share with me the create statement for the missing table?
Thanks
Regards
Roberto
_______________________________________________
Ntop mailing list
[email protected]
http://listgateway.unipi.it/mailman/listinfo/ntop
