Web UI cannot create new server

[leedave]

I just spun up a new server using
4 GB Memory / 80 GB Disk / 2 CPU Cores / Ubuntu 24.04 (LTS) x64
Standard DB as in (https://docs.postalserver.io/getting-started/installation)[docs]

I managed to get the Web UI working and created

• An IP Pool
• A new organisation
• Added Domain to organisation

Where I'm stuck no is the creation of a new server
As soon as I try, the button of the form switches to the loading animation, but nothing happens.
Checking the browser connections, I see that the server returns a 500 error.

So I ran docker logs on the web container and got this output
2024-08-27 13:34:56 +0000 ERROR POST /org/arcmedia/servers (500) event=request transaction=e95e572b89134cb9bf9b controller=ServersController action=create format=json method=POST path=/org/arcmedia/servers request_id=8c703760-7ff5-4cf9-b08f-4b12a2976e44 ip_address=82.136.67.7 status=500 db_runtime=12.332424999214709 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'

As a non-ruby coder, I don't understand this message. It seems to me as it's some connectivity issue. But generally the DB is working, as required for the Web UI to even work. I assume postal is trying to create further databases in the postal-mariadb container and failing. The DB user is root and therefore should have permissions.

I don't know how I should tackle this problem.

[leedave]

Fixed it, turns out you need to configure the DB again for message_db in /opt/postal/config/postal.yml

I assumed message_db was a queue container (like rabbitMQ)... turns out it is just another mysql/mariadb setup which is used when creating new servers.