pgbouncer configuration

Started by Chris Stephensalmost 5 years ago4 messagesgeneral

cstephens16@gmail.com

almost 5 years ago

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?

Laurenz Albe

laurenz.albe@cybertec.at

almost 5 years ago

In reply to: Chris Stephens (#1)

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 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

Chris Stephens

cstephens16@gmail.com

almost 5 years ago

In reply to: Laurenz Albe (#2)

Re: pgbouncer configuration

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@cybertec.at>
wrote:

Show quoted text

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

Chris Stephens

cstephens16@gmail.com

almost 5 years ago

In reply to: Chris Stephens (#3)

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@gmail.com>
wrote:

Show quoted text

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@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