Thread: BUG #15690: PostgreSQL integration with AD via LDAP and special characters in the password

The following bug has been logged on the website:

Bug reference:      15690
Logged by:          ashish puneet
Email address:      ashishpuneet@gmail.com
PostgreSQL version: 9.6.6
Operating system:   RHEL 7.4
Description:

Hi Team,

We are  trying to integrate PostgreSQL (9.6.6) with AD (Active directory)
using LDAP and  facing issues with integration and it seems that issue is
because of the special characters that has been used in the password. 
 
Is it a know issue in PostgreSQL? Do we have any fix for this issue? 

Thanks,
Ashish Puneet

Greetings,

* PG Bug reporting form (noreply@postgresql.org) wrote:
> PostgreSQL version: 9.6.6

You should really upgrade to the most recent 9.6 version of PostgreSQL.

> We are  trying to integrate PostgreSQL (9.6.6) with AD (Active directory)
> using LDAP and  facing issues with integration and it seems that issue is
> because of the special characters that has been used in the password.

Can you be more specific regarding exactly what you're seeing?  What
does "special characters" here mean, what's happening?

> Is it a know issue in PostgreSQL? Do we have any fix for this issue?

You might want to consider using Kerberos when integrating with an AD
environment from PostgreSQL, which would certainly avoid this issue.
You can see the PostgreSQL documentation for that here:

https://www.postgresql.org/docs/current/gssapi-auth.html

and I wrote up a blog post to try and help make it easier for people
which covers the Windows AD setup side of things and how you go about
actually getting a keytab and such here:

https://info.crunchydata.com/blog/windows-active-directory-postgresql-gssapi-kerberos-authentication

Thanks!

Stephen