| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Meirav Rath <meirav(dot)rath(at)imperva(dot)com> |
| Cc: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #15035: scram-sha-256 blocks all logins |
| Date: | 2018-01-30 04:40:53 |
| Message-ID: | 29276.1517287253@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Meirav Rath <meirav(dot)rath(at)imperva(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Meirav Rath | 2018-01-30 07:56:40 | RE: BUG #15035: scram-sha-256 blocks all logins |
| Previous Message | David G. Johnston | 2018-01-30 04:37:53 | BUG #15035: scram-sha-256 blocks all logins |