Im installing for the first time a ChirpStack Server on a Ubuntu VPS that have access to a remote managed PostgreSQL on Digital Ocean. I can access PostgreSQL from the VPS itself but no connection from the ChirpStack.
On my chirpstack.toml config I have:
dsn=“postgresql://DBName:PassWord@RemoteServer:25060/chirpstack?sslmode=require”
using this command sudo journalctl -f -n 100 -u chirpstack
I can see the error
2023-05-23T03:14:35.739193Z INFO chirpstack::storage: Setting up PostgreSQL connection pool
May 22 22:15:05 : Error: Setup PostgreSQL connection pool error
May 22 22:15:05 : Caused by: timed out waiting for connection: connection to server at “RemoteServer” (159.203.101.2), port 25060 failed: certificate could not be obtained: no SSL error reported
Asking for a Certificate. that could not be obtained but the certificate is already installed on the local VPS and I was able to connect using psql.
I have recently seen (and confirmed) an equal issue. Interestingly, from within a Docker environment ChirpStack was able connect to the remote host, but without using Docker it resulted in the above error. I need to investigate this further.
I restored an image of my VM Server prior to install old Chirpstack. Just follow again the installation wiki with 4.4.0 version, modified the poster settings, same results
While it still does not work, I believe the failed: certificate could not be obtained: no SSL error reported error has gone, which is what was fixed in v4.4.0.
The error that you now see is related to the available connection slot. It looks like all slots are consumed already and PostgreSQL reached its limit. Therefore ChirpStack is unable to connect.
You need to look into:
Which other application is consuming these slots
Or if you could increase the number of connection slots
