Active Directory authentication for PostgreSQL users

 2020-10-12

It is easy, you just need to add to the configuration file /var/lib/postgresql/data/pg_hba.conf

host all all 0.0.0.0/0 ldap ldapserver="myldapserver" ldapbasedn="OU=USERS,DC=group,DC=redaelli,DC=org" ldapbinddn="CN=matteo,OU=USERS,DC=group,DC=redaelli,DC=org" ldapbindpasswd="MySillyPwd" ldapsearchattribute="sAMAccountName" ldapscheme="ldaps"

And inside your database yu need to create a role for the Active director users and then grant them to the required databases.

 Tags: #active directory #ldap #postgres

Share on the Fediverse

Enter your instance's address

Cancel Share

LDAP search examples from command line

 2020-10-12 |  #active directory #command line #ldap

setup In these examples I use kerberos authentication but you could also use basic authentication with -D and -w options For semplicity I put common options into the environment and I have created an alias

Continue reading 

Using a GraphQL gateway for backend services (Active Directory, AWS and Qliksense Api samples)

 2020-10-11 |  #active directory #aws #clojure #graphQL #ldap #qliksense #web service

Complex web sites read and write data from/to several backend systems using different interfaces (sql, soap , rest, rpc,..). But it could be simpler and useful to create a single endpoint and interface for all the backends.

Continue reading 

MR70

Active Directory authentication for PostgreSQL users

Enter your instance's address

More posts like this

LDAP search examples from command line

Using a GraphQL gateway for backend services (Active Directory, AWS and Qliksense Api samples)