Mailing List Archive: Missing table after update

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
Ntop@listgateway.unipi.it
http://listgateway.unipi.it/mailman/listinfo/ntop

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 <ralvarado@anycast.cl> 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
> Ntop@listgateway.unipi.it
> http://listgateway.unipi.it/mailman/listinfo/ntop