pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jacob Champion <pchampion@vmware.com>
To: tgl@sss.pgh.pa.us <tgl@sss.pgh.pa.us>
To: michael@paquier.xyz <michael@paquier.xyz>
Cc: pgsql-committers@lists.postgresql.org <pgsql-committers@lists.postgresql.org>
Subject: Re: pgsql: Add some information about authenticated identity via log_connec
Date: Wed, 7 Apr 2021 16:20:18 +0000
Message-ID: <fa8dbbb58c20b1d1adf0082769f80d5466eaf485.camel@vmware.com> (raw)
In-Reply-To: <1544704.1617805663@sss.pgh.pa.us>
References: <E1lTwp4-0002l4-L9@gemulon.postgresql.org>
	<YG05nCI8x8B+Ad3G@paquier.xyz>
	<1544704.1617805663@sss.pgh.pa.us>

On Wed, 2021-04-07 at 10:27 -0400, Tom Lane wrote:
> Michael Paquier <michael@paquier.xyz> writes:
> > On Wed, Apr 07, 2021 at 01:17:34AM +0000, Michael Paquier wrote:
> > > Add some information about authenticated identity via log_connections
> > So, fairywren, that is able to run the SSL tests on Windows, has been
> > complaining here:
> 
> prairiedog is also not happy, apparently for a different reason.
> Let me know if you need help debugging that one.

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.

--Jacob


Attachments:

  [text/x-patch] fix-prariedog.patch (811B, ../fa8dbbb58c20b1d1adf0082769f80d5466eaf485.camel@vmware.com/2-fix-prariedog.patch)
  download | inline diff:
diff --git a/src/test/ssl/t/002_scram.pl b/src/test/ssl/t/002_scram.pl
index 0280d0a1ef..4eb130754e 100644
--- a/src/test/ssl/t/002_scram.pl
+++ b/src/test/ssl/t/002_scram.pl
@@ -104,8 +104,8 @@ $node->connect_fails(
 
 # Certificate verification at the connection level should still work fine.
 $node->connect_ok(
-	"sslcert=ssl/client.crt sslkey=$client_tmp_key sslrootcert=invalid hostaddr=$SERVERHOSTADDR dbname=verifydb user=ssltestuser channel_binding=require",
-	"SCRAM with clientcert=verify-full and channel_binding=require",
+	"sslcert=ssl/client.crt sslkey=$client_tmp_key sslrootcert=invalid hostaddr=$SERVERHOSTADDR dbname=verifydb user=ssltestuser",
+	"SCRAM with clientcert=verify-full",
 	log_like => [ qr/connection authenticated: identity="ssltestuser" method=scram-sha-256/ ]);
 
 # clean up


view thread (8+ messages)  latest in thread

Message-ID: <fa8dbbb58c20b1d1adf0082769f80d5466eaf485.camel@vmware.com>
Permalink:  ../fa8dbbb58c20b1d1adf0082769f80d5466eaf485.camel@vmware.com/
Also on:    postgresql.org/message-id/fa8dbbb58c20b1d1adf0082769f80d5466eaf485.camel@vmware.com

 ·  · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: pchampion@vmware.com, tgl@sss.pgh.pa.us, michael@paquier.xyz, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Add some information about authenticated identity via log_connec
  In-Reply-To: <fa8dbbb58c20b1d1adf0082769f80d5466eaf485.camel@vmware.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox