Adapter: iobroker.backitup (stable Release)

Trademan

Genau das was ich gesucht habe! Danke, toller Adapter!

nieIP

Hallo

noch mal zu meinem Problem mit dem Mysql Backup…

Ich mache das Mysql Backup zusammen mit dem Minimalen Backup.

Dazu gleich noch einmal die Frage, was der Haken

"MySql Backup bei Standard-Backup" bewirkt?? Wann wird dasBackup gemacht, wenn der Haken nicht gesetzt ist?

Die Größe der Backups ist gleichbleibend 89...91 Byte. Ich gehe davon aus, dass das Backup nicht funktioniert.

Im Log File ist mir aufgefallen, dass bei Erstellung des SQL Backup die IP Nummer 192.168.1.114 auf taucht. Die IP des NAS, wo das Backup hin geschrieben wird ist aber 192.168.1.113

Wo kommt die 114 her ? Und dann steht da eine Fehlermeldung mit "mysqldump".

Was kann ich ändern, damit es funktioniert?

`Gestartet...
[DEBUG] [mount] start with {"mountType":"CIFS","type":"storage","source":"NAS / Copy","mount":"//192.168.1.113","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"/R_Backup_HomeMatic/ioBroker/ioBroker","dirMinimal":"R_Backup_HomeMatic/ioBroker/ioBroker","dirTotal":"R_Backup_HomeMatic/ioBroker/ioBroker","user":"iobroker","pass":"****","backupDir":"/opt/iobroker/backups"}
[DEBUG] [mount] - done
[DEBUG] [minimal] start with {"type":"creator","time":"02:10","debugging":false,"everyXDays":"1","deleteBackupAfter":0,"mysqlEnabled":true,"redisEnabled":false,"cifs":{"enabled":true,"mountType":"CIFS","type":"storage","source":"NAS / Copy","mount":"//192.168.1.113","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"/R_Backup_HomeMatic/ioBroker/ioBroker","dirMinimal":"R_Backup_HomeMatic/ioBroker/ioBroker","dirTotal":"R_Backup_HomeMatic/ioBroker/ioBroker","user":"iobroker","pass":"****","context":{"fileNames":[],"errors":{},"done":["mount"],"types":[]},"adapter":null},"mysql":{"enabled":true,"type":"creator","ftp":{"enabled":false,"type":"storage","source":"NAS / Copy","host":"192.168.1.113","deleteOldBackup":false,"ownDir":false,"bkpType":"Minimal","dir":"","dirMinimal":"/backupDir/minimal","dirTotal":"/backupDir/total","user":"iobroker","pass":"ioBroker66","port":"21"},"cifs":{"enabled":true,"mountType":"CIFS","type":"storage","source":"NAS / Copy","mount":"192.168.1.113","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"R_Backup_HomeMatic/ioBroker/ioBroker","dirMinimal":"R_Backup_HomeMatic/ioBroker/ioBroker","dirTotal":"R_Backup_HomeMatic/ioBroker/ioBroker","user":"iobroker","pass":"ioBroker66"},"dropbox":{"enabled":false,"type":"storage","source":"NAS / Copy","deleteOldBackup":false,"accessToken":"","ownDir":false,"bkpType":"Minimal","dir":"","dirMinimal":"","dirTotal":""},"dbName":"iobroker","user":"iobroker","pass":"****","deleteBackupAfter":"5","host":"192.168.1.114","port":"3307","exe":""},"dir":"/opt/iobroker","redis":{"enabled":false,"type":"creator","ftp":{"enabled":false,"type":"storage","source":"NAS / Copy","host":"192.168.1.113","deleteOldBackup":false,"ownDir":false,"bkpType":"Minimal","dir":"","dirMinimal":"/backupDir/minimal","dirTotal":"/backupDir/total","user":"iobroker","pass":"ioBroker66","port":"21"},"cifs":{"enabled":true,"mountType":"CIFS","type":"storage","source":"NAS / Copy","mount":"192.168.1.113","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"R_Backup_HomeMatic/ioBroker/ioBroker","dirMinimal":"R_Backup_HomeMatic/ioBroker/ioBroker","dirTotal":"R_Backup_HomeMatic/ioBroker/ioBroker","user":"iobroker","pass":"ioBroker66"},"dropbox":{"enabled":false,"type":"storage","source":"NAS / Copy","deleteOldBackup":false,"accessToken":"","ownDir":false,"bkpType":"Minimal","dir":"","dirMinimal":"","dirTotal":""},"path":"/var/lib/redis/dump.rdb"},"history":{"enabled":true,"type":"message","entriesNumber":"25","systemLang":"de"},"telegram":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"","SilentNotice":false,"NoticeType":null,"User":null,"systemLang":"de"},"email":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"email.0","NoticeType":"shortEmailNotice","emailReceiver":"ioBroker@maddy.de","emailSender":"ioBroker@maddy.de","systemLang":"de"},"backupDir":"/opt/iobroker/backups"}
[DEBUG] [minimal] - Backup created: /opt/iobroker/backups/minimal_2018_12_02-14_30_32_backupiobroker.tar.gz

[DEBUG] [minimal] - done
[DEBUG] [mysql] start with {"type":"creator","cifs":{"enabled":true,"mountType":"CIFS","type":"storage","source":"NAS / Copy","mount":"192.168.1.113","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"R_Backup_HomeMatic/ioBroker/ioBroker","dirMinimal":"R_Backup_HomeMatic/ioBroker/ioBroker","dirTotal":"R_Backup_HomeMatic/ioBroker/ioBroker","user":"iobroker","pass":"****"},"dbName":"iobroker","user":"iobroker","pass":"****","deleteBackupAfter":"5","host":"192.168.1.114","port":"3307","exe":""}
[ERROR] [mysql] - [IGNORED] Error: spawn mysqldump ENOENT
[DEBUG] [mysql] - done
[DEBUG] [cifs] start with {"mountType":"CIFS","type":"storage","source":"NAS / Copy","mount":"//192.168.1.113","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"/R_Backup_HomeMatic/ioBroker/ioBroker","dirMinimal":"R_Backup_HomeMatic/ioBroker/ioBroker","dirTotal":"R_Backup_HomeMatic/ioBroker/ioBroker","user":"iobroker","pass":"****","backupDir":"/opt/iobroker/backups","deleteBackupAfter":0}
[DEBUG] [cifs] - done
[DEBUG] [clean] start with {"deleteBackupAfter":0}
[ERROR] [clean] - Backup files not deleted from /opt/iobroker/backups because some errors.
[DEBUG] [clean] - done
[DEBUG] [email] start with {"type":"creator","time":"02:10","debugging":false,"everyXDays":"1","deleteBackupAfter":0,"mysqlEnabled":true,"redisEnabled":false,"cifs":{"enabled":true,"mountType":"CIFS","type":"storage","source":"NAS / Copy","mount":"//192.168.1.113","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"/R_Backup_HomeMatic/ioBroker/ioBroker","dirMinimal":"R_Backup_HomeMatic/ioBroker/ioBroker","dirTotal":"R_Backup_HomeMatic/ioBroker/ioBroker","user":"iobroker","pass":"****","context":{"fileNames":["/opt/iobroker/backups/minimal_2018_12_02-14_30_32_backupiobroker.tar.gz","/opt/iobroker/backups/mysql_2018_12_02-14_30_44_backupiobroker.tar.gz"],"errors":{"mysql":{"code":"ENOENT","errno":"ENOENT","syscall":"spawn mysqldump","path":"mysqldump","spawnargs":["-u","iobroker","-pdu77x1wa","iobroker","-h","192.168.1.114","-P","3307"]}},"done":["mount","minimal"],"types":["minimal"]},"adapter":null},"mysql":{"enabled":true,"type":"creator","ftp":{"enabled":false,"type":"storage","source":"NAS / Copy","host":"192.168.1.113","deleteOldBackup":false,"ownDir":false,"bkpType":"Minimal","dir":"","dirMinimal":"/backupDir/minimal","dirTotal":"/backupDir/total","user":"iobroker","pass":"ioBroker66","port":"21"},"cifs":{"enabled":true,"mountType":"CIFS","type":"storage","source":"NAS / Copy","mount":"192.168.1.113","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"R_Backup_HomeMatic/ioBroker/ioBroker","dirMinimal":"R_Backup_HomeMatic/ioBroker/ioBroker","dirTotal":"R_Backup_HomeMatic/ioBroker/ioBroker","user":"iobroker","pass":"ioBroker66"},"dropbox":{"enabled":false,"type":"storage","source":"NAS / Copy","deleteOldBackup":false,"accessToken":"","ownDir":false,"bkpType":"Minimal","dir":"","dirMinimal":"","dirTotal":""},"dbName":"iobroker","user":"iobroker","pass":"****","deleteBackupAfter":"5","host":"192.168.1.114","port":"3307","exe":""},"dir":"/opt/iobroker","redis":{"enabled":false,"type":"creator","ftp":{"enabled":false,"type":"storage","source":"NAS / Copy","host":"192.168.1.113","deleteOldBackup":false,"ownDir":false,"bkpType":"Minimal","dir":"","dirMinimal":"/backupDir/minimal","dirTotal":"/backupDir/total","user":"iobroker","pass":"ioBroker66","port":"21"},"cifs":{"enabled":true,"mountType":"CIFS","type":"storage","source":"NAS / Copy","mount":"192.168.1.113","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"R_Backup_HomeMatic/ioBroker/ioBroker","dirMinimal":"R_Backup_HomeMatic/ioBroker/ioBroker","dirTotal":"R_Backup_HomeMatic/ioBroker/ioBroker","user":"iobroker","pass":"ioBroker66"},"dropbox":{"enabled":false,"type":"storage","source":"NAS / Copy","deleteOldBackup":false,"accessToken":"","ownDir":false,"bkpType":"Minimal","dir":"","dirMinimal":"","dirTotal":""},"path":"/var/lib/redis/dump.rdb"},"history":{"enabled":true,"type":"message","entriesNumber":"25","systemLang":"de"},"telegram":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"","SilentNotice":false,"NoticeType":null,"User":null,"systemLang":"de"},"email":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"email.0","NoticeType":"shortEmailNotice","emailReceiver":"ioBroker@maddy.de","emailSender":"ioBroker@maddy.de","systemLang":"de","time":"02\. Dezember 2018 um 14:30 Uhr"},"backupDir":"/opt/iobroker/backups"}
[DEBUG] [email] - done
[DEBUG] [history] start with {"type":"creator","time":"02:10","debugging":false,"everyXDays":"1","deleteBackupAfter":0,"mysqlEnabled":true,"redisEnabled":false,"cifs":{"enabled":true,"mountType":"CIFS","type":"storage","source":"NAS / Copy","mount":"//192.168.1.113","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"/R_Backup_HomeMatic/ioBroker/ioBroker","dirMinimal":"R_Backup_HomeMatic/ioBroker/ioBroker","dirTotal":"R_Backup_HomeMatic/ioBroker/ioBroker","user":"iobroker","pass":"****","context":{"fileNames":["/opt/iobroker/backups/minimal_2018_12_02-14_30_32_backupiobroker.tar.gz","/opt/iobroker/backups/mysql_2018_12_02-14_30_44_backupiobroker.tar.gz"],"errors":{"mysql":{"code":"ENOENT","errno":"ENOENT","syscall":"spawn mysqldump","path":"mysqldump","spawnargs":["-u","iobroker","-pdu77x1wa","iobroker","-h","192.168.1.114","-P","3307"]}},"done":["mount","minimal"],"types":["minimal"]},"adapter":null},"mysql":{"enabled":true,"type":"creator","ftp":{"enabled":false,"type":"storage","source":"NAS / Copy","host":"192.168.1.113","deleteOldBackup":false,"ownDir":false,"bkpType":"Minimal","dir":"","dirMinimal":"/backupDir/minimal","dirTotal":"/backupDir/total","user":"iobroker","pass":"ioBroker66","port":"21"},"cifs":{"enabled":true,"mountType":"CIFS","type":"storage","source":"NAS / Copy","mount":"192.168.1.113","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"R_Backup_HomeMatic/ioBroker/ioBroker","dirMinimal":"R_Backup_HomeMatic/ioBroker/ioBroker","dirTotal":"R_Backup_HomeMatic/ioBroker/ioBroker","user":"iobroker","pass":"ioBroker66"},"dropbox":{"enabled":false,"type":"storage","source":"NAS / Copy","deleteOldBackup":false,"accessToken":"","ownDir":false,"bkpType":"Minimal","dir":"","dirMinimal":"","dirTotal":""},"dbName":"iobroker","user":"iobroker","pass":"****","deleteBackupAfter":"5","host":"192.168.1.114","port":"3307","exe":""},"dir":"/opt/iobroker","redis":{"enabled":false,"type":"creator","ftp":{"enabled":false,"type":"storage","source":"NAS / Copy","host":"192.168.1.113","deleteOldBackup":false,"ownDir":false,"bkpType":"Minimal","dir":"","dirMinimal":"/backupDir/minimal","dirTotal":"/backupDir/total","user":"iobroker","pass":"ioBroker66","port":"21"},"cifs":{"enabled":true,"mountType":"CIFS","type":"storage","source":"NAS / Copy","mount":"192.168.1.113","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"R_Backup_HomeMatic/ioBroker/ioBroker","dirMinimal":"R_Backup_HomeMatic/ioBroker/ioBroker","dirTotal":"R_Backup_HomeMatic/ioBroker/ioBroker","user":"iobroker","pass":"ioBroker66"},"dropbox":{"enabled":false,"type":"storage","source":"NAS / Copy","deleteOldBackup":false,"accessToken":"","ownDir":false,"bkpType":"Minimal","dir":"","dirMinimal":"","dirTotal":""},"path":"/var/lib/redis/dump.rdb"},"history":{"enabled":true,"type":"message","entriesNumber":"25","systemLang":"de","time":"02\. Dezember 2018 um 14:30 Uhr"},"telegram":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"","SilentNotice":false,"NoticeType":null,"User":null,"systemLang":"de"},"email":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"email.0","NoticeType":"shortEmailNotice","emailReceiver":"ioBroker@maddy.de","emailSender":"ioBroker@maddy.de","systemLang":"de"},"backupDir":"/opt/iobroker/backups"}
[DEBUG] [umount] start with {"mountType":"CIFS","type":"storage","source":"NAS / Copy","mount":"//192.168.1.113","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"/R_Backup_HomeMatic/ioBroker/ioBroker","dirMinimal":"R_Backup_HomeMatic/ioBroker/ioBroker","dirTotal":"R_Backup_HomeMatic/ioBroker/ioBroker","user":"iobroker","pass":"****","backupDir":"/opt/iobroker/backups"}
[DEBUG] [mysql] - done
[EXIT] 0
[DEBUG] [mysql] - MySql File deleted!
[DEBUG] [history] - backitup.0.history.html
[EXIT] 0
[DEBUG] [umount] - done
[EXIT] 0`[/email][/email]

simatec

Deine Einstellungen für mysql sind nicht richtig konfiguriert.

Prüfe diese bitte.

IP ist normal localhost und Port 3306.

Wenn der Haken gesetzt ist, wird mysql beim minimal gesichert.

Gesendet von iPhone mit Tapatalk

nieIP

Hier die Einstellungen

Ausser dem Pfad rechts unten habe ich alles eingetragen. Da steht, man kann es frei lassen.

1282_screenshot_2018-12-02_17.42.24.png

nieIP

~~@simatec:~~

Wenn der Haken gesetzt ist, wird mysql beim minimal gesichert. `

Und wann wird gesichert, wenn der Haken nicht gesetzt ist ?

simatec

~~@nieIP:~~

Hier die Einstellungen

Ausser dem Pfad rechts unten habe ich alles eingetragen. Da steht, man kann es frei lassen.

filename="Screenshot 2018-12-02 17.42.24.png" index="0">~~ `

Ja und da steht die 114 als IP.

Wo läuft dein mysql? Doch nicht auf der 114 oder?

Der Standard Port ist 3306.

Gesendet von iPhone mit Tapatalk

simatec

~~@nieIP:~~

~~@simatec:~~

Wenn der Haken gesetzt ist, wird mysql beim minimal gesichert. `

Und wann wird gesichert, wenn der Haken nicht gesetzt ist ? `

Beim total

Gesendet von iPhone mit Tapatalk

nieIP

Hallo

der Speicherort für das Backup ist auf 192.168.1.113 (funktioniert für Minimal Backup)

Der SQL Server läuft auf 192.168.1.114 Port 3307 (funktioniert für sql Adapter)

ioBroker läuft auf 192.168.1.161 (RasPi)

1282_screenshot_2018-12-02_18.05.09.png

simatec

Dann hast du doch die Erklärung, was die 114 ist.

Hast du mysqldump denn überhaupt als Paket installiert?

Gesendet von iPhone mit Tapatalk

nieIP

~~@simatec:~~

Hast du mysqldump denn überhaupt als Paket installiert? `

Ich vermute mal - Nein

PS über apt-get wird das Paket mysqldump nicht gefunden. Wie macht man das ?

nieIP

Hallo

die Installation von

apt-get install mysql-client

war die Lösung

Jetzt ist der Befehl mysqldump verfügbar und in dem erzeugten Archiv sind auch Daten.

Danke für die Geduld.

simatec

Ab sofort ist die Version 0.3.9 im Github Online und ab morgen früh im latest.

0.3.9 (03.12.2018)

(simatec) Fix cifs/nfs mount and umount

Röstkartoffel

~~@simatec:~~

Überprüfe auch mal deine Zeitzonen Einstellungen auf deinem iob System.

Gesendet von iPhone mit Tapatalk `

Ich habe heute um 13:10 Uhr die Zeitzone auf dem ioBroker System überprüft:

      Local time: Mo 2018-12-03 13:10:48 CET
  Universal time: Mo 2018-12-03 12:10:48 UTC
        RTC time: Mo 2018-12-03 12:10:48
       Time zone: Europe/Berlin (CET, +0100)
 Network time on: yes
NTP synchronized: yes
 RTC in local TZ: no

Ich habe ebenfalls auf lokal umgestellt, aber auch das ergibt das gleiche Verhalten, das die neuesten Dateien und nicht die ältesten gelöscht werden.

Das sagt er im Log vom 01.12. (lokal gespeichert):

2018-12-01 00:35:21.815 - debug: backitup.0 [minimal/minimal] Backup created: /opt/iobroker/backups/minimal_2018_12_01-00_35_10_Rock64_backupiobroker.tar.gz
2018-12-01 00:35:21.909 - debug: backitup.0 [minimal/minimal] done
2018-12-01 00:35:21.936 - debug: backitup.0 [minimal/clean] delete /opt/iobroker/backups/minimal_2018_12_01-00_35_10_Rock64_backupiobroker.tar.gz
2018-12-01 00:35:21.942 - debug: backitup.0 [minimal/clean] done

Also er legt die Datei an und löscht diese gleich wieder, wenn die Anzahl der nicht zu löschenden Dateien erreicht ist.

Ich habe dann den Adapter und die Instanz gelöscht und neu angelegt. Leider hat sich das Verhalten nicht geändert.

Dann habe ich es mit dem Komplett ausprobiert, identischer Fehler auf meinem System.

ioBroker gestoppt und wieder gestartet. Automatisch das Backup durchführen lassen, Fehler ist immer noch vorhanden.

Ich werde die Version 0.3.9 morgen mal ausprobieren und testweise auch extra Pfade auf der NAS anlegen.

Ansonsten bleibt ja eigentlich nur noch die npm (3.10.10) und node (v6.14.3) Versionen übrig, oder?

simatec

Ja npm und node könnte ein Update vertragen.

Was sehr komisch ist, dass du der einzige mit dem Problem bist.

Ich habe auf all meinen 4 Systemen probiert das nachzustellen.

Aber auf allen Systemen funktioniert das löschen local, nas, ftp und dropbox problemlos.

Mach mal ein Update auf npm 4 und nimm mal den Namenszusatz weg oder ändere ihn mal auf „Rock“

Gesendet von iPhone mit Tapatalk

Peoples

~~@simatec:~~

Ja npm und node könnte ein Update vertragen.

Was sehr komisch ist, dass du der einzige mit dem Problem bist.

Ich habe auf all meinen 4 Systemen probiert das nachzustellen.

Aber auf allen Systemen funktioniert das löschen local, nas, ftp und dropbox problemlos.

Mach mal ein Update auf npm 4 und nimm mal den Namenszusatz weg oder ändere ihn mal auf „Rock“

Gesendet von iPhone mit Tapatalk `

Kann das auch nicht nachstellen, weder auf meinem rasp noch in meiner vm

simatec

Ab sofort ist im Github und ab morgen früh im latest die Version 0.4.0 verfügbar.

0.4.0 (04.12.2018)

(simatec) Added Pushover Notification

TomT

Super

Das ist ja mal ein Grund, den Adapter up zu daten

Danke euch

Grüße

Tom

sigi234

Super, funktioniert einwandfrei…........Danke.

Apropo

~~@simatec:~~

Was sehr komisch ist, dass du der einzige mit dem Problem bist. `

Er ist nicht der Einzige. Ich hatte das hier einige Seiten vorher auch schon mal gemeldet. Bei mir werden auch die neusten Backups gelöscht. Ich hab auch testweise auf ein anderes NAS sichern lassen. Da gibt es das gleiche Problem. Also daran liegt es nicht. Es muss irgendwas mit dem Adapter zu tun haben. Früher lief es gut bei mir. Der Fehler hat sich mit irgendeinem Update eingeschlichen.

` > backitup.0 2018-12-05 02:00:39.372 debug [minimal] exec: done

backitup.0 2018-12-05 02:00:39.356 debug [minimal/umount] done

backitup.0 2018-12-05 02:00:29.313 debug [minimal/history] backitup.0.history.html

backitup.0 2018-12-05 02:00:29.258 debug [minimal/clean] done

backitup.0 2018-12-05 02:00:29.229 debug [minimal/clean] delete /opt/iobroker/backups/minimal_2018_12_05-02_00_26_backupiobroker.tar.gz

backitup.0 2018-12-05 02:00:29.224 debug [minimal/cifs] done

backitup.0 2018-12-05 02:00:29.222 debug [minimal/minimal] done

backitup.0 2018-12-05 02:00:29.197 debug [minimal/minimal] Backup created: /opt/iobroker/backups/minimal_2018_12_05-02_00_26_backupiobroker.tar.gz

backitup.0 2018-12-05 02:00:26.542 debug [minimal/mount] done `

simatec

Auch hier wäre mal interessant, wie deine IOB Installation ausschaut.

Seit Version 0.3.0 wurde am Clean Vorgang nix geändert und bei mir läuft es unter Windows, debian und armbian.

Poste mal bitte npm, nodejs und js-controller.

NEWS

Adapter: iobroker.backitup (stable Release)

Support us

626

32.4k

81.3k

1.3m