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

From Tom Lane
Subject Re: BUG #15035: scram-sha-256 blocks all logins
Date
Msg-id 29276.1517287253@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #15035: scram-sha-256 blocks all logins  (Meirav Rath <meirav.rath@imperva.com>)
List pgsql-bugs
Meirav Rath <meirav.rath@imperva.com> writes:
> I set up the password hashing method to scram and now no one can login to the server and that's not a bug??

You told it to lock out md5 passwords, and it did.

Try changing the passwords to scram type *first*.  Note where it
says in the fine manual:

    To ease transition from the md5 method to the newer SCRAM method, if
    md5 is specified as a method in pg_hba.conf but the user's password on
    the server is encrypted for SCRAM (see below), then SCRAM-based
    authentication will automatically be chosen instead.

            regards, tom lane


pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: BUG #15035: scram-sha-256 blocks all logins
Next
From: Meirav Rath
Date:
Subject: RE: BUG #15035: scram-sha-256 blocks all logins