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

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.

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

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