Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1swPWb-003euH-6B for pgsql-admin@arkaria.postgresql.org; Thu, 03 Oct 2024 17:22:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1swPWZ-000uCD-P4 for pgsql-admin@arkaria.postgresql.org; Thu, 03 Oct 2024 17:21:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1swPWZ-000uC4-Cy for pgsql-admin@lists.postgresql.org; Thu, 03 Oct 2024 17:21:59 +0000 Received: from mail-oa1-x2d.google.com ([2001:4860:4864:20::2d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1swPWV-002Ne0-Ap for pgsql-admin@lists.postgresql.org; Thu, 03 Oct 2024 17:21:58 +0000 Received: by mail-oa1-x2d.google.com with SMTP id 586e51a60fabf-2689e7a941fso669559fac.3 for ; Thu, 03 Oct 2024 10:21:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1727976114; x=1728580914; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=eYvnw23MPMF+fD8KkMu/G34wObsLuac23Fvm71Juq2U=; b=buFRMW84GGJEsdpekJr4U1FHebEaFY3UjpwkMrwniQl2i1hRnX8IK0jxwVHwXU2pEY +88DuHv6sxvV5XjO6EZQ9bfHP/qq8+U3NRY/alZRI1LKXfedGjiAnbnqGB0DLE/q1d9A 0F9E3U0YPqwbUom7THN4+PoCxAQ82NQfVhnlzkfAFTTtZtztldKtLrqCBGU2fSygKghS 06cAtxWcD6X2prnHZP5mDYPXeQz65L8GJ7YSDKx6XZc1BlYEECTxSYfODUplGb2X23Sj Eh0fQp0aT6x5eo9s/tjL4efarRT8rbNQrptfn8YYnpu711cKzCzaVsT19WN42tFxF/br wyZA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1727976114; x=1728580914; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=eYvnw23MPMF+fD8KkMu/G34wObsLuac23Fvm71Juq2U=; b=hpHn3/alD19jtSRSyyyn24lXRoNPL98znySGUrFzZ6cCk1QO7dbOQbYKTWUhGBIdWn iBtUt04oPyLrxJAZkz0fAZE2YwKUIaawT7DSjse+6lECXaMuik/GeiIzoIQmF0KLy3ko RiILAj5w53XzgGftCE6cp+PNi8Vo+jroI3iQx3WxMHmV1n3PzByzYnWiA4aNwDdR9H8O gaSa5rqIVkUXpBCy+/aQL3GaqsMi3MoCPc/xmicWssVJWLw0oh37MnE3FXyEJgKK19sw 6auk1vo/4o7HD+Jbyn1NSpep7exxKaWZ5iWUk3qSnnqkrFtLH99G0LfVXosbKs3FCfO4 vUkA== X-Gm-Message-State: AOJu0YzFUVvOJC1gj6USuIXhy5o30NlwUNpr2lIG3EiSYyldpELqXLNN GACKSW+FyFxK0kGppl660nJMib5Nt+jWxdWQBiLgXohjKUlOxMprWINkiYrjXAVgHV0Mvp68xDC 2A7D9Juw9UT5zYQlYDqjDxqrrWPB7Pj6k X-Google-Smtp-Source: AGHT+IFtlpAnVte/I8B+IBY490oImeDwdL2GX0X53H5cffmtDrE5GQHCQixjr9aTb9QQrD/M6YA2jLje3HLpYfWYxrE= X-Received: by 2002:a05:6871:e25b:b0:287:5003:c6f4 with SMTP id 586e51a60fabf-287c2300130mr84070fac.39.1727976113987; Thu, 03 Oct 2024 10:21:53 -0700 (PDT) MIME-Version: 1.0 From: Ron Johnson Date: Thu, 3 Oct 2024 13:21:43 -0400 Message-ID: Subject: Can't log in after password change To: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000746b03062395ca1e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000746b03062395ca1e Content-Type: text/plain; charset="UTF-8" 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=# ALTER ROLE "11026270" WITH PASSWORD 'blarge'; ALTER ROLE postgres=# select rolpassword from pg_authid where rolname='11026270'; rolpassword --------------------------------------------------------------------------------------------------------------------------------------- SCRAM-SHA-256$4096:x551tt4biKIvossG7VwbjA==$syOJXKLOFZ8/LHUxHq8rE5q5dCEDNzB5wgOAHq1vmdI=:q670pqidak6v8YjP9KCCWrRmfkkJSvyf/AL0Ydg1k/o= (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 "11026270" -- Death to , and butter sauce. Don't boil me, I'm still alive. crustacean! --000000000000746b03062395ca1e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
PG 14.13

Changed a user's expired p= assword from user "postgres", and now that user can't log in.=

I know it's something simple, but I just can&= #39;t see it.

Linux server:

$ ssh -q FISPCDSPGS401A grep 11026270 '$PGDATA'/pg_hba.co= nf
host =C2=A0 =C2=A0all =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 11026= 270 =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
<= br>$ psql -h FISPCDSPGS401A
=C2=A0keyword =C2=A0| =C2=A0 =C2=A0 value = =C2=A0 =C2=A0
----------+---------------
=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)

psql (16.4, se= rver 14.13)
Type "help" for help.

postgres=3D# ALTER RO= LE "11026270" WITH PASSWORD 'blarge';
ALTER ROLE
po= stgres=3D# select rolpassword from pg_authid where rolname=3D'11026270&= #39;;
=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>=C2=A0SCRAM-SHA-256$4096:x551tt4biKIvossG7VwbjA=3D=3D$syOJXKLOFZ8/LHUxHq= 8rE5q5dCEDNzB5wgOAHq1vmdI=3D:q670pqidak6v8YjP9KCCWrRmfkkJSvyf/AL0Ydg1k/o=3D=
(1 row)

Windows server:

C= :\Users\11026270>psql -h FISPCDSPGS401A postgres
Password for user 11= 026270:
psql: error: connection to server at "FISPCDSPGS401A" = (10.143.170.55), port 5432 failed: FATAL: =C2=A0password authentication fai= led for user "11026270"


--
Death to <Redacted>, and butter sauce.
Don't boil= me, I'm still alive.
<Redacted> crustacean!
--000000000000746b03062395ca1e--