Bad error message on valuntil - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Bad error message on valuntil
Date
Msg-id 51B22ACC.60600@commandprompt.com
Whole thread Raw
Responses Re: Bad error message on valuntil
List pgsql-hackers
Hello,

I had a customer pulling their hair out today because they couldn't 
login to their system. The error was consistently:

2013-06-07 08:42:44 MST postgres 10.1.11.67 27440 FATAL:  password
authentication failed for user "user

However the problem had nothing to do with password authentication. It 
was because the valuntil on the user had been set till a date in the 
past. Now technically if we just removed the word "password" from the 
error it would be accurate but it seems it would be better to say, 
"FATAL: the user "user" has expired".

Sincerely,

Joshua D. Drake


-- 
Command Prompt, Inc. - http://www.commandprompt.com/  509-416-6579
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
For my dreams of your image that blossoms   a rose in the deeps of my heart. - W.B. Yeats



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Redesigning checkpoint_segments
Next
From: Tom Lane
Date:
Subject: Re: ALTER DEFAULT PRIVILEGES FOR ROLE is broken