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 1krQcp-0001Ao-A4 for pgsql-hackers@arkaria.postgresql.org; Mon, 21 Dec 2020 19:13:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1krQco-0007SN-7z for pgsql-hackers@arkaria.postgresql.org; Mon, 21 Dec 2020 19:13:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1krQco-0007SG-0k for pgsql-hackers@lists.postgresql.org; Mon, 21 Dec 2020 19:13:42 +0000 Received: from tamriel.snowman.net ([70.109.60.50]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1krQcm-0002OL-3F for pgsql-hackers@postgresql.org; Mon, 21 Dec 2020 19:13:41 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 808A05F799; Mon, 21 Dec 2020 14:13:39 -0500 (EST) Date: Mon, 21 Dec 2020 14:13:39 -0500 From: Stephen Frost To: Magnus Hagander Cc: Tom Lane , Jeff Janes , Thomas Munro , k.yudhveer@gmail.com, pgsql-hackers Subject: Re: BUG #16079: Question Regarding the BUG #16064 Message-ID: <20201221191339.GN27507@tamriel.snowman.net> References: <20201221005825.GQ16415@tamriel.snowman.net> <543836.1608575492@sss.pgh.pa.us> <20201221183511.GI27507@tamriel.snowman.net> <544464.1608576242@sss.pgh.pa.us> <20201221190608.GM27507@tamriel.snowman.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="sGwo475CiIwWEjLI" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --sGwo475CiIwWEjLI Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Magnus Hagander (magnus@hagander.net) wrote: > On Mon, Dec 21, 2020 at 8:06 PM Stephen Frost wrote: > > * Magnus Hagander (magnus@hagander.net) wrote: > > > On Mon, Dec 21, 2020 at 7:44 PM Tom Lane wrote: > > > > BTW, do we have a client-side setting to insist that passwords not = be > > > > sent in MD5 hashing either? A person who is paranoid about this wo= uld > > > > likely want to disable that code path as well. > > > > > > I don't think we do, and we possibly should. You can require channel > > > binding which will require scram which solves the problem, but it does > > > so only for scram. > > > > > > IIRC we've discussed having a parameter that says "allowed > > > authentication methods" on the client as well, but I don't believe it > > > has been built. But it wouldn't be bad to be able to for example force > > > the client to only attempt gssapi auth, regardless of what the server > > > asks for, and just fail if it's not there. > > > > The client is able to require a GSS encrypted connection, and a savy > > user will realize that they should 'kinit' (or equivilant) locally and > > never provide their password explicitly to the psql (or equivilant) > > command, but that's certainly less than ideal. >=20 > Sure, but even if you do, then if you connect to a server that has gss > support but is configured for password auth, it will perform password > auth. Right, and that's bad. Think we agree on that. I was just saying that someone who understanding how GSS works wouldn't actually provide their password at that point. Trusting to that is definitely not sufficient though. > > Having a way to explicitly tell libpq what auth methods are acceptable > > was discussed previously and does generally seem like a good idea, as > > otherwise there's a lot of risk of what are essentially downgrade > > attacks. >=20 > That was my point exactly.. Yes, it was my intention to agree with you on this. :) Thanks, Stephen --sGwo475CiIwWEjLI Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJf4PPjAAoJEO1sijiDR2RVj6oQAK/u785PI2BeppAlpb0W1oJY Svm+V1DCwh4D3Sz62MWriZfD2T0qB2092TC3fwoNXzWWR+CEX/N7+vL2u3XId/zz x/qHIkj+/Bij8f7APSKt306EiauNdtl6EwOeQNEqoh+SUZGzueiGofA2U5ZjIlio 1ligD2l+EfwaZwr6pknDoVsp5qdG+AkPLpep70WN1RyIHAus8fHtiod41D10JJ6q M297EgzecICWFFBvp90LLg+MEIzAi2yOAQOu0lzyyfPXIkKgMHC4eh9g7h2oQxSQ OBJykG5pxPQobc41km0xMd69+1gUdDknH3dcdxjDalpQJcm1UuBHa98aqMOzNC2x NQrC7ZIbCmTzMmV+beKir+NHv43QkTwKR1K16r58D6sfy8q2B64k3fTOuICJlfgL itoKiKQ3S4Y18SqH7UmzzG9TsW2qU5jZI0pfsZTuzpoRL+IUVZFVygqnVIl14R1C 1I/NspeGKTPJjmyXs4KsbniQgWDcKd6AQrE16bSTZ/pHs0pTexGS9KWN11eXq9wC X8rnvw7QFyVVxrs6KRVGBG+YGiKfgS6DCdyWAhIpL2EoO+L4g7teEh07WR+4eHbW p8hvlcb9iuJE64MOJ+HMvms8cBNU657zD4wAifBupbzLcwbKfPKAffHfoMRIZV6K 4ICT0nw0jbVBYwb4Zxp1 =T+VY -----END PGP SIGNATURE----- --sGwo475CiIwWEjLI--