BackitUp-SQL Sicherung

StefanW

Hallo,

ich habe eine Master / Slave Umgebung

Auf dem Master läuft eine IOBroker SQL Instanz, die ich nicht ins Backup reinbekomme.
(SQL-Server ist eine andere Maschine)

Das Abrufen der Autokonfiguration funktioniert, auch schon mit anderem Account getestet der volle Rechte hat.
Telnet auf 3306 vom IOBroker funktioniert.

Vielleicht jemand ein Tipp für mich, Danke schon mal.

Stefan

simatec

@stefanw mysqldump ist auf deinem Host System nicht installiert

StefanW

@simatec

ich habe es nochmals neu installiert war genau das gleiche.

Habe dann zum Test den Pfad mal manuell angepasst

dort liegt auch mysqldump.exe

leider ändert sich am Fehler nichts, es kommen immer die selben Fehler

Hat vielleicht mir jemand noch ein Tipp, Danke schon mal
Stefan

simatec

@stefanw

C:/Temp/mysqldump.exe

StefanW

@simatec

hab es geändert

die Fehlermeldung ist dieselbe

Gruß
Stefan

simatec

@stefanw dein T in Temp ist wieder klein geschrieben

StefanW

@simatec
ich wusste nicht, dass hier case sensitive ist :-(
trotzdem bleibt der Fehler der selbe.

Hab noch einiges probiert und folgendes festgestellt:

Hab das gefunden

und mit "no-tablespace" kommt kein Fehler mehr

Ich hab dem Benutzer im SQL Studio mal die vollen Rechte gegeben, hat aber nix geholfen. Ist die "Process" Berechtigung eine andere?

Grüße
Stefan

axel

@stefanw Konntet ihr das Problem lösen? Ich habe seit geraumer Zeit das gleiche Thema. Backitup (aktuelle Version) produziert den Befehls-String

mysqldump -u iobroker -p**** [user] -h 192.168.12.183 -P 3306 --quick --single-transaction > /opt/iobroker/backups/mysql_2025_02_01-13_59_38_backupiobroker.sql

der in der Fehlermeldung

mysqldump: Got error: 1045: "Access denied for user 'iobroker'@'dbserver.fritz.box' (using password: YES)" when trying to connect

resultiert. Ich nutze eine Remote Verbindung zu einer Server-Instanz. Das Problem ist wohl weit bekannt, aber ich kann keine Lösung finden. Der Hinweis, das es sich mit einem Versionsupdate eingeschlichen hat, ist wahrscheilich richt. Bis zum 12.07.2024 hat der Befehl so auch funktioniert. Danach nicht mehr.

axel

@axel sagte in BackitUp-SQL Sicherung:

@stefanw Konntet ihr das Problem lösen? Ich habe seit geraumer Zeit das gleiche Thema. Backitup (aktuelle Version) produziert den Befehls-String

mysqldump -u iobroker -p**** [user] -h 192.168.12.183 -P 3306 --quick --single-transaction > /opt/iobroker/backups/mysql_2025_02_01-13_59_38_backupiobroker.sql

der in der Fehlermeldung

mysqldump: Got error: 1045: "Access denied for user 'iobroker'@'dbserver.fritz.box' (using password: YES)" when trying to connect

resultiert. Ich nutze eine Remote Verbindung zu einer Server-Instanz. Das Problem ist wohl weit bekannt, aber ich kann keine Lösung finden. Der Hinweis, das es sich mit einem Versionsupdate eingeschlichen hat, ist wahrscheilich richt. Bis zum 12.07.2024 hat der Befehl so auch funktioniert. Danach nicht mehr.

Nachtrag: Die Backup-Datei wird in /opt/iobroker/backups/ angelegt, sie ist aber leer.

simatec

@axel zeige mal deine Config als json und den kompletten Log vom Backup. Mir ist da kein Bug bekannt

axel

@simatec Hier die ergänzenden Infos:

backitup.0.json

Bakitup-Ausführung:
12:15:38.833
INFO
gui
Backup gestartet ...
[DEBUG] [mount] start with {"mountType":"CIFS","type":"storage","source":"cifs","mount":"//192.168.12.185","debugging":true,"fileDir":"/opt/iobroker/iobroker-data/backitup","wakeOnLAN":false,"macAd":"20:DE:20:DE:20:DE","wolTime":"25","wolPort":"9","wolExtra":false,"smb":"vers=3.1.1","sudo":true,"cifsDomain":"","clientInodes":false,"cacheLoose":false,"deleteOldBackup":false,"ownDir":true,"dir":"/smarthome/smarthome/Sicherung_smarthome/iobroker","dirMinimal":"smarthome/smarthome/Sicherung_smarthome/iobroker","user":"axel","pass":"****","expertMount":"sudo mount -t cifs -o username=<username>,password=\"<password>\",noserverino,cache=loose,rw,uid=iobroker,gid=iobroker,file_mode=0777,dir_mode=0777,vers=3.1.1 //192.168.0.1/NAS/BACKUP /opt/iobroker/backups","ignoreErrors":false,"backupDir":"/opt/iobroker/backups","timestamp":1738460411464,"influxDBEvents":[],"mySqlEvents":[],"pgSqlEvents":[]}
12:15:48.860
DEBUG
mount
cifs-mount command: "sudo mount -t cifs -o username=axel,password=****,rw,forceuid,uid=iobroker,forcegid,gid=iobroker,file_mode=0777,dir_mode=0777,vers=3.1.1 //192.168.12.185/smarthome/smarthome/Sicherung_smarthome/iobroker /opt/iobroker/backups"
12:15:48.997
DEBUG
mount
mount successfully completed
12:15:49.000
DEBUG
mount
done
[DEBUG] [iobroker] start with {"type":"creator","workDir":"/opt/iobroker/node_modules/iobroker.js-controller/iobroker.js","time":"02:40","cronjob":"00 48 02 */1 * *","ownCron":false,"debugging":true,"slaveBackup":"Single","everyXDays":"1","deleteBackupAfter":0,"cifs":{"enabled":true,"mountType":"CIFS","type":"storage","source":"cifs","mount":"//192.168.12.185","debugging":true,"fileDir":"/opt/iobroker/iobroker-data/backitup","wakeOnLAN":false,"macAd":"20:DE:20:DE:20:DE","wolTime":"25","wolPort":"9","wolExtra":false,"smb":"vers=3.1.1","sudo":true,"cifsDomain":"","clientInodes":false,"cacheLoose":false,"deleteOldBackup":false,"ownDir":true,"dir":"/smarthome/smarthome/Sicherung_smarthome/iobroker","dirMinimal":"smarthome/smarthome/Sicherung_smarthome/iobroker","user":"axel","pass":"****","expertMount":"sudo mount -t cifs -o username=<username>,password=\"<password>\",noserverino,cache=loose,rw,uid=iobroker,gid=iobroker,file_mode=0777,dir_mode=0777,vers=3.1.1 //192.168.0.1/NAS/BACKUP /opt/iobroker/backups","ignoreErrors":false,"context":{"fileNames":[],"errors":{},"done":["mount"],"types":[]},"timestamp":1738494938094,"adapter":null,"influxDBEvents":[],"mySqlEvents":[],"pgSqlEvents":[]},"ignoreErrors":false,"mysql":{"enabled":true,"type":"creator","ftp":{"enabled":false,"type":"storage","source":"cifs","host":"","debugging":true,"deleteOldBackup":false,"ftpDeleteAfter":10,"advancedDelete":false,"ownDir":false,"dir":"/backupDir","dirMinimal":"/backupDir/iobroker","user":"","pass":"****","port":"21","secure":false,"signedCertificates":true,"ignoreErrors":false},"cifs":{"enabled":true,"mountType":"CIFS","type":"storage","source":"cifs","mount":"192.168.12.185","debugging":true,"fileDir":"/opt/iobroker/iobroker-data/backitup","wakeOnLAN":false,"macAd":"20:DE:20:DE:20:DE","wolTime":"25","wolPort":"9","wolExtra":false,"smb":"vers=3.1.1","sudo":true,"cifsDomain":"","clientInodes":false,"cacheLoose":false,"deleteOldBackup":false,"ownDir":true,"dir":"smarthome/smarthome/Sicherung_smarthome/iobroker","dirMinimal":"smarthome/smarthome/Sicherung_smarthome/iobroker","user":"axel","pass":"****","expertMount":"sudo mount -t cifs -o username=<username>,password=\"<password>\",noserverino,cache=loose,rw,uid=iobroker,gid=iobroker,file_mode=0777,dir_mode=0777,vers=3.1.1 //192.168.0.1/NAS/BACKUP /opt/iobroker/backups","ignoreErrors":false},"dropbox":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"dropboxDeleteAfter":10,"advancedDelete":false,"accessToken":"****","dropboxAccessJson":"","dropboxTokenType":"custom","ownDir":false,"dir":"/backupDir","dirMinimal":"/backupDir/iobroker","ignoreErrors":false},"onedrive":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"onedriveDeleteAfter":10,"advancedDelete":false,"onedriveAccessJson":"****","ownDir":false,"dir":"backupDir","dirMinimal":"backupDir/iobroker","ignoreErrors":false},"webdav":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"webdavDeleteAfter":10,"advancedDelete":false,"username":"username","pass":"****","url":"https://example.com/remote.php/dav/files/username/","ownDir":false,"dir":"/backupDir","dirMinimal":"/backupDir/iobroker","signedCertificates":true,"ignoreErrors":false},"googledrive":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"googledriveDeleteAfter":10,"advancedDelete":false,"newToken":false,"ownDir":false,"dir":"/backupDir","dirMinimal":"/backupDir/iobroker","ignoreErrors":false,"accessJson":"****"},"nameSuffix":"","mysqlQuick":true,"slaveSuffix":"","hostType":"Single","mysqlSingleTransaction":true,"dbName":"iobroker","user":"axel","pass":"****","deleteBackupAfter":5,"host":"192.168.12.183","port":3306,"mySqlEvents":[],"mySqlMulti":false,"ignoreErrors":false,"exe":""},"dir":"/opt/iobroker","javascripts":{"enabled":true,"type":"creator","ftp":{"enabled":false,"type":"storage","source":"cifs","host":"","debugging":true,"deleteOldBackup":false,"ftpDeleteAfter":10,"advancedDelete":false,"ownDir":false,"dir":"/backupDir","dirMinimal":"/backupDir/iobroker","user":"","pass":"****","port":"21","secure":false,"signedCertificates":true,"ignoreErrors":false},"cifs":{"enabled":true,"mountType":"CIFS","type":"storage","source":"cifs","mount":"192.168.12.185","debugging":true,"fileDir":"/opt/iobroker/iobroker-data/backitup","wakeOnLAN":false,"macAd":"20:DE:20:DE:20:DE","wolTime":"25","wolPort":"9","wolExtra":false,"smb":"vers=3.1.1","sudo":true,"cifsDomain":"","clientInodes":false,"cacheLoose":false,"deleteOldBackup":false,"ownDir":true,"dir":"smarthome/smarthome/Sicherung_smarthome/iobroker","dirMinimal":"smarthome/smarthome/Sicherung_smarthome/iobroker","user":"axel","pass":"****","expertMount":"sudo mount -t cifs -o username=<username>,password=\"<password>\",noserverino,cache=loose,rw,uid=iobroker,gid=iobroker,file_mode=0777,dir_mode=0777,vers=3.1.1 //192.168.0.1/NAS/BACKUP /opt/iobroker/backups","ignoreErrors":false},"dropbox":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"dropboxDeleteAfter":10,"advancedDelete":false,"accessToken":"****","dropboxAccessJson":"","dropboxTokenType":"custom","ownDir":false,"dir":"/backupDir","dirMinimal":"/backupDir/iobroker","ignoreErrors":false},"onedrive":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"onedriveDeleteAfter":10,"advancedDelete":false,"onedriveAccessJson":"****","ownDir":false,"dir":"backupDir","dirMinimal":"backupDir/iobroker","ignoreErrors":false},"webdav":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"webdavDeleteAfter":10,"advancedDelete":false,"username":"username","pass":"****","url":"https://example.com/remote.php/dav/files/username/","ownDir":false,"dir":"/backupDir","dirMinimal":"/backupDir/iobroker","signedCertificates":true,"ignoreErrors":false},"googledrive":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"googledriveDeleteAfter":10,"advancedDelete":false,"newToken":false,"ownDir":false,"dir":"/backupDir","dirMinimal":"/backupDir/iobroker","ignoreErrors":false,"accessJson":"****"},"slaveSuffix":"","hostType":"Single","nameSuffix":"","ignoreErrors":false},"grafana":{"enabled":true,"type":"creator","ftp":{"enabled":false,"type":"storage","source":"cifs","host":"","debugging":true,"deleteOldBackup":false,"ftpDeleteAfter":10,"advancedDelete":false,"ownDir":false,"dir":"/backupDir","dirMinimal":"/backupDir/iobroker","user":"","pass":"****","port":"21","secure":false,"signedCertificates":true,"ignoreErrors":false},"cifs":{"enabled":true,"mountType":"CIFS","type":"storage","source":"cifs","mount":"192.168.12.185","debugging":true,"fileDir":"/opt/iobroker/iobroker-data/backitup","wakeOnLAN":false,"macAd":"20:DE:20:DE:20:DE","wolTime":"25","wolPort":"9","wolExtra":false,"smb":"vers=3.1.1","sudo":true,"cifsDomain":"","clientInodes":false,"cacheLoose":false,"deleteOldBackup":false,"ownDir":true,"dir":"smarthome/smarthome/Sicherung_smarthome/iobroker","dirMinimal":"smarthome/smarthome/Sicherung_smarthome/iobroker","user":"axel","pass":"****","expertMount":"sudo mount -t cifs -o username=<username>,password=\"<password>\",noserverino,cache=loose,rw,uid=iobroker,gid=iobroker,file_mode=0777,dir_mode=0777,vers=3.1.1 //192.168.0.1/NAS/BACKUP /opt/iobroker/backups","ignoreErrors":false},"dropbox":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"dropboxDeleteAfter":10,"advancedDelete":false,"accessToken":"****","dropboxAccessJson":"","dropboxTokenType":"custom","ownDir":false,"dir":"/backupDir","dirMinimal":"/backupDir/iobroker","ignoreErrors":false},"onedrive":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"onedriveDeleteAfter":10,"advancedDelete":false,"onedriveAccessJson":"****","ownDir":false,"dir":"backupDir","dirMinimal":"backupDir/iobroker","ignoreErrors":false},"webdav":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"webdavDeleteAfter":10,"advancedDelete":false,"username":"username","pass":"****","url":"https://example.com/remote.php/dav/files/username/","ownDir":false,"dir":"/backupDir","dirMinimal":"/backupDir/iobroker","signedCertificates":true,"ignoreErrors":false},"googledrive":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"googledriveDeleteAfter":10,"advancedDelete":false,"newToken":false,"ownDir":false,"dir":"/backupDir","dirMinimal":"/backupDir/iobroker","ignoreErrors":false,"accessJson":"****"},"host":"192.168.12.183","port":"3000","protocol":"http","username":"admin","pass":"****","apiKey":"****","nameSuffix":"","slaveSuffix":"","hostType":"Single","ignoreErrors":false,"signedCertificates":true},"historyHTML":{"enabled":true,"type":"message","entriesNumber":"25","ignoreErrors":false,"systemLang":"de"},"historyJSON":{"enabled":true,"type":"message","entriesNumber":"25","ignoreErrors":false,"systemLang":"de"},"telegram":{"enabled":true,"notificationsType":"WhatsApp","type":"message","instance":"","SilentNotice":false,"NoticeType":"longTelegramNotice","User":"allTelegramUsers","onlyError":false,"telegramWaiting":0,"hostName":"","ignoreErrors":false,"systemLang":"de"},"email":{"enabled":true,"notificationsType":"WhatsApp","type":"message","instance":"","NoticeType":"longEmailNotice","emailReceiver":"axel.a.stahl@gmx.de","emailSender":"axel.a.stahl@gmx.de","onlyError":false,"emailWaiting":0,"hostName":"","ignoreErrors":false,"systemLang":"de"},"pushover":{"enabled":true,"notificationsType":"WhatsApp","type":"message","instance":"","SilentNotice":false,"NoticeType":"longPushoverNotice","deviceID":"","onlyError":false,"pushoverWaiting":0,"hostName":"","ignoreErrors":false,"systemLang":"de"},"whatsapp":{"enabled":true,"notificationsType":"WhatsApp","type":"message","instance":"whatsapp-cmb.0","NoticeType":"longWhatsappNotice","onlyError":true,"whatsappWaiting":0,"hostName":"","ignoreErrors":false,"systemLang":"de"},"gotify":{"enabled":true,"notificationsType":"WhatsApp","type":"message","instance":"","NoticeType":"longGotifyNotice","onlyError":false,"gotifyWaiting":0,"hostName":"","ignoreErrors":false,"systemLang":"de"},"signal":{"enabled":true,"notificationsType":"WhatsApp","type":"message","instance":"","NoticeType":"longSignalNotice","onlyError":false,"signalWaiting":0,"hostName":"","ignoreErrors":false,"systemLang":"de"},"matrix":{"enabled":true,"notificationsType":"WhatsApp","type":"message","instance":"","NoticeType":"longMatrixNotice","onlyError":false,"matrixWaiting":0,"hostName":"","ignoreErrors":false,"systemLang":"de"},"discord":{"enabled":true,"notificationsType":"WhatsApp","type":"message","instance":"","target":"","onlyError":false,"discordWaiting":0,"hostName":"","ignoreErrors":false,"systemLang":"de"},"notification":{"type":"message","ignoreErrors":false,"bashDir":"/opt/iobroker/iobroker-data/backitup","entriesNumber":"25","systemLang":"de"},"backupDir":"/opt/iobroker/backups","timestamp":1738494938094,"influxDBEvents":[],"mySqlEvents":[],"pgSqlEvents":[]}
12:15:54.354
DEBUG
iobroker
host.sh 28411 objects saved
12:15:55.521
DEBUG
iobroker
host.sh 23007 states saved
host.sh Validating backup ...
12:15:55.565
DEBUG
iobroker
host.sh "config.json" is valid
12:15:55.567
DEBUG
iobroker
host.sh "objects.jsonl" exists
12:15:55.573
DEBUG
iobroker
host.sh "states.jsonl" exists
12:15:56.058
DEBUG
iobroker
host.sh JSONL lines are valid
12:15:56.255
DEBUG
iobroker
host.sh The backup is valid!
12:15:59.074
DEBUG
iobroker
Backup created: /opt/iobroker/backups/iobroker_2025_02_02-12_15_48_backupiobroker.tar.gz
12:15:59.077
DEBUG
iobroker
This backup can only be restored with js-controller version 7.0 or higher
12:16:00.097
DEBUG
iobroker
done
12:16:00.405
DEBUG
mysql
MySql-Backup started ...
12:16:00.443
ERROR
mysql
Error: Command failed: mysqldump -u axel -p**** iobroker -h 192.168.12.183 -P 3306 --quick --single-transaction > /opt/iobroker/backups/mysql_2025_02_02-12_15_59_backupiobroker.sql
/bin/sh: 1: mysqldump: not found
12:16:00.462
DEBUG
mysql
done
12:16:01.463
DEBUG
grafana
Start Grafana Backup ...
12:16:01.471
DEBUG
grafana
Created grafana_tmp directory: "/opt/iobroker/backups/grafana_tmp"
12:16:01.478
DEBUG
grafana
Created dashboard directory
12:16:01.482
DEBUG
grafana
Created dashboards_manually_restore directory
12:16:01.495
DEBUG
grafana
start Grafana request ...
12:16:01.498
DEBUG
grafana
Grafana is available ... Status: 200
12:16:03.749
DEBUG
grafana
found Dashboard: warmepumpe-uebersicht
12:16:04.407
DEBUG
grafana
found Dashboard: dachfenster-analyse
12:16:04.415
DEBUG
grafana
found Dashboard: aussen-alles
12:16:05.244
DEBUG
grafana
found Dashboard: kan-weg
12:16:05.329
DEBUG
grafana
found Dashboard: strom-details-taglicher-strombedarf
12:16:05.371
DEBUG
grafana
found Dashboard: photovoltaik
12:16:05.624
DEBUG
grafana
found Dashboard: beschattung
12:16:05.638
DEBUG
grafana
found Dashboard: verbrauch
12:16:05.704
DEBUG
grafana
found Dashboard: wetter
12:16:05.712
DEBUG
grafana
found Dashboard: warmepumpe-statistik
12:16:06.328
DEBUG
grafana
found Dashboard: duty-cycle
12:16:06.363
DEBUG
grafana
found Dashboard: wetterstation
12:16:06.366
DEBUG
grafana
found Dashboard: experimentieren
12:16:06.408
DEBUG
grafana
found Dashboard: warmepumpe-analyse
12:16:06.633
DEBUG
grafana
found Dashboard: strom-details-stuendlicher-strombedarf
12:16:06.652
DEBUG
grafana
found Dashboard: raume
12:16:06.702
DEBUG
grafana
found Dashboard: rollladen
12:16:06.710
DEBUG
grafana
found Dashboard: auto
12:16:06.852
DEBUG
grafana
start Grafana backup compress ...
12:16:11.885
DEBUG
grafana
Backup created: /opt/iobroker/backups/grafana_2025_02_02-12_16_06_backupiobroker.tar.gz
12:16:11.927
DEBUG
grafana
Try deleting the Grafana tmp directory: "/opt/iobroker/backups/grafana_tmp"
12:16:11.955
DEBUG
grafana
Grafana tmp directory "/opt/iobroker/backups/grafana_tmp" successfully deleted
12:16:11.998
DEBUG
grafana
done
12:16:12.477
DEBUG
javascripts
Created javascript_tmp directory: "/opt/iobroker/backups/tmpScripts"
12:16:12.598
DEBUG
javascripts
found Script: Bewegung
12:16:12.725
DEBUG
javascripts
found Script: 000_aktuelle_Werte
12:16:12.873
DEBUG
javascripts
found Script: 001_stündliche_Werte

axel

@axel sagte in BackitUp-SQL Sicherung:

@simatec Hier die ergänzenden Infos:

War zu groß. Die ganzen Scripte habe ich weggelassen. Das funktioniert ja auch...

axel

@axel sagte in BackitUp-SQL Sicherung:

Der Fehler

Error: Command failed: mysqldump -u axel -p**** iobroker -h 192.168.12.183 -P 3306 --quick --single-transaction > /opt/iobroker/backups/mysql_2025_02_02-12_15_59_backupiobroker.sql

/bin/sh: 1: mysqldump: not found

ist wohl entscheident. lokal läuft der Dump. Muß am Remote Zugriff liegen!

simatec

@axel sagte in BackitUp-SQL Sicherung:

Command failed: mysqldump

Ist denn mysqldump auf deinem iobroker Host installiert?
https://github.com/simatec/ioBroker.backitup/wiki/ioBroker.backitup-Wiki-Deutsch#mysql-backup

axel

@simatec der läuft doch aud dem DB-Server und soll remote gestartet werden, oder?

axel

@simatec ohhh, das war. Ich war der Überzeugung, das der dump remote gestartet wird. Danke für die Unterstützung.

Community Forum

NEWS

BackitUp-SQL Sicherung

Support us

605

32.6k

82.0k

1.3m