Authentication failed for user \"appserver\"

[Kev]

Hi All, have setup network server and application server on CentOS 8.

OS: CentOS 8
postgresql: 13
app server: latest (3.14.0) installed from rpm

Gateway and MQTT (mosquitto ) are running on my raspberry pi zero, looks like connections to that are ok.

The application service is running, however I’m getting these errors every 2 seconds:
chirpstack-application-server[290872]: time=“2021-02-01T15:45:52+11:00” level=warning msg=“storage: ping PostgreSQL database error, will retry in 2s” error=“pq: password authentication failed for user “appserver””

I know it’s connecting, because if I change the password it throw an authentication error with the chirpstack_as_events username… then if I get the username correct, it throws an error using the ‘appserver’ username.

It’s as if the appserver user has been hard coded?

Config:
I’ve tried a few combinations under the [postgresql] stanza, and also
under the [application_server.integration.postgresql] stanza.

I’ve tried using the dsn format, and also the format as below

I can confirm I can login as the chirpstack_as_events user, using the password in my dsn.

#[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_as dbname=chirpstack_as sslmode=disable’.

#dsn=“postgres://chirpstack_as:mypassword@localhost/chirpstack_as_events?sslmode=disable”
[application_server.integration.postgresql]

dbname=“chirpstack_as_events”
user=“chirpstack_as_events”
password=“mypassword”
host=“localhost”
sslmode=“disable”
connect_timeout=“5”

How do I fix that error?

Thanks,
Kev

[Kev]

I’ll note I tried changing the user… I changed it from chirpstack_as_events to chirpstack_as_even

Feb 1 16:47:53 servername chirpstack-application-server[4097]: time=“2021-02-01T16:47:53+11:00” level=warning msg=“storage: ping PostgreSQL database error, will retry in 2s” error=“pq: role “chirpstack_as_even” is not permitted to log in”
Feb 1 16:47:56 servername chirpstack-application-server[4097]: time=“2021-02-01T16:47:56+11:00” level=warning msg=“storage: ping PostgreSQL database error, will retry in 2s” error=“pq: role “chirpstack_as_even” is not permitted to log in”
Feb 1 16:47:58 servername chirpstack-application-server[4097]: time=“2021-02-01T16:47:58+11:00” level=warning msg=“storage: ping PostgreSQL database error, will retry in 2s” error=“pq: role “chirpstack_as_even” is not permitted to log in”
Feb 1 16:48:00 servername chirpstack-application-server[4097]: time=“2021-02-01T16:48:00+11:00” level=warning msg=“storage: ping PostgreSQL database error, will retry in 2s” error=“pq: role “chirpstack_as_even” is not permitted to log in”

---

—>>> At this point I changed the config .toml file dsn username from chirpstack_ns_events to chirpstack_ns_even. Ensuring the password matched.
Then I did a systemctl restart chirpstack-application-server.service

The new table was blank, so it did some setup:

Feb 1 16:48:02 servername chirpstack-application-server[4097]: time=“2021-02-01T16:48:02+11:00” level=info msg=“storage: applying PostgreSQL data migrations”
Feb 1 16:48:02 servername chirpstack-application-server[4097]: time=“2021-02-01T16:48:02+11:00” level=info msg=“storage: PostgreSQL data migrations applied” count=0
Feb 1 16:48:02 servername chirpstack-application-server[4097]: time=“2021-02-01T16:48:02+11:00” level=info msg=“integration: configuring global integrations”
Feb 1 16:48:02 servername chirpstack-application-server[4097]: time=“2021-02-01T16:48:02+11:00” level=info msg=“integration/mqtt: TLS config is empty”
Feb 1 16:48:02 servername chirpstack-application-server[4097]: time=“2021-02-01T16:48:02+11:00” level=info msg=“integration/mqtt: connecting to mqtt broker” server=“tcp://192.168.50.76:1883”
Feb 1 16:48:02 servername chirpstack-application-server[4097]: time=“2021-02-01T16:48:02+11:00” level=info msg=“integration/postgresql: connecting to PostgreSQL database”
Feb 1 16:48:02 servername chirpstack-application-server[4097]: time=“2021-02-01T16:48:02+11:00” level=info msg=“integration/mqtt: connected to mqtt broker”
Feb 1 16:48:02 servername chirpstack-application-server[4097]: time=“2021-02-01T16:48:02+11:00” level=info msg=“integration/mqtt: subscribing to tx topic” qos=0 topic=application/+/device/+/command/down

Then it does it again!

Feb 1 16:48:02 servername chirpstack-application-server[4097]: time=“2021-02-01T16:48:02+11:00” level=warning msg=“integration/postgresql: ping PostgreSQL database error, will retry in 2s” error=“pq: password authentication failed for user “appserver””
Feb 1 16:48:04 servername chirpstack-application-server[4097]: time=“2021-02-01T16:48:04+11:00” level=warning msg=“integration/postgresql: ping PostgreSQL database error, will retry in 2s” error=“pq: password authentication failed for user “appserver””
Feb 1 16:48:06 servername chirpstack-application-server[4097]: time=“2021-02-01T16:48:06+11:00” level=warning msg=“integration/postgresql: ping PostgreSQL database error, will retry in 2s” error=“pq: password authentication failed for user “appserver””