BUG #11204: Log reason for authentication failure

tony.locke@wessexwater.co.uk writes:

The following bug has been logged on the website:
Bug reference: 11204
Logged by: Tony Locke
Email address: tony.locke@wessexwater.co.uk
PostgreSQL version: 9.2.9
Operating system: Windows Server 2008
Description:

Hi, recently I couldn't work out why a user couldn't log in, and it turned
out that their role had expired. In the log, postgres merely said that the
log in had failed, but didn't give the reason. It would be really good if it
said in the log that it failed because the role had expired.

Already done for 9.4 and later.

http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=64e43c59b817a78ddf70f2fd62de31a4add5d988

regards, tom lane

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

That's awesome, thank you!

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: 18 August 2014 15:19
To: Tony Locke
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #11204: Log reason for authentication failure

tony.locke@wessexwater.co.uk writes:

The following bug has been logged on the website:
Bug reference: 11204
Logged by: Tony Locke
Email address: tony.locke@wessexwater.co.uk
PostgreSQL version: 9.2.9
Operating system: Windows Server 2008
Description:

Hi, recently I couldn't work out why a user couldn't log in, and it
turned out that their role had expired. In the log, postgres merely
said that the log in had failed, but didn't give the reason. It would
be really good if it said in the log that it failed because the role had expired.

Already done for 9.4 and later.

http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=64e43c
59b817a78ddf70f2fd62de31a4add5d988

regards, tom lane

__________________________________________________________
____________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
__________________________________________________________
____________

***********************************************************************************

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please contact the Wessex Water Support Centre

email :- support@wessexwater.co.uk

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com

***********************************************************************************

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs