Re: Allowing SSL connection of v11 client to v10 server with SCRAMchannel binding - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Allowing SSL connection of v11 client to v10 server with SCRAMchannel binding
Date
Msg-id CAB7nPqQAbVhejXBk-nNpgrFyzOVKk16JVfbQ+tJLK8zumXdO1g@mail.gmail.com
Whole thread Raw
In response to Re: Allowing SSL connection of v11 client to v10 server with SCRAMchannel binding  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: Allowing SSL connection of v11 client to v10 server with SCRAMchannel binding
List pgsql-hackers
On Fri, Dec 1, 2017 at 11:55 PM, Peter Eisentraut
<peter.eisentraut@2ndquadrant.com> wrote:
> On 11/30/17 00:36, Michael Paquier wrote:
>> On Wed, Nov 29, 2017 at 1:04 AM, Peter Eisentraut
>> <peter.eisentraut@2ndquadrant.com> wrote:
>>> On 11/22/17 21:08, Michael Paquier wrote:
>>>> Yes, agreed. This patch looks good to me. In fe-auth-scram.c, it would
>>>> be also nice to add a comment to keep in sync the logics in
>>>> build_client_first_message() and build_client_final_message() which
>>>> assign the cbind flag value.
>>>
>>> Could you clarify what comment you would like to have added or changed?
>>
>> Sure. Here is with the attached patch what I have in mind. The way
>> cbind-flag is assigned in the client-first message should be kept
>> in-sync with the way the client-final message builds the binding data
>> in c=. It could be possible to add more sanity-checks based on
>> assertions by keeping track of the cbind-flag assigned in the
>> client-first message as your upthread patch is doing in the backend
>> code, but I see a simple comment as a sufficient reminder.
>
> Committed with that comment, thanks.

Cool. Thanks. For REL_10_STABLE, I would suggest the attached patch
then. This ensures that eSws is checked in the final message and that
the cbind-flag sent in the first message maps with the data of the
final message in the backend. I have checked with the following
configurations with a v10 backend:
- v11 libpq with SSL
- v11 libpq without SSL
- v10 libpq with SSL
- v10 libpq without SSL
And in all cases the connection is accepted as it should.
-- 
Michael

Attachment

pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: [HACKERS] pow support for pgbench
Next
From: Andres Freund
Date:
Subject: Re: [HACKERS] Parallel Hash take II