PostgreSQL server: authentication method 10 not supported

Started by Ram Pratap Mauryaover 4 years ago2 messageshackers
Jump to latest
#1Ram Pratap Maurya
ram.maurya@lavainternational.in

Hi Team,

I am facing connectivity issue with PostgreSQL -13 , can you please suggest .

Error coming:

"PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: authentication method 10 not supported in

/var/www/html/myLavaUat/app/webroot/myLavaCronDirect/cron/mylava_stg_arch.php on line 9 "

DB "pg_hba.conf" Conf file setting is as below (172.16.40.32 is my application IP address).

# TYPE DATABASE USER ADDRESS METHOD

# "local" is for Unix domain socket connections only

local all all peer

#local all postgres peer

local all postgres ident

# IPv4 local connections:

host all all 127.0.0.1/32 md5

# IPv6 local connections:

host all all ::1/128 md5

# Allow replication connections from localhost, by a user with the

# replication privilege.

local replication all peer

host replication all 127.0.0.1/32 md5

host replication all ::1/128 md5

host replication replication 192.168.1.133/32 md5

host replication postgres 192.168.1.133/32 trust

host replication replication 192.168.1.138/32 md5

host replication postgres 192.168.1.138/32 trust

host replication replication 172.16.40.30/32 md5

host replication postgres 172.16.40.30/32 trust

host replication postgres 127.0.0.1/32 trust

host all all 0.0.0.0/0 md5

host replication replication 172.16.40.32/32 md5

host replication postgres 172.16.40.32/32 trust

Regards,

Ram Pratap.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Ram Pratap Maurya (#1)
Re: PostgreSQL server: authentication method 10 not supported

Ram Pratap Maurya <ram.maurya@lavainternational.in> writes:

"PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: authentication method 10 not supported in
/var/www/html/myLavaUat/app/webroot/myLavaCronDirect/cron/mylava_stg_arch.php on line 9 "

You need to update your client's libpq to a version that knows about
SCRAM authentication, or else not use a SCRAM-encrypted password.

regards, tom lane