Error, will retry in 2s: pq: password authentication failed for user “loraserver”"

Setup and configuration
3

Hey iegomez,

Thanks for you reply!

Here is what I set (exactly the same as the setup procedure)

create role loraserver_as with login password ‘dbpassword’;
create role loraserver_ns with login password ‘dbpassword’;

create database loraserver_as with owner loraserver_as;
create database loraserver_ns with owner loraserver_ns;

– exit psql
\q

Here is what I set for postgresql dsn /etc/default/loraserver.

#postgresql dsn (e.g.: postgres://user:password@hostname/database?sslmode=disable)**
postgres://loraserver_ns:dbpassword@localhost/loraserver?sslmode=disable

root@lora-server:~# journalctl -u loraserver -f
– Logs begin at Sat 2017-10-21 09:31:17 UTC. –
Oct 21 13:14:48 lora-server systemd[1]: loraserver.service: Ignoring invalid environment assignment ‘postgres://loraserver_ns:dbpassword@localhost/loraserver?sslmode=disable’: /etc/default/loraserver
Oct 21 13:14:48 lora-server systemd[1]: Started LoRa Server.
Oct 21 13:14:48 lora-server loraserver[14560]: time=“2017-10-21T13:14:48Z” level=info msg=“starting LoRa Server” band=“EU_863_870” docs=“https://docs.loraserver.io/” net_id=010203 version=0.21.0
Oct 21 13:14:48 lora-server loraserver[14560]: time=“2017-10-21T13:14:48Z” level=info msg=“setup redis connection pool” url=“redis://localhost:6379”
Oct 21 13:14:48 lora-server loraserver[14560]: time=“2017-10-21T13:14:48Z” level=info msg=“connecting to postgresql”
Oct 21 13:14:48 lora-server loraserver[14560]: time=“2017-10-21T13:14:48Z” level=error msg=“ping database error, will retry in 2s: pq: password authentication failed for user “loraserver””
…
…

I’m starting to think I need to replace localhost for cloud server IP?

Many thanks in advance for you reply iegomez!
Leon