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 1lUBPO-0000uv-6Y for pgsql-committers@arkaria.postgresql.org; Wed, 07 Apr 2021 16:52:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lUBPN-0003ZN-48 for pgsql-committers@arkaria.postgresql.org; Wed, 07 Apr 2021 16:52:01 +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 1lUBPM-0003Wc-Uz for pgsql-committers@lists.postgresql.org; Wed, 07 Apr 2021 16:52:00 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lUBPK-0003bZ-U8 for pgsql-committers@lists.postgresql.org; Wed, 07 Apr 2021 16:51:59 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 137GpvY11597947; Wed, 7 Apr 2021 12:51:57 -0400 From: Tom Lane To: Jacob Champion cc: "michael@paquier.xyz" , "pgsql-committers@lists.postgresql.org" Subject: Re: pgsql: Add some information about authenticated identity via log_connec In-reply-to: References: <1544704.1617805663@sss.pgh.pa.us> Comments: In-reply-to Jacob Champion message dated "Wed, 07 Apr 2021 16:20:18 -0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1597945.1617814317.1@sss.pgh.pa.us> Date: Wed, 07 Apr 2021 12:51:57 -0400 Message-ID: <1597946.1617814317@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Jacob Champion writes: > On Wed, 2021-04-07 at 10:27 -0400, Tom Lane wrote: >> prairiedog is also not happy, apparently for a different reason. > That one's failing because older OpenSSL doesn't support channel > binding, and the new test I wrote forgot to check to make sure channel > binding was supported... sorry. > But the test doesn't truly *need* channel binding anyway; it just needs > to check the interaction between SCRAM and verify-full, to ensure that > the correct authn_id is set. Patch attached, tested locally with > OpenSSL 1.0.1 and 1.1.1. Sounds reasonable, pushed. (I didn't actually verify it on prairiedog, because that would have taken a couple hours :-(. We can revisit if that animal fails to go green.) regards, tom lane