E-Mail restore doesn't work

[OriginalXiaomi]

Greetings!

First up: Mailcow is awesome. Thanks a lot for making my life so much easier.

When I switched my server to another hoster, everything worked out, but now every SOGo account doesn't have the hostname, it looks like that:

Also, I restored all my data, but no emails show up in SOGo or in gmail. I've double checked and they're actually in /var/lib/docker/volumes/mailcowdockerized_vmail-vol-1, but still, they aren't showing up in SOGo.

Thanks a lot in advance 👍

Edit: I don't really care about the IP address in SOGo as is works with or without it. The emails don't show up anyways.

[OriginalXiaomi]

I can receive and write emails, so I think the problem is in linking the data from vmail to mailcow.

[andryyy]

Hi, you are welcome! :)

If you didn’t see an IP there before, you didn’t update mailcow before moving it. Newer mailcows list the IP instead of the hostname. I don’t really think that’s the problem here anyway, just to clarify why you see the IP.

I cannot help any further, as you deleted the issue template and didn’t provide any container logs. :/

Please attach sogo-mailcow, dovecot-mailcow and mysql-mailcow logs. Limit the logs to the time you try to access your mails. Don’t post all logs, please. :)

How did you move your installation by the way?

[andryyy]

Probably wrong MySQL credentials. Try to reset them as described in the docs. If you did it manually somehow, it probably broke or they changed.

Make sure mailcow.conf is a symlink to .env too.

I think it is just a SQL credentials issue. If not, I’m not able to help you here.

[nk-87]

For the database - I believe the username and password in the mailcow.conf file of your backup needs to match the credentials on the host's mailcow.conf.

For the missing emails, if you're coming from an old or long running host, it restores them to /var/lib/docker/volumes/mailcowdockerized_vmail-vol-1/_data/<domain>/<mailbox>, but it needs to go into another directory within it: /var/lib/docker/volumes/mailcowdockerized_vmail-vol-1/_data/<domain>/<mailbox>/Maildir.

I had to empty Maildir and move all the folder directories and Dovecot files in it to get my mail to show up.

[Braintelligence]

@OriginalXiaomi Did you solve your problem or find a workaround?

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[bobskee]

For the database - I believe the username and password in the mailcow.conf file of your backup needs to match the credentials on the host's mailcow.conf.

For the missing emails, if you're coming from an old or long running host, it restores them to /var/lib/docker/volumes/mailcowdockerized_vmail-vol-1/_data/<domain>/<mailbox>, but it needs to go into another directory within it: /var/lib/docker/volumes/mailcowdockerized_vmail-vol-1/_data/<domain>/<mailbox>/Maildir.

I had to empty Maildir and move all the folder directories and Dovecot files in it to get my mail to show up.

This fixed it for me! Thanks

[andryyy]

yep, copy the mailcow.conf! :)

It will prepend or leave the Maildir prefix. It is all in your original mailcow.conf

[johanvandyck]

Hi I stumbled on the same issue. I was forced to reinstall my mailcow from scratch, but while importing I encountered the above bug/feature of the restore function.

_For the missing emails, if you're coming from an old or long running host, it restores them to /var/lib/docker/volumes/mailcowdockerized_vmail-vol-1/_data//, but it needs to go into another directory within it: /var/lib/docker/volumes/mailcowdockerized_vmail-vol-1/data///Maildir.

I like to make a resume, as the above text was not clear to me on first read.

• old installation has in mailcow.conf file the parameter "Maildir_sub="
• Newer installation has in mailcow.conf the parameter "Maildir_sub=Maildir"
• a feature / bug in the restore function doesn't take this parameter into account. It will restore in the same $Maildir_sub during the time the backup was taken. If this param is different now, the mail is restored, but not visible in the mailboxes.
• workaround: make sure the Maildir_sub is the same as during backup; restore; force resync during restore or afterwarts. It would be nice if the restore function is adapted or at least warns the user for this issue.

Regards

Johan.