Error msg: ping database error, will retry in 2

Balisteri · September 15, 2017, 1:23pm

Hello All!!

Today I did my first installation of the Lora server and the Lora Application Server and the Lora Server Gateway. Apparently everything is running ok. But the web page does not load and in the log files I see this message.

ubuntu lora-app-server [13835]: time = “2017-09-14T22: 12: 01-03: 00” level = error msg = "ping database error, will retry in 2s: dial tcp: address tcp / lora: unknown port "

My installation is done on top of a proxmox virtual server running ubuntu server 16.04.

Follow the tutorials on the page and I have already seen and reviewed the settings and I can not understand why it is not working.

Could you please help me?

brocaar · September 15, 2017, 1:25pm

ubuntu lora-app-server [13835]: time = “2017-09-14T22: 12: 01-03: 00” level = error msg = "ping database error, will retry in 2s: dial tcp: address tcp / lora: unknown port "

Looks like the --postgres-dsn value is not set correctly. Please see https://docs.loraserver.io/lora-app-server/install/config/

David · September 24, 2017, 12:34am

Something important I noticed is that you cant, even accidentally, insert a ‘#’ to any of your postgreSQL password. If you do, in your config files, it will be recognized as an incorrect config file which has all settings commented after the ‘3’. I received this exact error because of it. I spent so much time debugging it and finally realised it. May be this wont solve your issue, but I am stating it in case.

brocaar · September 25, 2017, 7:36am

I think you can, but you need to escape it E.g. by putting \ in front of it (not tested).

David · September 25, 2017, 7:50am

I did try it in my earlier attempt. But it didn’t work out for me. I didnt bother so much because I had plenty of other characters on the keyboard

Balisteri · September 26, 2017, 9:23am

Hi, first of all thanks for the answers.
I have reviewed my password settings and I have a special character as #.

So I logged in to the loraserver settings and inserted the \ before # by getting ******* \ # **** and still has the same connection error to the database.

Honestly I would not want to have a password with no character # because at my view would be a step back in the security issue of the Lora server.

If someone has any light please provide the solution.

Thank you in advance for a great week.

David · September 28, 2017, 4:28pm

You can have a very strong password without the ‘#’ sign. You can simply refrain from using the # sign. Just use other characters. There are plenty

sokolbiba · October 10, 2017, 9:04am

Hello everyone. I am new to lora server and I am trying to figure out how it works.After the successfull installation of loraserver and lora-app-server I am struggling to start both of them. It seems that they are not able to read the configuration file in /etc/defaults/ directory. I changed the settings as suggested in the https://docs.loraserver.io/loraserver/overview/ .

Please give some help.
Thanks in advance

shixingsun · October 10, 2017, 2:04am

maybe the dausername doesnt match the passwd?

sokolbiba · October 10, 2017, 8:05am

what do you mean by dausername?

shixingsun · October 10, 2017, 8:24am

the db username must match the password

julien · April 8, 2018, 1:35pm

Hello,

the behavior of my LoRa Server & LoRa App Server seems to be not ok according to the log file.
I’m little bit confuse because the status of Servers is active please could you tell me if something is wrong ?

Hereinafter status snapshot:

I have only change PostgreSQL dsn in each respective configuration file:
dsn=“postgres://loraserver_ns:heremyreal_ns_dbpassword@Debian03/loraserver?sslmode=disable”
dsn=“postgres://loraserver_as:heremyreal_as_dbpassword@Debian03/loraserver?sslmode=disable”

FYI I am retrieving the same kind of log with journalctl -u loraserver.

Thank you for your help

brocaar · April 8, 2018, 2:58pm

As you can see, it tries to (re)connect to the database, which raises the error connection refused.

julien · April 8, 2018, 3:08pm

Yes,
so I tried to connect to database manually with ==> psql -h localhost -U loraserver_ns -W loraserver_ns

It works, but by doing snapshot I saw maybe the issue psql (9.4.15) while it’s recommended to use 9.5 isn’t it ?

Just can I follow your instruction to upgrade psql:

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

export DISTRIB_CODENAME=lsb_release -sc
sudo echo “deb http://apt.postgresql.org/pub/repos/apt/ ${DISTRIB_CODENAME}-pgdg main” | sudo tee /etc/apt/sources.list.d/pgdg.list
sudo apt-get update

sudo apt-get install postgresql-9.6

???

Thank you

brocaar · April 8, 2018, 4:49pm

That is not the same hostname as from your configuration:

dsn=“postgres://loraserver_ns:heremyreal_ns_dbpassword@Debian03/loraserver?sslmode=disable”

julien · April 8, 2018, 5:10pm

dsn=“postgres://loraserver_ns:heremyreal_ns_dbpassword@localhost/loraserver_ns?sslmode=disable”

better like this

Ivor · November 27, 2018, 10:01pm

Hi,

i followed the quickstart for docker-compose but i keep getting error when staring the server.

Can somebody help me please.

Ivor · November 27, 2018, 10:38pm

So i added username to postgres dns string and now the message changed:

[postgresql]
dsn=“postgres://loraserver_ns:ivor_ns_dbpassword@localhost/loraserver_ns?sslmode=disable”