RE: BUG #15035: scram-sha-256 blocks all logins

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

Postgresql service is running. However, I can't login with user postgres, with the following error message:
"The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supported by the driver."
When trying DBeaver and with
" FATAL: password authentication failed for user "postgres""
When using PGadmin 4 version 2.1 flask version 0.12.2

-----Original Message-----
From: Daniel Gustafson [mailto:daniel(dot)gustafson(at)gmail(dot)com] On Behalf Of Daniel Gustafsson
Sent: Tuesday, January 30, 2018 10:03
To: Meirav Rath <meirav(dot)rath(at)imperva(dot)com>
Cc: David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>; 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 30 Jan 2018, at 08:56, Meirav Rath <meirav(dot)rath(at)imperva(dot)com> wrote:
>
> Like this?

> host all all 0.0.0.0/0 scram-sha256

There is a typo in this authentication method, it should be scram-sha-256 (not the second dash between "sha" and "256”).

> Because I can’t restart the postgresql service, it crashes when this is the setup….

Changing the above should allow the database to start up.

cheers ./daniel
-------------------------------------------
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.