Re: pgbouncer configuration

On Tue, 2021-04-27 at 19:46 -0500, Chris Stephens wrote:
> I'm trying to run pgbouncer but am having trouble with what looks like a very simple configuration.
> 
> centos 7
> postgres 12
> pgbouncer 1.15
> 
> we are already using pam for database auth. pgbouncer was compiled with --with-pam. there is a /etc/pam.d/pgbouncer
configfile copied from the one currently being used for postgres auth.
 
> 
> i can list the whole config file if needed but i get the following when trying to start pgbouncer up:
> 
> [postgres@lsst-pgsql02 ~]$ pgbouncer  -d /etc/pgbouncer/pgbouncer.ini
> 2021-04-27 19:37:34.256 CDT [10653] ERROR invalid value "pam" for parameter auth_type in configuration
(/etc/pgbouncer/pgbouncer.ini:118)
> 2021-04-27 19:37:34.256 CDT [10653] FATAL cannot load config file
> 
> [postgres@lsst-pgsql02 pgbouncer]$ egrep "auth_type" pgbouncer.ini
> auth_type = pam
> 
> any ideas? 

I'd suspect that pgBouncer is not built with PAM support after all.

Run "ldd" on the executable and see if it links with OpenLDAP.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com