Date: Wed, 31 Oct 2018 18:55:01 +0900
From: Michael Paquier <michael@paquier.xyz>
To: "Joshua D. Drake" <jd@commandprompt.com>
Cc: MichaelDBA <MichaelDBA@sqlexec.com>,
	pgsql-performance@lists.postgresql.org
Subject: Re: SCRAM question
Message-ID: <20181031095501.GH7862@paquier.xyz>
References: <5BD89A3D.5060108@sqlexec.com>
 <7460ee84-6c64-dcbc-4fc6-c88507ccb2ee@commandprompt.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="Q59ABw34pTSIagmi"
Content-Disposition: inline
In-Reply-To: <7460ee84-6c64-dcbc-4fc6-c88507ccb2ee@commandprompt.com>
Precedence: bulk


--Q59ABw34pTSIagmi
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

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:
>>=20
>> User "myuser" does not have a valid SCRAM verifier.
>>=20
>> How do I get around this? And also how would I do this for psql?
>=20
> You need to update the password using SCRAM I believe...
>=20
> |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

--Q59ABw34pTSIagmi
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlvZe/UACgkQnvQgOdby
QH0y9Q/+LlKCDggWd+DBH2va7119+RypYLFXssNH5NbDXDv/Lri0aEj4nINHfEfp
VdXQmgti5GknEFqjDLYYCX5R82U/D7puwyvHfwZcRyap4Ze3UFyZiK0ApSb6pTS/
ti3Q/ztpE3B/L25eZlm6TP60v379rE7b7olSLG68U4Klnf4HposwYt88MK0i8xKx
4rsjiX+ypfFSBpMG4/HIz/BbewK3VVQLO4+Wd51ypQDC6GPljq+unoUU+IllAQv5
EbXYUXdDxsjWFojBXJ2f0rVOK16f6GE8NSEh4C3XJcOgbOTd/whTjBXaha4s34h5
Q++r/UUAqvCWt8L+vAoGxXtYoBpHBFdg6fdnkFFuvH7juJRNwOsF/7bohraPBMfo
YfnZj3Ipk+PG4Z2a0qrGE1qEsMEVnjchHRi+zrWtsU53dcvuKKt4/b7yVNI3YkHr
DMAhlsRss0nVxlcfv2/mo/h+yvTFbMpJ40bXjKm5o/kfufZa/MJfZj3nEzphvV/+
aOZ1KgNfUskVVmWzC5aEKVtcmuKd40ddZOn1HPmTF6tEc6lTRkdvInV88TP6GA1+
5HLaTQJdVZjTUkUQuaf+QPt2yYU8pAyIsopvIs2GXqycZJDbz3MPhl3v2lJvoA16
tsGg3VtqRKMwH5p4x9MXqXEDg6DU8OHl8TWmehfR15vssA17So4=
=yJSI
-----END PGP SIGNATURE-----

--Q59ABw34pTSIagmi--