<html><head></head><body><div class="ydp8fd20f69yahoo-style-wrap" style="font-family:bookman old style, new york, times, serif;font-size:16px;"><span><div style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">Dear all</div><div style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><br></div><div style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">I am configuring pgpool with pam</div><div style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><br></div><div style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">Here is my pool_hba.conf</div><div style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><br></div><div style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><div><i>[root@dbi-pg-tools pgpool-II-11]# cat pool_hba.conf | grep -v ^#</i></div><div><i>local all all trust<br></i></div><div><i>host all all 127.0.0.1/32 trust</i></div><div><i>host all all ::1/128 trust</i></div><div><i>host all usr1 192.168.22.0/24 md5</i></div><div><i>host all usr2 192.168.22.0/24 pam</i></div><div><br></div>Here is my pg_hba.conf </div><div style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><br></div><div style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><div>[root@dbi-pg-essentials data]# cat pg_hba.conf | grep -v ^#</div><div>l<i>ocal all all peer<br></i></div><div><i>host all all 127.0.0.1/32 ident</i></div><div><i>host all usr1 192.168.22.0/24 md5</i></div><div><i>host all usr2 192.168.22.0/24 pam</i></div><div><i>host all all ::1/128 ident</i></div><div><i>local replication all peer</i></div><div><i>host replication all 127.0.0.1/32 ident</i></div><div><i>host replication all ::1/128 ident</i></div><div><br></div><br></div><div style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">here my pgpool service for the pam</div><div style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><br></div><div style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><div><i>[root@dbi-pg-tools pam.d]# cat /etc/pam.d/pgpool</i></div><div><i>#%PAM-1.0</i></div><div><i>auth required pam_permit.so</i></div><div><i>account required pam_permit.so</i></div><div><i>[root@dbi-pg-tools pam.d]#</i></div><div><br></div><br></div><div style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">But when trying to connect using pgpool I have following issue</div><div style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><br></div><div style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><div><i>[postgres@dbi-pg-tools ~]$ psql -h 192.168.22.100 -U usr2 -d postgres -p 9999</i></div><div><i><b>psql: ERROR: authenticate_frontend called with PAM</b></i></div><div><i>[postgres@dbi-pg-tools ~]$</i></div><div><br></div><br></div><div style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">Can you help please</div><div style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;"><br></div><div style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif;">Regards</div></span></div></body></html>