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

From Robert Haas
Subject Re: [BUG] SSPI authentication fails on Windows when server parameter is localhost or domain name
Date
Msg-id CA+Tgmoa3qu471-BytNn5sUKAhi+cv2nYQsHLzFpnvGbpt0c2Hg@mail.gmail.com
Whole thread Raw
In response to Re: [BUG] SSPI authentication fails on Windows when server parameter is localhost or domain name  (Thom Brown <thom@linux.com>)
List pgsql-hackers
On Fri, Jun 17, 2011 at 6:32 AM, Thom Brown <thom@linux.com> wrote:
> On 15 June 2011 12:16, Dave Page <dpage@pgadmin.org> wrote:
>> 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.
>
> I can confirm this affects versions back to 8.3.

Seems like we'd better try to get this committed before the next set
of minor releases (and ideally also before 9.1beta3).

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: testing nested case-when scoping
Next
From: "Albe Laurenz"
Date:
Subject: Re: Bug in SQL/MED?