[pgpool-general: 5139] Re: md5 authentication

[David Sisk -X (dsisk - TEKSYSTEMS INC at Cisco)]

I *believe* (although I'm not certain) that you have to configure pgpool -> postgres as trust, and appserver -> pgpool as md5. That's what I've done in my installation here.  There may be other ways...perhaps someone else will chime in.

HTH,

[banner2]



David Sisk
Engineer - Software
dsisk at cisco.com<mailto:dsisk at cisco.com>
Tel:

Cisco Systems, Inc.
7025-6 Kit Creek Road PO Box 14987
RESEARCH TRIANGLE PARK
27709-4987
United States
cisco.com


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif]Think before you print.

This email may contain confidential and privileged material for the sole use of the intended recipient. Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender by reply email and delete all copies of this message.
Please click here<http://www.cisco.com/web/about/doing_business/legal/cri/index.html> for Company Registration Information.


From: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of Avi Weinberg
Sent: Sunday, November 20, 2016 11:38 AM
To: pgpool-general at pgpool.net
Subject: [pgpool-general: 5129] md5 authentication

Hi Experts


I have in both pool_hba.conf and pg_hba.conf authentication method md5.  I have password file pool_passwd defined with user postgres and I also have user password file for postgres ".pgpass".
If I connect using port 5432 all works well

If I connect using port 9999 I'm getting this error

[root at h2-nms pgpool]# psql -Upostgres -h 172.18.255.40 -p9999
psql: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.

If I change pg_hba.conf to trust it works well again.

What am I missing?

Thanks
Avi
IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161122/dad03ae1/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 121724 bytes
Desc: image005.png
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161122/dad03ae1/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.png
Type: image/png
Size: 1469 bytes
Desc: image006.png
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161122/dad03ae1/attachment-0003.png>