Re: LDAP Authentication?

Lists: pgsql-hackers
From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: LDAP Authentication?
Date: 2005-10-06 19:56:14
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE92E708@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

People,

After writing dblink-ldap (http://pgfoundry.org/projects/dblink-ldap),
several people have contacted me asking if this will give LDAP
authentication to PostgreSQL, because they need this. And this is before
I've even released it, so apparantly there are a lot of people who want
this.

You can do this today using PAM authenication, but this is not always
possible. Notably it's never possible on Windows, and there are several
unix platforms/distros that don't support it without a lot of work.

It should be fairly easy to write a LDAP "backend" to password
authentication using openldap, winldap or whatever ldap library is
available.

Before I start working on anything I'd like to check if a patch for this
would be accepted?

//Magnus


From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Magnus Hagander" <mha(at)sollentuna(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: LDAP Authentication?
Date: 2005-10-10 11:43:58
Message-ID: 200510101343.58883.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Magnus Hagander wrote:
> You can do this today using PAM authenication, but this is not always
> possible. Notably it's never possible on Windows, and there are
> several unix platforms/distros that don't support it without a lot of
> work.

Or you port PAM to Windows, and then everybody wins.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/


From: Satoshi Nagayasu <nagayasus(at)nttdata(dot)co(dot)jp>
To: Magnus Hagander <mha(at)sollentuna(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: LDAP Authentication?
Date: 2005-10-15 11:02:37
Message-ID: 4350E1CD.3060407@nttdata.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Magnus,

Magnus Hagander wrote:
> It should be fairly easy to write a LDAP "backend" to password
> authentication using openldap, winldap or whatever ldap library is
> available.
>
> Before I start working on anything I'd like to check if a patch for this
> would be accepted?

Also I was thinking about LDAP authentication before.

LDAP is the most important infrastracture for enterprise users
who have the centerized account management.

Samba and Apache have LDAP auth.

Also we need it for PostgreSQL.
--
NAGAYASU Satoshi <nagayasus(at)nttdata(dot)co(dot)jp>


From: Euler Taveira de Oliveira <eulerto(at)yahoo(dot)com(dot)br>
To: Satoshi Nagayasu <nagayasus(at)nttdata(dot)co(dot)jp>, Magnus Hagander <mha(at)sollentuna(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: LDAP Authentication?
Date: 2005-10-31 11:43:35
Message-ID: 20051031114335.73841.qmail@web32714.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

--- Magnus Hagander wrote:

> > It should be fairly easy to write a LDAP "backend" to password
> > authentication using openldap, winldap or whatever ldap library is
> > available.
> >
I support the idea. It would be a good gain for PostgreSQL
authentication.
If you want to discuss ideas, drop me a line.

Euler Taveira de Oliveira
euler[at]yahoo_com_br



_______________________________________________________
Promoção Yahoo! Acesso Grátis: a cada hora navegada você
acumula cupons e concorre a mais de 500 prêmios! Participe!
http://yahoo.fbiz.com.br/


From: "Bruno Almeida do Lago" <teolupus(at)gmail(dot)com>
To: "'Euler Taveira de Oliveira'" <eulerto(at)yahoo(dot)com(dot)br>, "'Satoshi Nagayasu'" <nagayasus(at)nttdata(dot)co(dot)jp>, "'Magnus Hagander'" <mha(at)sollentuna(dot)net>
Cc: "'PostgreSQL-development'" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: LDAP Authentication?
Date: 2005-10-31 13:50:56
Message-ID: 43662144.0da8160d.31a2.382e@mx.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

I can help on this one too.

-----Original Message-----
From: pgsql-hackers-owner(at)postgresql(dot)org
[mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Euler Taveira de
Oliveira
Sent: Monday, October 31, 2005 9:44 AM
To: Satoshi Nagayasu; Magnus Hagander
Cc: PostgreSQL-development
Subject: Re: [HACKERS] LDAP Authentication?

--- Magnus Hagander wrote:

> > It should be fairly easy to write a LDAP "backend" to password
> > authentication using openldap, winldap or whatever ldap library is
> > available.
> >
I support the idea. It would be a good gain for PostgreSQL
authentication.
If you want to discuss ideas, drop me a line.

Euler Taveira de Oliveira
euler[at]yahoo_com_br



_______________________________________________________
Promoção Yahoo! Acesso Grátis: a cada hora navegada você
acumula cupons e concorre a mais de 500 prêmios! Participe!
http://yahoo.fbiz.com.br/

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match