Database networks table was not inserted genuine data and console not working.

[Johnston557]

Hi, team, I am now trying to set up a set of Akvorado on my Ubuntu 24 server.
Due to network restriction, I'm unavailable to set up the set with Docker nether Source, thus I was using executable APP.
Due to lack of many default config files, I got stuck by many steps but fortunately almost everything were solved, but there's one step to reach the end stops me again, and this time I can't find any feature on the internet to help me solve this issue.

Issue: The "networks" table in database for Akvorado was not inserted any genuine data, then console can't generate any figures.

Core features and configuration

Release:

Distributor ID: Ubuntu
Description: Ubuntu 24.04.3 LTS
Release: 24.04
Codename: noble

Orchestrator:

http:
listen: 0.0.0.0:8103
clickhousedb:
servers: 127.0.0.1:9000
username: default
password: *******
database: akvorado

Inlet:

http:
listen: 0.0.0.0:8101
flow:
inputs:
- type: udp
decoder: netflow
listen: :2056
workers: 4
receive-buffer: 212992
use-src-addr-for-exporter-addr: true
- type: udp
decoder: sflow
listen: :6343
workers: 4
receive-buffer: 212992

Outlet:

http:
listen: 0.0.0.0:8102
flow:
state-persist-file:
/tmp/NetFlow/flow_info.state
metadata:
workers: 10
providers:
- type: snmp
credentials:
::/0:
communities:
- AAcwaN2019
cache-persist-file: /var/lib/akvorado/outlet/cache-persist.tmp
core:
default-sampling-rate: 100
clickhousedb:
servers: 127.0.0.1:9000
username: default
password: *******
database: akvorado

Console:

http:
listen: 0.0.0.0:8104
clickhouse:
servers: 127.0.0.1:9000
username: default
password: admin@123
database: akvorado

Key Troubleshooting Log

Outlet I/O log:

sudo curl -s http://127.0.0.1:8102/api/v0/outlet/metrics | grep -P 'akvorado_outlet_core_(received|forwarded)'
akvorado_outlet_core_forwarded_flows_total{exporter="10.255.255.54"} 24797
akvorado_outlet_core_received_flows_total{exporter="10.255.255.54"} 24797
akvorado_outlet_core_received_flows_total{exporter="127.0.0.1"} 933
akvorado_outlet_core_received_raw_flows_total 5237

Outlet Error Messages:

sudo curl -s http://127.0.0.1:8102/api/v0/outlet/metrics | grep 'akvorado_outlet_core.*errors‘
[sudo] password for a-chize:
akvorado_outlet_core_flows_errors_total{error="input and output interfaces missing",exporter="127.0.0.1"} 933
Note: This should be due to ignored local traffic, for the exporter 10.255.255.54, there's no significant error message.

Database Dictionary Status:

SELECT name, status, origin, element_count, last_exception FROM system.dictionaries

SELECT
name,
status,
origin,
element_count,
last_exception
FROM system.dictionaries

Query id: ffd1c1c5-b08b-466f-a3b8-c4e98e645b2f

┌─name──────┬─status─┬─origin───────────────────────────────┬─element_count─┬─last_exception─┐

1. │ udp │ LOADED │ 66ec029a-93f7-4825-ae6a-dce3808f9ec0 │ 5493 │ │
   2. │ networks │ LOADED │ 6571a82c-19c4-47ea-b9ec-02ae88ec2cb0 │ 0 │ │
2. │ icmp │ LOADED │ 3634c31e-0b1d-4878-9c62-c7ba772453e9 │ 58 │ │
3. │ protocols │ LOADED │ f8531ee7-e855-4e52-b36c-aa7e6027eec3 │ 129 │ │
4. │ tcp │ LOADED │ 9ff19644-ebfb-4297-b9e3-7548e5a2d4c4 │ 5882 │ │
5. │ asns │ LOADED │ 597287d3-54f1-478b-9f8c-752efab1e729 │ 102132 │ │
   └───────────┴────────┴──────────────────────────────────────┴───────────────┴────────────────┘

6 rows in set. Elapsed: 0.005 sec.
Note: Here it is telling that there's no data wrote to networks, while there's no exception happens to dictionary table.

Summary

I've tried to ask Chat-GPT what's going on but it just told me that I should put "networks" feature into Outlet->Metadata. While going through the official documents, I didn't see similar feature within Outlet yaml configuration, thus I think Chat-GPT is telling shit. (This mf did a lot of shit which has wasted me a lot of time earlier)

I have no choice but to counting on this resort, if anyone could share me with your solution if you have ever encountered into similar issue, I'll be sincerely appreciate your help!

[vincentbernat]

This looks mostly OK. You need to configure interface classification to get something meaningful in the console.

The networks table is empty because you don't have GeoIP databases. You need to put them in /usr/share/GeoIP.

[Johnston557]

This looks mostly OK. You need to configure interface classification to get something meaningful in the console.

The networks table is empty because you don't have GeoIP databases. You need to put them in /usr/share/GeoIP.

Hi, Vincent:

Thank you for your reply.

I put a 3rd party GeoIP database to a location and then put a simple interface classification there, then I can see the figure there, thank you for you kindly support!