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