How To Configure PostgreSQL to Use LDAP for Authentication
От | Henry Ashu |
---|---|
Тема | How To Configure PostgreSQL to Use LDAP for Authentication |
Дата | |
Msg-id | CABHPps4FeMPPqm36+SnhW67HKd=f1wcsZGxES6w=Ay6O5YQKNQ@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: How To Configure PostgreSQL to Use LDAP for Authentication
|
Список | pgsql-admin |
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@domain.com 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@domain.com" 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"
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@domain.com" 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
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
В списке pgsql-admin по дате отправления: