Unable to create server after creating organization

[rinorbytyci]

Hi,

After successfully creating an organization in the admin panel, i am unable to create a Server for said organization. Checking docker logs i see the following issue:

[30/Apr/2024:14:21:10 +0000] "GET /org/demo-2/servers/new HTTP/1.0" 200 - 0.0304
2024-04-30 14:21:12 +0000 ERROR  POST /org/demo-2/servers (500) event=request transaction=764394125073bc1b5b23 controller=ServersController action=create format=json method=POST path=/org/demo-2/servers request_id=765233d8-9c34-4cc6-9334-01ca9f7120a2 ip_address=162.158.*.* status=500 db_runtime=9.147994995117188 exception_class=NoMethodError exception_message=undefined method `query' for nil:NilClass exception_backtrace=/opt/postal/app/lib/postal/message_db/database.rb:326:in `query_on_connection'\n/opt/postal/app/lib/postal/message_db/database.rb:318:in `block in query'\n/opt/postal/app/lib/postal/message_db/connection_pool.rb:20:in `use'\n/opt/postal/app/lib/postal/message_db/database.rb:345:in `with_mysql'

Any ideas?

[willpower232]

It looks a little like a temporary connection issue, are you able to try again?

[rinorbytyci]

Hello, yes I've tried restarting the server multiple times, everything else in the dashboard works except for creating the Server

[willpower232]

How have you configured your Postal? with the config file or environment variables? It is possible to configure the connections for the main database and the message databases separately so you need to be sure you've filled both in with valid details.

[rinorbytyci]

I've configured it with the /opt/postal/config/postal.yml file (as per the guide), I don't see there two different db connection string?

[willpower232]

There is a section called main_db and another called message_db

postal/doc/config/yaml.yml

Lines 53 to 81 in d510499

	main_db:
	# Hostname for the main MariaDB server
	host: localhost
	# The MariaDB port to connect to
	port: 3306
	# The MariaDB username
	username: postal
	# The MariaDB password
	password:
	# The MariaDB database name
	database: postal
	# The maximum size of the MariaDB connection pool
	pool_size: 5
	# The encoding to use when connecting to the MariaDB database
	encoding: utf8mb4
	message_db:
	# Hostname for the MariaDB server which stores the mail server databases
	host: localhost
	# The MariaDB port to connect to
	port: 3306
	# The MariaDB username
	username: postal
	# The MariaDB password
	password:
	# The encoding to use when connecting to the MariaDB database
	encoding: utf8mb4
	# The MariaDB prefix to add to database names
	database_name_prefix: postal

[rinorbytyci]

Well, i indeed forgot that part. Thank you!

[willpower232]

Glad to hear that fixed it, probably explains a few other nils people have seen over the years