[pgpool-general: 7116] Re: postgres db login via pgpool using PAM (on *nix OS)

[Bo Peng]

Hi,

On Thu, 25 Jun 2020 07:47:56 -0600
orafin at xmission.com wrote:

> Oh pgpool masters!
> 
> Scenario:
> 
> Want to log into 11.X postpgres db using uname and pword setup in db,  
> using pgpool 4.X.
> I think I need to use PAM in pool_hba.conf.  Believe I have setup pgpool.conf,
> pool_hba.conf and pgpool file in /etc/pam.d correctly.
> 
>  From a remote machine host2, I do:
> 
> psql -h host1 -d dbname -U default_pgpool_software_owner_in_docs -p  
> default_port_in_docs
> 
> I get
> 
> plsql.bin error authentication failed
> detail ldap authentication failed for user  
> default_pgpool_software_owner_in_docs

Could you share the pgpool.log?
I want to check the error messages.
 
> I want PAM to send the pword to db when it creates the backend  
> connection and it's not working.
> 
> ps -ef shows a number of pgpool processes waiting.
> 
> Suggestions/examples where to start (have read docs already).  Not  
> much in google.
> 
> TIA
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan