Status Page using Collectd, InfluxDB and Grafana

Collectd is already grabbing statistics from my services and drop them into InfluxDB so that I can get pretty graphes with Grafana. One thing I miss is a single page that shows the overall status for all those systems ; somehow also known as Status Page.

Continue reading “Status Page using Collectd, InfluxDB and Grafana”

Monitoring the Linky electricity meter

Linky is a “smart electricity meter” from the French power grid operator Enedis. One nice thing about this device is that it automatically reports your electricty consumption. By polling the operator’s portal, one can fetch back its own data. And if the data are then stored in InfluxDB, one can keep a pretty look on its power consumption.

Continue reading “Monitoring the Linky electricity meter”

Storing unbound(8) logs into InfluxDB

I’m using unbound(8) on OpenBSD to block Ads. In the logs, I can see which domains were queried and blocked ; but I like to have a more graphical overview of whats happening over weeks. So I stole a few ideas from the Pi-Hole Web Interface, routed the logs to InfluxDB via syslog-ng and rendered statistics using Grafana.

Continue reading “Storing unbound(8) logs into InfluxDB”

Cleaning InfluxDB measurements with mixed Tags and Fields

While experimenting with Telegraf, SNMP and InfluxDB, I ended up filling some measurements with tags and fields that have the same name. InfluxDB works nicely with such user-case by adding numbers (in format “_###”) to those keys. But that’s a mess to deal with when using Grafana. And a mess in general.

Continue reading “Cleaning InfluxDB measurements with mixed Tags and Fields”

Monitoring unbound(8) using Net-SNMP, Telegraf, InfluxDB and Elasticsearch

I’ve enabled an OpenBSD unbound(8) daemon that is used as a central DNS cache resolver. Now I needed to know what it was doing and how it performed. The question was answered grabbing statistics from unbound and render them using Grafana.

The whole monitoring stack is composed of Net-SNMP, Telegraf and InfluxDB for the metrics part ; and syslogd(8), Logstash and Elasticsearch for the logs part. Of course, most of those run on OpenBSD (6.3) ; except Telegraf, which is not available (yet).

Continue reading “Monitoring unbound(8) using Net-SNMP, Telegraf, InfluxDB and Elasticsearch”