NEWS
SOLVED [gelöst] Wiederherstellung mit backitup
-
Hallo,
ich musste auf meinem RaspberryPi das System mit iobroker und MySQL neu installieren.
Für das Backup habe ich den Adapter Backitup benutzt, welcher auch den Minimal, Total und MySQL auf mein NAS (WD-MyCloud) gesichert hat. Als Verbindung habe ich FTP gewählt. Bei der Wiederherstellung hat auch alles soweit funktioniert, bis auf MySQL. Da gab es folgende Ausgabe:Gestartet...
[ERROR] [mysql] ERROR 1045 (28000): Access denied for user 'iobroker'@'raspberrypi.fritz.box' (using password: YES) [EXIT] undefined [EXIT] 0 [DEBUG] [pushover] start with {"type":"creator","time":"03:00","debugging":true,"everyXDays":"3","deleteBackupAfter":"5","ftp":{"enabled":true,"type":"storage","source":"Local","host":"192.168.178.100","deleteOldBackup":false,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/komplett/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"****","port":"21"},"history":{"enabled":true,"type":"message","entriesNumber":"25","systemLang":"de"},"telegram":{"enabled":true,"notificationsType":"Pushover","type":"message","instance":"","SilentNotice":false,"NoticeType":"longTelegramNotice","User":null,"onlyError":false,"systemLang":"de"},"email":{"enabled":true,"notificationsType":"Pushover","type":"message","instance":"","NoticeType":"longEmailNotice","emailReceiver":"xxx@xxx.com","emailSender":"xxx@xxx.com","onlyError":false,"systemLang":"de"},"pushover":{"enabled":true,"notificationsType":"Pushover","type":"message","instance":"pushover.0","SilentNotice":false,"NoticeType":"shortPushoverNotice","deviceID":"","onlyError":false,"systemLang":"de","time":"18. Maerz 2019 um 22:33 Uhr"},"mysql":{"enabled":true,"type":"creator","ftp":{"enabled":true,"type":"storage","source":"Local","host":"192.168.178.100","deleteOldBackup":false,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/komplett/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"chris","port":"21"},"cifs":{"enabled":false,"mountType":"CIFS","type":"storage","source":"Local","mount":"192.168.178.100","fileDir":"/opt/iobroker/node_modules/iobroker.backitup","wakeOnLAN":false,"macAd":"20:DE:20:DE:20:DE","wolTime":"25","smb":"vers=1.0","sudo":false,"deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/komplett/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"6iw:u"},"dropbox":{"enabled":false,"type":"storage","source":"Local","deleteOldBackup":false,"accessToken":"","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal","dirTotal":"/backupDir/total"},"dbName":"iobroker","user":"iobroker","pass":"****","deleteBackupAfter":5,"host":"192.168.178.153","port":"3306","exe":""},"dir":"/opt/iobroker","redis":{"enabled":false,"ftp":{"enabled":true,"type":"storage","source":"Local","host":"192.168.178.100","deleteOldBackup":false,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/komplett/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"chris","port":"21"},"cifs":{"enabled":false,"mountType":"CIFS","type":"storage","source":"Local","mount":"192.168.178.100","fileDir":"/opt/iobroker/node_modules/iobroker.backitup","wakeOnLAN":false,"macAd":"20:DE:20:DE:20:DE","wolTime":"25","smb":"vers=1.0","sudo":false,"deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/komplett/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"6iw:u"},"dropbox":{"enabled":false,"type":"storage","source":"Local","deleteOldBackup":false,"accessToken":"","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal","dirTotal":"/backupDir/total"},"path":"/var/lib/redis"},"stopIoB":true,"afterBackup":true,"backupDir":"/opt/iobroker/backups"} [DEBUG] [pushover] - [total] used pushover-Instance: pushover.0 [DEBUG] [pushover] - done [DEBUG] [history] start with {"type":"creator","time":"03:00","debugging":true,"everyXDays":"3","deleteBackupAfter":"5","ftp":{"enabled":true,"type":"storage","source":"Local","host":"192.168.178.100","deleteOldBackup":false,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/komplett/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"****","port":"21"},"history":{"enabled":true,"type":"message","entriesNumber":"25","systemLang":"de","time":"18. Maerz 2019 um 22:33 Uhr"},"telegram":{"enabled":true,"notificationsType":"Pushover","type":"message","instance":"","SilentNotice":false,"NoticeType":"longTelegramNotice","User":null,"onlyError":false,"systemLang":"de"},"email":{"enabled":true,"notificationsType":"Pushover","type":"message","instance":"","NoticeType":"longEmailNotice","emailReceiver":"xxx@xxx.com","emailSender":"xxx@xxx.com","onlyError":false,"systemLang":"de"},"pushover":{"enabled":true,"notificationsType":"Pushover","type":"message","instance":"pushover.0","SilentNotice":false,"NoticeType":"shortPushoverNotice","deviceID":"","onlyError":false,"systemLang":"de"},"mysql":{"enabled":true,"type":"creator","ftp":{"enabled":true,"type":"storage","source":"Local","host":"192.168.178.100","deleteOldBackup":false,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/komplett/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"chris","port":"21"},"cifs":{"enabled":false,"mountType":"CIFS","type":"storage","source":"Local","mount":"192.168.178.100","fileDir":"/opt/iobroker/node_modules/iobroker.backitup","wakeOnLAN":false,"macAd":"20:DE:20:DE:20:DE","wolTime":"25","smb":"vers=1.0","sudo":false,"deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/komplett/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"6iw:u"},"dropbox":{"enabled":false,"type":"storage","source":"Local","deleteOldBackup":false,"accessToken":"","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal","dirTotal":"/backupDir/total"},"dbName":"iobroker","user":"iobroker","pass":"****","deleteBackupAfter":5,"host":"192.168.178.153","port":"3306","exe":""},"dir":"/opt/iobroker","redis":{"enabled":false,"ftp":{"enabled":true,"type":"storage","source":"Local","host":"192.168.178.100","deleteOldBackup":false,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/komplett/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"chris","port":"21"},"cifs":{"enabled":false,"mountType":"CIFS","type":"storage","source":"Local","mount":"192.168.178.100","fileDir":"/opt/iobroker/node_modules/iobroker.backitup","wakeOnLAN":false,"macAd":"20:DE:20:DE:20:DE","wolTime":"25","smb":"vers=1.0","sudo":false,"deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/komplett/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"6iw:u"},"dropbox":{"enabled":false,"type":"storage","source":"Local","deleteOldBackup":false,"accessToken":"","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal","dirTotal":"/backupDir/total"},"path":"/var/lib/redis"},"stopIoB":true,"afterBackup":true,"backupDir":"/opt/iobroker/backups"} [DEBUG] [history] - backitup.0.history.html [EXIT] 0
Den Error in der 2. Zeile verstehe ich nicht so richtig, weil die Wiederherstellung "total" ja klappt.
kann mir da jemand weiterhelfen?
Gruß
Chris -
Nun habe ich ein Backup über FTP erfolgreich gemacht. Daher könnte das Thema geschlossen werden.
Das Problem war anscheinend die Rechte am Backups-Ordner.Gruß
Chris -
Da besteht ein Rechteproblem.
Hast du den Pfad zu mysqldump richtig angegeben?
Probiere das backup mal lokal abzulegen und dann darüber die Wiederherstellung zu starten. -
Ich habe gerade mal ein Backup gemacht und hier ist die dazugehörige Ausgabe. Dort ist auch ein Error.
Gestartet...
[DEBUG] [minimal] start with {"type":"creator","time":"02:00","debugging":true,"everyXDays":"1","deleteBackupAfter":0,"mysqlEnabled":true,"redisEnabled":false,"ftp":{"enabled":true,"type":"storage","source":"FTP","host":"192.168.178.100","deleteOldBackup":false,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/standart/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"****","port":"21"},"mysql":{"enabled":true,"type":"creator","ftp":{"enabled":true,"type":"storage","source":"FTP","host":"192.168.178.100","deleteOldBackup":false,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/standart/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"chris","port":"21"},"cifs":{"enabled":false,"mountType":"CIFS","type":"storage","source":"FTP","mount":"192.168.178.100","fileDir":"/opt/iobroker/node_modules/iobroker.backitup","wakeOnLAN":false,"macAd":"20:DE:20:DE:20:DE","wolTime":"25","smb":"vers=1.0","sudo":false,"deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/standart/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"6iw:u"},"dropbox":{"enabled":false,"type":"storage","source":"FTP","deleteOldBackup":false,"accessToken":"","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal","dirTotal":"/backupDir/total"},"dbName":"iobroker","user":"iobroker","pass":"****","deleteBackupAfter":5,"host":"192.168.178.153","port":"3306","exe":""},"dir":"/opt/iobroker","redis":{"enabled":false,"type":"creator","ftp":{"enabled":true,"type":"storage","source":"FTP","host":"192.168.178.100","deleteOldBackup":false,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/standart/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"chris","port":"21"},"cifs":{"enabled":false,"mountType":"CIFS","type":"storage","source":"FTP","mount":"192.168.178.100","fileDir":"/opt/iobroker/node_modules/iobroker.backitup","wakeOnLAN":false,"macAd":"20:DE:20:DE:20:DE","wolTime":"25","smb":"vers=1.0","sudo":false,"deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/standart/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"6iw:u"},"dropbox":{"enabled":false,"type":"storage","source":"FTP","deleteOldBackup":false,"accessToken":"","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal","dirTotal":"/backupDir/total"},"path":"/var/lib/redis"},"history":{"enabled":true,"type":"message","entriesNumber":"25","systemLang":"de"},"telegram":{"enabled":true,"notificationsType":"Pushover","type":"message","instance":"","SilentNotice":false,"NoticeType":"longTelegramNotice","User":null,"onlyError":false,"systemLang":"de"},"email":{"enabled":true,"notificationsType":"Pushover","type":"message","instance":"","NoticeType":"longEmailNotice","emailReceiver":"xxx@xxx.com","emailSender":"xxx@xxx.com","onlyError":false,"systemLang":"de"},"pushover":{"enabled":true,"notificationsType":"Pushover","type":"message","instance":"pushover.0","SilentNotice":false,"NoticeType":"shortPushoverNotice","deviceID":"","onlyError":false,"systemLang":"de"},"backupDir":"/opt/iobroker/backups"} [DEBUG] [minimal] - Backup created: /opt/iobroker/backups/minimal_2019_03_19-02_42_58_backupiobroker.tar.gz [DEBUG] [minimal] - done [DEBUG] [mysql] start with {"type":"creator","ftp":{"enabled":true,"type":"storage","source":"FTP","host":"192.168.178.100","deleteOldBackup":false,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/standart/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"****","port":"21"},"dbName":"iobroker","user":"iobroker","pass":"****","deleteBackupAfter":5,"host":"192.168.178.153","port":"3306","exe":""} [ERROR] [mysql] - mysqldump: Got error: 1045: "Access denied for user 'iobroker'@'raspberrypi.fritz.box' (using password: YES)" when trying to connect [DEBUG] [mysql] - done [DEBUG] [ftp] start with {"type":"storage","source":"FTP","host":"192.168.178.100","deleteOldBackup":false,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/standart/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"****","port":"21","deleteBackupAfter":0} [DEBUG] [mysql] - done [DEBUG] [mysql] - MySql File deleted! [DEBUG] [clean] start with {"deleteBackupAfter":0} [DEBUG] [clean] - done [DEBUG] [pushover] start with {"type":"creator","time":"02:00","debugging":true,"everyXDays":"1","deleteBackupAfter":0,"mysqlEnabled":true,"redisEnabled":false,"ftp":{"enabled":true,"type":"storage","source":"FTP","host":"192.168.178.100","deleteOldBackup":false,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/standart/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"****","port":"21"},"mysql":{"enabled":true,"type":"creator","ftp":{"enabled":true,"type":"storage","source":"FTP","host":"192.168.178.100","deleteOldBackup":false,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/standart/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"chris","port":"21"},"cifs":{"enabled":false,"mountType":"CIFS","type":"storage","source":"FTP","mount":"192.168.178.100","fileDir":"/opt/iobroker/node_modules/iobroker.backitup","wakeOnLAN":false,"macAd":"20:DE:20:DE:20:DE","wolTime":"25","smb":"vers=1.0","sudo":false,"deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/standart/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"6iw:u"},"dropbox":{"enabled":false,"type":"storage","source":"FTP","deleteOldBackup":false,"accessToken":"","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal","dirTotal":"/backupDir/total"},"dbName":"iobroker","user":"iobroker","pass":"****","deleteBackupAfter":5,"host":"192.168.178.153","port":"3306","exe":""},"dir":"/opt/iobroker","redis":{"enabled":false,"type":"creator","ftp":{"enabled":true,"type":"storage","source":"FTP","host":"192.168.178.100","deleteOldBackup":false,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/standart/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"chris","port":"21"},"cifs":{"enabled":false,"mountType":"CIFS","type":"storage","source":"FTP","mount":"192.168.178.100","fileDir":"/opt/iobroker/node_modules/iobroker.backitup","wakeOnLAN":false,"macAd":"20:DE:20:DE:20:DE","wolTime":"25","smb":"vers=1.0","sudo":false,"deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/standart/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"6iw:u"},"dropbox":{"enabled":false,"type":"storage","source":"FTP","deleteOldBackup":false,"accessToken":"","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal","dirTotal":"/backupDir/total"},"path":"/var/lib/redis"},"history":{"enabled":true,"type":"message","entriesNumber":"25","systemLang":"de"},"telegram":{"enabled":true,"notificationsType":"Pushover","type":"message","instance":"","SilentNotice":false,"NoticeType":"longTelegramNotice","User":null,"onlyError":false,"systemLang":"de"},"email":{"enabled":true,"notificationsType":"Pushover","type":"message","instance":"","NoticeType":"longEmailNotice","emailReceiver":"xxx@xxx.com","emailSender":"xxx@xxx.com","onlyError":false,"systemLang":"de"},"pushover":{"enabled":true,"notificationsType":"Pushover","type":"message","instance":"pushover.0","SilentNotice":false,"NoticeType":"shortPushoverNotice","deviceID":"","onlyError":false,"systemLang":"de","time":"19. Maerz 2019 um 02:43 Uhr"},"backupDir":"/opt/iobroker/backups"} [DEBUG] [pushover] - [minimal] used pushover-Instance: pushover.0 [DEBUG] [pushover] - done [DEBUG] [history] start with {"type":"creator","time":"02:00","debugging":true,"everyXDays":"1","deleteBackupAfter":0,"mysqlEnabled":true,"redisEnabled":false,"ftp":{"enabled":true,"type":"storage","source":"FTP","host":"192.168.178.100","deleteOldBackup":false,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/standart/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"****","port":"21"},"mysql":{"enabled":true,"type":"creator","ftp":{"enabled":true,"type":"storage","source":"FTP","host":"192.168.178.100","deleteOldBackup":false,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/standart/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"chris","port":"21"},"cifs":{"enabled":false,"mountType":"CIFS","type":"storage","source":"FTP","mount":"192.168.178.100","fileDir":"/opt/iobroker/node_modules/iobroker.backitup","wakeOnLAN":false,"macAd":"20:DE:20:DE:20:DE","wolTime":"25","smb":"vers=1.0","sudo":false,"deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/standart/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"6iw:u"},"dropbox":{"enabled":false,"type":"storage","source":"FTP","deleteOldBackup":false,"accessToken":"","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal","dirTotal":"/backupDir/total"},"dbName":"iobroker","user":"iobroker","pass":"****","deleteBackupAfter":5,"host":"192.168.178.153","port":"3306","exe":""},"dir":"/opt/iobroker","redis":{"enabled":false,"type":"creator","ftp":{"enabled":true,"type":"storage","source":"FTP","host":"192.168.178.100","deleteOldBackup":false,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/standart/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"chris","port":"21"},"cifs":{"enabled":false,"mountType":"CIFS","type":"storage","source":"FTP","mount":"192.168.178.100","fileDir":"/opt/iobroker/node_modules/iobroker.backitup","wakeOnLAN":false,"macAd":"20:DE:20:DE:20:DE","wolTime":"25","smb":"vers=1.0","sudo":false,"deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"Backup-Ras/standart/","dirMinimal":"Backup-Ras/standart/","dirTotal":"Backup-Ras/komplett/","user":"backup-ras","pass":"6iw:u"},"dropbox":{"enabled":false,"type":"storage","source":"FTP","deleteOldBackup":false,"accessToken":"","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal","dirTotal":"/backupDir/total"},"path":"/var/lib/redis"},"history":{"enabled":true,"type":"message","entriesNumber":"25","systemLang":"de","time":"19. Maerz 2019 um 02:43 Uhr"},"telegram":{"enabled":true,"notificationsType":"Pushover","type":"message","instance":"","SilentNotice":false,"NoticeType":"longTelegramNotice","User":null,"onlyError":false,"systemLang":"de"},"email":{"enabled":true,"notificationsType":"Pushover","type":"message","instance":"","NoticeType":"longEmailNotice","emailReceiver":"xxx@xxx.com","emailSender":"xxx@xxx.com","onlyError":false,"systemLang":"de"},"pushover":{"enabled":true,"notificationsType":"Pushover","type":"message","instance":"pushover.0","SilentNotice":false,"NoticeType":"shortPushoverNotice","deviceID":"","onlyError":false,"systemLang":"de"},"backupDir":"/opt/iobroker/backups"} [DEBUG] [history] - backitup.0.history.html [EXIT] 0 [DEBUG] [ftp] - FTP connected. [DEBUG] [ftp] - Send minimal_2019_03_19-02_42_58_backupiobroker.tar.gz [DEBUG] [ftp] - Send mysql_2019_03_19-02_43_04_backupiobroker.tar.gz [DEBUG] [ftp] - done [EXIT] 0
-
@keinstein77 sagte in Wiederherstellung mit backitup:
Access denied for user
Dein mysql ist nicht korrekt für den User iobroker eingerichtet.
Dr. Google hilft ... -
ich habe jetzt einfach mal den Ordner "Backups" mit chmod 777 die Rechte vergeben. Ich hab es erstmal lokal versucht. Nun funktioniert es. Ob es über FTP geht muß ich erst mal probieren. Dazu später.
-
Nun habe ich ein Backup über FTP erfolgreich gemacht. Daher könnte das Thema geschlossen werden.
Das Problem war anscheinend die Rechte am Backups-Ordner.Gruß
Chris -
Setze bitte das Thema auf gelöst ....