Re: Missing table after update - flows_alerts

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