public inbox for [email protected]help / color / mirror / Atom feed
How To Configure PostgreSQL to Use LDAP for Authentication 3+ messages / 3 participants [nested] [flat]
* How To Configure PostgreSQL to Use LDAP for Authentication @ 2024-12-06 14:15 Henry Ashu <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Henry Ashu @ 2024-12-06 14:15 UTC (permalink / raw) To: [email protected] 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; ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How To Configure PostgreSQL to Use LDAP for Authentication @ 2024-12-20 08:32 Achilleas Mantzios - cloud <[email protected]> parent: Henry Ashu <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Achilleas Mantzios - cloud @ 2024-12-20 08:32 UTC (permalink / raw) To: [email protected] On 12/6/24 16:15, Henry Ashu wrote: > 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 <http://0.0.0.0/0; ldap > ldapserver=ldap://adserver.domain.com <http://adserver.domain.com; > ldapport=389 ldapprefix="DOMAIN\" ldapsuffix="" > [email protected] ldapbindpasswd=mypassword > > > host all all 0.0.0.0/0 <http://0.0.0.0/0; ldap > ldapurl="ldaps://adserver.domain.com:636 > <http://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 <http://0.0.0.0/0; ldap > ldapserver="adserver.domain.com <http://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 Fix your pg_hba.conf, LDAP is the least of your problems. > > Thank you > > *Henry Ashu* > > Database Administrator > *o:* 503.672.5114 | *f:* 800.551.8821 | DAT.com > > DAT Solutions <https://www.dat.com/; Like us on Facebook > <https://www.facebook.com/loadboards; Follow us on Twitter > <https://twitter.com/loadboards; Connect with us on LinkedIn > <https://www.linkedin.com/company/datsolutions; Visit our YouTube > Channel <https://www.youtube.com/datloadboards; Visit us on Instagram > <https://instagram.com/dat_solutions; ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How To Configure PostgreSQL to Use LDAP for Authentication @ 2024-12-20 15:08 Sam Stearns <[email protected]> parent: Achilleas Mantzios - cloud <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Sam Stearns @ 2024-12-20 15:08 UTC (permalink / raw) To: Achilleas Mantzios - cloud <[email protected]>; +Cc: [email protected] Yes, we got this working by formatting the pg_hba.conf entry correctly. Thanks! On Fri, Dec 20, 2024 at 12:33 AM Achilleas Mantzios - cloud < [email protected]> wrote: > On 12/6/24 16: 15, Henry Ashu wrote: 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\" > ZjQcmQRYFpfptBannerStart > This Message Is From an Untrusted Sender > You have not previously corresponded with this sender. > > ZjQcmQRYFpfptBannerEnd > > > On 12/6/24 16:15, Henry Ashu wrote: > > 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 > > Fix your pg_hba.conf, LDAP is the least of your problems. > > 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; > > -- *Samuel Stearns* Lead Database Administrator *c:* 971 762 6879 | *o:* 503 672 5115 | DAT.com [image: DAT] <https://www.dat.com/?utm_medium=email&utm_source=DAT_email_signature_link; ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-12-20 15:08 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-12-06 14:15 How To Configure PostgreSQL to Use LDAP for Authentication Henry Ashu <[email protected]> 2024-12-20 08:32 ` Achilleas Mantzios - cloud <[email protected]> 2024-12-20 15:08 ` Sam Stearns <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox