public inbox for [email protected]
help / color / mirror / Atom feedHow 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]>
2024-12-20 08:32 ` Re: How To Configure PostgreSQL to Use LDAP for Authentication Achilleas Mantzios - cloud <[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-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 ` Re: How To Configure PostgreSQL to Use LDAP for Authentication Sam Stearns <[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-06 14:15 How To Configure PostgreSQL to Use LDAP for Authentication Henry Ashu <[email protected]>
2024-12-20 08:32 ` Re: How To Configure PostgreSQL to Use LDAP for Authentication Achilleas Mantzios - cloud <[email protected]>
@ 2024-12-20 15:08 ` Sam Stearns <[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