MIME-Version: 1.0
References: 
 <CANzqJaChJ74uKN8Qsd+zfxH-89dZQxfkGBR6rhLoCSaYtoCU-A@mail.gmail.com>
In-Reply-To: 
 <CANzqJaChJ74uKN8Qsd+zfxH-89dZQxfkGBR6rhLoCSaYtoCU-A@mail.gmail.com>
From: Casey <kcj.knite@gmail.com>
Date: Thu, 3 Oct 2024 16:48:20 -0500
Message-ID: 
 <CAOWpV65KjSNZKL9iemFTKrydiHuwoRwLQ7L0ZbhQz65nVhUxkg@mail.gmail.com>
Subject: Re: Can't log in after password change
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000000d85270623998415"
Archived-At: 
 <https://www.postgresql.org/message-id/CAOWpV65KjSNZKL9iemFTKrydiHuwoRwLQ7L0ZbhQz65nVhUxkg%40mail.gmail.com>
Precedence: bulk

--0000000000000d85270623998415
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

=F0=9F=98=82

On Thu, Oct 3, 2024, 12:22 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:

> PG 14.13
>
> Changed a user's expired password from user "postgres", and now that user
> can't log in.
>
> I know it's something simple, but I just can't see it.
>
> Linux server:
>
> $ ssh -q FISPCDSPGS401A grep 11026270 '$PGDATA'/pg_hba.conf
> host    all             11026270        10.176.64.0/22
>  scram-sha-256
>
> $ psql -h FISPCDSPGS401A
>  keyword  |     value
> ----------+---------------
>  database | postgres
>  user     | postgres
>  host     | 10.143.170.55
>  port     | 5432
> (4 rows)
>
> psql (16.4, server 14.13)
> Type "help" for help.
>
> postgres=3D# ALTER ROLE "11026270" WITH PASSWORD 'blarge';
> ALTER ROLE
> postgres=3D# select rolpassword from pg_authid where rolname=3D'11026270'=
;
>                                                               rolpassword
>
>
> -------------------------------------------------------------------------=
--------------------------------------------------------------
>
>  SCRAM-SHA-256$4096:x551tt4biKIvossG7VwbjA=3D=3D$syOJXKLOFZ8/LHUxHq8rE5q5=
dCEDNzB5wgOAHq1vmdI=3D:q670pqidak6v8YjP9KCCWrRmfkkJSvyf/AL0Ydg1k/o=3D
> (1 row)
>
> Windows server:
>
> C:\Users\11026270>psql -h FISPCDSPGS401A postgres
> Password for user 11026270:
> psql: error: connection to server at "FISPCDSPGS401A" (10.143.170.55),
> port 5432 failed: FATAL:  password authentication failed for user "110262=
70"
>
>
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> crustacean!
>

--0000000000000d85270623998415
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">=F0=9F=98=82=C2=A0</div><br><div class=3D"gmail_quote"><d=
iv dir=3D"ltr" class=3D"gmail_attr">On Thu, Oct 3, 2024, 12:22 PM Ron Johns=
on &lt;<a href=3D"mailto:ronljohnsonjr@gmail.com">ronljohnsonjr@gmail.com</=
a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 =
0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr">PG 1=
4.13<div><br></div><div>Changed a user&#39;s expired password from user &qu=
ot;postgres&quot;, and now that user can&#39;t log in.</div><div><br></div>=
<div>I know it&#39;s something simple, but I just can&#39;t see it.</div><d=
iv><br></div><div>Linux server:<br><br><font face=3D"monospace">$ ssh -q FI=
SPCDSPGS401A grep 11026270 &#39;$PGDATA&#39;/pg_hba.conf<br>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=A0<a href=3D"http://10.176.64.0/22" target=3D"_blank" rel=3D"norefe=
rrer">10.176.64.0/22</a> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0sc=
ram-sha-256<br><br>$ psql -h FISPCDSPGS401A <br>=C2=A0keyword =C2=A0| =C2=
=A0 =C2=A0 value =C2=A0 =C2=A0 <br>----------+---------------<br>=C2=A0data=
base | postgres<br>=C2=A0user =C2=A0 =C2=A0 | postgres<br>=C2=A0host =C2=A0=
 =C2=A0 | 10.143.170.55<br>=C2=A0port =C2=A0 =C2=A0 | 5432<br>(4 rows)<br><=
br>psql (16.4, server 14.13)<br>Type &quot;help&quot; for help.<br><br>post=
gres=3D# ALTER ROLE &quot;11026270&quot; WITH PASSWORD &#39;blarge&#39;;<br=
>ALTER ROLE<br>postgres=3D# select rolpassword from pg_authid where rolname=
=3D&#39;11026270&#39;;<br>=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 rolpassword =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<br>--------------------------------------------=
---------------------------------------------------------------------------=
----------------<br>=C2=A0SCRAM-SHA-256$4096:x551tt4biKIvossG7VwbjA=3D=3D$s=
yOJXKLOFZ8/LHUxHq8rE5q5dCEDNzB5wgOAHq1vmdI=3D:q670pqidak6v8YjP9KCCWrRmfkkJS=
vyf/AL0Ydg1k/o=3D<br>(1 row)<br></font><br>Windows server:<br><br><font fac=
e=3D"monospace">C:\Users\11026270&gt;psql -h FISPCDSPGS401A postgres<br>Pas=
sword for user 11026270:<br>psql: error: connection to server at &quot;FISP=
CDSPGS401A&quot; (10.143.170.55), port 5432 failed: FATAL: =C2=A0password a=
uthentication failed for user &quot;11026270&quot;</font><br></div><div><br=
 clear=3D"all"><div><br></div><span class=3D"gmail_signature_prefix">-- </s=
pan><br><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_=
signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<di=
v>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; cru=
stacean!</div></div></div></div></div></div></div>
</blockquote></div>

--0000000000000d85270623998415--