Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 520C7650E7D for ; Sun, 29 Jun 2008 10:44:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 85846-06 for ; Sun, 29 Jun 2008 10:44:05 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.30]) by postgresql.org (Postfix) with ESMTP id 5CA58650DBC for ; Sun, 29 Jun 2008 10:44:11 -0300 (ADT) Received: by yw-out-2324.google.com with SMTP id 3so533257ywj.73 for ; Sun, 29 Jun 2008 06:44:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type:content-transfer-encoding :content-disposition; bh=+WS35uNUky3mdNBfdsrLy5jLXWKZu5p7G4dq3Fy1U3c=; b=FthnfYBN2rUjGK1/Mse7OyNRylL4xQinTTc8LONwsukGWeijCIibxS+a/yx7E7hdtX yYzFA2PTyY2RtcKkjwiCyImoOe0MdujHuWvCD4sD46pD2susDTc6HV8JQod3f2R6VzlT OhVDdzR22uT/X3LAmZbRdo19bRy79G+Cs6qpw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type :content-transfer-encoding:content-disposition; b=Fh7NaMArEbDH/wxffR3JO/Q1IWhbpWvX1VpnlYWldn6sHrSeRhpFmFyWSHAoHQYxQ5 8GsewCRbdByCidkRnLDXmsuO2KEIs01BWS8cQwZxNLXbqI6vmNMqkihFPUBNmcelPwH5 r3bOJ3zBANJ8aDLK016Lt6s3oYBG9SdNvO1pc= Received: by 10.151.44.15 with SMTP id w15mr6316424ybj.209.1214747041957; Sun, 29 Jun 2008 06:44:01 -0700 (PDT) Received: by 10.151.10.12 with HTTP; Sun, 29 Jun 2008 06:44:01 -0700 (PDT) Message-ID: <6e4906da0806290644q40ab3253p27b83488861f66d2@mail.gmail.com> Date: Sun, 29 Jun 2008 16:44:01 +0300 From: "Taha Ozket" To: pgsql-general@postgresql.org Subject: LDAP Authentication MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.396 tagged_above=0 required=5 tests=AWL=2.396 X-Spam-Level: ** X-Archive-Number: 200806/989 X-Sequence-Number: 134518 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? [1] http://wiki.postgresql.org/wiki/LDAP_Authentication_against_AD