public inbox for [email protected]
help / color / mirror / Atom feedFrom: Henry Ashu <[email protected]>
To: [email protected]
Subject: How To Configure PostgreSQL to Use LDAP for Authentication
Date: Fri, 6 Dec 2024 06:15:31 -0800
Message-ID: <CABHPps4FeMPPqm36+SnhW67HKd=f1wcsZGxES6w=Ay6O5YQKNQ@mail.gmail.com> (raw)
Hi,
Please, I need help with how to configure postgresql to use LDAP for
Authentication.
*Here is what I have tried;*
host all all 0.0.0.0/0 ldap ldapserver=ldap://adserver.domain.com
ldapport=389 ldapprefix="DOMAIN\" ldapsuffix="" ldapbinddn=
[email protected] ldapbindpasswd=mypassword
host all all 0.0.0.0/0 ldap
ldapurl="ldaps://adserver.domain.com:636" ldapbasedn="OU=Users,OU=England
053,OU=Commercial Services,DC=domain,DC=com" ldapbinddn="
[email protected]" ldapbindpasswd="mypassword"
ldapsearchattribute="OU=Users,OU=England 053,OU=Commercial
Services,DC=domain,DC=com"
host all all 0.0.0.0/0 ldap
ldapserver="adserver.domain.com" ldapport=636 ldapscheme="ldaps"
ldapbasedn="OU=Users,OU=England 053,OU=Commercial
Services,DC=domain,DC=com" ldapbinddn="OU=Users,OU=England
053,OU=Commercial Services,DC=domain,DC=com"
ldapbindpasswd="mypassword" ldapsearchattribute="adservice-account"
*And this is the error I'm getting;*
[postgres@myserver ~]$ psql -U myuser mydatabase
psql: error: connection to server on socket "/run/postgresql/.s.PGSQL.5432"
failed: FATAL: no pg_hba.conf entry for host "[local]", user "myuser",
database "mydatabase", no encryption
[postgres@myserver ~]$ psql -U "MYDOMAIN\myuser" mydatabase
psql: error: connection to server on socket "/run/postgresql/.s.PGSQL.5432"
failed: FATAL: no pg_hba.conf entry for host "[local]", user
"MYDOMAIN\myuser", database "mydatabase", no encryption
Thank you
*Henry Ashu*
Database Administrator
*o:* 503.672.5114 | *f:* 800.551.8821 | DAT.com
[image: DAT Solutions] <https://www.dat.com/; [image: Like us on
Facebook] <https://www.facebook.com/loadboards; [image: Follow us on
Twitter] <https://twitter.com/loadboards; [image: Connect with us on
LinkedIn] <https://www.linkedin.com/company/datsolutions; [image: Visit
our YouTube Channel] <https://www.youtube.com/datloadboards; [image: Visit
us on Instagram] <https://instagram.com/dat_solutions;
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: How To Configure PostgreSQL to Use LDAP for Authentication
In-Reply-To: <CABHPps4FeMPPqm36+SnhW67HKd=f1wcsZGxES6w=Ay6O5YQKNQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox