LDAP support in pgbouncer

26689 views
1

I am looking for RPM or build instruction for pgbouncer that has LDAP support.
I think GP added that feature, which is not available in the pgbouncer natively.

Can you please help?

Thanks
Dinesh

0

Can you have a look here and let us know any more questions?

https://gpdb.docs.pivotal.io/500Beta/utility_guide/admin_utilities/pgbouncer-ref.html

1

Here is the code:
https://github.com/greenplum-db/gpdb/tree/master/gpAux/extensions/pgbouncer

1

https://github.com/greenplum-db/pgbouncer

0

pgbouncer is a submodule of Greenplum source code. Update it with following command:
git submodule update –init –recursive

0

I was able to find some community AIM ( aws ) and able to start up pgbouncer. Now I am running into LDAP specific issue.

with postgres ( pg_hba.conf) following LDAP string works, but does not work with pgouncer. I need to able to bind with service account and authenticate that way. Does anyone know how do I work around this issue? When I enter the following it get “Bad ldap url format”.

ldap ldapserver=”ldap.jumpcloud.com” ldapport=389 ldaptls=1 ldapbasedn=”ou=Users,o=######,dc=jumpcloud,dc=com”ldapbinddn=”uid=#####,ou=Users,o=#####,dc=jumpcloud,dc=com” ldapbindpasswd=”#####”

On Greenplum doc, the recommended approach is:
“gpdbuser1” “ldap://10.0.0.11:10389/uid=gpdbuser1,ou=users,ou=system”

Thanks.

Write your answer..