Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jJad0-0004NK-HC for pgsql-admin@arkaria.postgresql.org; Wed, 01 Apr 2020 10:29:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jJacz-0006f7-BR for pgsql-admin@arkaria.postgresql.org; Wed, 01 Apr 2020 10:29:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jJacy-0006ez-U2 for pgsql-admin@lists.postgresql.org; Wed, 01 Apr 2020 10:29:45 +0000 Received: from cloudearth.serversfarm.com ([216.244.65.90]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jJacw-0003OX-H5 for pgsql-admin@postgresql.org; Wed, 01 Apr 2020 10:29:43 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=ibosstech-us.com; s=x; h=Content-Type:Mime-Version:Reply-To:Message-Id:Date :Subject:To:From:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:Resent-Date:Resent-From:Resent-Sender:Resent-To:Resent-Cc :Resent-Message-ID:In-Reply-To:References:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=GZvt3qCV1kWQ4bwTqqVxohrRvf4HVbmaF/EretrQWlw=; b=PRxrBvxnQjsDc9hxx5Ut1O/bKR qUS+We1d2QLLxZaie7ZZfdjNWu1HHqMFLPZff2kbz5stpLCdMNfa4a7QAd21FFDXjExMtL1VXguAo ADmXnrhyRB8FkEKnmE4+F1KbER5TnbrVptKzUtynE+T6g5sMdOzJwGd6qxfBDgDld4zQTnlWYDR9a DHJm785wMuFr1iGyMPVWV/IEVeUpRw/0PK6RbocxdduskC3tMUnA36cPzFZwVo4UkZJlxHaIMqhpE yaEupz1OvvP3RA6Z2zEM1ezg2nAYl8cnGypihpLTdUzCDIKtjfYTIdJHxh0hN4FQHzLvgC12twMkK aix8oDVA==; Received: from [111.93.60.54] (helo=[192.168.20.105]) by cloudearth.serversfarm.com with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.93.0.4) (envelope-from ) id 1jJacu-005IjQ-42 for pgsql-admin@postgresql.org; Wed, 01 Apr 2020 06:29:40 -0400 From: "Anjul Tyagi" To: pgsql-admin Subject: LDAP Configuration Date: Wed, 01 Apr 2020 10:29:35 +0000 Message-Id: Reply-To: "Anjul Tyagi" X-Priority: 1 (highest) Importance: high User-Agent: eM_Client/7.2.37929.0 Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="------=_MBDF943FCB-FA36-40D6-8868-8877BE4781D8" X-Authenticated-Id: anjul@ibosstech-us.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --------=_MBDF943FCB-FA36-40D6-8868-8877BE4781D8 Content-Type: text/plain; format=flowed; charset=utf-8 Content-Transfer-Encoding: quoted-printable Team, we are implementing the LDAP authentication and we are able to connect=20 with LDAP and able to authenticate the user with that. However we have 2=20 type of users, one - corporate users and available of Active Directory=20 and second application user, which is used by different application to=20 connect with database. Below entry i did in the pg_hba.conf file, if i create user in DB=20 (similar exist on AD) it works. However if i create one user with=20 password, it calls the LDAP server for authentication and fails as it=20 does not exists in AD. host all all 0.0.0.0/0 ldap=20 ldapserver=3D ldapbasedn=3D"OU=3DCorporate,DC=3Detch,dc=3Dcom"= =20 ldapbinddn=3D"CN=3DAdSyncAcct,OU=3DService Accounts,DC=3Detch,DC=3Dcom"=20 ldapbindpasswd=3D"Password" ldapsearchattribute=3D"sAMAccountName" we are using the postgres 10.10 version. can you please suggest the pg_hba.conf file entry, that will help us to=20 authenticate the users from LDAP and from postgres as well. Regards, Anjul TYAGI =C3=BC Go Green --------=_MBDF943FCB-FA36-40D6-8868-8877BE4781D8 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Team,

we are implementing the LDAP au= thentication and we are able to connect with LDAP and able to authenticate= the user with that. However we have 2 type of users, one - corporate users= and available of Active Directory and second application user, which is use= d by different application to connect with database.=C2=A0

=
Below entry i did in the pg_hba.conf file, if i create user in D= B (similar exist on AD) it works. However if i create one user with passwor= d, it calls the LDAP server for authentication and fails as it does not exi= sts in AD.=C2=A0

host=C2=A0 =C2=A0 all=C2=A0 =C2= =A0=C2=A0 =C2=A0=C2=A0 =C2=A0=C2=A0 =C2=A0 all=C2=A0 =C2=A0=C2=A0 =C2=A0 0.= 0.0.0/0=C2=A0 =C2=A0=C2=A0 =C2=A0=C2=A0 =C2=A0=C2=A0 =C2=A0ldap ldapserver= =3D<LDAL Server> ldapbasedn=3D"OU=3DCorporate,DC=3Detch,dc=3Dcom" lda= pbinddn=3D"CN=3DAdSyncAcct,OU=3DService Accounts,DC=3Detch,DC=3Dcom" ldapbi= ndpasswd=3D"Password" ldapsearchattribute=3D"sAMAccountName"

we are using the postgres 10.10 version.=C2=A0
<= div>
can you please suggest the pg_hba.conf file entry, tha= t will help us to authenticate the users from LDAP and from postgres as wel= l.=C2=A0
=C2=A0
=C2=A0
=C2=A0

Regards,

Anjul TYAGI

=C2=A0

=C3=BC<= /b>=C2=A0Go=C2= =A0Green


--------=_MBDF943FCB-FA36-40D6-8868-8877BE4781D8--