Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUG] SSPI authentication fails on Windows when server parameter is localhost or domain name - Mailing list pgsql-hackers

From Dave Page
Subject Re: [BUG] SSPI authentication fails on Windows when server parameter is localhost or domain name
Date
Msg-id BANLkTimjbg8qa+kS5dNqys8XzY8HP3FXGw@mail.gmail.com
Whole thread Raw
In response to [BUG] SSPI authentication fails on Windows when server parameter is localhost or domain name  (Ahmed Shinwari <ahmed.shinwari@gmail.com>)
Responses Re: [BUG] SSPI authentication fails on Windows when server parameter is localhost or domain name
List pgsql-hackers
Tree view 
On Wed, Jun 15, 2011 at 10:53 AM, Ahmed Shinwari
<ahmed.shinwari@gmail.com> wrote:
> Hi All,
>
> I faced a bug on Windows while connecting via SSPI authentication. I was
> able to find the bug and have attached the patch. Details listed below;
>
> Postgres Installer: Version 9.0.4
> OS: Windows Server 2008 R2/Windows 7
>
> Bug Description:
> =============
> If database Server is running on Windows ('Server 2008 R2' or 'Windows 7')
> with authentication mode SSPI and one try to connect from the same machine
> via 'psql' with server parameter as 'localhost' or 'fully qualified domain
> name', the database throws error;

I've been able to reproduce this issue, and the patch does indeed fix
it. One of our customers has also confirmed it fixed it for them.


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Small SSI issues
Next
From: Pavel Stehule
Date:
Subject: testing nested case-when scoping