pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedSCRAM question
3+ messages / 3 participants
[nested] [flat]
* SCRAM question
@ 2018-10-30 17:51 MichaelDBA <MichaelDBA@sqlexec.com>
0 siblings, 1 reply; 3+ messages in thread
From: MichaelDBA @ 2018-10-30 17:51 UTC (permalink / raw)
To: pgsql-performance@lists.postgresql.org
I am using pgadmin4 version 3.4 with PG 11.0 and I get this error when I
try to connect with scram authorization:
User "myuser" does not have a valid SCRAM verifier.
How do I get around this? And also how would I do this for psql?
Regards,
Michael Vitale
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: SCRAM question
@ 2018-10-30 18:03 Joshua D. Drake <jd@commandprompt.com>
parent: MichaelDBA <MichaelDBA@sqlexec.com>
0 siblings, 1 reply; 3+ messages in thread
From: Joshua D. Drake @ 2018-10-30 18:03 UTC (permalink / raw)
To: MichaelDBA <MichaelDBA@sqlexec.com>; pgsql-performance@lists.postgresql.org
On 10/30/18 10:51 AM, MichaelDBA wrote:
> I am using pgadmin4 version 3.4 with PG 11.0 and I get this error when
> I try to connect with scram authorization:
>
> User "myuser" does not have a valid SCRAM verifier.
>
> How do I get around this? And also how would I do this for psql?
You need to update the password using SCRAM I believe...
|See here:
https://paquier.xyz/postgresql-2/postgres-10-scram-authentication/|
|
|
|JD
|
>
> Regards,
> Michael Vitale
--
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
*** A fault and talent of mine is to tell it exactly how it is. ***
PostgreSQL centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://postgresconf.org
***** Unless otherwise stated, opinions are my own. *****
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: SCRAM question
@ 2018-10-31 09:55 Michael Paquier <michael@paquier.xyz>
parent: Joshua D. Drake <jd@commandprompt.com>
0 siblings, 0 replies; 3+ messages in thread
From: Michael Paquier @ 2018-10-31 09:55 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: MichaelDBA <MichaelDBA@sqlexec.com>; pgsql-performance@lists.postgresql.org
On Tue, Oct 30, 2018 at 11:03:14AM -0700, Joshua D. Drake wrote:
> On 10/30/18 10:51 AM, MichaelDBA wrote:
>> I am using pgadmin4 version 3.4 with PG 11.0 and I get this error when I
>> try to connect with scram authorization:
>>
>> User "myuser" does not have a valid SCRAM verifier.
>>
>> How do I get around this? And also how would I do this for psql?
>
> You need to update the password using SCRAM I believe...
>
> |See here:
> https://paquier.xyz/postgresql-2/postgres-10-scram-authentication/|
In order to do that, you would basically need to:
1) Switch password_encryption to 'scram-sha-256' in the server
configuration.
2) Issue an ALTER ROLE command to update the password (likely it is
better to use \password from psql as this would send a hashed password
to the server, which relies on the server setting for
password_encryption).
3) Make sure that pg_hba.conf is using properly scram-sha-256 where it
should as authentication method.
If you do not want to upgrade to SCRAM, it is of course possible to
still remain with md5.
--
Michael
Attachments:
[application/pgp-signature] signature.asc (832B, ../../20181031095501.GH7862@paquier.xyz/2-signature.asc)
download
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2018-10-31 09:55 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-10-30 17:51 SCRAM question MichaelDBA <MichaelDBA@sqlexec.com>
2018-10-30 18:03 ` Joshua D. Drake <jd@commandprompt.com>
2018-10-31 09:55 ` Michael Paquier <michael@paquier.xyz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox