public inbox for [email protected]
help / color / mirror / Atom feedCan't log in after password change
4+ messages / 3 participants
[nested] [flat]
* Can't log in after password change
@ 2024-10-03 17:21 Ron Johnson <[email protected]>
2024-10-03 17:34 ` Re: Can't log in after password change Laurenz Albe <[email protected]>
2024-10-03 21:48 ` Re: Can't log in after password change Casey <[email protected]>
0 siblings, 2 replies; 4+ messages in thread
From: Ron Johnson @ 2024-10-03 17:21 UTC (permalink / raw)
To: Pgsql-admin <[email protected]>
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 <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> crustacean!
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Can't log in after password change
2024-10-03 17:21 Can't log in after password change Ron Johnson <[email protected]>
@ 2024-10-03 17:34 ` Laurenz Albe <[email protected]>
2024-10-03 17:39 ` Re: Can't log in after password change Ron Johnson <[email protected]>
1 sibling, 1 reply; 4+ messages in thread
From: Laurenz Albe @ 2024-10-03 17:34 UTC (permalink / raw)
To: Ron Johnson <[email protected]>; Pgsql-admin <[email protected]>
On Thu, 2024-10-03 at 13:21 -0400, Ron Johnson 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=# 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"
Did you look at the error message in the server log?
What does it say?
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Can't log in after password change
2024-10-03 17:21 Can't log in after password change Ron Johnson <[email protected]>
2024-10-03 17:34 ` Re: Can't log in after password change Laurenz Albe <[email protected]>
@ 2024-10-03 17:39 ` Ron Johnson <[email protected]>
0 siblings, 0 replies; 4+ messages in thread
From: Ron Johnson @ 2024-10-03 17:39 UTC (permalink / raw)
To: Pgsql-admin <[email protected]>
On Thu, Oct 3, 2024 at 1:34 PM Laurenz Albe <[email protected]>
wrote:
> On Thu, 2024-10-03 at 13:21 -0400, Ron Johnson 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=# 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"
>
> Did you look at the error message in the server log?
> What does it say?
>
Expired password. I guess I assumed that the ALTER ROLE would nullify it.
And that psql would mention it.
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> crustacean!
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Can't log in after password change
2024-10-03 17:21 Can't log in after password change Ron Johnson <[email protected]>
@ 2024-10-03 21:48 ` Casey <[email protected]>
1 sibling, 0 replies; 4+ messages in thread
From: Casey @ 2024-10-03 21:48 UTC (permalink / raw)
To: Ron Johnson <[email protected]>; +Cc: Pgsql-admin <[email protected]>
😂
On Thu, Oct 3, 2024, 12:22 PM Ron Johnson <[email protected]> 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=# 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 <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> crustacean!
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2024-10-03 21:48 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-10-03 17:21 Can't log in after password change Ron Johnson <[email protected]>
2024-10-03 17:34 ` Laurenz Albe <[email protected]>
2024-10-03 17:39 ` Ron Johnson <[email protected]>
2024-10-03 21:48 ` Casey <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox