BackitUp-SQL Sicherung
-
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
-
@stefanw mysqldump ist auf deinem Host System nicht installiert
-
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 -
C:/Temp/mysqldump.exe -
-
@stefanw dein T in Temp ist wieder klein geschrieben
-
@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 -
@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 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.
-
@axel zeige mal deine Config als json und den kompletten Log vom Backup. Mir ist da kein Bug bekannt
-
@simatec Hier die ergänzenden Infos:
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 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 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!
-
@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 -
@simatec der läuft doch aud dem DB-Server und soll remote gestartet werden, oder?
-
@simatec ohhh, das war. Ich war der Überzeugung, das der dump remote gestartet wird. Danke für die Unterstützung.
