Roberto, This is very likely an issue with file permissions. Please refer to this comment: https://github.com/ntop/ntopng/issues/1517#issuecomment-336499444 <https://github.com/ntop/ntopng/issues/1517#issuecomment-336499444>
Regards > On 18 Oct 2017, at 14:27, Roberto Alvarado <[email protected]> wrote: > > 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
_______________________________________________ Ntop mailing list [email protected] http://listgateway.unipi.it/mailman/listinfo/ntop
