Hi Guys
The lora-app-server can’t connect to the to postgres loraserver_as database i have this message
:~$ sudo -u appserver lora-app-server --config /etc/lora-app-server/lora-app-server.toml
INFO[0000] starting LoRa App Server docs="https://www.loraserver.io/" version=2.4.0
INFO[0000] connecting to postgresql
ERRO[0000] ping database error, will retry in 2s: pq: password authentication failed for user "appserver"
ERRO[0002] ping database error, will retry in 2s: pq: password authentication failed for user "appserver"
(same without the Flags --config)
The postgres dns in the config file /etc/lora-app-server/lora-app-server.toml
dns="postgres://loraserver_as:dbpassword@localhost/loraserver_as?sslmode=disable
I verified if the user and database have been setup correctly with
~$ psql -h localhost -U loraserver_as -W loraserver_as
Password for user loraserver_as:
psql (10.6 (Ubuntu 10.6-1.pgdg18.04+1))
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)
Type "help" for help.
loraserver_as=> \q
It’s OK
when I issue the command
~$ sudo -u appserver lora-app-server configfile
I get the screen output with the dns postgres
dsn="postgres://localhost/loraserver_as?sslmode=disable"
I think this is the reason of the malfunction of password authentication.
It looks like the config file in /etc/lora-app-server/ is never loaded
The user and group looks to be right
drwxr-x--- 2 appserver appserver 4096 Nov 30 01:41 lora-app-server
-rw-r----- 1 appserver appserver 9738 Nov 30 00:57 lora-app-server.toml
Thanks to read me, I am in a deadlock
I need help !
Alain
N.B Ubuntu 18.04