Thread: PostgreSQL server: authentication method 10 not supported

PostgreSQL server: authentication method 10 not supported

From
Ram Pratap Maurya
Date:

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.

Re: PostgreSQL server: authentication method 10 not supported

From
Tom Lane
Date:
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