We had a functional ChirpStack server integrated with PostgreSQL using MQTT bridge. Recently we have tried to obtain and install encryption and certificate generated from Letsencrypt and provisioned Certbot to renew it.
Proccedure we followed:
For Letsencrypt & Certbot: Certbot - Ubuntufocal Other
Snapcraft overview | Snapcraft documentation
For PostgreSQL: PostgreSQL SSL with Letsencrypt. Tutorial for setting up PostgreSQL… | by Pavel Evstigneev | Medium
Securing Postgres connections using Let's Encrypt certificates | Logan Marchione
For Chirpstack: We took idea from ChirpStack forum: Using secure websockets with Basic Station - ChirpStack Gateway Bridge - ChirpStack Community Forum
Problem: After the the generation of the certificate and configuring all the .conf and .toml files, the ChirpStack UI is not online. PostgreSQL 12 is not active. [error: (code=exited, status=1/FAILURE)]
We are planning to start over the full encryption process. Could you please provide some handy instruction to make the ChirpStack, MQTT, PostgreSQL work together after getting the Keys from Letsencrypt running on Ubuntu 20.04?
Thanks in advance!