<html><head></head><body><div class="ydpb9bb1c42yahoo-style-wrap" style="font-family: bookman old style, new york, times, serif; font-size: 16px;"><div></div>
<div>Hi</div><div><br></div><div>Yes I am using pgpool 4.0.2.</div><div>I will try with another version and will let you Know</div><div><br></div><div>Thanks a lot</div><div><br></div><div>Regards</div><div><br></div>
</div><div id="ydpa668019fyahoo_quoted_5917896008" class="ydpa668019fyahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
Le vendredi 21 décembre 2018 à 01:43:26 UTC+1, Takuma Hoshiai <hoshiai@sraoss.co.jp> a écrit :
</div>
<div><br></div>
<div><br></div>
<div><div dir="ltr">Hi,<br clear="none"><br clear="none">Sorry for replying so late.<br clear="none"><br clear="none">On Tue, 18 Dec 2018 14:31:23 +0000 (UTC)<br clear="none">Mouhamadou DIAW <<a shape="rect" href="mailto:diawfr@yahoo.fr" rel="nofollow" target="_blank">diawfr@yahoo.fr</a>> wrote:<br clear="none"><br clear="none">> Dear all<br clear="none">> I am configuring pgpool with pam<br clear="none">> Here is my pool_hba.conf<br clear="none">> [<a shape="rect" href="mailto:root@dbi-pg-tools" rel="nofollow" target="_blank">root@dbi-pg-tools</a> pgpool-II-11]# cat pool_hba.conf | grep -v ^#local all all trust<br clear="none">> host all all 127.0.0.1/32 trusthost all all ::1/128 trusthost all usr1 192.168.22.0/24 md5host all usr2 192.168.22.0/24 pam<br clear="none">> Here is my pg_hba.conf <br clear="none">> [<a shape="rect" href="mailto:root@dbi-pg-essentials" rel="nofollow" target="_blank">root@dbi-pg-essentials</a> data]# cat pg_hba.conf | grep -v ^#local all all peer<br clear="none">> host all all 127.0.0.1/32 identhost all usr1 192.168.22.0/24 md5host all usr2 192.168.22.0/24 pamhost all all ::1/128 identlocal replication all peerhost replication all 127.0.0.1/32 identhost replication all ::1/128 ident<br clear="none">> <br clear="none">> here my pgpool service for the pam<br clear="none">> [<a shape="rect" href="mailto:root@dbi-pg-tools" rel="nofollow" target="_blank">root@dbi-pg-tools</a> pam.d]# cat /etc/pam.d/pgpool#%PAM-1.0auth required pam_permit.soaccount required pam_permit.so[<a shape="rect" href="mailto:root@dbi-pg-tools" rel="nofollow" target="_blank">root@dbi-pg-tools</a> pam.d]#<br clear="none">> <br clear="none">> But when trying to connect using pgpool I have following issue<br clear="none">> [<a shape="rect" href="mailto:postgres@dbi-pg-tools" rel="nofollow" target="_blank">postgres@dbi-pg-tools</a> ~]$ psql -h 192.168.22.100 -U usr2 -d postgres -p 9999psql: ERROR: authenticate_frontend called with PAM[<a shape="rect" href="mailto:postgres@dbi-pg-tools" rel="nofollow" target="_blank">postgres@dbi-pg-tools</a> ~]$<br clear="none"><br clear="none">I think that this is a possibility of a bug.<br clear="none">Do you use Pgpool-II 4.0.2 ? <br clear="none">And if so this problem don't may happend other minor and major versions. <div class="ydpa668019fyqt8388390642" id="ydpa668019fyqtfd70803"><br clear="none"><br clear="none"><br clear="none">> Can you help please<br clear="none">> Regards<br clear="none"><br clear="none">Regards.</div><br clear="none"><br clear="none">-- <br clear="none">Takuma Hoshiai <<a shape="rect" href="mailto:hoshiai@sraoss.co.jp" rel="nofollow" target="_blank">hoshiai@sraoss.co.jp</a><div class="ydpa668019fyqt8388390642" id="ydpa668019fyqtfd30788">><br clear="none"></div></div></div>
</div>
</div></body></html>