backups not shown anymore

Discussion in 'General' started by jeensg, Feb 23, 2019.

  1. jeensg

    jeensg New Member

    Hey there.
    We have found that backups are not shown anymore in ISPConfig: Screenshot_2019-02-23 ISPConfig.png
    This has to do somehow with the loss of our sshfs-connection.
    -> ISPConfig 3.1.13p1, Debian9, Apache
    -> we included a separated backup-space in /var/backup, where all the backups are stored
    -> all backups done are there (e.g. one domain with id 13 -> 3x web13 -backups of DB and space are there in backup-folder)
    -> backups till last loss of our connection are not shown (we include backup-space with sshfs)
    -> backups since last loss of connection are shown (I can verify this b/c with most websites we have a weekly backup, some daily, which are there for the past 4 days)
    Any ideas on what to check now?
     
    Last edited: Feb 24, 2019
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Those two staments are opposites. Which of them is true?
    If the problem is loss of sshfs connection, can that not be repaired?
    Is that /var/backup mounted from somewhere with some exotic method?
     
  3. jeensg

    jeensg New Member

    I'm sorry, my mistake. backups from before are not shown, but only the ones "newly" created. I corrected that in the starting post. I also did verify this morning, that the newly created backups are there, but the ones from the past weeks (weekly backup) -- which are in the respecting folder! -- are not.
    To "repair" loss of connection, we reconnect mountpoint (mount -a), but as stated above, the old backups, that are correctly in the folder, are not shown in ISPConfig-panel.
    What is an exoctic method? We have a sshfs-mount-point in /etc//fstab.
     
    Last edited: Feb 24, 2019
  4. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    If you examine the host where that backup directory is mounted from, do the old files exist there? Maybe what is mounted now is not the same directory? Or the old backups got removed somehow?
     
  5. jeensg

    jeensg New Member

    Yo. The old backups are there. I attach 2 images, where you see that one backup is shown but 2 others not. Bildschirmfoto_2019-02-24_12-51-46.png Screenshot_2019-02-24 ISPConfig.png
     
  6. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    You blacked out the owner and group owner columns. Was it the same owner:group on all of those files?
     
  7. jeensg

    jeensg New Member

    Yes it was all the same. It's the user that we connect with to the backup-storage.
     
  8. jeensg

    jeensg New Member

    Mh, any more ideas why it's not shown anymore or what I can check why it is as said?
     
  9. jeensg

    jeensg New Member

    Mh, have tried a little more to figure anything out, but I#m stuck. I don't know where to look. User is the same and correct, files are there but backups not shown in panel :-(
     
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    is this a multiserver setup and the backups are taken on the slave? If yes, then the slave is probably not able to connect to the master anymore to write the backup records into the master database.
     
  11. jeensg

    jeensg New Member

    Thanks for the question. This is a single-server setup. The backups are written to /var/backup , where a storage is mounted via sshfs. This connection gets sometimes lost and has to be remounted afterwards manually.
    When you say master database: well, is it possible that after the loss of the connection the database is cleared when it doesn't "see" the backups in the folder? If so, why isn't it written back when the files are there again?
     
  12. till

    till Super Moderator Staff Member ISPConfig Developer

    What I said about master servers does not apply to your system, which is a single server. If the actual backup files are there or not does not matter for the backup list in ISPConfig, the backup list is a database table in the ispconfig database which gets filled by the script which does the backup when the backup is finished.
     
  13. jeensg

    jeensg New Member

    Ok, so the question is, if I get it right: Why did they get kicked out?
    Normally the should only be dropped from the database when the backup is deleted because there are enough old backups, right?
    I only do see a coincidence with the connection loss of the backup-storage ... but why would it be so. I have no clue...just do not want to happen again.
     
  14. till

    till Super Moderator Staff Member ISPConfig Developer

    I don't think that they get kicked out, at least not when the connection to your storage system is working. My guess is that they did not finish and unfinished or broken backups did not get added to the list. Set log level to debug or warning, then you should see failed logs with level 'warning' in the ispconfig log.
     
  15. jeensg

    jeensg New Member

    Thanks, I will try that and report back, when it happens again.
     
  16. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    You can set the backup-dir to "Backup directory is a mount" so ispconfig will run /usr/local/ispconfig/server/scripts/backup_dir_mount.sh before the backup/restore and /usr/local/ispconfig/server/scripts/backup_dir_umount.sh afterwards.
    if the mount fails, the backup will be skipped.
     
  17. jeensg

    jeensg New Member

    This sounds just perfect. Found the option to be actived. But:
    In the scripts-folder /usr/local/ispconfig/server/scripts/ the scripts backup_dir_mount.sh and backup_dir_umount.sh are not present. Where would I get them?
     
  18. florian030

    florian030 ISPConfig Developer ISPConfig Developer

Share This Page