Backup Grafana und InfluxDB

Beowolf

Hallo zusammen,

ich habe ein Problem mit meinem Backitup Adapter.

Info:

Ich habe zwei Raspberrys. Auf dem Ersten läuft ioBroker Master und auf dem Zweiten IoBroker als Slave.

Der Backitup-Adapter ist auf dem Master installiert.

Der influxbd Adapter ist auf dem Master installiert.

Grafana und die influxdb-Datenbank ist dem Slave installiert.

Wenn ich nun die Sicherung starte,kommt immer diese Fehlermeldung:

Started iobroker ...
[DEBUG] [mount] - Wake on LAN wait 90 Seconds for NAS!
[DEBUG] [mount] - Wake on LAN MAC-Address: 38:xx:xx:xx:xx:xx
[DEBUG] [mount] - mount successfully completed
[DEBUG] [mount] - done
[DEBUG] [iobroker] - host.ioBroker-Master 6033 states saved

[DEBUG] [iobroker] - host.ioBroker-Master 6008 objects saved

[DEBUG] [iobroker] - Backup created: /opt/iobroker/backups/iobroker_2021_04_23-18_06_48_backupiobroker.tar.gz

[DEBUG] [iobroker] - done
[DEBUG] [influxDB] - Start InfluxDB Backup ...
[DEBUG] [influxDB] - InfluxDB Backup tmp directory created 
[DEBUG] [influxDB] - Try deleting the InfluxDB tmp directory
[DEBUG] [influxDB] - InfluxDB tmp directory was successfully deleted
[ERROR] [influxDB] - [IGNORED] Error: Command failed: influxd backup -portable -database iobroker -host 192.168.49.43:8086 "/opt/iobroker/backups/influxDB_2021_04_23-18_06_58_backupiobroker"
/bin/sh: 1: influxd: not found

[DEBUG] [grafana] - Start Grafana Backup ...
[DEBUG] [grafana] - Try deleting the old grafana_tmp directory: "/opt/iobroker/backups/grafana_tmp"
[DEBUG] [grafana] - old grafana_tmp directory "/opt/iobroker/backups/grafana_tmp" successfully deleted
[DEBUG] [grafana] - Grafana tmp directory "/opt/iobroker/backups/grafana_tmp" cannot created ... Error: ENOENT: no such file or directory, mkdir '/opt/iobroker/backups/grafana_tmp'
[DEBUG] [grafana] - Grafana Backup cannot created: Error: ENOENT: no such file or directory, mkdir '/opt/iobroker/backups/grafana_tmp/dashboards'
[ERROR] [grafana] - [IGNORED] Error: ENOENT: no such file or directory, mkdir '/opt/iobroker/backups/grafana_tmp/dashboards'
[DEBUG] [grafana] - Grafana Backup cannot created ...

Die Sicherung wird auf einem NAS gespeichert. Die iobroker-Sicherung kommt ohne Fehler an.

Was mache ich falsch?

Welche Infos über die Einstellungen werden hier noch benötigt?

Grüße
Manfred

crunchip

@beowolf 192.168.49.43 ist dein slave?

FredF

@beowolf
Ich meine das Backitup die influxdb nur auf dem gleichen Host sichern kann. Würde bedeuten das eine 2. Instanz von Backitup auf dem Slave zu installieren ist und dort die Sicherung zu erstellen ist.

Beowolf

@crunchip

Jepp

simatec

@beowolf
Auf dem System auf dem du Influx sichern willst, muss influxd auch installiert sein.
Dann musst du in Backitup in den Influx Einstellungen Remote wählen.

Grafana kannst du auch vom Slave mit dem Master sichern.

Ist alles in der Doku von Backitup beschrieben.

https://github.com/simatec/ioBroker.backitup/blob/master/docs/de/backitup.md#influxdb-backup

Beowolf

@simatec

Also, ich habe jetzt in der influxdb.conf

das so eingetragen


# Bind address to use for the RPC service for backup and restore.
bind-address = "192.168.49.43:8086"

Datenbank läuft und es werden auch Werte eingetragen.

Wenn ich eine Sicherung starte, kommt immer noch diese Meldung:

Started iobroker ...
[DEBUG] [mount] - Wake on LAN wait 90 Seconds for NAS!
[DEBUG] [mount] - Wake on LAN MAC-Address: 38:xx:xx:xx:xx:xx
[DEBUG] [mount] - mount successfully completed
[DEBUG] [mount] - done
[DEBUG] [iobroker] - host.ioBroker-Master 5992 states saved

[DEBUG] [iobroker] - host.ioBroker-Master 6013 objects saved

[DEBUG] [iobroker] - Backup created: /opt/iobroker/backups/iobroker_2021_04_23-23_31_26_backupiobroker.tar.gz

[DEBUG] [iobroker] - done
[DEBUG] [influxDB] - Start InfluxDB Backup ...
[DEBUG] [influxDB] - InfluxDB Backup tmp directory created 
[DEBUG] [influxDB] - Try deleting the InfluxDB tmp directory
[DEBUG] [influxDB] - InfluxDB tmp directory was successfully deleted
[ERROR] [influxDB] - [IGNORED] Error: Command failed: influxd backup -portable -database iobroker -host 192.168.49.43:8086 "/opt/iobroker/backups/influxDB_2021_04_23-23_31_36_backupiobroker"
/bin/sh: 1: influxd: not found

[DEBUG] [grafana] - Start Grafana Backup ...
[DEBUG] [grafana] - Try deleting the old grafana_tmp directory: "/opt/iobroker/backups/grafana_tmp"
[DEBUG] [grafana] - old grafana_tmp directory "/opt/iobroker/backups/grafana_tmp" successfully deleted
[DEBUG] [grafana] - Created grafana_tmp directory
[DEBUG] [grafana] - Created dashboard directory
[DEBUG] [grafana] - Created dashboards_manually_restore directory
[DEBUG] [grafana] - Created datasource directory
[DEBUG] [grafana] - start Grafana request ...
[DEBUG] [grafana] - Grafana is available ... Status: 200
[DEBUG] [grafana] - Error on Grafana Datasource Request
[DEBUG] [grafana] - found Dashboard: vorgarten
[DEBUG] [grafana] - found Dashboard: phase-1
[DEBUG] [grafana] - found Dashboard: erdgeschoss
[DEBUG] [grafana] - found Dashboard: obergeschoss
[DEBUG] [grafana] - found Dashboard: wohnhaus
[DEBUG] [grafana] - found Dashboard: olheizung
[DEBUG] [grafana] - found Dashboard: umweltdaten
[DEBUG] [grafana] - found Dashboard: dachgeschoss
[DEBUG] [grafana] - start Grafana backup compress ...
[DEBUG] [grafana] - Try deleting the Grafana tmp directory: "/opt/iobroker/backups/grafana_tmp"
[DEBUG] [grafana] - Grafana tmp directory "/opt/iobroker/backups/grafana_tmp" cannot deleted ... Error: ENOTEMPTY: directory not empty, rmdir '/opt/iobroker/backups/grafana_tmp/dashboards'
[DEBUG] [grafana] - cannot found Grafana Backup files
[DEBUG] [grafana] - done
[DEBUG] [cifs] - done
[ERROR] [clean] - Backup files not deleted from /opt/iobroker/backups because some errors.
[DEBUG] [clean] - done
[DEBUG] [pushover] - done
[DEBUG] [historyHTML] - new history html values created
[DEBUG] [historyHTML] - done
[DEBUG] [historyJSON] - new history json values created
[DEBUG] [historyJSON] - done
[DEBUG] [umount] - mount activ, umount is started ...
[DEBUG] [umount] - umount successfully completed
[DEBUG] [umount] - done
[EXIT] 0

Eine Idee?

crunchip

@beowolf warum Port 8086?

simatec

@beowolf Für den Remote Zugriff musst du Port 8088 wählen

Beowolf

@simatec

In den Einstellung in Grafana steht bei "Data Sources / InfluxDB" unter HTTP "http://localhost:8086" als Port.

Ist damit nicht dieser gemeint?

Beowolf

So, ich habe jetzt eine zusätzliche Instanz von Backitup installiert und dem Slave zugeordnet.

Dort alles eingetragen. Jetzt kommt diese Meldung:

Started iobroker ...
[DEBUG] [mount] - Wake on LAN wait 25 Seconds for NAS!
[DEBUG] [mount] - Wake on LAN MAC-Address: xx:xx:xx:xx:xx:xx
[DEBUG] [mount] - mount successfully completed
[DEBUG] [mount] - done
[DEBUG] [iobroker] - host.ioBroker-Slave-1 6019 states saved

[DEBUG] [iobroker] - host.ioBroker-Slave-1 6046 objects saved

[DEBUG] [iobroker] - Backup created: /opt/iobroker/backups/iobroker_2021_04_24-09_15_39_backupiobroker.tar.gz

[DEBUG] [iobroker] - done
[DEBUG] [influxDB] - Start InfluxDB Backup ...
[DEBUG] [influxDB] - InfluxDB Backup tmp directory created 
[DEBUG] [influxDB] - Try deleting the InfluxDB tmp directory
[DEBUG] [influxDB] - InfluxDB tmp directory was successfully deleted
[ERROR] [influxDB] - [IGNORED] Error: Command failed: influxd backup -portable -database iobroker -host 192.168.49.43:8088 "/opt/iobroker/backups/influxDB_2021_04_24-09_16_06_backupiobroker"
2021/04/24 09:16:06 Download shard 0 failed dial tcp 192.168.49.43:8088: connect: connection refused.  Waiting 2s and retrying (0)...
2021/04/24 09:16:08 Download shard 0 failed dial tcp 192.168.49.43:8088: connect: connection refused.  Waiting 2s and retrying (1)...
2021/04/24 09:16:10 Download shard 0 failed dial tcp 192.168.49.43:8088: connect: connection refused.  Waiting 2s and retrying (2)...
2021/04/24 09:16:12 Download shard 0 failed dial tcp 192.168.49.43:8088: connect: connection refused.  Waiting 2s and retrying (3)...
2021/04/24 09:16:14 Download shard 0 failed dial tcp 192.168.49.43:8088: connect: connection refused.  Waiting 2s and retrying (4)...
2021/04/24 09:16:16 Download shard 0 failed dial tcp 192.168.49.43:8088: connect: connection refused.  Waiting 2s and retrying (5)...
2021/04/24 09:16:18 Download shard 0 failed dial tcp 192.168.49.43:8088: connect: connection refused.  Waiting 3.01s and retrying (6)...
2021/04/24 09:16:21 Download shard 0 failed dial tcp 192.168.49.43:8088: connect: connection refused.  Waiting 11.441s and retrying (7)...
2021/04/24 09:16:32 Download shard 0 failed dial tcp 192.168.49.43:8088: connect: connection refused.  Waiting 43.477s and retrying (8)...
2021/04/24 09:17:16 Download shard 0 failed dial tcp 192.168.49.43:8088: connect: connection refused.  Waiting 2m45.216s and retrying (9)...
backup: dial tcp 192.168.49.43:8088: connect: connection refused

[DEBUG] [cifs] - done
[ERROR] [clean] - Backup files not deleted from /opt/iobroker/backups because some errors.
[DEBUG] [clean] - done
[DEBUG] [telegram] - done
[DEBUG] [historyHTML] - new history html values created
[DEBUG] [historyHTML] - done
[DEBUG] [historyJSON] - new history json values created
[DEBUG] [historyJSON] - done
[DEBUG] [umount] - mount activ, umount is started ...
[DEBUG] [umount] - umount successfully completed
[DEBUG] [umount] - done
[EXIT] 0

Wo kann ich noch suchen?

simatec

@beowolf
Du benötigst keine zweite Instanz auf dem Slave.
Einfach laut Doku die bind in der Config anpassen und in Backitup auf Remote stellen.
Dann wie in der Doku beschrieben auf dem Master Influx installieren oder dass dort eine Datenbank läuft.
Der Master benötigt nur die influxd, um das Backup zu erstellen.
Backitup arbeitet mit der originalen und in Influx integrierten Backup Methode.

Beowolf

@simatec

So, ich habe jetzt beide Pi3 auf den aktuellen Stand gebracht.

Das kommt jetzt als Meldung:

Started iobroker ...
[DEBUG] [mount] - Wake on LAN wait 5 Seconds for NAS!
[DEBUG] [mount] - Wake on LAN MAC-Address: xx:xx:xx:xx:xx:xx
[DEBUG] [mount] - mount successfully completed
[DEBUG] [mount] - done
[DEBUG] [iobroker] - host.ioBroker-Master 6035 states saved

[DEBUG] [iobroker] - host.ioBroker-Master 6013 objects saved

[DEBUG] [iobroker] - Backup created: /opt/iobroker/backups/iobroker_2021_04_24-15_57_14_backupiobroker.tar.gz

[DEBUG] [iobroker] - done
[DEBUG] [influxDB] - Start InfluxDB Backup ...
[DEBUG] [influxDB] - InfluxDB Backup tmp directory created 
[DEBUG] [influxDB] - Backup created: /opt/iobroker/backups/influxDB_2021_04_24-15_57_25_backupiobroker.tar.gz
[DEBUG] [influxDB] - Try deleting the InfluxDB tmp directory
[DEBUG] [influxDB] - InfluxDB tmp directory was successfully deleted
[DEBUG] [influxDB] - done
[DEBUG] [grafana] - Start Grafana Backup ...
[DEBUG] [grafana] - Created grafana_tmp directory: "/opt/iobroker/backups/grafana_tmp"
[DEBUG] [grafana] - Created dashboard directory
[DEBUG] [grafana] - Created dashboards_manually_restore directory
[DEBUG] [grafana] - Created datasource directory
[DEBUG] [grafana] - start Grafana request ...
[DEBUG] [grafana] - Grafana is available ... Status: 200
[DEBUG] [grafana] - found Dashboard: obergeschoss
[DEBUG] [grafana] - found Dashboard: dachgeschoss
[DEBUG] [grafana] - found Dashboard: olheizung
[DEBUG] [grafana] - found Dashboard: phase-1
[DEBUG] [grafana] - found Dashboard: umweltdaten
[DEBUG] [grafana] - found Dashboard: wohnhaus
[DEBUG] [grafana] - found Dashboard: erdgeschoss
[DEBUG] [grafana] - found Dashboard: vorgarten
[DEBUG] [grafana] - start Grafana backup compress ...
[DEBUG] [grafana] - Backup created: /opt/iobroker/backups/grafana_2021_04_24-15_57_48_backupiobroker.tar.gz
[DEBUG] [grafana] - Try deleting the Grafana tmp directory: "/opt/iobroker/backups/grafana_tmp"
[DEBUG] [grafana] - Grafana tmp directory "/opt/iobroker/backups/grafana_tmp" successfully deleted
[DEBUG] [grafana] - done
[DEBUG] [cifs] - done
[DEBUG] [clean] - done
[DEBUG] [pushover] - done
[DEBUG] [historyHTML] - new history html values created
[DEBUG] [historyHTML] - done
[DEBUG] [historyJSON] - new history json values created
[DEBUG] [historyJSON] - done
[DEBUG] [umount] - mount activ, umount is started ...

Die Backupdateien erscheinen jetzt auch auf meinem NAS.

Das sollte es doch jetzt gewesen sein, oder?

Noch eine Frage.

Ich habe jetzt in beiden "influxdb.conf" die bind-adress eingetragen. Richtig wird es doch wohl nur in einer sein, oder?

Aber welche? Ich wollte jetzt nicht wieder rumprobieren.

Grüße und vielen Dank für Deine Hilfe. :+1: :+1: :+1:

simatec

@beowolf
Bind muss nur am Slave geändert werden

daNick

@simatec

Hallo

Ich nutze influxdb in Docker Container.

Wie editiere ich da influxdb.conf (ich kann eine Telnet/bash Verbindung über Portainer aufbauen, verstehe aber nicht, wie ich dann (insbesondere "dauerhaft") verändere.

Ich finde die Datei, aber bekomme das Edit nicht hin.

Außerdem: Danke! :)

Gruß daNick

DEBUG] [influxDB] - Start InfluxDB Backup ...
[DEBUG] [influxDB] - InfluxDB Backup tmp directory created 
[DEBUG] [influxDB] - Try deleting the InfluxDB tmp directory
[DEBUG] [influxDB] - InfluxDB tmp directory was successfully deleted
[ERROR] [influxDB] - [IGNORED] Error: Command failed: influxd backup -portable -database telegraf -host 192.168.178.31:8086 "/opt/iobroker/backups/influxDB_2021_05_15-19_46_02_backupiobroker"
flag provided but not defined: -portable
backup: flag provided but not defined: -portable

Community Forum

NEWS

Backup Grafana und InfluxDB

Support us

805

32.5k

81.7k

1.3m