BUG #18262: Connecting ODI - Mailing list pgsql-bugs
From | PG Bug reporting form |
---|---|
Subject | BUG #18262: Connecting ODI |
Date | |
Msg-id | 18262-3b55fbed91508f98@postgresql.org Whole thread Raw |
Responses |
Re: BUG #18262: Connecting ODI
|
List | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 18262 Logged by: Nuno Rocha Email address: nunompintorocha@gmail.com PostgreSQL version: 15.5 Operating system: Linux Description: ODI connection failed. The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supported by the driver. we have this in one pg_hba file: # TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust # Allow replication connections from localhost, by a user with the # replication privilege. local replication all trust host replication all 127.0.0.1/32 trust host replication all ::1/128 trust host replication replicator 127.0.0.1/32 md5 host replication replicator 10.126.43.194/32 md5 host replication replicator 10.126.43.195/32 md5 host replication replicator 10.126.43.196/32 md5 host all all 0.0.0.0/0 scram-sha-256 host entrepostoisoltst odi 0.0.0.0/0 trust host entrepostoisoltst odi 0.0.0.0/0 trust host ivprd odi_iv 0.0.0.0/0 trust host ivprd odi_iv 0.0.0.0/0 trust But doesn't work, but we can connect at other instance with this pg_hba file: # TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust # Allow replication connections from localhost, by a user with the # replication privilege. local replication all trust host replication all 127.0.0.1/32 trust host replication all ::1/128 trust host replication replicator 127.0.0.1/32 scram-sha-256 host replication replicator 10.147.80.242/32 scram-sha-256 host replication replicator 10.147.80.243/32 scram-sha-256 host replication replicator 10.147.80.244/32 scram-sha-256 host replication replicator 10.147.80.245/32 scram-sha-256 host all all 0.0.0.0/0 scram-sha-256 host entrepostoisoltst odi 0.0.0.0/0 trust host entrepostoisoltst odi 0.0.0.0/0 trust host ivpp odi_ivpp 0.0.0.0/0 trust host ivpp odi_ivpp 0.0.0.0/0 trust Can you help please?
pgsql-bugs by date: