Error 502 - Zammad won't run after migrating to another host

adriancv · September 20, 2021, 9:25am

Hello guys,

today i made a backup of my zammad installation and restored it on another host with clean installtion and all prerequisites needed. Right after installation, zammad worked fine, until i restored the backup. Because I don’t have much experience with ruby, nginx or psql, I would like to ask for your help.

The error I get is 502 - bad gateway. The causes seem to be stored in the nginx zammad error log:

2021/09/20 09:33:35 [error] 865#865: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 09:33:36 [error] 865#865: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 09:46:26 [error] 867#867: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:46:30 [error] 867#867: *4 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:46:35 [error] 867#867: *6 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:46:39 [error] 867#867: *8 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:46:44 [error] 867#867: *10 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:50:24 [error] 867#867: *16 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:50:28 [error] 867#867: *18 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:50:33 [error] 867#867: *20 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:50:37 [error] 867#867: *22 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:50:42 [error] 867#867: *24 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:50:46 [error] 867#867: *26 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:50:51 [error] 867#867: *28 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:50:56 [error] 867#867: *30 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:51:02 [error] 867#867: *32 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:51:10 [error] 867#867: *34 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:51:23 [error] 867#867: *36 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:51:41 [error] 867#867: *38 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:52:10 [error] 867#867: *40 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:52:52 [error] 867#867: *42 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:53:52 [error] 867#867: *44 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:54:52 [error] 867#867: *46 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:55:52 [error] 867#867: *48 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:56:52 [error] 867#867: *50 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:57:52 [error] 866#866: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET /ws HTTP/1.1”, upstream: “http://127.0.0.1:6042/ws”, host: “censored”
2021/09/20 09:58:12 [error] 866#866: *3 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 10:03:37 [error] 866#866: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 10:03:38 [error] 866#866: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 10:03:39 [error] 866#866: *4 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 10:03:43 [error] 866#866: *4 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 10:03:47 [error] 866#866: *7 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 10:03:57 [error] 866#866: *9 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 10:06:06 [error] 2359#2359: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 10:06:07 [error] 2359#2359: *3 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 10:06:08 [error] 2359#2359: *3 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 10:06:45 [error] 2359#2359: *3 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 10:06:45 [error] 2359#2359: *7 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 10:31:33 [error] 2664#2664: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 10:31:34 [error] 2664#2664: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 10:31:34 [error] 2664#2664: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 10:31:34 [error] 2664#2664: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 10:32:21 [error] 2664#2664: *6 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 10:35:31 [error] 2664#2664: *8 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 10:44:44 [error] 872#872: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 10:48:37 [error] 1778#1778: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 10:48:38 [error] 1778#1778: *3 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://127.0.0.1:3000/”, host: “censored”
2021/09/20 10:51:38 [error] 1868#1868: *1 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://172.16.200.40:3000/”, host: “censored”
2021/09/20 10:51:39 [error] 1868#1868: *3 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://172.16.200.40:3000/”, host: “censored”
2021/09/20 10:51:39 [error] 1868#1868: *5 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://172.16.200.40:3000/”, host: “censored”
2021/09/20 10:51:39 [error] 1868#1868: *7 connect() failed (111: Connection refused) while connecting to upstream, client: 172.16.200.124, server: censored, request: “GET / HTTP/1.1”, upstream: “http://172.16.200.40:3000/”, host: “censored”

How should I start diagnose or is this a common problem?

Thanks in advance

Zammad Version: 4.0.x (/opt/zammad/VERSION)
Database: psql (PostgreSQL) 12.8 (Ubuntu 12.8-0ubuntu0.20.04.1)
OS: Ubuntu 20.04.3 LTS
Ruby: ruby 2.7.0p0 (2019-12-25 revision 647ee6f091) [x86_64-linux-gnu]

adriancv · September 21, 2021, 10:44am

EDIT:

I found out that the zammad railsserver and websocket are both not running on ports 3000 and 6042 by using lsof. How to it trace down the cause for that?

adriancv · September 22, 2021, 12:31pm

UPDATE: By running zammad run rails r “Setting.set(‘es_user’, ‘’)” I got an erro which says class Digest:SHA1 does not work. Maybe its a problem with ruby version 2.7?

Whole output:
Traceback (most recent call last):
30: from /opt/zammad/bin/rails:8:in <main>' 29: from /opt/zammad/bin/rails:8:in require_relative’
28: from /opt/zammad/config/boot.rb:3:in <top (required)>' 27: from /opt/zammad/vendor/ruby-2.6.6/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in require’
26: from /opt/zammad/vendor/ruby-2.6.6/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in require' 25: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/setup.rb:10:in <top (required)>’
24: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler.rb:101:in setup' 23: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler.rb:135:in definition’
22: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/definition.rb:34:in build' 21: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/dsl.rb:13:in evaluate’
20: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/dsl.rb:234:in to_definition' 19: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/dsl.rb:234:in new’
18: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/definition.rb:120:in initialize' 17: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/definition.rb:674:in converge_sources’
16: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source_list.rb:104:in replace_sources!' 15: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source_list.rb:85:in lock_sources’
14: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source_list.rb:85:in sort_by' 13: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source_list.rb:85:in each’
12: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:76:in to_s' 11: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:225:in revision’
10: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:299:in git_proxy' 9: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:216:in cache_path’
8: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:321:in git_scope' 7: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:287:in uri_hash’
6: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/shared_helpers.rb:225:in digest' 5: from /opt/zammad/vendor/ruby-2.6.6/lib/ruby/2.6.0/digest.rb:98:in Digest’
4: from /opt/zammad/vendor/ruby-2.6.6/lib/ruby/2.6.0/digest.rb:98:in synchronize' 3: from /opt/zammad/vendor/ruby-2.6.6/lib/ruby/2.6.0/digest.rb:100:in block in Digest’
2: from /opt/zammad/vendor/ruby-2.6.6/lib/ruby/2.6.0/digest.rb:17:in const_missing' 1: from /opt/zammad/vendor/ruby-2.6.6/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in require’
/opt/zammad/vendor/ruby-2.6.6/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in require': libcrypto.so.1.0.0: cannot open shared object file: No such file or directory - /opt/zammad/vendor/ruby-2.6.6/lib/ruby/2.6.0/x86_64-linux/digest/sha1.so (LoadError) 28: from /opt/zammad/bin/rails:8:in ’
27: from /opt/zammad/bin/rails:8:in require_relative' 26: from /opt/zammad/config/boot.rb:3:in <top (required)>’
25: from /opt/zammad/vendor/ruby-2.6.6/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in require' 24: from /opt/zammad/vendor/ruby-2.6.6/lib/ruby/2.6.0/rubygems/core_ext/kernel_require.rb:54:in require’
23: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/setup.rb:10:in <top (required)>' 22: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler.rb:101:in setup’
21: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler.rb:135:in definition' 20: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/definition.rb:34:in build’
19: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/dsl.rb:13:in evaluate' 18: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/dsl.rb:234:in to_definition’
17: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/dsl.rb:234:in new' 16: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/definition.rb:120:in initialize’
15: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/definition.rb:674:in converge_sources' 14: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source_list.rb:104:in replace_sources!’
13: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source_list.rb:85:in lock_sources' 12: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source_list.rb:85:in sort_by’
11: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source_list.rb:85:in each' 10: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:76:in to_s’
9: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:225:in revision' 8: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:299:in git_proxy’
7: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:216:in cache_path' 6: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:321:in git_scope’
5: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/source/git.rb:287:in uri_hash' 4: from /opt/zammad/vendor/bundle/ruby/2.6.0/gems/bundler-1.17.3/lib/bundler/shared_helpers.rb:225:in digest’
3: from /opt/zammad/vendor/ruby-2.6.6/lib/ruby/2.6.0/digest.rb:98:in Digest' 2: from /opt/zammad/vendor/ruby-2.6.6/lib/ruby/2.6.0/digest.rb:98:in synchronize’
1: from /opt/zammad/vendor/ruby-2.6.6/lib/ruby/2.6.0/digest.rb:100:in block in Digest' /opt/zammad/vendor/ruby-2.6.6/lib/ruby/2.6.0/digest.rb:16:in const_missing’: library not found for class Digest::SHA1 – digest/sha1 (LoadError)

system · January 20, 2022, 12:32pm

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.