Historical Flows lists do not show up about ntopng HOT 6 CLOSED

This issue has been resolved in the development branch with the commit c78ba0d and was reported in the closed issue (#8217).

@akusilvennoinen1, a new stable version with the fix should be available in a few hours. Please update and let us know if everything is alright.

from ntopng.

Hi, @NicoMaio : tested the version 6.0.240313 and it was fixed, thank you! 👍

from ntopng.

I concur that historical flows works now using 6.1.240314 (FreeBSD 14.0) on hosts.

I do notice some drop down selections are really hard to read in dark mode. ie Time selections Last xxx and some others.

from ntopng.

I do get the below error on the L7 contacts. The chart updates but the table does not which I am assuming the below error is. I do not use IPV6 and only IPV4.

14/Mar/2024 09:15:48 [historical_db_search.lua:44] [clickhouse_utils.lua:1246] WARNING Failure: Code: 47. DB::Exception: Missing columns: 'IPV6_SRC_ADDRc' while processing query: 'SELECT VLAN_ID, IPv4NumToString(IPV4_SRC_ADDR) AS IPV4_SRC_ADDR_FORMATTED, IPv4NumToString(IPV4_DST_ADDR) AS IPV4_DST_ADDR_FORMATTED, IPv6NumToString(IPV6_SRC_ADDR) AS IPV6_SRC_ADDR_FORMATTED, IPv6NumToString(IPV6_DST_ADDR) AS IPV6_DST_ADDR_FORMATTED, any(SRC_LABEL) AS SRC_LABEL, any(DST_LABEL) AS DST_LABEL, PROTOCOL, L7_PROTO, L7_PROTO_MASTER, count() AS count, sum(TOTAL_BYTES) AS total_bytes FROM flows WHERE ((INTERFACE_I
14/Mar/2024 09:15:48 [historical_db_search.lua:44] [clickhouse_utils.lua:1245] WARNING Query: SELECT VLAN_ID,IPv4NumToString(IPV4_SRC_ADDR) IPV4_SRC_ADDR_FORMATTED,IPv4NumToString(IPV4_DST_ADDR) IPV4_DST_ADDR_FORMATTED,IPv6NumToString(IPV6_SRC_ADDR) IPV6_SRC_ADDR_FORMATTED,IPv6NumToString(IPV6_DST_ADDR) IPV6_DST_ADDR_FORMATTED,any(SRC_LABEL) AS SRC_LABEL,any(DST_LABEL) AS DST_LABEL,PROTOCOL,L7_PROTO,L7_PROTO_MASTER,COUNT() AS count,SUM(TOTAL_BYTES) AS total_bytes FROM flows WHERE ((INTERFACE_ID=2) AND ((((IP_PROTOCOL_VERSION = 4) AND (flows.IPV4_SRC_ADDR=IPv4StringToNum('10.57.1.155'))) OR (flows.SRC_LABEL=('10.57.1.155'))) )) AND (FIRST_SEEN >= 1710420318 AND FIRST_SEEN <= 1710422118 AND LAST_SEEN <= 1710422118) GROUP BY VLAN_ID,IPV4_SRC_ADDR,IPV4_DST_ADDR,IPV6_SRC_ADDR,IPV6_DST_ADDR,PROTOCOL,L7_PROTO,L7_PROTO_MASTER ORDER BY IPv4NumToString(IPV4_SRC_ADDR) asc, IPv6NumToString(IPV6_SRC_ADDRc) asc LIMIT 10
14/Mar/2024 09:15:48 [MySQLDB.cpp:46] ERROR SQL error (1): Code: 47. DB::Exception: Missing columns: 'IPV6_SRC_ADDRc' while processing query: 'SELECT VLAN_ID, IPv4NumToString(IPV4_SRC_ADDR) AS IPV4_SRC_ADDR_FORMATTED, IPv4NumToString(IPV4_DST_ADDR) AS IPV4_DST_ADDR_FORMATTED, IPv6NumToString(IPV6_SRC_ADDR) AS IPV6_SRC_ADDR_FORMATTED, IPv6NumToString(IPV6_DST_ADDR) AS IPV6_DST_ADDR_FORMATTED, any(SRC_LABEL) AS SRC_LABEL, any(DST_LABEL) AS DST_LABEL, PROTOCOL, L7_PROTO, L7_PROTO_MASTER, count() AS count, sum(TOTAL_BYTES) AS total_bytes FROM flows WHERE ((INTERFACE_I
14/Mar/2024 09:15:48 [MySQLDB.cpp:45] ERROR SQL query: SELECT VLAN_ID,IPv4NumToString(IPV4_SRC_ADDR) IPV4_SRC_ADDR_FORMATTED,IPv4NumToString(IPV4_DST_ADDR) IPV4_DST_ADDR_FORMATTED,IPv6NumToString(IPV6_SRC_ADDR) IPV6_SRC_ADDR_FORMATTED,IPv6NumToString(IPV6_DST_ADDR) IPV6_DST_ADDR_FORMATTED,any(SRC_LABEL) AS SRC_LABEL,any(DST_LABEL) AS DST_LABEL,PROTOCOL,L7_PROTO,L7_PROTO_MASTER,COUNT() AS count,SUM(TOTAL_BYTES) AS total_bytes FROM flows WHERE ((INTERFACE_ID=2) AND ((((IP_PROTOCOL_VERSION = 4) AND (flows.IPV4_SRC_ADDR=IPv4StringToNum('10.57.1.155'))) OR (flows.SRC_LABEL=('10.57.1.155'))) )) AND (FIRST_SEEN >= 1710420318 AND FIRST_SEEN <= 1710422118 AND LAST_SEEN <= 1710422118) GROUP BY VLAN_ID,IPV4_SRC_ADDR,IPV4_DST_ADDR,IPV6_SRC_ADDR,IPV6_DST_ADDR,PROTOCOL,L7_PROTO,L7_PROTO_MASTER ORDER BY IPv4NumToString(IPV4_SRC_ADDR) asc, IPv6NumToString(IPV6_SRC_ADDRc) asc LIMIT 10
14/Mar/2024 09:15:48 [MySQLDB.cpp:947] Successfully connected to ClickHouse [[email protected]:9004][dbname: ntopng] for interface ix0

from ntopng.

Hi @dkggpeters, could you please open another issue?

from ntopng.

Verified as fixed.

from ntopng.