Обсуждение: BUG #18262: Connecting ODI

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?

PG Bug reporting form <noreply@postgresql.org> writes:
> ODI connection failed.
> The authentication type 10 is not supported.

This indicates that your client library doesn't support SCRAM passwords.
Preferably, fix it by getting an updated library; or if there is none,
you're depending on unmaintained software and should think about switching
to something else.  In the meantime, as a stopgap you could switch back
to an MD5-hashed password for the role being used.

            regards, tom lane