search

mailcow / mailcow-dockerized

mailcow: dockerized - 🐮 + 🐋 = 💕
https://mailcow.email
GNU General Public License v3.0
8.58k stars 1.15k forks source link

Opening SOGo gives 502 Bad Gateway (nginx) #2935

Closed MarkusP closed 4 years ago

MarkusP commented 4 years ago

Hi I have little problem with SOGo Webmailer... I cannot start/call the web-gui anymore. When ever I try to open the webpage I do get a 502 Bad Gateway. I am not sure since when this happens.

I tried with restarting the complete server. I tried with updating the server (with restart), I tried with updating also mailcow docker containers (and restart :-) ). But nothing helps me out.

So, telling the truth, I am not a very familiar with docker :)

Everything else seems to work fine.

My server is a root vServer (enough RAM, CPU/Cores, HDD) OS is Ubuntu 18.04 LTE mailcow-dockerized images before the update:

mailcow-dockerized Container Versionen vor dem Update
root@lxsrv04:/opt/mailcow-dockerized# docker-compose images
WARNING: The WATCHDOG_NOTIFY_EMAIL variable is not set. Defaulting to a blank string.
              Container                    Repository             Tag           Image Id      Size  
----------------------------------------------------------------------------------------------------
mailcowdockerized_acme-mailcow_1        mailcow/acme        1.53              57a42337c36b   98.8 MB
mailcowdockerized_clamd-mailcow_1       mailcow/clamd       1.22              f37b1d8d74cd   263 MB 
mailcowdockerized_dockerapi-mailcow_1   mailcow/dockerapi   1.26              3fd31aec44ad   111 MB 
mailcowdockerized_dovecot-mailcow_1     mailcow/dovecot     1.70              6c16a6cecc12   423 MB 
mailcowdockerized_ipv6nat-mailcow_1     robbertkl/ipv6nat   latest            db2b6c240561   33 MB  
mailcowdockerized_memcached-mailcow_1   memcached           alpine            b24490cae92d   9.76 MB
mailcowdockerized_mysql-mailcow_1       mariadb             10.2              c996ca36da0a   360 MB 
mailcowdockerized_netfilter-mailcow_1   mailcow/netfilter   1.23              3fea031fb3a3   68.7 MB
mailcowdockerized_nginx-mailcow_1       nginx               mainline-alpine   dd025cdfe837   15.3 MB
mailcowdockerized_php-fpm-mailcow_1     mailcow/phpfpm      1.36              75de6f6f14d2   303 MB 
mailcowdockerized_postfix-mailcow_1     mailcow/postfix     1.31              7e2cc7b052d3   216 MB 
mailcowdockerized_redis-mailcow_1       redis               5-alpine          631bf69df08e   48.5 MB
mailcowdockerized_rspamd-mailcow_1      mailcow/rspamd      1.40              df559fc68e55   182 MB 
mailcowdockerized_sogo-mailcow_1        mailcow/sogo        1.54              830bb160f6fc   465 MB 
mailcowdockerized_solr-mailcow_1        mailcow/solr        1.5               390a20578dbf   289 MB 
mailcowdockerized_unbound-mailcow_1     mailcow/unbound     1.6               bb7e4c3171ab   19.9 MB
mailcowdockerized_watchdog-mailcow_1    mailcow/watchdog    1.41              d0eabd828c1e   60 MB

mailcow-dockerized after the container update

mailcow-dockerized Container Versionen nach dem Update am 12.09.2019
root@lxsrv04:/opt/mailcow-dockerized# docker-compose images
WARNING: The WATCHDOG_NOTIFY_EMAIL variable is not set. Defaulting to a blank string.
              Container                    Repository             Tag           Image Id      Size  
----------------------------------------------------------------------------------------------------
mailcowdockerized_acme-mailcow_1        mailcow/acme        1.61              8221d83b29be   107 MB 
mailcowdockerized_clamd-mailcow_1       mailcow/clamd       1.28              3797f775172a   261 MB 
mailcowdockerized_dockerapi-mailcow_1   mailcow/dockerapi   1.32              59c68a5e4d64   70.9 MB
mailcowdockerized_dovecot-mailcow_1     mailcow/dovecot     1.88              1c9b1de37907   296 MB 
mailcowdockerized_ipv6nat-mailcow_1     robbertkl/ipv6nat   latest            a7472f0d2af0   33.1 MB
mailcowdockerized_memcached-mailcow_1   memcached           alpine            61705502e804   8.59 MB
mailcowdockerized_mysql-mailcow_1       mariadb             10.2              5e948595d0ad   324 MB 
mailcowdockerized_netfilter-mailcow_1   mailcow/netfilter   1.28              991a189a6e67   75.4 MB
mailcowdockerized_nginx-mailcow_1       nginx               mainline-alpine   d87c83ec7a66   20.2 MB
mailcowdockerized_olefy-mailcow_1       mailcow/olefy       1.1               5ddcb032e3ab   82.9 MB
mailcowdockerized_php-fpm-mailcow_1     mailcow/phpfpm      1.44              e61e4b9c5e5f   321 MB 
mailcowdockerized_postfix-mailcow_1     mailcow/postfix     1.39              1e6ab1ec30e6   250 MB 
mailcowdockerized_redis-mailcow_1       redis               5-alpine          ed7d2ff5a623   28 MB  
mailcowdockerized_rspamd-mailcow_1      mailcow/rspamd      1.46              0dd442642bf3   174 MB 
mailcowdockerized_sogo-mailcow_1        mailcow/sogo        1.61              7869a4da310f   445 MB 
mailcowdockerized_solr-mailcow_1        mailcow/solr        1.6               40358833edbf   593 MB 
mailcowdockerized_unbound-mailcow_1     mailcow/unbound     1.8               98e718f506da   19.9 MB
mailcowdockerized_watchdog-mailcow_1    mailcow/watchdog    1.58              8c6f0b3b900f   97.9 MB
root@lxsrv04:/opt/mailcow-dockerized#

All I can see in the SOGo logs is something like this...

root@lxsrv04:/opt/mailcow-dockerized# docker-compose logs --tail=1000 sogo-mailcow
WARNING: The WATCHDOG_NOTIFY_EMAIL variable is not set. Defaulting to a blank string.
Attaching to mailcowdockerized_sogo-mailcow_1
sogo-mailcow_1       | Will retry to setup SOGo password update trigger in 3s
sogo-mailcow_1       | ERROR 1359 (HY000) at line 2: Trigger already exists
sogo-mailcow_1       | Will retry to setup SOGo password update trigger in 3s
sogo-mailcow_1       | ERROR 1359 (HY000) at line 2: Trigger already exists
sogo-mailcow_1       | Will retry to setup SOGo password update trigger in 3s
sogo-mailcow_1       | ERROR 1359 (HY000) at line 2: Trigger already exists
sogo-mailcow_1       | Will retry to setup SOGo password update trigger in 3s
...
...
...
sogo-mailcow_1       | ERROR 1359 (HY000) at line 2: Trigger already exists
sogo-mailcow_1       | Will retry to setup SOGo password update trigger in 3s
sogo-mailcow_1       | ERROR 1359 (HY000) at line 2: Trigger already exists
sogo-mailcow_1       | Will retry to setup SOGo password update trigger in 3s
sogo-mailcow_1       | ERROR 1359 (HY000) at line 2: Trigger already exists
sogo-mailcow_1       | Will retry to setup SOGo password update trigger in 3s
sogo-mailcow_1       | ERROR 1359 (HY000) at line 2: Trigger already exists
sogo-mailcow_1       | Will retry to setup SOGo password update trigger in 3s
sogo-mailcow_1       | Sep 13 21:17:01 25c680017a99 CRON[23328]: pam_unix(cron:session): session opened for user root by (uid=0)
sogo-mailcow_1       | Sep 13 21:17:01 25c680017a99 CRON[23329]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
sogo-mailcow_1       | Sep 13 21:17:01 25c680017a99 CRON[23328]: pam_unix(cron:session): session closed for user root
sogo-mailcow_1       | ERROR 1359 (HY000) at line 2: Trigger already exists
sogo-mailcow_1       | Will retry to setup SOGo password update trigger in 3s
sogo-mailcow_1       | ERROR 1359 (HY000) at line 2: Trigger already exists
sogo-mailcow_1       | Will retry to setup SOGo password update trigger in 3s
sogo-mailcow_1       | ERROR 1359 (HY000) at line 2: Trigger already exists
sogo-mailcow_1       | Will retry to setup SOGo password update trigger in 3s
root@lxsrv04:/opt/mailcow-dockerized#

Anyone any ideas? Thanks in advance! Markus

andryyy commented 4 years ago

Try...

docker-compose down
rm /var/lib/docker/volumes/mailcowdockerized_mysql-vol-1/_data/mailcow/sogo_update_password.TRN
docker-compose up -d
MarkusP commented 4 years ago

Thx a lot! Solved!