No configuration file found at /config/postal.yml

[DrewNeon]

I've followed all the installation instructions. When executing postal initilize, the following errors occured. Where did I do wrong?

Initializing database
No configuration file found at /config/postal.yml
Only using environment variables for configuration
No secret key was specified in the Postal config file. Using one for just this session
Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)
Couldn't create 'postal' database. Please check your configuration.
rake aborted!
ActiveRecord::ConnectionNotEstablished: Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2) (ActiveRecord::ConnectionNotEstablished)
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/mysql2_adapter.rb:53:in `rescue in new_client'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/mysql2_adapter.rb:43:in `new_client'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/mysql2_adapter.rb:23:in `mysql2_connection'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:656:in `public_send'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:656:in `new_connection'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:700:in `checkout_new_connection'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:679:in `try_to_checkout_new_connection'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:640:in `acquire_connection'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:341:in `checkout'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:181:in `connection'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/abstract/connection_handler.rb:211:in `retrieve_connection'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_handling.rb:313:in `retrieve_connection'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_handling.rb:280:in `connection'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/tasks/mysql_database_tasks.rb:8:in `connection'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/tasks/mysql_database_tasks.rb:21:in `create'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/tasks/database_tasks.rb:122:in `create'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/tasks/database_tasks.rb:184:in `block in create_current'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/tasks/database_tasks.rb:557:in `block (2 levels) in each_current_configuration'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/tasks/database_tasks.rb:554:in `each'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/tasks/database_tasks.rb:554:in `block in each_current_configuration'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/tasks/database_tasks.rb:553:in `each'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/tasks/database_tasks.rb:553:in `each_current_configuration'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/tasks/database_tasks.rb:184:in `create_current'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/railties/databases.rake:45:in `block (2 levels) in <top (required)>'
/usr/local/bundle/gems/rake-13.1.0/exe/rake:27:in `<top (required)>'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/cli/exec.rb:58:in `load'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/cli/exec.rb:58:in `kernel_load'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/cli/exec.rb:23:in `run'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/cli.rb:451:in `exec'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/vendor/thor/lib/thor/command.rb:28:in `run'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/vendor/thor/lib/thor/invocation.rb:127:in `invoke_command'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/vendor/thor/lib/thor.rb:527:in `dispatch'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/cli.rb:34:in `dispatch'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/vendor/thor/lib/thor/base.rb:584:in `start'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/cli.rb:28:in `start'
/usr/local/bundle/gems/bundler-2.5.6/exe/bundle:28:in `block in <top (required)>'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/friendly_errors.rb:117:in `with_friendly_errors'
/usr/local/bundle/gems/bundler-2.5.6/exe/bundle:20:in `<top (required)>'
/opt/postal/app/bin/bundle:108:in `load'
/opt/postal/app/bin/bundle:108:in `<main>'

Caused by:
Mysql2::Error::ConnectionError: Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2) (Mysql2::Error::ConnectionError)
/usr/local/bundle/gems/mysql2-0.5.6/lib/mysql2/client.rb:97:in `connect'
/usr/local/bundle/gems/mysql2-0.5.6/lib/mysql2/client.rb:97:in `initialize'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/mysql2_adapter.rb:44:in `new'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/mysql2_adapter.rb:44:in `new_client'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/mysql2_adapter.rb:23:in `mysql2_connection'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:656:in `public_send'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:656:in `new_connection'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:700:in `checkout_new_connection'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:679:in `try_to_checkout_new_connection'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:640:in `acquire_connection'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:341:in `checkout'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:181:in `connection'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_adapters/abstract/connection_handler.rb:211:in `retrieve_connection'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_handling.rb:313:in `retrieve_connection'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/connection_handling.rb:280:in `connection'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/tasks/mysql_database_tasks.rb:8:in `connection'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/tasks/mysql_database_tasks.rb:21:in `create'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/tasks/database_tasks.rb:122:in `create'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/tasks/database_tasks.rb:184:in `block in create_current'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/tasks/database_tasks.rb:557:in `block (2 levels) in each_current_configuration'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/tasks/database_tasks.rb:554:in `each'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/tasks/database_tasks.rb:554:in `block in each_current_configuration'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/tasks/database_tasks.rb:553:in `each'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/tasks/database_tasks.rb:553:in `each_current_configuration'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/tasks/database_tasks.rb:184:in `create_current'
/usr/local/bundle/gems/activerecord-7.0.8.1/lib/active_record/railties/databases.rake:45:in `block (2 levels) in <top (required)>'
/usr/local/bundle/gems/rake-13.1.0/exe/rake:27:in `<top (required)>'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/cli/exec.rb:58:in `load'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/cli/exec.rb:58:in `kernel_load'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/cli/exec.rb:23:in `run'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/cli.rb:451:in `exec'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/vendor/thor/lib/thor/command.rb:28:in `run'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/vendor/thor/lib/thor/invocation.rb:127:in `invoke_command'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/vendor/thor/lib/thor.rb:527:in `dispatch'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/cli.rb:34:in `dispatch'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/vendor/thor/lib/thor/base.rb:584:in `start'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/cli.rb:28:in `start'
/usr/local/bundle/gems/bundler-2.5.6/exe/bundle:28:in `block in <top (required)>'
/usr/local/bundle/gems/bundler-2.5.6/lib/bundler/friendly_errors.rb:117:in `with_friendly_errors'
/usr/local/bundle/gems/bundler-2.5.6/exe/bundle:20:in `<top (required)>'
/opt/postal/app/bin/bundle:108:in `load'
/opt/postal/app/bin/bundle:108:in `<main>'
Tasks: TOP => db:create
(See full trace by running task with --trace)

[willpower232]

No configuration file found at /config/postal.yml
Only using environment variables for configuration

You have to configure postal either with the config file or the environment variables, which one are you using? did you definitely postal bootstrap as per the documentation? https://docs.postalserver.io/getting-started/installation

[slobodangacesa]

what does ss -lntp | grep :50 say?

[willpower232]

in addition to checking ss output, when you say it won't show up, what do you see in your browser? also did you try caddy or nginx? that would remove the port from the end of the URL

[DrewNeon]

what does ss -lntp | grep :50 say?

This command returns nothing.

in addition to checking ss output, when you say it won't show up, what do you see in your browser? also did you try caddy or nginx? that would remove the port from the end of the URL

The browser keeps trying open https://mail.[mydomain].com:5088 for quite a while, then ends up with ERR_CONNECTION_TIMED_OUT. I haven't run the Caddy container yet. Since I'm trying to change the default port of Postal, I wonder the standard docker command to run Caddy would still reverse to port 5000 or not. If the newly appointed port 5088 can't be accessed directly, will Caddy help?

[willpower232]

This command returns nothing.

Thats interesting because that suggests nothing is using the socket so Postal might not actually be running. Presumably there is nothing weird in postal logs web?

[DrewNeon]

This command returns nothing.

Thats interesting because that suggests nothing is using the socket so Postal might not actually be running. Presumably there is nothing weird in postal logs web?

This command returns nothing.

Thats interesting because that suggests nothing is using the socket so Postal might not actually be running. Presumably there is nothing weird in postal logs web?

The output of this command is too much, guess the following is what you need.

postal-web-1  | Puma starting in single mode...
postal-web-1  | * Puma version: 6.4.2 (ruby 3.2.2-p53) ("The Eagle of Durango")
postal-web-1  | *  Min threads: 5
postal-web-1  | *  Max threads: 5
postal-web-1  | *  Environment: production
postal-web-1  | *          PID: 9
postal-web-1  | bundler: failed to load command: puma (/usr/local/bundle/bin/puma)
postal-web-1  | /usr/local/bundle/gems/puma-6.4.2/lib/puma/binder.rb:334:in `initialize': Address already in use - bind(2) for "127.0.0.1" port 5000 (Errno::EADDRINUSE)
postal-web-1  |         from /usr/local/bundle/gems/puma-6.4.2/lib/puma/binder.rb:334:in `new'
postal-web-1  |         from /usr/local/bundle/gems/puma-6.4.2/lib/puma/binder.rb:334:in `add_tcp_listener'
postal-web-1  |         from /usr/local/bundle/gems/puma-6.4.2/lib/puma/binder.rb:163:in `block in parse'
postal-web-1  |         from /usr/local/bundle/gems/puma-6.4.2/lib/puma/binder.rb:146:in `each'
postal-web-1  |         from /usr/local/bundle/gems/puma-6.4.2/lib/puma/binder.rb:146:in `parse'
postal-web-1  |         from /usr/local/bundle/gems/puma-6.4.2/lib/puma/runner.rb:168:in `load_and_bind'
postal-web-1  |         from /usr/local/bundle/gems/puma-6.4.2/lib/puma/single.rb:44:in `run'
postal-web-1  |         from /usr/local/bundle/gems/puma-6.4.2/lib/puma/launcher.rb:194:in `run'
postal-web-1  |         from /usr/local/bundle/gems/puma-6.4.2/lib/puma/cli.rb:75:in `run'
postal-web-1  |         from /usr/local/bundle/gems/puma-6.4.2/bin/puma:10:in `<top (required)>'
postal-web-1  |         from /usr/local/bundle/bin/puma:25:in `load'
postal-web-1  |         from /usr/local/bundle/bin/puma:25:in `<top (required)>'
postal-web-1  |         from /usr/local/bundle/gems/bundler-2.5.6/lib/bundler/cli/exec.rb:58:in `load'
postal-web-1  |         from /usr/local/bundle/gems/bundler-2.5.6/lib/bundler/cli/exec.rb:58:in `kernel_load'
postal-web-1  |         from /usr/local/bundle/gems/bundler-2.5.6/lib/bundler/cli/exec.rb:23:in `run'
postal-web-1  |         from /usr/local/bundle/gems/bundler-2.5.6/lib/bundler/cli.rb:451:in `exec'
postal-web-1  |         from /usr/local/bundle/gems/bundler-2.5.6/lib/bundler/vendor/thor/lib/thor/command.rb:28:in `run'
postal-web-1  |         from /usr/local/bundle/gems/bundler-2.5.6/lib/bundler/vendor/thor/lib/thor/invocation.rb:127:in `invoke_command'
postal-web-1  |         from /usr/local/bundle/gems/bundler-2.5.6/lib/bundler/vendor/thor/lib/thor.rb:527:in `dispatch'
postal-web-1  |         from /usr/local/bundle/gems/bundler-2.5.6/lib/bundler/cli.rb:34:in `dispatch'
postal-web-1  |         from /usr/local/bundle/gems/bundler-2.5.6/lib/bundler/vendor/thor/lib/thor/base.rb:584:in `start'
postal-web-1  |         from /usr/local/bundle/gems/bundler-2.5.6/lib/bundler/cli.rb:28:in `start'
postal-web-1  |         from /usr/local/bundle/gems/bundler-2.5.6/exe/bundle:28:in `block in <top (required)>'
postal-web-1  |         from /usr/local/bundle/gems/bundler-2.5.6/lib/bundler/friendly_errors.rb:117:in `with_friendly_errors'
postal-web-1  |         from /usr/local/bundle/gems/bundler-2.5.6/exe/bundle:20:in `<top (required)>'
postal-web-1  |         from /opt/postal/app/bin/bundle:108:in `load'
postal-web-1  |         from /opt/postal/app/bin/bundle:108:in `<main>'
postal-web-1  | Loading config from /config/postal.yml
postal-web-1  | Puma starting in single mode...
postal-web-1  | * Puma version: 6.4.2 (ruby 3.2.2-p53) ("The Eagle of Durango")
postal-web-1  | *  Min threads: 5
postal-web-1  | *  Max threads: 5
postal-web-1  | *  Environment: production
postal-web-1  | *          PID: 8
postal-web-1  | * Listening on http://0.0.0.0:5088
postal-web-1  | Use Ctrl-C to stop
postal-web-1  | Loading config from /config/postal.yml
postal-web-1  | Puma starting in single mode...
postal-web-1  | * Puma version: 6.4.2 (ruby 3.2.2-p53) ("The Eagle of Durango")
postal-web-1  | *  Min threads: 5
postal-web-1  | *  Max threads: 5
postal-web-1  | *  Environment: production
postal-web-1  | *          PID: 10
postal-web-1  | * Listening on http://0.0.0.0:5088
postal-web-1  | Use Ctrl-C to stop