<html><head></head><body><div class="ydp5dd37f47yahoo-style-wrap" style="font-family: bookman old style, new york, times, serif; font-size: 16px;"><div></div>
<div>Hi </div><div><br></div><div>It works with the version 3.7.7 (but did not work for 4.0.1)</div><div><br></div><div><span><div style="mso-element:para-border-div;border:solid windowtext 1.0pt;mso-border-alt:solid windowtext .5pt;padding:1.0pt 4.0pt 1.0pt 4.0pt">
<p class="ydpe4de74f4dbiCode"><span lang="FR-CH">[root@dbi-pg-tools pgpool-II]# pgpool -v</span></p>
<p class="ydpe4de74f4dbiCode"><span lang="FR-CH">pgpool-II version 3.7.7 (amefuriboshi)</span></p>
<p class="ydpe4de74f4dbiCode"><span lang="FR-CH">[root@dbi-pg-tools pgpool-II]#</span></p>
</div></span><br></div><div><br></div><div><br></div><div>Thanks for your help</div><div><br></div><div><br></div><div>Regards</div><div><br></div>
</div><div id="ydp4e12e273yahoo_quoted_5879115113" class="ydp4e12e273yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
Le vendredi 21 décembre 2018 à 08:39:32 UTC+1, Mouhamadou DIAW <diawfr@yahoo.fr> a écrit :
</div>
<div><br></div>
<div><br></div>
<div><div id="ydp4e12e273yiv7945231052"><div><div class="ydp4e12e273yiv7945231052ydpb9bb1c42yahoo-style-wrap" style="font-family:bookman old style, new york, times, serif;font-size:16px;"><div></div>
<div>Hi</div><div><br clear="none"></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 clear="none"></div><div>Thanks a lot</div><div><br clear="none"></div><div>Regards</div><div><br clear="none"></div>
</div><div class="ydp4e12e273yiv7945231052ydpa668019fyahoo_quoted" id="ydp4e12e273yiv7945231052ydpa668019fyahoo_quoted_5917896008">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div class="ydp4e12e273yiv7945231052yqt8804717914" id="ydp4e12e273yiv7945231052yqtfd24994"><div>
Le vendredi 21 décembre 2018 à 01:43:26 UTC+1, Takuma Hoshiai <hoshiai@sraoss.co.jp> a écrit :
</div>
<div><br clear="none"></div>
<div><br clear="none"></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="ydp4e12e273yiv7945231052ydpa668019fyqt8388390642" id="ydp4e12e273yiv7945231052ydpa668019fyqtfd70803"><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="ydp4e12e273yiv7945231052ydpa668019fyqt8388390642" id="ydp4e12e273yiv7945231052ydpa668019fyqtfd30788">><br clear="none"></div></div></div>
</div></div><div class="ydp4e12e273yiv7945231052yqt8804717914" id="ydp4e12e273yiv7945231052yqtfd02999">
</div></div></div></div></div>
</div>
</div></body></html>