Re: BUG #15035: scram-sha-256 blocks all logins - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #15035: scram-sha-256 blocks all logins
Date
Msg-id CAKFQuwbgWAp2DuJ5N=ycFbfxO3aTn7Y4jvWpZFaUev=DHvL5KQ@mail.gmail.com
Whole thread Raw
In response to RE: BUG #15035: scram-sha-256 blocks all logins  (Meirav Rath <meirav.rath@imperva.com>)
Responses RE: BUG #15035: scram-sha-256 blocks all logins
List pgsql-bugs
On Tuesday, January 30, 2018, Meirav Rath <meirav.rath@imperva.com> wrote:
Yes, I was following a previous bug I found on your site  - pg_hba_file_rules: "scram-sha256" instead of "scram-sha-256".

So I fixed it, now pg_hba.conf looks like this:

hostallall0.0.0.0/0scram-sha-256
hostallpostgres0.0.0.0/0trust

From the docs:

 Since the pg_hba.conf records are examined sequentially for each connection attempt, the order of the records is significant. Typically, earlier records will have tight connection match parameters and weaker authentication methods, while later records will have looser match parameters and stronger authentication methods.

David J.

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15037: gdal-libs-1.11.4-12 updates require proj unavailableversion
Next
From: Meirav Rath
Date:
Subject: RE: BUG #15035: scram-sha-256 blocks all logins