FastNetMon Community (1.2.9) and grafana dashboards

[Stephen “Doctor Madjik” Falken]

Hello community :)

While testing FastNetMon community edition and following the installation instructions for both the community fastnetmon and the associated vistual stack, I have some trouble having the predefined grafana dashboards return some output.

They all returns errors like this:

Received exception from server (version 25.1.4):
Code: 60. DB::Exception: Received from localhost:9000. DB::Exception: Unknown table expression identifier 'fastnetmon.network_24_metrics_ipv4' in scope SELECT toStartOfInterval(toDateTime(metricDateTime), toIntervalSecond(2)) AS time, network, avg(bits_incoming) AS Bandwidth FROM fastnetmon.network_24_metrics_ipv4 WHERE (metricDateTime >= toDateTime(1739635416)) AND (metricDateTime <= toDateTime(1739639016)) AND ((metricDateTime >= toDateTime(1739635416)) AND (metricDateTime <= toDateTime(1739639016))) AND (network = '') GROUP BY network, time ORDER BY time ASC. (UNKNOWN_TABLE)

It looks like it is querying clickhouse for unexistant tables.

Here are the tables created by fastnetmon community edition:

fastnetmon :) show tables;

SHOW TABLES

Query id: 3ddd2f10-61ca-46be-8d59-1963f3542b9d

   ┌─name─────────────────┐
1. │ host_metrics         │
2. │ host_metrics_ipv6    │
3. │ network_metrics      │
4. │ network_metrics_ipv6 │
5. │ system_metrics       │
6. │ total_metrics        │
7. │ total_metrics_ipv4   │
8. │ total_metrics_ipv6   │
   └──────────────────────┘

It looks like there are a lot of missing tables if I compare to what the dashboards are trying to query.

Have I missed a step or configuration option ?

Kind regrads!

[Pavel Odintsov]

Hello!

Thank you for sharing your issue.

This table is available only in our commercial offering FastNetMon Advanced. Community edition has no option to populate per-24 networks 

Sincerely yours, Pavel Odintsov

--
Follow us on social media: Twitter: https://twitter.com/fastnetmon | Facebook: https://www.facebook.com/fastnetmon/ | LinkedIn: https://www.linkedin.com/company/fastnetmon/
---
You received this message because you are subscribed to the Google Groups "FastNetMon user group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to fastnetmon+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/fastnetmon/8ac749bd-b80e-4a64-857a-439e4fee3769n%40googlegroups.com.

[Stephen “Doctor Madjik” Falken]

Hello Pavel!

Thank you for your quick reply. 

Oh okay, I see. It seems there are "only" two of the installed dashboards that can be used with the community edition then.

- Total Traffic Clickhouse official

- Traffic for specific host

These seems to be working with CE, all the others are returning an error with missing tables.

At first, I thought I had misconfigured something. 

Thanks for the info and for FastNetMon :)

Kind regards