brocaar
commented
2 years ago As I mentioned in my response to one of your other issues, please see https://github.com/brocaar/chirpstack-docker for a working Compose environment.
Closed sergorl closed 2 years ago
brocaar
commented
2 years ago As I mentioned in my response to one of your other issues, please see https://github.com/brocaar/chirpstack-docker for a working Compose environment.
What happened?
No connection with
Postgres db:chirpstack-network-server_1 | time="2022-04-18T14:57:00.743578041Z" level=warning msg="storage: ping PostgreSQL database error, will retry in 2s" error="dial tcp 127.0.0.1:5432: connect: connection refused"What did you expect?
Successfull connection with
Postfres db.Steps to reproduce this issue
Steps:
-- create the chirpstack_ns user with password 'dbpassword' create role chirpstack_ns with login password 'dbpassword';
-- create the chirpstack_ns database create database chirpstack_ns with owner chirpstack_ns;
-- exit the prompt \q
psql -h localhost -U chirpstack_ns -W chirpstack_ns
Password: psql (12.9 (Ubuntu 12.9-0ubuntu0.20.04.1)) SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off) Type "help" for help.
This configuration configures ChirpStack Network Server for the EU868 band using a MQTT
broker to communicate with the gateways. Many options and defaults have been
omitted for simplicity.
#
For other bands, see the ./examples/ sub-directory.
#
See https://www.chirpstack.io/network-server/install/config/ for a full
configuration example and documentation.
PostgreSQL settings.
#
Please note that PostgreSQL 9.5+ is required.
[postgresql]
PostgreSQL dsn (e.g.: postgres://user:password@hostname/database?sslmode=disable).
#
Besides using an URL (e.g. 'postgres://user:password@hostname/database?sslmode=disable')
it is also possible to use the following format:
'user=chirpstack_ns dbname=chirpstack_ns sslmode=disable'.
#
The following connection parameters are supported:
#
* dbname - The name of the database to connect to
* user - The user to sign in as
* password - The user's password
host="127.0.0.1"
port=5432
* host - The host to connect to. Values that start with / are for unix domain sockets. (default is localhost)
* port - The port to bind to. (default is 5432)
* sslmode - Whether or not to use SSL (default is require, this is not the default for libpq)
* fallback_application_name - An application_name to fall back to if one isn't provided.
* connect_timeout - Maximum wait for connection, in seconds. Zero or not specified means wait indefinitely.
* sslcert - Cert file location. The file must contain PEM encoded data.
* sslkey - Key file location. The file must contain PEM encoded data.
* sslrootcert - The location of the root certificate file. The file must contain PEM encoded data.
#
Valid values for sslmode are:
#
* disable - No SSL
* require - Always SSL (skip verification)
* verify-ca - Always SSL (verify that the certificate presented by the server was signed by a trusted CA)
* verify-full - Always SSL (verify that the certification presented by the server was signed by a trusted CA and the server host name matches the one in the certificate)
dsn="postgres://localhost/chirpstack_ns_ns?sslmode=disable"
dsn="postgres://chirpstack_ns:dbpassword@localhost/chirpstack_ns?sslmode=disable"
Redis settings
#
Please note that Redis 2.6.0+ is required.
[redis]
Redis url (e.g. redis://user:password@hostname/0)
#
For more information about the Redis URL format, see:
https://www.iana.org/assignments/uri-schemes/prov/redis
url="redis://localhost:6379"
Network-server settings.
[network_server]
Network identifier (NetID, 3 bytes) encoded as HEX (e.g. 010203)
net_id="000000"
LoRaWAN regional band configuration.
#
Note that you might want to consult the LoRaWAN Regional Parameters
specification for valid values that apply to your region.
See: https://www.lora-alliance.org/lorawan-for-developers
[network_server.band] name="EU868"
LoRaWAN network related settings.
[network_server.network_settings]
Network-server API
#
This is the network-server API that is used by ChirpStack Application Server or other
custom components interacting with ChirpStack Network Server.
[network_server.api]
ip:port to bind the api server
bind="127.0.0.1:8000"
Backend defines the gateway backend settings.
#
The gateway backend handles the communication with the gateway(s) part of
the LoRaWAN network.
[network_server.gateway.backend]
Backend
type="mqtt"
Metrics collection settings.
[metrics]
Timezone
#
The timezone is used for correctly aggregating the metrics (e.g. per hour,
day or month).
Example: "Europe/Amsterdam" or "Local" for the the system's local time zone.
timezone="Local"
Join-server settings.
[join_server]
Default join-server settings.
#
This join-server will be used when resolving the JoinEUI is set to false
or as a fallback when resolving the JoinEUI fails.
[join_server.default]
hostname:port of the default join-server
#
This API is provided by ChirpStack Application Server.
server="http://localhost:8003"
Your Environment