Thread: BUG #11204: Log reason for authentication failure
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. Thanks, Tony.
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
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 >=20 > 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: >=20 > > 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 ha= d expired. >=20 > Already done for 9.4 and later. >=20 > http://git.postgresql.org/gitweb/?p=3Dpostgresql.git&a=3Dcommitdiff&h=3D6= 4e43c > 59b817a78ddf70f2fd62de31a4add5d988 >=20 > regards, tom lane >=20 > __________________________________________________________ > ____________ > 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 Su= pport 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 ***************************************************************************= ********