Re: PostgreSQL and OpenLdap - Mailing list pgsql-general

From Magnus Hagander
Subject Re: PostgreSQL and OpenLdap
Date
Msg-id 45D20E33.808@hagander.net
Whole thread Raw
In response to Re: PostgreSQL and OpenLdap  ("Cristiano Panvel" <cristiano.panvel@gmail.com>)
List pgsql-general
Cristiano Panvel wrote:
> It does not appear nothing in log, only in /var/log/message the error
> of failed in login.
>
> Feb 13 12:04:16 fns4 postgres[7055]: [4-1] FATAL:  LDAP authentication
> failed for user "scott"
> Feb 13 12:04:20 fns4 postgres[7056]: [4-1] FATAL:  LDAP authentication
> failed for user "scott"
> Feb 13 12:04:20 fns4 postgres[7057]: [4-1] FATAL:  LDAP authentication
> failed for user "scott"
> Feb 13 12:45:57 fns4 postgres[7216]: [4-1] FATAL:  LDAP authentication
> failed for user "sflo"
> Feb 13 12:46:10 fns4 postgres[7223]: [4-1] FATAL:  LDAP authentication
> failed for user "dbadm"

There definitely should be more than that. Note however that most of
these things are not classified as errors, so they are logged at LOG
level. It may be that you're filtering so you're not showing LOG level
information, or perhaps your syslogd is configured to write them to a
different file.

AFAICS, the only code-path that does not log *why* it rejected the
authentication is the case when the client refuses to send a password.

//Magnus

pgsql-general by date:

Previous
From: Emi Lu
Date:
Subject: Re: Function in psql to Compare two numbers and return the bigger value
Next
From: Tom Lane
Date:
Subject: Re: Having a problem with my stored procedure