Обсуждение: Authentication Postgres user via LDAP
Hello guys,
I'm configuring a new server, and I would to authenticate the users via LDAP. We already have systems doing this, like Intranet (Joomla! Framework) and Imap Mail.
So, for tests, I added the following line in the pg_hba.conf (according the Postgres Documentation):
host all "r.domiciano" 172.16.5.20 255.255.255.255 ldap "ldap://172.16.5.1/ou=usuarios,dc=senffnet,dc=intranet;SENFFNET\"
The user "r.domiciano" is already created in the Postgres.
When Trying to connect in the databse via psql, I'm prompted for password, and then for the error message:
psql postgres -h 172.16.5.20 -U "r.domiciano"
psql: FATAL: autenticação do tipo LDAP falhou para usuário "r.domiciano"
psql: FATAL: LDAP authentication failed for user: "r.domiciano"
In the log I get a message saying "error code: 34"... googling a while I get that this is a invalid DN syntax. But i thing the pg_hba.conf is ok.
Has anyone get the same trouble? Helps?
Best Regards,
Rafael Domiciano
I'm configuring a new server, and I would to authenticate the users via LDAP. We already have systems doing this, like Intranet (Joomla! Framework) and Imap Mail.
So, for tests, I added the following line in the pg_hba.conf (according the Postgres Documentation):
host all "r.domiciano" 172.16.5.20 255.255.255.255 ldap "ldap://172.16.5.1/ou=usuarios,dc=senffnet,dc=intranet;SENFFNET\"
The user "r.domiciano" is already created in the Postgres.
When Trying to connect in the databse via psql, I'm prompted for password, and then for the error message:
psql postgres -h 172.16.5.20 -U "r.domiciano"
psql: FATAL: autenticação do tipo LDAP falhou para usuário "r.domiciano"
psql: FATAL: LDAP authentication failed for user: "r.domiciano"
In the log I get a message saying "error code: 34"... googling a while I get that this is a invalid DN syntax. But i thing the pg_hba.conf is ok.
Has anyone get the same trouble? Helps?
Best Regards,
Rafael Domiciano