Re: pgbouncer configuration

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 <cstephens16(at)gmail(dot)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(dot)albe(at)cybertec(dot)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(at)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(at)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
>>
>>