No configuration file found - password authentication failed


#1

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


#2

In case that’s not a typo here but in your configuration file, it’s dsn (as in Data Source Name), not dns. That could be your issue.


#3

I must change my glasses !
The typo was in my config file ,i have been struggling for hours, that was the issue.
Nothing is worth a new eye.
Thanks @iegomez