Mailcow 12-2022a fresh install

Ckruijntjens

Hi all,

With a fresh install of mailcow the preparing never ends.

I can’t get by the what is happening page.

Anyone some advise?

Ckruijntjens

this is the error

mailcowdockerized-php-fpm-mailcow-1 | SQL upgrade iteration #1
mailcowdockerized-php-fpm-mailcow-1 | No valid reponse for mysql_upgrade was received, debug output:
mailcowdockerized-php-fpm-mailcow-1 | { “type”: “error”, “msg”: “mysql_upgrade: error running command”, “text”: “Reading datadir from the MariaDB server failed. Got the following error when executing the ‘mysql’ command line client\nERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/run/mysqld/mysqld.sock’ (2)\nFATAL ERROR: Upgrade failed\n” }
mailcowdockerized-php-fpm-mailcow-1 | SQL upgrade iteration #2
mailcowdockerized-php-fpm-mailcow-1 | No valid reponse for mysql_upgrade was received, debug output:
mailcowdockerized-php-fpm-mailcow-1 | { “type”: “error”, “msg”: “mysql_upgrade: error running command”, “text”: “Reading datadir from the MariaDB server failed. Got the following error when executing the ‘mysql’ command line client\nERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/run/mysqld/mysqld.sock’ (2)\nFATAL ERROR: Upgrade failed\n” }
mailcowdockerized-php-fpm-mailcow-1 | SQL upgrade iteration #3
mailcowdockerized-php-fpm-mailcow-1 | No valid reponse for mysql_upgrade was received, debug output:
mailcowdockerized-php-fpm-mailcow-1 | { “type”: “error”, “msg”: “mysql_upgrade: error running command”, “text”: “Reading datadir from the MariaDB server failed. Got the following error when executing the ‘mysql’ command line client\nERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/run/mysqld/mysqld.sock’ (2)\nFATAL ERROR: Upgrade failed\n” }
mailcowdockerized-php-fpm-mailcow-1 | SQL upgrade iteration #4
mailcowdockerized-php-fpm-mailcow-1 | No valid reponse for mysql_upgrade was received, debug output:
mailcowdockerized-php-fpm-mailcow-1 | { “type”: “error”, “msg”: “mysql_upgrade: error running command”, “text”: “Reading datadir from the MariaDB server failed. Got the following error when executing the ‘mysql’ command line client\nERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/run/mysqld/mysqld.sock’ (2)\nFATAL ERROR: Upgrade failed\n” }
mailcowdockerized-php-fpm-mailcow-1 | SQL upgrade iteration #5
mailcowdockerized-php-fpm-mailcow-1 | MySQL applied an upgrade, debug output:
mailcowdockerized-php-fpm-mailcow-1 | { “type”: “warning”, “msg”: “mysql_upgrade: upgrade was applied”, “text”: “Reading datadir from the MariaDB server failed. Got the following error when executing the ‘mysql’ command line client\nERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/run/mysqld/mysqld.sock’ (2)\nFATAL ERROR: Upgrade failed\n” }
mailcowdockerized-php-fpm-mailcow-1 | Uptime: 2 Threads: 3 Questions: 5 Slow queries: 0 Opens: 17 Open tables: 10 Queries per second avg: 2.500
mailcowdockerized-php-fpm-mailcow-1 | Tried to upgrade MySQL and failed, giving up after 5 retries and starting container (oops, not good)
mailcowdockerized-php-fpm-mailcow-1 | Restarting Postfix
mailcowdockerized-php-fpm-mailcow-1 | command completed successfully
mailcowdockerized-php-fpm-mailcow-1 | Sleeping 5 seconds…

this is the error

Ckruijntjens

i dont know what is happening,

Bu a fresh install never finish. any update on this? tried several times now

Ckruijntjens

i Found the solution.

For everyone that is having this problem.

In mailcow.conf disable the check for

Skip running ACME (acme-mailcow, Let’s Encrypt certs) - y/n

SKIP_LETS_ENCRYPT=y

Ckruijntjens

hmm i was to early.

its strange. i did a fresh install and everything went fine. now after 8 hours i do a reboot and again i am routed to the preparing page?

how can i debug this? Ps it only happens after update 12-2022 and the version after this…….. the versions before dont have this issue.

[unknown]

In the log it tels me that it cant connect to upstream server. All docker containers are up and running.

mailcowdockerized-nginx-mailcow-1 | 2022/12/28 07:13:08 [error] 22#22: *1 no live upstreams while connecting to upstream, client: 192.168.2.86, server: mail.ckruijntjens.nl, request: “GET / HTTP/1.1”, upstream: “fastcgi://phpfpm”, host: “192.168.2.114”
mailcowdockerized-nginx-mailcow-1 | 192.168.2.86 - - [28/Dec/2022:07:13:08 +0100] “GET / HTTP/1.1” 502 2038 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36”
mailcowdockerized-nginx-mailcow-1 | 2022/12/28 07:13:08 [error] 22#22: *1 no live upstreams while connecting to upstream, client: 192.168.2.86, server: mail.ckruijntjens.nl, request: “GET / HTTP/1.1”, upstream: “fastcgi://phpfpm”, host: “192.168.2.114”