Re: [BUG] SSPI authentication fails on Windows when server parameter is localhost or domain name

On Fri, Jun 17, 2011 at 6:32 AM, Thom Brown <thom(at)linux(dot)com> wrote:
> On 15 June 2011 12:16, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>> On Wed, Jun 15, 2011 at 10:53 AM, Ahmed Shinwari
>> <ahmed(dot)shinwari(at)gmail(dot)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