Postgres Pro
Downloads
Home   >   mailing lists

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

From Meirav Rath
Subject Re: BUG #15035: scram-sha-256 blocks all logins
Date
Msg-id DM2PR0601MB09561C86B3F67A7B56A38938E4E40@DM2PR0601MB0956.namprd06.prod.outlook.com
Whole thread Raw
In response to Re: BUG #15035: scram-sha-256 blocks all logins  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses BUG #15035: scram-sha-256 blocks all logins
Re: BUG #15035: scram-sha-256 blocks all logins
List pgsql-bugs
Tree view
I set up the password hashing method to scram and now no one can login to the server and that's not a bug??



���� ��������� �-Samsung Galaxy ���.


-------- ����� ������ --------
���: Tomas Vondra <tomas.vondra@2ndquadrant.com>
�����: 30.1.2018 04:29 (GMT+02:00)
��: Meirav Rath <meirav.rath@imperva.com>, pgsql-bugs@lists.postgresql.org, PG Bug reporting form <noreply@postgresql.org>
����: Re: BUG #15035: scram-sha-256 blocks all logins

This is not a bug - at least you haven't explained why the behavior
should be considered incorrect. This is a question and so belongs to
pgsql-general. Please, post it again to the right list.


On 01/29/2018 04:20 PM, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference:      15035
> Logged by:          Meirav Rath
> Email address:      meirav.rath@imperva.com
> PostgreSQL version: 10.0
> Operating system:   windows server 2012 R2
> Description:       
>
> Hi,
>
> I'm trying to set up the new SCRAM-SHA-256 authentication method. The only
> problem is that the moment I set this in both postgresql.conf and
> pg_hba.conf I can no longer login with any user, and so I can't create new
> users with passwords that are compatible.
>
> Here's what pg_hba.conf looks like:
>
> ...
regards

--
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
-------------------------------------------
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.

pgsql-bugs by date:

Previous
From: Thomas Munro
Date:
Subject: Re: BUG #15036: Un-killable queries Hanging in BgWorkerShutdown
Next
From: "David G. Johnston"
Date:
Subject: BUG #15035: scram-sha-256 blocks all logins