In chirpstack.toml it looks like this
dsn="postgres://chirpstack:chirpstack@localhost/chirpstack?sslmode=disable"
And then i go:
vboxuser@Ubuntu:~$ sudo -u postgres psql
[sudo] password for vboxuser:
psql (14.9 (Ubuntu 14.9-0ubuntu0.22.04.1))
Type "help" for help.
postgres=# \c chirpstack
You are now connected to database "chirpstack" as user "postgres".
chirpstack=# \du
And get:
List of roles
Role name | Attributes | Member of
------------+------------------------------------------------------------+-----------
chirpstack | | {}
postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
i re-entered password and re-started the chirpstack and got this in the logs:
окт 05 10:50:53 Ubuntu systemd[1]: Started ChirpStack open-source LoRaWAN Network Server.
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.647031Z INFO chirpstack::cmd::root: Starting ChirpStack LoRaWAN Network Server version="4.5.0" docs="https://www.chirpstack.io/"
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.647104Z INFO chirpstack::storage: Setting up PostgreSQL connection pool
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.709666Z INFO chirpstack::storage: Applying schema migrations
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.711786Z INFO chirpstack::storage: Setting up Redis client
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.718860Z INFO chirpstack::region: Setting up regions
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.718950Z INFO setup{common_name=CN779 region_id=cn779}: chirpstack::region: Configuring region
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.719056Z WARN setup{common_name=US915 region_id=us915_4}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'us915_4' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.719085Z WARN setup{common_name=CN470 region_id=cn470_5}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'cn470_5' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.719110Z WARN setup{common_name=CN470 region_id=cn470_7}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'cn470_7' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.719136Z WARN setup{common_name=CN470 region_id=cn470_0}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'cn470_0' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.719161Z INFO setup{common_name=IN865 region_id=in865}: chirpstack::region: Configuring region
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.719219Z INFO setup{common_name=ISM2400 region_id=ism2400}: chirpstack::region: Configuring region
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.719264Z WARN setup{common_name=CN470 region_id=cn470_6}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'cn470_6' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.719289Z INFO setup{common_name=US915 region_id=us915_0}: chirpstack::region: Configuring region
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.719478Z WARN setup{common_name=CN470 region_id=cn470_9}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'cn470_9' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.719505Z WARN setup{common_name=CN470 region_id=cn470_1}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'cn470_1' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.719529Z INFO setup{common_name=AU915 region_id=au915_0}: chirpstack::region: Configuring region
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.719655Z WARN setup{common_name=US915 region_id=us915_2}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'us915_2' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.719681Z WARN setup{common_name=US915 region_id=us915_5}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'us915_5' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.719706Z INFO setup{common_name=AS923_4 region_id=as923_4}: chirpstack::region: Configuring region
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.719758Z WARN setup{common_name=AU915 region_id=au915_2}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'au915_2' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.719783Z WARN setup{common_name=AU915 region_id=au915_4}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'au915_4' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.719809Z INFO setup{common_name=RU864 region_id=ru864}: chirpstack::region: Configuring region
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.719862Z WARN setup{common_name=CN470 region_id=cn470_3}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'cn470_3' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.719887Z WARN setup{common_name=US915 region_id=us915_3}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'us915_3' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.719913Z WARN setup{common_name=AU915 region_id=au915_7}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'au915_7' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.719938Z INFO setup{common_name=AS923 region_id=as923}: chirpstack::region: Configuring region
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.720012Z WARN setup{common_name=CN470 region_id=cn470_2}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'cn470_2' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.720038Z INFO setup{common_name=EU433 region_id=eu433}: chirpstack::region: Configuring region
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.720126Z WARN setup{common_name=US915 region_id=us915_6}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'us915_6' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.720153Z WARN setup{common_name=AU915 region_id=au915_3}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'au915_3' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.720179Z WARN setup{common_name=US915 region_id=us915_7}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'us915_7' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.720204Z INFO setup{common_name=KR920 region_id=kr920}: chirpstack::region: Configuring region
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.720260Z WARN setup{common_name=CN470 region_id=cn470_8}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'cn470_8' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.720286Z INFO setup{common_name=AS923_2 region_id=as923_2}: chirpstack::region: Configuring region
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.720336Z INFO setup{common_name=CN470 region_id=cn470_10}: chirpstack::region: Configuring region
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.720466Z WARN setup{common_name=AU915 region_id=au915_5}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'au915_5' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.720493Z WARN setup{common_name=CN470 region_id=cn470_4}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'cn470_4' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.720519Z INFO setup{common_name=US915 region_id=us915_1}: chirpstack::region: Configuring region
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.720692Z WARN setup{common_name=AU915 region_id=au915_1}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'au915_1' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.720718Z WARN setup{common_name=AU915 region_id=au915_6}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'au915_6' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.720744Z WARN setup{common_name=CN470 region_id=cn470_11}: chirpstack::region: Config exists, but region is not enabled. To enable it, add 'cn470_11' to 'network.enabled_regions'
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.720769Z INFO setup{common_name=AS923_3 region_id=as923_3}: chirpstack::region: Configuring region
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.720819Z INFO setup{common_name=EU868 region_id=eu868}: chirpstack::region: Configuring region
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.720950Z INFO chirpstack::backend::joinserver: Setting up Join Server clients
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.720963Z INFO chirpstack::backend::roaming: Setting up roaming clients
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.720975Z INFO chirpstack::adr: Setting up adr algorithms
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.721023Z INFO chirpstack::integration: Setting up global integrations
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.721035Z INFO chirpstack::integration::redis: Initializing Redis integration
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.721048Z INFO chirpstack::integration::mqtt: Initializing MQTT integration
окт 05 10:50:53 Ubuntu chirpstack[4948]: 2023-10-05T05:50:53.737935Z INFO chirpstack::integration::mqtt: Connecting to MQTT broker server_uri=tcp://localhost:1883/ client_id=afe1127c901f36fb clean_session=false
окт 05 10:50:53 Ubuntu chirpstack[4948]: Error: Setup MQTT integration
окт 05 10:50:53 Ubuntu chirpstack[4948]: Caused by:
окт 05 10:50:53 Ubuntu chirpstack[4948]: 0: Connect to MQTT broker
окт 05 10:50:53 Ubuntu chirpstack[4948]: 1: [-1] TCP/TLS connect failure
окт 05 10:50:53 Ubuntu systemd[1]: chirpstack.service: Main process exited, code=exited, status=1/FAILURE
окт 05 10:50:53 Ubuntu systemd[1]: chirpstack.service: Failed with result 'exit-code'.
окт 05 10:50:54 Ubuntu systemd[1]: chirpstack.service: Scheduled restart job, restart counter is at 5.
окт 05 10:50:54 Ubuntu systemd[1]: Stopped ChirpStack open-source LoRaWAN Network Server.