need help understanding the error-message: Error Connecting to database FATAL : no pg_hba.conf entry
0
votes
2
answers
10318
views
We're trying to connect to a postgres/postgis installation on a remote server, using QGIS-Application. When accessing from another pc or from the same pc via pgadmin4v4 with the same credential/authentification settings, it works just fine. Therefore I conclude the pg_hba.conf is ok and it's in fact a problem of QGIS.
In order to better understand the problem and maybe file a bug for QGIS I need help analysing the error message. It sais:
Area: dbname = , host , port 5432, user , password , authcfg =
SSL error: certificate verify failed
FATAL: no pg_hba.conf entry for host , user , database , SSL off
My main questions:
1. shouldn't the host-ip addresses be identical? Could it be part of the problem, that the second ip mentioned is not the correct server-ip? As far as I can see, there should be only one host (remote server) and one client involved (pc trying to get access).
2. why doesn't it say "no pg_hba.conf entry for **client** ..."
3. does QGIS think is it is a certificate problem, or a pg_hba.conf problem, or is that both the same
*Update: further Details about the installation*
- Client-PC1: Win10, QGIS 3.4 [error] pgAdmin 4v4 [access ok]
- Client-PC2: Win10, QGIS 3.10 [access ok] pgAdmin 4v4 [access ok]
- Server: postgres 12
- pg_hba.conf:
# Database administrative login by Unix domain socket
local all postgres peer
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 0.0.0.0/0 scram-sha-256
# IPv6 local connections:
hostssl all all ::0/0 scram-sha-256
Asked by xof
(35 rep)
Apr 8, 2020, 08:42 AM
Last activity: Apr 8, 2020, 04:32 PM
Last activity: Apr 8, 2020, 04:32 PM