Chirpstack Docker image - can't connect to postgres

Setup and configuration
#1

Hi All,

I’m not familiar with docker beyond the intro tutorial. The ChirpStack docker file doesn’t seem to setup the database correctly. I looked through the forum and didn’t find an answer. It looks like the correct commands are in the shell files 001-init-chirpstack_ns.sh etc.

Actions I made to resolve the issue:

pulled latest docker file
removed old containers and volumes

Error messages:
postgresql_1 | FATAL: password authentication failed for user “chirpstack_as”
postgresql_1 | DETAIL: Role “chirpstack_as” does not exist.
postgresql_1 | Connection matched pg_hba.conf line 95: “host all all all md5”
postgresql_1 | FATAL: password authentication failed for user “chirpstack_ns”
postgresql_1 | DETAIL: Role “chirpstack_ns” does not exist.
postgresql_1 | Connection matched pg_hba.conf line 95: “host all all all md5”
chirpstack-network-server_1 | time=“2021-01-18T14:17:52Z” level=warning msg=“storage: ping PostgreSQL database error, will retry in 2s” error=“pq: password authentication failed for user “chirpstack_ns””
postgresql_1 | FATAL: password authentication failed for user “chirpstack_as”
postgresql_1 | DETAIL: Role “chirpstack_as” does not exist.
postgresql_1 | Connection matched pg_hba.conf line 95: “host all all all md5”
chirpstack-application-server_1 | time=“2021-01-18T14:17:53Z” level=warning msg=“storage: ping PostgreSQL database error, will retry in 2s” error=“pq: password authentication failed for user “chirpstack_as””
chirpstack-network-server_1 | time=“2021-01-18T14:17:54Z” level=warning msg=“storage: ping PostgreSQL database error, will retry in 2s” error=“pq: password authentication failed for user “chirpstack_ns””

I’m running MacOS 10.14 and Docker Engine 20.10.2, Compose 1.27.4

#2

Looks like a password issue to me. Can you eyeball where “chirpstack_as” came from?

The username and password set in: /etc/chirpstack-network-server/chirpstack-network-server.toml must match where it was set in the postgresl SQL setup here:

– 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

2 Likes
#3

I am also getting this problem on macOS - could it be a problem with running this docker-compose on macOS? it seems to me that we might not be running the code in the configuration/postgresql/initdb directory, although that might be a red herring

#4

Hi all, just to confirm - I tried using docker-compose up with exactly the same setup on a Linux VM - it didn’t complain at all so I do think this is Mac-specific - I’m going to continue development on the VM - it would be good to know if this can be fixed by changing the Chirpstack repo or if this an issue with docker-compose that can’t be fixed.