Search Postgresql Archives

Re: pgbouncer configuration

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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.albe@xxxxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux