Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: LDAP Authen...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 4 Topic 15925 of 17437
Post > Topic >>

Re: LDAP Authentication

by magnus@[EMAIL PROTECTED] (Magnus Hagander) Jun 29, 2008 at 05:58 PM

Taha Ozket wrote:
> Hi,
> 
> I have a ldap group, "pgsql-developers". I have an user (user1) member
> of this group;
> 
> group
> dn: cn=pgsql-developers,ou=Groups,o=Dep,dc=x,dc=x,dc=x
> objectClass: groupOfUniqueNames
> objectClass: top
> cn: SVN Committers
> uniqueMember: uid=user1,ou=Users,o=Dep,dc=x,dc=x,dc=x
> 
> user
> dn: uid=user1,ou=Users,o=Dep,dc=x,dc=x,dc=x
> objectClass: person
> objectClass: top
> objectClass: uidObject
> cn:: Denem1
> sn:: Deneme2
> uid: user1
> userPassword:: e01ENX10WnhudnhscVIxZ1pIa0wzWm5ET3VnPT0=
> 
> I added this line to pg_hba.conf [1]
> 
> host         all         all             172.20.0.0/16         ldap
>
"ldap://localhost/basedn;cn=;,cn=pgsql-developers,ou=Groups,o=Dep,dc=x,dc=x,dc=x"
> 
> But now postgresql requires my user1 must be define under
> cn=pgsql-developers,ou=Groups.. But I want to give login permission to
> pgsql-developers members.
> 
> How can I change this line for give login permission to
> pgsql-developers members?

This is not something you currently can do. We can only do LDAP
authentication, not authorization. There's no way to restrict it to a
particular group.

One way to accomplish what you're trying to do is to have a script that
synchronizes the members of the group to PostgreSQL accounts (account
name and role member****p only), and still use LDAP for authentication.
It doesn't work in every case, but it does work in most.

//Magnus

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 4 Posts in Topic:
LDAP Authentication
tahaozket@[EMAIL PROTECTE  2008-06-29 16:44:01 
Re: LDAP Authentication
magnus@[EMAIL PROTECTED]   2008-06-29 17:58:04 
Re: LDAP Authentication
rpeterso@[EMAIL PROTECTED  2008-07-03 21:17:50 
Re: LDAP Authentication
rpeterso@[EMAIL PROTECTED  2008-07-03 21:31:23 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 15:54:35 CST 2008.