Find individual E-Mails in Kopano Backup Volume

Individual emails from an ems_kopano-vol volume backup can be found as follows:

Assuming the volume is named backup-ems_kopano-vol.tar.gz:

tar -xzvf backup-ems_kopano-vol.tar.gz

The user data as well as the emails can then be found under ./system/var/storage/u-data/

To find the folder of a user execute the following on a running groupios instance.

docker exec -it kopano bash
USERNAME="y.sautter@groupios.com"
echo $(mysql email -e "SELECT maildir FROM users WHERE username='$USERNAME';" -sN | sed 's|/opt/exchange4all||')

All emails are located here. Individual emails can be found with:

grep ./ -lare 'Subject: AW: Urgent: Backup and Restore of Mailboxes'