Osimis Orthanc PostgreSQL Connection issue

General
1

Hello,

I have an Orthanc JSON configuration file with the following configuration of PostgreSQL:

"PostgreSQL": {
    "EnableIndex" : true,
    "EnableStorage" : false,
    "Host" : "mdm-dev-do-user-3133376-0.b.db.ondigitalocean.com",
    "Port" : 25060,
    "Database" : "orthanc_db",
    "Username" : "doadmin",
}

It’s hosted on DigitalOcean. However when I try to up the server, I get the following error:

PostgreSQL error: FATAL: no pg_hba.conf entry for host “202.65.134.242”, user “doadmin”, database “orthanc_db”, no encryption

The issue is the IP the error message shows, is of my organization, not that of DigitalOcean. The DigitalOcean Host has a domain name, not an IP Address. Is it a Domain Name Resolution issue?

2

I just pinged:

mdm-dev-do-user-3133376-0.b.db.ondigitalocean.com

and is resolves to:

64 bytes from 165.22.214.123: icmp_seq=0 ttl=52 time=150.691 ms
64 bytes from 165.22.214.123: icmp_seq=1 ttl=52 time=149.093 ms
64 bytes from 165.22.214.123: icmp_seq=2 ttl=52 time=148.281 ms

from my PC in Austria.

I would have to read documentation about what that means.

https://www.postgresql.org/docs/current/auth-pg-hba-conf.html