Message-ID: <3b111b08b49a9ba4ccc70f3638a366ad721eea6e.camel@cybertec.at>
Subject: Re: Can't log in after password change
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Ron Johnson <ronljohnsonjr@gmail.com>, Pgsql-admin
	 <pgsql-admin@lists.postgresql.org>
Date: Thu, 03 Oct 2024 19:34:09 +0200
In-Reply-To: 
 <CANzqJaChJ74uKN8Qsd+zfxH-89dZQxfkGBR6rhLoCSaYtoCU-A@mail.gmail.com>
References: 
	<CANzqJaChJ74uKN8Qsd+zfxH-89dZQxfkGBR6rhLoCSaYtoCU-A@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.4 (3.52.4-1.fc40) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/3b111b08b49a9ba4ccc70f3638a366ad721eea6e.camel%40cybertec.at>
Precedence: bulk

On Thu, 2024-10-03 at 13:21 -0400, Ron Johnson wrote:
> PG 14.13
>=20
> Changed a user's expired password from user "postgres", and now that user=
 can't log in.
>=20
> I know it's something simple, but I just can't see it.
>=20
> Linux server:
>=20
> $ ssh -q FISPCDSPGS401A grep 11026270 '$PGDATA'/pg_hba.conf
> host =C2=A0 =C2=A0all =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 11026270 =
=C2=A0 =C2=A0 =C2=A0 =C2=A010.176.64.0/22 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0scram-sha-256
>=20
> $ psql -h FISPCDSPGS401A=20
> =C2=A0keyword =C2=A0| =C2=A0 =C2=A0 value =C2=A0 =C2=A0=20
> ----------+---------------
> =C2=A0database | postgres
> =C2=A0user =C2=A0 =C2=A0 | postgres
> =C2=A0host =C2=A0 =C2=A0 | 10.143.170.55
> =C2=A0port =C2=A0 =C2=A0 | 5432
> (4 rows)
>=20
> psql (16.4, server 14.13)
> Type "help" for help.
>=20
> postgres=3D# ALTER ROLE "11026270" WITH PASSWORD 'blarge';
> ALTER ROLE
> postgres=3D# select rolpassword from pg_authid where rolname=3D'11026270'=
;
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 rolpa=
ssword =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0
> -------------------------------------------------------------------------=
--------------------------------------------------------------
> =C2=A0SCRAM-SHA-256$4096:x551tt4biKIvossG7VwbjA=3D=3D$syOJXKLOFZ8/LHUxHq8=
rE5q5dCEDNzB5wgOAHq1vmdI=3D:q670pqidak6v8YjP9KCCWrRmfkkJSvyf/AL0Ydg1k/o=3D
> (1 row)
>=20
> Windows server:
>=20
> C:\Users\11026270>psql -h FISPCDSPGS401A postgres
> Password for user 11026270:
> psql: error: connection to server at "FISPCDSPGS401A" (10.143.170.55), po=
rt 5432 failed: FATAL: =C2=A0password authentication failed for user "11026=
270"

Did you look at the error message in the server log?
What does it say?

Yours,
Laurenz Albe