Infos:
- Used Zammad version: 5.4.0
- Used Zammad installation type: docker
- Operating system: Debian GNU/Linux 11 (bullseye)
Expected behavior:
- Login page should come up
Actual behavior:
- 502 bad gateway error
Hello everyone. I have some problem with migration my zammad from docker to source installation. I have same version of installed zammad on both VM, but different OS, docker install - Debian 11 OS version, source install - Ubuntu 22.04 OS version. It can be a problem, but i don’t sure about this.
I have the next problem after sucessful migration from docker VM to new VM in nginx log (*new_server_host - server, which installed by source installation way):
[error] 1534#1534: *130 connect() failed (111: Unknown error) while connecting to upstream, client: *my_windows_host*, server: *new_server_host*, request: "GET / HTTP/2.0", upstream: "http://127.0.0.1:3000/", host: *new_server_host*
Also i can’t assign new IP-addres of my new elasticsearch host. Next error after my attempt try this command rails r “Setting.set(‘es_url’, ‘https://elasticsearch_host:9200’)” i have next error:
/usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/postgresql_adapter.rb:83:in `rescue in new_client': could not translate host name "zammad-postgresql" to address: Temporary failure in name resolution (ActiveRecord::ConnectionNotEstablished)
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/postgresql_adapter.rb:77:in `new_client'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/postgresql_adapter.rb:37:in `postgresql_connection'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:882:in `public_send'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:882:in `new_connection'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:926:in `checkout_new_connection'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:905:in `try_to_checkout_new_connection'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:866:in `acquire_connection'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:588:in `checkout'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:428:in `connection'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:1128:in `retrieve_connection'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_handling.rb:327:in `retrieve_connection'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_handling.rb:283:in `connection'
from /opt/zammad/config/initializers/logo.rb:7:in `block in <main>'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:427:in `instance_exec'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:427:in `block in make_lambda'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:198:in `block (2 levels) in halting'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:604:in `block (2 levels) in default_terminator'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:603:in `catch'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:603:in `block in default_terminator'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:199:in `block in halting'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:512:in `block in invoke_before'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:512:in `each'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:512:in `invoke_before'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:105:in `run_callbacks'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/reloader.rb:88:in `prepare!'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/application/finisher.rb:124:in `block in <module:Finisher>'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/initializable.rb:32:in `instance_exec'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/initializable.rb:32:in `run'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/initializable.rb:61:in `block in run_initializers'
from /usr/share/rvm/rubies/ruby-3.1.3/lib/ruby/3.1.0/tsort.rb:228:in `block in tsort_each'
from /usr/share/rvm/rubies/ruby-3.1.3/lib/ruby/3.1.0/tsort.rb:350:in `block (2 levels) in each_strongly_connected_component'
from /usr/share/rvm/rubies/ruby-3.1.3/lib/ruby/3.1.0/tsort.rb:431:in `each_strongly_connected_component_from'
from /usr/share/rvm/rubies/ruby-3.1.3/lib/ruby/3.1.0/tsort.rb:349:in `block in each_strongly_connected_component'
from /usr/share/rvm/rubies/ruby-3.1.3/lib/ruby/3.1.0/tsort.rb:347:in `each'
from /usr/share/rvm/rubies/ruby-3.1.3/lib/ruby/3.1.0/tsort.rb:347:in `call'
from /usr/share/rvm/rubies/ruby-3.1.3/lib/ruby/3.1.0/tsort.rb:347:in `each_strongly_connected_component'
from /usr/share/rvm/rubies/ruby-3.1.3/lib/ruby/3.1.0/tsort.rb:226:in `tsort_each'
from /usr/share/rvm/rubies/ruby-3.1.3/lib/ruby/3.1.0/tsort.rb:205:in `tsort_each'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/initializable.rb:60:in `run_initializers'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/application.rb:391:in `initialize!'
from /opt/zammad/config/environment.rb:7:in `<main>'
from /usr/share/rvm/gems/ruby-3.1.3/gems/bootsnap-1.16.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require'
from /usr/share/rvm/gems/ruby-3.1.3/gems/bootsnap-1.16.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require'
from /usr/share/rvm/gems/ruby-3.1.3/gems/zeitwerk-2.6.7/lib/zeitwerk/kernel.rb:38:in `require'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/dependencies.rb:332:in `block in require'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/dependencies.rb:299:in `load_dependency'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/dependencies.rb:332:in `require'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/application.rb:367:in `require_environment!'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/command/actions.rb:28:in `require_environment!'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/command/actions.rb:15:in `require_application_and_environment!'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/commands/runner/runner_command.rb:33:in `perform'
from /usr/share/rvm/gems/ruby-3.1.3/gems/thor-1.2.1/lib/thor/command.rb:27:in `run'
from /usr/share/rvm/gems/ruby-3.1.3/gems/thor-1.2.1/lib/thor/invocation.rb:127:in `invoke_command'
from /usr/share/rvm/gems/ruby-3.1.3/gems/thor-1.2.1/lib/thor.rb:392:in `dispatch'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/command/base.rb:69:in `perform'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/command.rb:48:in `invoke'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/commands.rb:18:in `<main>'
from /usr/share/rvm/gems/ruby-3.1.3/gems/bootsnap-1.16.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require'
from /usr/share/rvm/gems/ruby-3.1.3/gems/bootsnap-1.16.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require'
from /opt/zammad/bin/rails:5:in `<main>'
/usr/share/rvm/gems/ruby-3.1.3/gems/pg-1.2.3/lib/pg.rb:58:in `initialize': could not translate host name "zammad-postgresql" to address: Temporary failure in name resolution (PG::ConnectionBad)
from /usr/share/rvm/gems/ruby-3.1.3/gems/pg-1.2.3/lib/pg.rb:58:in `new'
from /usr/share/rvm/gems/ruby-3.1.3/gems/pg-1.2.3/lib/pg.rb:58:in `connect'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/postgresql_adapter.rb:78:in `new_client'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/postgresql_adapter.rb:37:in `postgresql_connection'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:882:in `public_send'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:882:in `new_connection'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:926:in `checkout_new_connection'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:905:in `try_to_checkout_new_connection'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:866:in `acquire_connection'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:588:in `checkout'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:428:in `connection'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:1128:in `retrieve_connection'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_handling.rb:327:in `retrieve_connection'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activerecord-6.1.7.2/lib/active_record/connection_handling.rb:283:in `connection'
from /opt/zammad/config/initializers/logo.rb:7:in `block in <main>'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:427:in `instance_exec'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:427:in `block in make_lambda'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:198:in `block (2 levels) in halting'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:604:in `block (2 levels) in default_terminator'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:603:in `catch'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:603:in `block in default_terminator'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:199:in `block in halting'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:512:in `block in invoke_before'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:512:in `each'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:512:in `invoke_before'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/callbacks.rb:105:in `run_callbacks'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/reloader.rb:88:in `prepare!'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/application/finisher.rb:124:in `block in <module:Finisher>'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/initializable.rb:32:in `instance_exec'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/initializable.rb:32:in `run'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/initializable.rb:61:in `block in run_initializers'
from /usr/share/rvm/rubies/ruby-3.1.3/lib/ruby/3.1.0/tsort.rb:228:in `block in tsort_each'
from /usr/share/rvm/rubies/ruby-3.1.3/lib/ruby/3.1.0/tsort.rb:350:in `block (2 levels) in each_strongly_connected_component'
from /usr/share/rvm/rubies/ruby-3.1.3/lib/ruby/3.1.0/tsort.rb:431:in `each_strongly_connected_component_from'
from /usr/share/rvm/rubies/ruby-3.1.3/lib/ruby/3.1.0/tsort.rb:349:in `block in each_strongly_connected_component'
from /usr/share/rvm/rubies/ruby-3.1.3/lib/ruby/3.1.0/tsort.rb:347:in `each'
from /usr/share/rvm/rubies/ruby-3.1.3/lib/ruby/3.1.0/tsort.rb:347:in `call'
from /usr/share/rvm/rubies/ruby-3.1.3/lib/ruby/3.1.0/tsort.rb:347:in `each_strongly_connected_component'
from /usr/share/rvm/rubies/ruby-3.1.3/lib/ruby/3.1.0/tsort.rb:226:in `tsort_each'
from /usr/share/rvm/rubies/ruby-3.1.3/lib/ruby/3.1.0/tsort.rb:205:in `tsort_each'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/initializable.rb:60:in `run_initializers'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/application.rb:391:in `initialize!'
from /opt/zammad/config/environment.rb:7:in `<main>'
from /usr/share/rvm/gems/ruby-3.1.3/gems/bootsnap-1.16.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require'
from /usr/share/rvm/gems/ruby-3.1.3/gems/bootsnap-1.16.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require'
from /usr/share/rvm/gems/ruby-3.1.3/gems/zeitwerk-2.6.7/lib/zeitwerk/kernel.rb:38:in `require'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/dependencies.rb:332:in `block in require'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/dependencies.rb:299:in `load_dependency'
from /usr/share/rvm/gems/ruby-3.1.3/gems/activesupport-6.1.7.2/lib/active_support/dependencies.rb:332:in `require'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/application.rb:367:in `require_environment!'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/command/actions.rb:28:in `require_environment!'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/command/actions.rb:15:in `require_application_and_environment!'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/commands/runner/runner_command.rb:33:in `perform'
from /usr/share/rvm/gems/ruby-3.1.3/gems/thor-1.2.1/lib/thor/command.rb:27:in `run'
from /usr/share/rvm/gems/ruby-3.1.3/gems/thor-1.2.1/lib/thor/invocation.rb:127:in `invoke_command'
from /usr/share/rvm/gems/ruby-3.1.3/gems/thor-1.2.1/lib/thor.rb:392:in `dispatch'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/command/base.rb:69:in `perform'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/command.rb:48:in `invoke'
from /usr/share/rvm/gems/ruby-3.1.3/gems/railties-6.1.7.2/lib/rails/commands.rb:18:in `<main>'
from /usr/share/rvm/gems/ruby-3.1.3/gems/bootsnap-1.16.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require'
from /usr/share/rvm/gems/ruby-3.1.3/gems/bootsnap-1.16.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require'
from /opt/zammad/bin/rails:5:in `<main>'
Any ideas?