Hey,

I have a fresh installation with fresh config.yaml file. I set only the ssh part and the communication with backup server is fine.

docker compose exec borgmatic-mailcow borgmatic extract --path mnt/source --archive latest has no result output to see if is restored or not. Checking docker container sizes with docker system df -v show me that over file size that is not done.

If I try to restore the DB with docker compose exec borgmatic-mailcow borgmatic restore --archive latest than the access to DB is denied:

root@mailcow:/opt/mailcow-dockerized# docker compose exec borgmatic-mailcow borgmatic restore --archive latest
rsync: Error running actions for repository
Command 'mysql --batch --user mailcow' returned non-zero exit status 1.
/etc/borgmatic.d/config.yaml: An error occurred

summary:
/etc/borgmatic.d/config.yaml: An error occurred
rsync: Error running actions for repository
ERROR 1227 (42000) at line 94: Access denied; you need (at least one of) the SUPER, SET USER privilege(s) for this operation
Command 'mysql --batch --user mailcow' returned non-zero exit status 1.

Need some help? https://torsion.org/borgmatic/#issues

    I could extract the files after docker exec into borgmatic-mailcow but restoring the database is still was not possible. I try to restore it with root user and root password from mailcow.conf which has worked somehow partly, domains, email addresses are now listed in mailcow but still with error.

    mailcow:/# borgmatic restore --archive latest
rsync: Error running actions for repository
Command 'mysql --batch --user root' returned non-zero exit status 1.
/etc/borgmatic.d/config.yaml: An error occurred

summary:
/etc/borgmatic.d/config.yaml: An error occurred
rsync: Error running actions for repository
ERROR 1449 (HY000) at line 4635: The user specified as a definer ('mailcow_'@'%') does not exist
Command 'mysql --batch --user root' returned non-zero exit status 1.

Need some help? https://torsion.org/borgmatic/#issues

    Have something to say?

    Join the community by quickly registering to participate in this discussion. We'd like to see you joining our great moo-community!

    semaf

    Giving the user full rights, just for the restore, gave me the same error live above that the user does not exist.

    mailcow:/# borgmatic restore --archive latest
rsync: Error running actions for repository
Command 'mysql --batch --user mailcow' returned non-zero exit status 1.
/etc/borgmatic.d/config.yaml: An error occurred

summary:
/etc/borgmatic.d/config.yaml: An error occurred
rsync: Error running actions for repository
ERROR 1449 (HY000) at line 4635: The user specified as a definer ('mailcow_'@'%') does not exist
Command 'mysql --batch --user mailcow' returned non-zero exit status 1.

Need some help? https://torsion.org/borgmatic/#issues
      No one is typing