Hi,
i´m trying to install the Chirpstack on Rocky Linux and have again a authentication error with postgresql.
Feb 20 16:54:28 server chirpstack[160646]: Error: Setup PostgreSQL connection pool error
Feb 20 16:54:28 server chirpstack[160646]: Caused by:
Feb 20 16:54:28 server chirpstack[160646]: timed out waiting for connection: FATAL: Ident authentication failed for user “chirpstack”
Feb 20 16:54:28 server chirpstack[160646]:
Feb 20 16:54:28 server systemd[1]: chirpstack.service: Main process exited, code=exited, status=1/FAILURE
Feb 20 16:54:28 server systemd[1]: chirpstack.service: Failed with result ‘exit-code’.
Feb 20 16:54:28 server systemd[1]: chirpstack.service: Scheduled restart job, restart counter is at 1.
Feb 20 16:54:28 server systemd[1]: Stopped ChirpStack open-source LoRaWAN Network Server.
Feb 20 16:54:28 server systemd[1]: Started ChirpStack open-source LoRaWAN Network Server.
Feb 20 16:54:28 server chirpstack[160727]: 2024-02-20T19:54:28.746551Z INFO chirpstack::cmd::root: Starting ChirpStack LoRaWAN Network Server version=“4.6.0” docs=“https://www.chirpstack.io/”
Feb 20 16:54:28 server chirpstack[160727]: 2024-02-20T19:54:28.746625Z INFO chirpstack::storage: Setting up PostgreSQL connection pool
I followed this documentation:
Within the SQL console:
-- create role for authentication
create role chirpstack with login password 'chirpstack';
-- create database
create database chirpstack with owner chirpstack;
-- change to chirpstack database
\c chirpstack
-- create pg_trgm extension
create extension pg_trgm;
-- exit psql
\q
The configuration file has already been checked and is ok.
Is any way to have more logs and know where is the problem?
Thanks for now.