Domoticz, Influx en Grafana

Orgineel https://ehoco.nl/influxdb-installeren-op-een-raspberry-pi/  en https://ehoco.nl/grafana-installeren-op-een-raspberry-pi/ en https://ehoco.nl/domoticz-data-weergeven-grafana-grafieken/

Stappenplan:

1. Installeer Influx (database)
2. Installeer Grafana (presentatie tool)
3. Configureer Domoticz om je data naar Influx te sturen
4. Configureer Grafana om je data te presenteren

Installeer Influx:

sudo apt update
sudo apt upgrade
wget -qO- https://repos.influxdata.com/influxdb.key | sudo apt-key add -
echo "deb https://repos.influxdata.com/debian buster stable" | sudo tee /etc/apt/sources.list.d/influxdb.list
sudo apt update
sudo apt install influxdb
sudo systemctl unmask influxdb
sudo systemctl enable influxdb
sudo systemctl start influxdb

Database (voorbeeld Domoticz maar pas naar believen aan) maken:

influx
CREATE DATABASE Domoticz
USE Domoticz
exit

Gebruiker maken

influx
CREATE USER admin WITH PASSWORD '<password>' WITH ALL PRIVILEGES
exit

sudo vi/etc/influxdb/influxdb.conf

Voeg onderstaande opties toe:

auth-enabled = true
pprof-enabled = true
pprof-auth-enabled = true
ping-auth-enabled = true

sudo systemctl restart influxdb

influx -username admin -password <password>

influx
INSERT temperature,location=living_room value=20
INSERT temperature,location=living_room value=10
INSERT temperature,location=bedroom value=34
INSERT temperature,location=bedroom value=23
exit

influx
SELECT * FROM temperature

sudo apt update
sudo apt upgrade

sudo wget https://dl.grafana.com/oss/release/grafana_6.6.1_armhf.deb
sudo dpkg -i grafana_6.6.1_armhf.deb

sudo systemctl enable grafana-server

sudo systemctl start grafana-server