Univention OX-AppSuite (Drive / Calendar) Restore

UCS - Univention Corporate Server
, , ,
#1

Hello!

Today one of our users had a problem with his mail-accounts.
He could not see any of his mail accounts and the appsuite always showed a connection error or timeout. We tried a view different things to exclude some possible reasons.

So other network and client, with or without VPN, and so on. The Logs on the mailserver didn’t show anything noticeable and every other account and user worked fine.

So we took a backup of the maildir-directory under /var/spool/dovecot and then deactivated the user for OX in the management-console. After that we reactivated it.

Then the mails come back in, but the calendar, contact and drive-data was lost.
So here is my question any possibility or idea how we can restore this data?

Thank you for reading!

#2

image

Uncheck will delete!

The user and all its data was deleted from the OX database.
The emails are not OX data, as they are handled separately by an IMAP server (Dovecot) to which OX web UI connects.
To restore the other data (contacts, calendar, drive), restore the MySQL databases used by OX to a point before the deletion. Be aware that this will delete all data entered since then by all other users. Be sure to make a backup before doing a restore, in case the outcome is not desirable.

Greetings
Daniel Tröder

#3

Thank you for the fast answer!

ok understood, thanks for the information…
i think the database or better the univention-mailserver doesn’t make mysql-dumps or something like that by itself. So if there is no manuel made mysql-backup there won’t be a chance to restore, right?

#4

Yes, that’s right - UCS does not automatically create SQL backups.
Sorry.

#5

Hi,

Can you tell me the location and name of databases used by OX , that I need to do backup

Thanks
Nilesh

#6

It’s the MySQL database. Use mysqldump. Also backup the configuration folder: /opt/open-xchange/etc.

#7

Noted.

Thanks Troeder

#8

Thank you again for the answers.
One more question, where i can find the mysql-standard user?
There is no password of username anywhere and i also can not remember to create one with the installation.

#9

Debian creates a user for maintenance work: /etc/mysql/debian.cnf

#10

Thank you very much!

Mastodon