Patrick Müller

Influxdb installieren

per SSH auf dem openhab System einloggen

curl -sL https://repos.influxdata.com/influxdb.key | sudo apt-key add -
echo "deb https://repos.influxdata.com/debian stretch stable" | sudo tee /etc/apt/sources.list.d/influxdb.list

per

sudo apt update

per

sudo apt install influxdb

per

sudo systemctl enable influxdb

per

sudo systemctl start influxdb

per

influx

per

CREATE DATABASE openhab_db

per

CREATE USER admin WITH PASSWORD 'admin' WITH ALL PRIVILEGES

per

CREATE USER openhab WITH PASSWORD 'openhab'

per

CREATE USER grafana WITH PASSWORD 'grafana'

per

GRANT ALL ON openhab_db TO openhab

per

GRANT READ ON openhab_db TO grafana

per

Exit

Sudo nano /etc/influxdb/influxdb.conf
# entfernen und gegebenf. Werte ändern
http endpoint…
enabled = true
bind adress http service
bind-address = „:8086“
http authentication
auth-enabled = true
sudo systemctl restart influxdb
test-> localhost:8086 -> 404 page not found oder influx eingeben

Persistenz aktivieren

paperui-> addons persistence-> influx db persistence installieren

sudo nano /etc/openhab2/services/influxdb.cfg
url=http://192.168.2.129:8086
user=openhab
password=openhab
db=openhab_db
retentionPolicy=autogen
sudo nano /etc/openhab2/persistence/influxdb.persist

Werte mit Regel persistent abspeichern

Strategies
{
everyMinute : „0 * * * * ?“
everyHour : „0 0 * * * ?“
everyDay : „0 0 0 * * ?“
default = everyChange
}
Items
{
Temperature : strategy = everyMinute
}

Grafana installieren

weboberfläche: localhost:3000 benutzer:admin passwort: admin
in grafana -> add data source
namen vergeben
url eingeben
basic auth anhaken
user: grafana
password: grafana
datenbank openhab_db
benutzer grafana
passwort grafana
grafana neues dashboard
auf panel title klicken
dann auf edit
metric-> item auswählen