From: | Meirav Rath <meirav(dot)rath(at)imperva(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | Daniel Gustafsson <daniel(at)yesql(dot)se>, 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 14:15:00 |
Message-ID: | DM2PR0601MB09562F1FE04E9176992E0080E4E40@DM2PR0601MB0956.namprd06.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
If what you’re trying to say is “switch the order of the two lines in the file” then that is a very, very obscure way of doing it.
That works
From: David G. Johnston [mailto:david(dot)g(dot)johnston(at)gmail(dot)com]
Sent: Tuesday, January 30, 2018 16:04
To: Meirav Rath <meirav(dot)rath(at)imperva(dot)com>
Cc: Daniel Gustafsson <daniel(at)yesql(dot)se>; Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>; pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15035: scram-sha-256 blocks all logins
On Tuesday, January 30, 2018, Meirav Rath <meirav(dot)rath(at)imperva(dot)com<mailto:meirav(dot)rath(at)imperva(dot)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.
-------------------------------------------
NOTICE:
This email and all attachments are confidential, may be proprietary, and may be privileged or otherwise protected from disclosure. They are intended solely for the individual or entity to whom the email is addressed. However, mistakes sometimes happen in addressing emails. If you believe that you are not an intended recipient, please stop reading immediately. Do not copy, forward, or rely on the contents in any way. Notify the sender and/or Imperva, Inc. by telephone at +1 (650) 832-6006 and then delete or destroy any copy of this email and its attachments. The sender reserves and asserts all rights to confidentiality, as well as any privileges that may apply. Any disclosure, copying, distribution or action taken or omitted to be taken by an unintended recipient in reliance on this message is prohibited and may be unlawful.
Please consider the environment before printing this email.
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2018-01-30 14:24:45 | Re: BUG #15035: scram-sha-256 blocks all logins |
Previous Message | David G. Johnston | 2018-01-30 14:04:17 | Re: BUG #15035: scram-sha-256 blocks all logins |