I had to install pam-devel before reinstalling pgbouncer. appears to be working now. thanks for pointing me in the right direction Laurenz!
On Wed, Apr 28, 2021 at 7:09 AM Chris Stephens <cstephen...@gmail.com> wrote: > huh. you are right. i originally installed pgbouncer with yum but removed > with just "yum remove pgbouncer" before following "Building from Git" > section at http://www.pgbouncer.org/install.html. > > i just ran "make uninstall" -> reinstalled with > > 403 21-04-28 06:58:32 git submodule init > 404 21-04-28 06:58:36 git submodule update > 405 21-04-28 06:58:45 ./autogen.sh > 406 21-04-28 06:59:23 ./configure --with-pam --with-systemd > 407 21-04-28 07:02:11 make > 408 21-04-28 07:02:16 make install > > but it still looks like no ldap or pam and same error when starting up. > any suggestions on how to completely remove and reinstall with support for > pam? > > > > On Wed, Apr 28, 2021 at 1:51 AM Laurenz Albe <laurenz.a...@cybertec.at> > wrote: > >> 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 config file 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 >> >>
