Enabling Debug Logging

Support
1

hi all,

I enable the logs to see why foreman cannot start, but I dont see any changes in production.log
We change the domain name of the server from e.g test.xyz.com to test.abc.com.

In /etc/foreman/settings.yaml file. and I try to start foreman

    :logging:
      :level: debug

$: journcalctl -xfu foreman
Mär 01 13:59:18 testdev foreman[152593]: /var/lib/gems/2.7.0/gems/bundler-1.16.1/lib/bundler/rubygems_integration.rb:196: warning: constant Gem::ConfigMap is deprecated
Mär 01 13:59:18 testdev foreman[152593]: /var/lib/gems/2.7.0/gems/bundler-1.16.1/lib/bundler/rubygems_integration.rb:196: warning: constant Gem::ConfigMap is deprecated
Mär 01 13:59:21 testdev foreman[152593]: /usr/share/foreman/vendor/ruby/2.7.0/gems/graphql-1.8.18/lib/graphql/schema/mutation.rb:70: warning: Using the last argument as keyword parameters is deprecated; maybe ** should be added to the call
Mär 01 13:59:21 testdev foreman[152593]: /usr/share/foreman/vendor/ruby/2.7.0/gems/graphql-1.8.18/lib/graphql/schema/member/has_fields.rb:51: warning: The called method `field' is defined here
Mär 01 13:59:22 testdev foreman[152593]: => Booting Puma
Mär 01 13:59:22 testdev foreman[152593]: => Rails 6.0.3.7 application starting in production
Mär 01 13:59:22 testdev foreman[152593]: => Run `rails server --help` for more startup options
Mär 01 13:59:22 testdev foreman[152593]: /usr/share/foreman/app/registries/foreman/settings/general.rb:48: warning: Passing the keyword argument as the last hash parameter is deprecated
Mär 01 13:59:22 testdev foreman[152593]: /usr/share/foreman/app/registries/foreman/setting_manager.rb:151: warning: The called method `validates' is defined here
Mär 01 13:59:22 testdev foreman[152593]: /usr/share/foreman/app/registries/foreman/settings/email.rb:82: warning: Passing the keyword argument as the last hash parameter is deprecated
Mär 01 13:59:22 testdev foreman[152593]: /usr/share/foreman/app/registries/foreman/setting_manager.rb:151: warning: The called method `validates' is defined here
Mär 01 13:59:22 testdev foreman[152593]: /usr/share/foreman/app/models/concerns/has_many_common.rb:48: warning: Using the last argument as keyword parameters is deprecated; maybe ** should be added to the call
Mär 01 13:59:22 testdev foreman[152593]: /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/associations.rb:1370: warning: The called method `has_many' is defined here
Mär 01 13:59:22 testdev foreman[152593]: /usr/share/foreman/app/models/concerns/has_many_common.rb:53: warning: Using the last argument as keyword parameters is deprecated; maybe ** should be added to the call
Mär 01 13:59:22 testdev foreman[152593]: /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/associations.rb:1826: warning: The called method `has_and_belongs_to_many' is defined here
Mär 01 13:59:22 testdev foreman[152593]: /usr/share/foreman/app/services/setting_registry.rb:139: warning: Using the last argument as keyword parameters is deprecated; maybe ** should be added to the call
Mär 01 13:59:22 testdev foreman[152593]: /usr/share/foreman/app/services/setting_registry.rb:168: warning: The called method `_add' is defined here
Mär 01 13:59:23 testdev foreman[152593]: /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql_adapter.rb:46: warning: Using the last argument as keyword parameters is deprecated; maybe ** should be added to the call
Mär 01 13:59:23 testdev foreman[152593]: /usr/share/foreman/vendor/ruby/2.7.0/gems/pg-1.3.5/lib/pg.rb:68: warning: The called method `connect' is defined here
Mär 01 13:59:23 testdev foreman[152593]: /usr/share/foreman/app/models/concerns/has_many_common.rb:77: warning: Using the last argument as keyword parameters is deprecated; maybe ** should be added to the call
Mär 01 13:59:23 testdev foreman[152593]: /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/associations.rb:1657: warning: The called method `belongs_to' is defined here
Mär 01 13:59:25 testdev foreman[152593]: Exiting
Mär 01 13:59:25 testdev foreman[152593]: /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql_adapter.rb:50:in `rescue in postgresql_connection': FATAL:  role "foreman" does not exist (ActiveRecord::NoDatabaseError)
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql_adapter.rb:33:in `postgresql_connection'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:887:in `new_connection'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:931:in `checkout_new_connection'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:910:in `try_to_checkout_new_connection'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:871:in `acquire_connection'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:593:in `checkout'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:437:in `connection'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:1119:in `retrieve_connection'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_handling.rb:221:in `retrieve_connection'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_handling.rb:189:in `connection'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/model_schema.rb:488:in `load_schema!'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/attributes.rb:247:in `load_schema!'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/attribute_decorators.rb:50:in `load_schema!'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/model_schema.rb:478:in `block in load_schema'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/model_schema.rb:475:in `synchronize'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/model_schema.rb:475:in `load_schema'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/model_schema.rb:352:in `columns_hash'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/app/services/graphql_attribute.rb:15:in `required?'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/app/graphql/types/base_object.rb:54:in `nullable?'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/app/graphql/types/base_object.rb:9:in `field'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/app/graphql/types/base_object.rb:14:in `timestamps'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/foreman_puppet-3.0.7/app/graphgl/foreman_puppet/types/environment.rb:8:in `<class:Environment>'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/foreman_puppet-3.0.7/app/graphgl/foreman_puppet/types/environment.rb:3:in `<module:Types>'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/foreman_puppet-3.0.7/app/graphgl/foreman_puppet/types/environment.rb:2:in `<module:ForemanPuppet>'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/foreman_puppet-3.0.7/app/graphgl/foreman_puppet/types/environment.rb:1:in `<top (required)>'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/polyglot-0.3.5/lib/polyglot.rb:65:in `require'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/polyglot-0.3.5/lib/polyglot.rb:65:in `require'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:324:in `block in require'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:291:in `load_dependency'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:324:in `require'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:411:in `block in require_or_load'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:40:in `block in load_interlock'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies/interlock.rb:14:in `block in loading'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/share_lock.rb:151:in `exclusive'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies/interlock.rb:13:in `loading'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:40:in `load_interlock'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:389:in `require_or_load'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:367:in `depend_on'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:280:in `require_dependency'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/engine.rb:481:in `block (2 levels) in eager_load!'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/engine.rb:480:in `each'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/engine.rb:480:in `block in eager_load!'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/engine.rb:477:in `each'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/engine.rb:477:in `eager_load!'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/engine.rb:356:in `eager_load!'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/application/finisher.rb:123:in `each'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/application/finisher.rb:123:in `block in <module:Finisher>'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/initializable.rb:32:in `instance_exec'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/initializable.rb:32:in `run'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/config/initializers/0_print_time_spent.rb:45:in `block in run'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/config/initializers/0_print_time_spent.rb:17:in `benchmark'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/config/initializers/0_print_time_spent.rb:45:in `run'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/initializable.rb:61:in `block in run_initializers'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/lib/ruby/2.7.0/tsort.rb:228:in `block in tsort_each'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/lib/ruby/2.7.0/tsort.rb:350:in `block (2 levels) in each_strongly_connected_component'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/lib/ruby/2.7.0/tsort.rb:431:in `each_strongly_connected_component_from'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/lib/ruby/2.7.0/tsort.rb:349:in `block in each_strongly_connected_component'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/lib/ruby/2.7.0/tsort.rb:347:in `each'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/lib/ruby/2.7.0/tsort.rb:347:in `call'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/lib/ruby/2.7.0/tsort.rb:347:in `each_strongly_connected_component'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/lib/ruby/2.7.0/tsort.rb:226:in `tsort_each'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/lib/ruby/2.7.0/tsort.rb:205:in `tsort_each'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/initializable.rb:60:in `run_initializers'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/application.rb:363:in `initialize!'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/railtie.rb:190:in `public_send'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/railtie.rb:190:in `method_missing'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/config/environment.rb:5:in `<top (required)>'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/polyglot-0.3.5/lib/polyglot.rb:65:in `require'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/polyglot-0.3.5/lib/polyglot.rb:65:in `require'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:324:in `block in require'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:291:in `load_dependency'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:324:in `require'
Mär 01 13:59:25 testdev foreman[152593]:         from config.ru:5:in `block in <main>'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/rack-2.2.3/lib/rack/builder.rb:116:in `eval'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/rack-2.2.3/lib/rack/builder.rb:116:in `new_from_string'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/rack-2.2.3/lib/rack/builder.rb:105:in `load_file'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/rack-2.2.3/lib/rack/builder.rb:66:in `parse_file'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/rack-2.2.3/lib/rack/server.rb:349:in `build_app_and_options_from_config'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/rack-2.2.3/lib/rack/server.rb:249:in `app'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/rack-2.2.3/lib/rack/server.rb:422:in `wrapped_app'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/rack-2.2.3/lib/rack/server.rb:312:in `block in start'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/rack-2.2.3/lib/rack/server.rb:379:in `handle_profiling'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/rack-2.2.3/lib/rack/server.rb:311:in `start'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/commands/server/server_command.rb:39:in `start'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/commands/server/server_command.rb:147:in `block in perform'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/commands/server/server_command.rb:138:in `tap'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/commands/server/server_command.rb:138:in `perform'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/thor-1.1.0/lib/thor/command.rb:27:in `run'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/thor-1.1.0/lib/thor/invocation.rb:127:in `invoke_command'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/thor-1.1.0/lib/thor.rb:392:in `dispatch'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/command/base.rb:69:in `perform'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/command.rb:46:in `invoke'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/commands.rb:18:in `<top (required)>'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:324:in `require'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:324:in `block in require'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:291:in `load_dependency'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:324:in `require'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/bin/rails:9:in `<main>'
Mär 01 13:59:25 testdev foreman[152593]: /usr/share/foreman/vendor/ruby/2.7.0/gems/pg-1.3.5/lib/pg/connection.rb:637:in `async_connect_or_reset': FATAL:  role "foreman" does not exist (PG::ConnectionBad)
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/pg-1.3.5/lib/pg/connection.rb:707:in `new'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/pg-1.3.5/lib/pg.rb:69:in `connect'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/postgresql_adapter.rb:46:in `postgresql_connection'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:887:in `new_connection'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:931:in `checkout_new_connection'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:910:in `try_to_checkout_new_connection'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:871:in `acquire_connection'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:593:in `checkout'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:437:in `connection'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_adapters/abstract/connection_pool.rb:1119:in `retrieve_connection'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_handling.rb:221:in `retrieve_connection'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/connection_handling.rb:189:in `connection'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/model_schema.rb:488:in `load_schema!'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/attributes.rb:247:in `load_schema!'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/attribute_decorators.rb:50:in `load_schema!'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/model_schema.rb:478:in `block in load_schema'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/model_schema.rb:475:in `synchronize'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/model_schema.rb:475:in `load_schema'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activerecord-6.0.3.7/lib/active_record/model_schema.rb:352:in `columns_hash'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/app/services/graphql_attribute.rb:15:in `required?'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/app/graphql/types/base_object.rb:54:in `nullable?'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/app/graphql/types/base_object.rb:9:in `field'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/app/graphql/types/base_object.rb:14:in `timestamps'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/foreman_puppet-3.0.7/app/graphgl/foreman_puppet/types/environment.rb:8:in `<class:Environment>'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/foreman_puppet-3.0.7/app/graphgl/foreman_puppet/types/environment.rb:3:in `<module:Types>'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/foreman_puppet-3.0.7/app/graphgl/foreman_puppet/types/environment.rb:2:in `<module:ForemanPuppet>'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/foreman_puppet-3.0.7/app/graphgl/foreman_puppet/types/environment.rb:1:in `<top (required)>'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/polyglot-0.3.5/lib/polyglot.rb:65:in `require'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/polyglot-0.3.5/lib/polyglot.rb:65:in `require'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:324:in `block in require'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:291:in `load_dependency'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:324:in `require'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:411:in `block in require_or_load'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:40:in `block in load_interlock'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies/interlock.rb:14:in `block in loading'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/concurrency/share_lock.rb:151:in `exclusive'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies/interlock.rb:13:in `loading'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:40:in `load_interlock'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:389:in `require_or_load'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:367:in `depend_on'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:280:in `require_dependency'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/engine.rb:481:in `block (2 levels) in eager_load!'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/engine.rb:480:in `each'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/engine.rb:480:in `block in eager_load!'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/engine.rb:477:in `each'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/engine.rb:477:in `eager_load!'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/engine.rb:356:in `eager_load!'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/application/finisher.rb:123:in `each'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/application/finisher.rb:123:in `block in <module:Finisher>'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/initializable.rb:32:in `instance_exec'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/initializable.rb:32:in `run'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/config/initializers/0_print_time_spent.rb:45:in `block in run'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/config/initializers/0_print_time_spent.rb:17:in `benchmark'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/config/initializers/0_print_time_spent.rb:45:in `run'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/initializable.rb:61:in `block in run_initializers'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/lib/ruby/2.7.0/tsort.rb:228:in `block in tsort_each'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/lib/ruby/2.7.0/tsort.rb:350:in `block (2 levels) in each_strongly_connected_component'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/lib/ruby/2.7.0/tsort.rb:431:in `each_strongly_connected_component_from'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/lib/ruby/2.7.0/tsort.rb:349:in `block in each_strongly_connected_component'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/lib/ruby/2.7.0/tsort.rb:347:in `each'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/lib/ruby/2.7.0/tsort.rb:347:in `call'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/lib/ruby/2.7.0/tsort.rb:347:in `each_strongly_connected_component'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/lib/ruby/2.7.0/tsort.rb:226:in `tsort_each'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/lib/ruby/2.7.0/tsort.rb:205:in `tsort_each'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/initializable.rb:60:in `run_initializers'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/application.rb:363:in `initialize!'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/railtie.rb:190:in `public_send'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/railtie.rb:190:in `method_missing'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/config/environment.rb:5:in `<top (required)>'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/polyglot-0.3.5/lib/polyglot.rb:65:in `require'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/polyglot-0.3.5/lib/polyglot.rb:65:in `require'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:324:in `block in require'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:291:in `load_dependency'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:324:in `require'
Mär 01 13:59:25 testdev foreman[152593]:         from config.ru:5:in `block in <main>'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/rack-2.2.3/lib/rack/builder.rb:116:in `eval'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/rack-2.2.3/lib/rack/builder.rb:116:in `new_from_string'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/rack-2.2.3/lib/rack/builder.rb:105:in `load_file'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/rack-2.2.3/lib/rack/builder.rb:66:in `parse_file'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/rack-2.2.3/lib/rack/server.rb:349:in `build_app_and_options_from_config'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/rack-2.2.3/lib/rack/server.rb:249:in `app'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/rack-2.2.3/lib/rack/server.rb:422:in `wrapped_app'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/rack-2.2.3/lib/rack/server.rb:312:in `block in start'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/rack-2.2.3/lib/rack/server.rb:379:in `handle_profiling'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/rack-2.2.3/lib/rack/server.rb:311:in `start'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/commands/server/server_command.rb:39:in `start'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/commands/server/server_command.rb:147:in `block in perform'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/commands/server/server_command.rb:138:in `tap'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/commands/server/server_command.rb:138:in `perform'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/thor-1.1.0/lib/thor/command.rb:27:in `run'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/thor-1.1.0/lib/thor/invocation.rb:127:in `invoke_command'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/thor-1.1.0/lib/thor.rb:392:in `dispatch'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/command/base.rb:69:in `perform'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/command.rb:46:in `invoke'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/railties-6.0.3.7/lib/rails/commands.rb:18:in `<top (required)>'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:324:in `require'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:324:in `block in require'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:291:in `load_dependency'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/vendor/ruby/2.7.0/gems/activesupport-6.0.3.7/lib/active_support/dependencies.rb:324:in `require'
Mär 01 13:59:25 testdev foreman[152593]:         from /usr/share/foreman/bin/rails:9:in `<main>'
Mär 01 13:59:25 testdev systemd[1]: foreman.service: Main process exited, code=exited, status=1/FAILURE
-- Subject: Unit process exited
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- An ExecStart= process belonging to unit foreman.service has exited.
--
-- The process' exit code is 'exited' and its exit status is 1.
Mär 01 13:59:25 testdev systemd[1]: foreman.service: Failed with result 'exit-code'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- The unit foreman.service has entered the 'failed' state with result 'exit-code'.
Mär 01 13:59:25 testdev systemd[1]: Failed to start Foreman.
-- Subject: A start job for unit foreman.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- A start job for unit foreman.service has finished with a failure.
--
-- The job identifier is 94659 and the job result is failed.
Mär 01 13:59:25 testdev systemd[1]: Starting Foreman...
-- Subject: A start job for unit foreman.service has begun execution
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- A start job for unit foreman.service has begun execution.

**Foreman and Proxy versions:**foreman 3.2.1 , foreman-proxy 3.2.1

Foreman and Proxy plugin versions:

Distribution and version: Ubuntu 20.04.4 LTS

thank you all

2

I see that there is no Database for foreman!

$ psql
psql (12.12 (Ubuntu 12.12-0ubuntu0.20.04.1))
Type "help" for help.

postgres=# \l
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
 postgres  | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 |
 template0 | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 template1 | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
(3 rows)

How can this happens? we restart the server many times… but we dont delete the database!

Is there a special way how we restart the server for foreman ?

3

Try sudo -u postgres psql ?

To restart services, it’s sudo foreman-maintain service restart

1 Like
4

thanks for your answer @jeremylenz, here is the output:

root@test-dev:/etc/puppetlabs# sudo -u postgres psql
psql (12.12 (Ubuntu 12.12-0ubuntu0.20.04.1))
Type "help" for help.

postgres=# \l
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
 postgres  | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 |
 template0 | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 template1 | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
(3 rows)

postgres=#

The foreman Database is missing! Does anyone know why ?

root@test-dev:~# foreman-maintain service restart
foreman-maintain: command not found
root@test-dev:~# foreman-
foreman-debug          foreman-installer      foreman-prepare-realm  foreman-puma-status    foreman-rake           foreman-ruby           foreman-tail

We use foreman with puppet without Katello… Maybe thats why this command is not available…

5

Postgresql logs:

# cat postgresql-12-main.log | tail
2023-03-02 09:27:49 CET FATAL:  role "foreman" does not exist
2023-03-02 09:27:49 CET FATAL:  role "foreman" does not exist

Simillar issue also after restart!

6 
postgres=# \du
                                   List of roles
 Role name |                         Attributes                         | Member of
-----------+------------------------------------------------------------+-----------
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
7

I have no idea why the Foreman database would be missing. maybe a run of foreman-installer will help?

1 Like
8

Thank @jeremylenz i don’t know also!

But it’s very annoying, I had this also once on production server but before restart the server I create database backup! And I could restore from backup!

I don’t know why foreman do that!

I’ll do that right now… and give here my feedback

9

thank you so much @jeremylenz after run foreman-installer it works again and I can login with my old credential but where was the foreman database?

I run again your command to check the database:

# sudo -u postgres psql
psql (12.14 (Ubuntu 12.14-0ubuntu0.20.04.1))
Type "help" for help.

postgres=# \l
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
 foreman   | foreman  | UTF8     | en_US.utf8  | en_US.utf8  | =T/foreman           +
           |          |          |             |             | foreman=CTc/foreman
 postgres  | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 |
 template0 | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 template1 | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
(4 rows)

So there is the foreman! Do you have any idea why this happens ? thanks again

1 Like
10 
l# foreman-installer
2023-03-02 16:36:32 [NOTICE] [root] Loading installer configuration. This will take some time.
2023-03-02 16:36:39 [NOTICE] [root] Running installer with log based terminal output at level NOTICE.
2023-03-02 16:36:39 [NOTICE] [root] Use -l to set the terminal output log level to ERROR, WARN, NOTICE, INFO, or DEBUG. See --full-help for definitions.
2023-03-02 16:36:42 [NOTICE] [configure] Starting system configuration.
2023-03-02 16:36:55 [NOTICE] [configure] 250 configuration steps out of 1338 steps complete.
2023-03-02 16:36:56 [NOTICE] [configure] 500 configuration steps out of 1340 steps complete.
2023-03-02 16:36:57 [NOTICE] [configure] 750 configuration steps out of 1448 steps complete.
2023-03-02 16:37:03 [NOTICE] [configure] 1000 configuration steps out of 1449 steps complete.
2023-03-02 16:40:57 [NOTICE] [configure] 1250 configuration steps out of 1449 steps complete.
2023-03-02 16:42:29 [NOTICE] [configure] System configuration has finished.
Executing: foreman-rake upgrade:run
  Success!
11

Glad it helped! Did you lose your data?

12

Unfortunately yes I lose all hosts! Is there a way to find them ?

13

You’ll probably have to restore from your backup then. :confused:

14

That mean before restarting the server I have to create backup with foreman-rake right ? It’s very strange! That this happens!