Re: PostgreSQL and OpenLdap - Mailing list pgsql-general

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"

Cris.


On 2/13/07, Magnus Hagander <magnus@hagander.net> wrote:
> Fisrt, you still have not shown us the output in the server log.  That
> is still where you will see more information about why it's failing.
>
> Second, if that's what you want, you should probably try:
> ldap://ldap.cb.sc.gov.br/dc=cb,dc=sc,dc=gov,dc=br;uid=;ou=users,
>
> Or something along that line.
>
> //Magnus
>
> On Tue, Feb 13, 2007 at 11:49:54AM -0200, Cristiano Panvel wrote:
> > I am not trying thus passed the usuary, and this users does not
> > function is active and functioned in the OpenLdap.
> >
> > ldap ldap://ldap.cb.sc.gov.br/uid=scott,ou=Users,dc=cb,dc=sc,dc=gov,dc=br
> >
> > something is very strange
> >
> > Cris.
> >
> > On 2/13/07, Magnus Hagander <magnus@hagander.net> wrote:
> > >On Mon, Feb 12, 2007 at 09:41:44PM -0200, Cristiano Panvel wrote:
> > >> Thanks Magnus,
> > >>
> > >> Now I am passing the line thus pg_hba.conf
> > >>
> > >> ##
> > >> host    all         all         10.193.4.0/24          ldap
> > >> ldap://ldap.cb.sc.gov.br/dc=cb,dc=sc,dc=gov,dc=br
> > >> ##
> > >>
> > >> However error in login is occurring
> > >>
> > >> % psql postgresql -h server -U scott -W
> > >> psql: FATAL:  LDAP authentication failed for user "scott"
> > >
> > >That's one step further. Now is the time you need to check the server
> > >log.
> > >
> > >> I must pass plus some thing.
> > >>
> > >> My base Ldap:
> > >> dc=cb,dc=sc,dc=gov,dc=br
> > >>
> > >> The Bind:
> > >> ou=Users
> > >
> > >Uh, you want to bind as an OU? That's not really possible? Or do you
> > >mean that your actual bind shuold be as something like
> > >cn=scott,ou=Users,dc=cb,dc=sc,dc=gov,dc=br? If so, try something like
> > >ldap://ldap.cb.sc.gov.br/dc=cb,dc=sc,dc=gov,dc=br;;ou=users,
> > >
> > >(note the double semicolons - the first one is for the prefix, the
> > >second one for suffix)
> > >
> > >But to re-iterate, your server log shuold contain more information about
> > >the problem.
> > >
> > >//Magnus
> > >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: don't forget to increase your free space map settings
>