Am 03.06.2024 um 11:15 schrieb Christian Mack
(christian.m...@uni-konstanz.de):
Hello
Am 02.06.24 um 22:47 schrieb Paul Leiber (p...@onlineschubla.de):
Dear SOGo users,
Due to some unknown circumstance, I seem to have lost all my personal
contact and calendar information in SOGo.
I have been using MySQL backup functionality (mariadb-backup) to
regularly back up the complete MySQL database, including the SOGo
database. Now, when trying to restore the database, the calendar and
contact information stays empty, independent from the specific backup
I am restoring. I also noticed that the file sizes of the database
files created by mariadb-backup are more or less identical and do not
change over time.
To narrow down the error, I would like to know if it is possible in
principle to backup SOGo calendar and contact information by backing
up the MySQL database, like I did (or better tried to do). If this is
possible, then I seem to have made an error while backing up or
restoring the database. If this is not possible, then I don't need to
work on the MySQL part.
Any other help is of course also appreciated.
And a +1 for always testing restoration when implementing a backup
strategy to avoid situations like mine...
MariaDB Backup should contain all data for calendars, address books and
settings.
Did you backup the data too, or only the table structure?
(You can see the data inside "INSERT" statements.)
Thank you for your reply. I am sure I have the database backed up
including data itself.
Good news is that I have the calendar and contact information back. I
have an assumption what went wrong.
I recently added the entries OCSAdminURL, OCSStoreURL OCSAclURL, and
OCSCacheFolderURL. Due to an error message in the logs, I added
OCSAdminUrl. At the same time, I saw entries referring to localhost
being used for cache, so I tried pointing OCSStoreURL OCSAclURL, and
OCSCacheFolderURL to the database server, but without copying any data
from localhost to the database server.
I assume that the data stored in the tables OCSStoreURL OCSAclURL, and
OCSCacheFolderURL (or at least one of them) contain SOGo calendar and
contact information. If my assumption is right, then of course my
account couldn't show the calendar and contact information anymore after
pointing to an empty database.
Does this explanation seem correct?
BTW: While fiddling around with the database, I managed to create a
situation where the file for the table sogo_sessions_folder got lost (I
swear I didn't delete it). Solution: I needed to drop the table, after
which it was recreated.
Best regards,
Paul
