[pgpool-general: 6357] Re: Issue : pgpool with PAM
Takuma Hoshiai
hoshiai at sraoss.co.jp
Fri Dec 21 09:43:24 JST 2018
Hi,
Sorry for replying so late.
On Tue, 18 Dec 2018 14:31:23 +0000 (UTC)
Mouhamadou DIAW <diawfr at yahoo.fr> wrote:
> 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 ~]$
I think that this is a possibility of a bug.
Do you use Pgpool-II 4.0.2 ?
And if so this problem don't may happend other minor and major versions.
> Can you help please
> Regards
Regards.
--
Takuma Hoshiai <hoshiai at sraoss.co.jp>
More information about the pgpool-general
mailing list