OK so I followed the guide for migrating a Mailcow instance, but the thing is I couldn’t rsync to the root user, so I rsynced to another user and in my infinite wisdom just chowned all of them to root:root, including /opt/mailcow-dockerized and /var/lib/docker/volumes/*
It was stuck on “Preparing”, and it told me to check the PHP container, which said Waiting for SQL, so I checked mailcowdockerized-mysql-mailcow-1, which is saying:
2024-09-29 9:26:48 0 [ERROR] mysqld: Can't create/write to file '/run/mysqld/mysqld.pid' (Errcode: 13 "Permission denied")
2024-09-29 9:26:48 0 [ERROR] Can't start server: can't create PID file: Permission denied
Also, I checked /var/lib/docker/volumes/mailcowdockerized_mysql-vol-1/_data/ and it all seemed to belong to 999:systemd-journal.
I couldn’t exec into the MySQL container, but I tried making an Alpine container, mounting the volume, and chowning everything to mysql:mysql and that seemed to work, but it didn’t last.
Please save me from my own idiocy
–Quokka.