Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iF7Wv-00013n-Gq for pgsql-committers@arkaria.postgresql.org; Tue, 01 Oct 2019 02:04:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iF7Wu-0006c1-9o for pgsql-committers@arkaria.postgresql.org; Tue, 01 Oct 2019 02:04:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iF7Ws-0006bf-RY for pgsql-committers@lists.postgresql.org; Tue, 01 Oct 2019 02:04:44 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iF7Wp-0008K5-2V for pgsql-committers@lists.postgresql.org; Tue, 01 Oct 2019 02:04:42 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 5D3A021C4E; Mon, 30 Sep 2019 22:04:37 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Mon, 30 Sep 2019 22:04:37 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=0DjD2HxSxQaFTCQr/+mG/V8e43e ZrAJCnm3j/IPzSMY=; b=J7kPayJsDF2rSUUWK5q9SP41nZIiTwFfc1TUbIk92Kb h2hDqyONTyWuf8C+P9q50A7611xvmnOOzhkMKjo6GC3+X2HtBiT18F+aoayekxng c/QYyOqBvnGCv36Uv07DPhBhzVG9MDbOzIPUsdDTRcqB0WUc/bF/QH0EUV3bMHmm VCG7jw8oxDQYOjpnKXFJ6zoZnSKGKyxtiwmLR87RN4MpI2oJyr6KvHeTsHwiODGg SflmZjK7qzwUa5N6N9WulmN68l+Dso42FZ6YM2N7S5LxoyJ5Tg9LbizpPjJgHHTR lPbdZROKANtdmjLMgwreE/LURZevwpkkncSXA/btggw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=0DjD2H xSxQaFTCQr/+mG/V8e43eZrAJCnm3j/IPzSMY=; b=ANF+bjWpSzlRgWSx0+WIJs EpePmEn9XEOI0TAD7eoNspNjwLKRn4BEOYfP8YLXl5CI0N4KMS/rN4ElBxL9e6r2 6+FSfFl7VA9mEM8g0E3beCzjDZT62B2XGtkWe3RiCqgNocR4bcUlEHdsHZHEQwJs QARE2jxdS66H6nuIZhQLMZQalZbdMUGYFpDbI+ejWpwWv6ne98xumNgyzlQbOIQJ RBIc65SC6jZ32PTFTyjzQnFYwiiCJubOnrlLs/vwS9h2femIReLG0ozxITq+IE4h LK1UKZknlMJm3BtDfiV7A/5YNQoHVMLbYm2eL4eKmXvsj6YY51W0N1DivXk9sLqA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedrgeefgdehudcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdefhedmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecukfhppeduudekrddvgedurddvhedurddvfeegnecurfgrrhgr mhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiinecuvehluh hsthgvrhfuihiivgeptd X-ME-Proxy: Received: from paquier.xyz (mp76f1fbea.ap.nuro.jp [118.241.251.234]) by mail.messagingengine.com (Postfix) with ESMTPA id AB88280059; Mon, 30 Sep 2019 22:04:33 -0400 (EDT) Date: Tue, 1 Oct 2019 11:04:30 +0900 From: Michael Paquier To: Tom Lane Cc: Jeff Davis , Jeff Davis , pgsql-committers@lists.postgresql.org Subject: Re: pgsql: Add libpq parameter 'channel_binding'. Message-ID: <20191001020430.GD2781@paquier.xyz> References: <24857.1569775891@sss.pgh.pa.us> <20190929234733.GA2888@paquier.xyz> <20190930064539.GK2888@paquier.xyz> <20190930070826.GM2888@paquier.xyz> <11a5c3b483f1c0140f9fc5cf863d8ac61a28e60a.camel@j-davis.com> <19002.1569867629@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="LTeJQqWS0MN7I/qa" Content-Disposition: inline In-Reply-To: <19002.1569867629@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --LTeJQqWS0MN7I/qa Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Sep 30, 2019 at 02:20:29PM -0400, Tom Lane wrote: > Jeff Davis writes: >> For 2-3, shouldn't we error at an earlier stage? The user of the client >> has requested something impossible to satisfy. >=20 > Can't get excited about that. It'd require duplicating this code > somewhere else, which is a maintenance issue. And the case of building > with obsolete OpenSSL ought to be fairly infrequent and getting more so > as time goes on, so I'm not really eager to expend lots of work on it. Neither am I, and there is one extra reason on top of what Tom has mentioned: there is still value in warning the client if a rogue server sends SCRAM-SHA-256-PLUS without SSL even if channel_binding is required. I have double-checked the patch and done more tests (server publishing SCRAM-SHA-256-PLUS with various libpq clients). I have included the full description of the behavior in the commit log, and applied it. -- Michael --LTeJQqWS0MN7I/qa Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl2StC4ACgkQnvQgOdby QH1/QQ/+MHqRfDVuDUkiX8O5dG+v0H4I1LMzhL2VLKCMRyUu2r7DMxk99d0Y9wMJ ejmji3vcIQoiEtVEieQ3/RjjJvOLplnpfVPjDJp/rgKkz/sCK0T+pyWNhXSiqZ0X 9rHvOm5zOthfYM7AAQRNwvu14GS48qpAoH5Fk5uKqskEjx0/LNpz84pGTyqL0iDM 9cER5aH7v+i3O0fQk6mjxjyIcPlofZtY1QNFYrYmZZfDH6ZhvoxHzvBBQwG+4XFo xfzmyG8f75i0Glhr5WXKl9ek00TYLoFo1eUMxpBBGhvESw8bv0zvd1FQaleHqbfm yBZkc+522BRVMfLErB2P+HsQAFNPARVYNiWUFpWbonwuBQ6UvmTZAY/FQ/JPibwe +Gaj0kmOe/mlwSRM/nklnm1hF6JhEGOZEBJsZq/2j+TMNDFSxXBe2/qwd9bNebR7 oJ3GafV5Za3Q4HkQkfYZNsM9vVZtru4+eqJ2qu9/ZNVeStYz2o2im0zdNoiBOVp6 XhkoqIu2eG1/MBNsA1H0yfP2PrnMxS8iI6+D0BNmI4x2kj4REMQe9H9fVGJMwmeU cjscr+6V6p3pShbaF/P8L+jsCROz70kdoISresEnynQUMtcERaktUZvc33cUo4X9 Q5gzl6J3Qf8pge7d/SC8SDthcer1zCJheurNRNalHYzx3EcSrPs= =RrRl -----END PGP SIGNATURE----- --LTeJQqWS0MN7I/qa--