[pgpool-general: 4857] Pgpool2:Virtual IP not authenticating genuine Users

[Kanak Upadhyay]

Hi,

[cid:image001.png at 01D1ED83.5C568DD0][cid:image002.png at 01D1ED83.5C568DD0]      Delegate IP


                postDB(0)   watchdog enabled            postDB(1)
                master                                                  standby
                pgpool1                                                pgpool2


I have created pool_passwd for md5 authentication. So that client connections from genuine IP that are present in pool_hba.conf should only connect through the virtual IP .
But it is not so. Any random IP is able to access the database by the connection string:
Even in pool_hba configuration there is no entry of the IP's

psql -h delegate_IP -p 9999 -U postgres

Can You please suggest what is wrong with the configuration.






Thanks and Regards,
Kanak Upadhyay
Xavient Information Systems

***DISCLAIMER*** This communication & accompanying documents ("this e-mail") contains confidential and/or privileged information for exclusive use of the individual to whom it is addressed. If you are not the intended recipient, please immediately notify the company & delete this e-mail. Any unauthorized use or disclosure of this e-mail is strictly prohibited. Representations in this e-mail are subject to contract. As an e-mail user please be cautious of the technical & other vulnerabilities of the internet which may result in malicious and/or unauthorized access to / use / alteration of e-mails/e-mail IDs. Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160803/fe19764a/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 470 bytes
Desc: image001.png
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160803/fe19764a/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 479 bytes
Desc: image002.png
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160803/fe19764a/attachment-0003.png>