Re: BUG #11204: Log reason for authentication failure

From: Tony Locke <Tony(dot)Locke(at)wessexwater(dot)co(dot)uk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #11204: Log reason for authentication failure
Date: 2014-08-18 14:27:50
Message-ID: C793905A6FE5C248A55553A7172812A7B15300@wxexcmbxoc01.wwcorp.ad.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

That's awesome, thank you!

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: 18 August 2014 15:19
> To: Tony Locke
> Cc: pgsql-bugs(at)postgresql(dot)org
> Subject: Re: [BUGS] BUG #11204: Log reason for authentication failure
>
> tony(dot)locke(at)wessexwater(dot)co(dot)uk writes:
> > The following bug has been logged on the website:
> > Bug reference: 11204
> > Logged by: Tony Locke
> > Email address: tony(dot)locke(at)wessexwater(dot)co(dot)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(at)wessexwater(dot)co(dot)uk

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

www.mimesweeper.com

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message justin.vanwinkle 2014-08-18 19:56:34 BUG #11207: empty path will segfault jsonb #>
Previous Message Tom Lane 2014-08-18 14:19:07 Re: BUG #11204: Log reason for authentication failure