[pgpool-general: 8609] Re: PGPOOL SSL setup Issues

[Abhishek 1. Garg (Nokia)]

Below are the details



root at sr-vm-abh-1:/etc/pgpool2# cat pool_passwd

pgpool:TEXTpgpool

postgres:TEXTpostgres

root at sr-vm-abh-1:/etc/pgpool2# pwd

/etc/pgpool2

root at sr-vm-abh-1:/etc/pgpool2#



-----Original Message-----
From: Bo Peng <pengbo at sraoss.co.jp>
Sent: Friday, February 17, 2023 5:53 PM
To: Abhishek 1. Garg (Nokia) <abhishek.1.garg at nokia.com>
Cc: pgpool-general at pgpool.net; Srikant Sharma (Nokia) <srikant.sharma at nokia.com>
Subject: Re: [pgpool-general: 8603] PGPOOL SSL setup Issues



[You don't often get email from pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp>. Learn why this is important at https://aka.ms/LearnAboutSenderIdentification ]



Hi,



> Error:

> 2023-02-15 13:51:38.201: main pid 46946: LOG:  find_primary_node: make_persistent_db_connection_noerror failed on node 1



Pgpool-II uses the user specified in "sr_check_user" to fine the primary node.

Because sr_check_password is empty, Pgpool-II will read the password from pool_passwd file.

Please check if you have set the password correctly in pool_passwd file?



-------------------------

sr_check_user = 'pgpool'

sr_check_password = ''

-------------------------



On Wed, 15 Feb 2023 09:12:52 +0000

"Abhishek 1. Garg (Nokia)" <abhishek.1.garg at nokia.com<mailto:abhishek.1.garg at nokia.com>> wrote:



> Hi Team,

>

> We are facing challenges in our Sandbox environment where we are trying to configure 2 PGPOOL nodes with 2 PostgreSQL servers(with Standby Replication).

> Refer attached conf file and logs.

>

> Error:

> 2023-02-15 13:51:38.201: main pid 46946: LOG:  find_primary_node: make_persistent_db_connection_noerror failed on node 1

>

> Can you please suggest?

>

> P.S. -     This setup works fine when pool_hba.conf is updated with below entries, result shown below

> hostssl all         all         0.0.0.0/0             trust

>

> [cid:image001.png at 01D9414B.C5876E00]

>

> Regards

> Abhishek Garg





--

Bo Peng <pengbo at sraoss.co.jp<mailto:pengbo at sraoss.co.jp>>

SRA OSS LLC

https://www.sraoss.co.jp/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230220/feff29fa/attachment.htm>