[pgpool-general: 6353] Issue : pgpool with PAM
Mouhamadou DIAW
diawfr at yahoo.fr
Tue Dec 18 23:31:23 JST 2018
Dear all
I am configuring pgpool with pam
Here is my pool_hba.conf
[root at dbi-pg-tools pgpool-II-11]# cat pool_hba.conf | grep -v ^#local all all trust
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
Here is my pg_hba.conf
[root at dbi-pg-essentials data]# cat pg_hba.conf | grep -v ^#local all all peer
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
here my pgpool service for the pam
[root at dbi-pg-tools pam.d]# cat /etc/pam.d/pgpool#%PAM-1.0auth required pam_permit.soaccount required pam_permit.so[root at dbi-pg-tools pam.d]#
But when trying to connect using pgpool I have following issue
[postgres at dbi-pg-tools ~]$ psql -h 192.168.22.100 -U usr2 -d postgres -p 9999psql: ERROR: authenticate_frontend called with PAM[postgres at dbi-pg-tools ~]$
Can you help please
Regards
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20181218/bc90fe37/attachment.htm>
More information about the pgpool-general
mailing list