I had a working system, then I ran upgrade.sh (stable)
which has resulted in a broken system.
The webui does not load, just leaving me with a static error page
to be specific:
source mailcow.conf ; docker compose exec mysql-mailcow mysql -u${DBUSER} -p${DBPASS} ${DBNAME}
connects me to the database, and there appears to be data in it (there are tables at least)
But:
php-fpm-mailcow-1 | Waiting for SQL…
is the only thing that container is logging.
Some digging seems to suggest that the above message is a docker-entrypoint script which is looking for: /var/run/mysqld/mysqld.sock, which isn’t readable from within php-fpm-mailcow-1 (permission denied)
re-running update.sh doesn’t error, and I don’t think it errored in the first place. in docker DNS appears to be correct, ie I can nc mysql-mailcow 3306 from php-fpm-mailcow-1 and successfully connect to mariadb.
So I assume this is some docker volume foo that I don’t understand. The volume appears in docker volume ls,
# docker volume ls | grep mysql-socket-vol-1
local mailcowdockerized_mysql-socket-vol-1
on the host
# ls “/var/lib/docker/volumes/mailcowdockerized_mysql-socket-vol-1/_data”
returns
mysqld.pid mysqld.sock
but I don’t know how to diagnose why it either isn’t mounted by php-fpm-mailcow-1 or it isn’t mounted correctly
Rocky linux 9.5
x86_64
vm
on closer inspection it does appear to be mounted, because in
php-fpm-mailcow-1
# ls -ldn /var/run/mysqld/
drwxrwxrwt 2 999 999 4096 Apr 22 20:59 /var/run/mysqld/
999:999 is the uid:gid that of the mysql from mysql-mailcow, which can’t be a co-incidence.
But I can’t access /var/run/mysqld/ from php-fpm-mailcow:
# ls -ln /var/run/mysqld/
ls: can’t open ‘/var/run/mysqld/’: Permission denied
This feels like a file permissions error, but drwxrwxrwt should allow anyone to list, so I’m confused.
on closer inspection it does appear to be mounted, because in
php-fpm-mailcow-1
# ls -ldn /var/run/mysqld/
drwxrwxrwt 2 999 999 4096 Apr 22 20:59 /var/run/mysqld/
999:999 is the uid:gid that of the mysql from mysql-mailcow, which can’t be a co-incidence.
But I can’t access /var/run/mysqld/ from php-fpm-mailcow:
# ls -ln /var/run/mysqld/
ls: can’t open ‘/var/run/mysqld/’: Permission denied
This feels like a file permissions error, but drwxrwxrwt should allow anyone to list, so I’m confused.