Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sN5ly-006jld-Hz for pgsql-hackers@arkaria.postgresql.org; Fri, 28 Jun 2024 07:11:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sN5lw-001tkY-Vl for pgsql-hackers@arkaria.postgresql.org; Fri, 28 Jun 2024 07:11:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sN5lw-001tkQ-Ls for pgsql-hackers@lists.postgresql.org; Fri, 28 Jun 2024 07:11:52 +0000 Received: from fhigh6-smtp.messagingengine.com ([103.168.172.157]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sN5lq-003x6h-KR for pgsql-hackers@postgresql.org; Fri, 28 Jun 2024 07:11:52 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailfhigh.nyi.internal (Postfix) with ESMTP id A57991140356; Fri, 28 Jun 2024 03:11:44 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Fri, 28 Jun 2024 03:11:44 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eisentraut.org; h=cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1719558704; x=1719645104; bh=Uv9d6kQ6w6ympxSinNqljwtgnT3nay45o8kTUI3LFNs=; b= B2xKD9KOY/JtV+6WiqMFr0bQEj+4KSvPlGwQuz3PBz2mOrVgcmPpmV4mD5075SXr BZ5T7PsZblZhqvDw3grzPH0A2n5YRD3K0WjfGeM2dPhri/1IecIO2ChSQswgYENQ t9uPK6LZbXqHq/j+6RLDr46zAYCNmwq30CKA4jFl6RhDfY/JGNAGWWQWqfQke6cU jxw4c56R4ogO6DREv8nchaAewWsg1OhG6TthsFF2fIlyut0/CPMHdv3ohoV9t8oG UKl4Da+sKht/qhg96+d/8XhLmf/xwTXw4GH05Bh2bvO17tvp2qK8DFT1Xtnbc8r7 08AP6Fq0Y+0KgY6XAMg5MQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1719558704; x= 1719645104; bh=Uv9d6kQ6w6ympxSinNqljwtgnT3nay45o8kTUI3LFNs=; b=I saqiOSyA2twLjvbdn/3KFwbpVFFg/moBIel+Ghpw1wsUSNuMtgG3H5G8AehAlIZG Sw8/P1JOI3qvxzeLNe/77+5C41nZH5ey9/zEUWhdwRbwcjCi7ry8G43hBKw5UMDM J077C0GiiKWm4BUKCq1IdJLhmAPoOit6w9BzDkHRVuAgK06CjpWYNsd2NknOdXcW BzAeNyVcJS2cn5vb4xjoWIdKDn1ddjjiBqnCv9Soo5qOdH24jDEm5uhhmAcxZE06 Teya4mbYyDRBhd8eWK/331RXvDDQ+qLOP6AQFpocoFgXLrlS8FnXNCGTNiJhNAO5 1uGWRBPlPgdSLBfCelDfQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrtdehgdduudekucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvfhfhjggtgfesthejredttddvjeenucfhrhhomheprfgvthgv rhcugfhishgvnhhtrhgruhhtuceophgvthgvrhesvghishgvnhhtrhgruhhtrdhorhhgqe enucggtffrrghtthgvrhhnpeffjeehueevhfdvjeefjeefjeehudegfeehiedtkefhveeh lefgudegheetteehgeenucffohhmrghinhepvgigrghmphhlvgdrnhgvthenucevlhhush htvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehpvghtvghrsegvihhs vghnthhrrghuthdrohhrgh X-ME-Proxy: Feedback-ID: ie0a040ee:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 28 Jun 2024 03:11:43 -0400 (EDT) Message-ID: <99058de4-bf2a-497a-91a3-537228ad143f@eisentraut.org> Date: Fri, 28 Jun 2024 09:11:42 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Document use of ldapurl with LDAP simple bind To: Jacob Champion , PostgreSQL Hackers References: Content-Language: en-US From: Peter Eisentraut In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 24.05.24 20:54, Jacob Champion wrote: > Our documentation implies that the ldapurl setting in pg_hba is used > for search+bind mode only. It was pointed out to me recently that this > is not true, and if you're dealing with simple bind on a non-standard > scheme or port, then ldapurl makes the HBA easier to read: > > ... ldap ldapurl="ldaps://ldap.example.net:49151" ldapprefix="cn=" > ldapsuffix=", dc=example, dc=net" > > 0001 tries to document this helpful behavior a little better, and 0002 > pins it with a test. WDYT? Yes, this looks correct. Since ldapurl is really just a shorthand that is expanded to various other parameters, it makes sense that it would work for simple bind as well. hba.c has this error message: "cannot use ldapbasedn, ldapbinddn, ldapbindpasswd, ldapsearchattribute, ldapsearchfilter, or ldapurl together with ldapprefix" This appears to imply that specifying ldapurl is only applicable for search+bind. Maybe that whole message should be simplified to something like "configuration mixes arguments for simple bind and search+bind" (The old wording also ignores that the error might arise via "ldapsuffix".)