backups not shown anymore

Hey there.
We have found that backups are not shown anymore in ISPConfig:
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?

 

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?

 

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.

 

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?

 

Yo. The old backups are there. I attach 2 images, where you see that one backup is shown but 2 others not.

 

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

 

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

 

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

 

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 :-(

 

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?

 

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.

 

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

 

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.

 

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?

 

You have to create the scriüts yourself. see https://schaal-it.com/ispconfig-backup-space/ as an example.