Re: How To Configure PostgreSQL to Use LDAP for Authentication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <a.mantzios@xxxxxxxxxxxxxxxxxxxx> 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=postgres-user@xxxxxxxxxx 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="postgres-user@xxxxxxxxxx" 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

DAT Solutions    Like us on Facebook  Follow us on Twitter  Connect with us on LinkedIn  Visit our YouTube Channel  Visit us on Instagram


--

Samuel Stearns
Lead Database Administrator
c: 971 762 6879 | o: 503 672 5115 | DAT.com

DAT

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux