Re: pgbouncer with ldap

2019-09-22 Thread Achilleas Mantzios
On 23/9/19 9:10 π.μ., Ayub M wrote: Achilleas, I am struggling with libpam_ldap package install. Does its setup also involves sssd daemon with nss and pam? I am seeing many different ways of dealing with ldap with pam and different modules which I am not familiar with (nscld, sssd etc). If you ha

Re: pgbouncer with ldap

2019-09-16 Thread Achilleas Mantzios
Please dont top-post. On 14/9/19 9:41 π.μ., Ayub M wrote: Yes I did set that, here is how pgbouncer looks like --- -rwsrwsr-x. 1 root root 2087504 Sep 13 00:45 pgbouncer If you had set the same password in the postgresql server for the user and in the pgbouncer local unix user it should wo

Re: pgbouncer with ldap

2019-09-13 Thread Ayub M
Yes I did set that, here is how pgbouncer looks like --- -rwsrwsr-x. 1 root root 2087504 Sep 13 00:45 pgbouncer On Fri, Sep 13, 2019 at 6:50 AM Achilleas Mantzios < ach...@matrix.gatewaynet.com> wrote: > On 13/9/19 10:19 π.μ., Ayub M wrote: > > Stumbled in the first step - PAM authentica

Re: pgbouncer with ldap

2019-09-13 Thread Achilleas Mantzios
On 13/9/19 10:19 π.μ., Ayub M wrote: Stumbled in the first step - PAM authentication via pgbouncer. After compiling pgbouncer with the pam plug-in, I am unable to login into the db - throws PAM error message. Please help. User created with the same password as linux user -- localhost:~$ psql -

Re: pgbouncer with ldap

2019-09-13 Thread Ayub M
Stumbled in the first step - PAM authentication via pgbouncer. After compiling pgbouncer with the pam plug-in, I am unable to login into the db - throws PAM error message. Please help. User created with the same password as linux user -- localhost:~$ psql -h dbhost -p 3306 -U admin -W db1 db1=> cr

Re: pgbouncer with ldap

2019-09-12 Thread Ayub M
Okay, thanks for the response. Unfortunately Aurora does not expose these files or I should say there is no concept of these files in AWS managed Aurora DB service. Anyway I will give a try and let you know. On Thu, Sep 12, 2019 at 1:52 AM Achilleas Mantzios < ach...@matrix.gatewaynet.com> wrote:

Re: pgbouncer with ldap

2019-09-11 Thread Achilleas Mantzios
On 11/9/19 2:47 μ.μ., Ayub M wrote: Achilleas, for this setup to work are changes to postgresql.conf and pg_hba.conf needed? I am trying to implement this for AWS rds Aurora where these files are not accessible. Those files are needed in any case if you work with postgresql. Unfortunately no

Re: pgbouncer with ldap

2019-09-11 Thread Ayub M
Achilleas, for this setup to work are changes to postgresql.conf and pg_hba.conf needed? I am trying to implement this for AWS rds Aurora where these files are not accessible. On Mon, Sep 9, 2019, 6:46 AM Achilleas Mantzios < ach...@matrix.gatewaynet.com> wrote: > On 9/9/19 12:41 μ.μ., Laurenz Al

Re: pgbouncer with ldap

2019-09-09 Thread Ayub M
Thank you Achilleas and Laurenz for the points, will try this out. On Mon, Sep 9, 2019, 6:46 AM Achilleas Mantzios < ach...@matrix.gatewaynet.com> wrote: > On 9/9/19 12:41 μ.μ., Laurenz Albe wrote: > > Christoph Moench-Tegeder wrote: > >>> It has hba and via hba file one can specify ldap connecti

Re: pgbouncer with ldap

2019-09-09 Thread Achilleas Mantzios
On 9/9/19 12:41 μ.μ., Laurenz Albe wrote: Christoph Moench-Tegeder wrote: It has hba and via hba file one can specify ldap connections https://www.postgresql.org/docs/9.3/auth-pg-hba-conf.html https://pgbouncer.github.io/config.html#hba-file-format "Auth-method field: Only methods supported by

Re: pgbouncer with ldap

2019-09-09 Thread Laurenz Albe
Christoph Moench-Tegeder wrote: > > It has hba and via hba file one can specify ldap connections > > > > https://www.postgresql.org/docs/9.3/auth-pg-hba-conf.html > > https://pgbouncer.github.io/config.html#hba-file-format > "Auth-method field: Only methods supported by PgBouncer’s auth_type > ar

Re: pgbouncer with ldap

2019-09-09 Thread Ayub M
It has hba and via hba file one can specify ldap connections https://www.postgresql.org/docs/9.3/auth-pg-hba-conf.html On Mon, Sep 9, 2019, 3:40 AM Christoph Moench-Tegeder wrote: > ## Ayub M (hia...@gmail.com): > > > Hello, I am trying to setup pgbouncer with ldap to conn

Re: pgbouncer with ldap

2019-09-09 Thread Christoph Moench-Tegeder
## Ayub M (hia...@gmail.com): > It has hba and via hba file one can specify ldap connections > > https://www.postgresql.org/docs/9.3/auth-pg-hba-conf.html https://pgbouncer.github.io/config.html#hba-file-format "Auth-method field: Only methods supported by PgBouncer’s auth_type are supported", a

Re: pgbouncer with ldap

2019-09-09 Thread Christoph Moench-Tegeder
## Ayub M (hia...@gmail.com): > Hello, I am trying to setup pgbouncer with ldap to connect with rds > postgres. Downloaded latest version of pbbouncer (1.11) and using hba > auth_type. Getting below error when starting pgbouncer daemon. Am I > missing something? There's no

pgbouncer with ldap

2019-09-09 Thread Ayub M
Hello, I am trying to setup pgbouncer with ldap to connect with rds postgres. Downloaded latest version of pbbouncer (1.11) and using hba auth_type. Getting below error when starting pgbouncer daemon. Am I missing something? [centos@ip-x.x.x.x etc]$ pgbouncer -V PgBouncer version 1.11.0 [centos