Re: "could not accept SSPI security context" - Mailing list pgsql-general

From Ahmed Shinwari
Subject Re: "could not accept SSPI security context"
Date
Msg-id AANLkTikvcY7Sdwx+keizn9VJ=BVzWB0OR3gzfd8ONU38@mail.gmail.com
Whole thread Raw
In response to Re: "could not accept SSPI security context"  (Ahmed Shinwari <ahmed.shinwari@gmail.com>)
Responses Re: "could not accept SSPI security context"  ("Francisco Figueiredo Jr." <francisco@npgsql.org>)
Re: "could not accept SSPI security context"  (G_Hosa_Phat <jgamble@ciaokc.com>)
List pgsql-general
Hi Fransisco,

I tested the latest Npgsql driver (2.0.12.0), the issue has been fixed. I was able to connect Npgsql test application from my Windows XP client machine with the PostgreSQL server running on Windows 2003 Server.

Thank you for applying the patch.


On Thu, Feb 24, 2011 at 3:37 PM, Ahmed Shinwari <ahmed.shinwari@gmail.com> wrote:


On Sat, Feb 19, 2011 at 11:31 PM, Brar Piening <brar@gmx.de> wrote:
On Thu, 17 Feb 2011 07:58:46 -0800 (PST), Ahmed <ahmed.shinwari@gmail.com> wrote:
I tried changing that one line to use UTF-8 encoder, but the password packet
didn't get fixed. It works smoothly if kept in byte array instead of string.
Yes, as SSPI uses binary bytes we have to avoid to convert them to characters and back to bytes during message generation.

While "char *buffer" in C can serve as both a string and a buffer of binary bytes, we have "byte[]" as binary buffer and "string" as string in c#.
This is the reason why we need to use byte[] in all places where libpq uses char* without really caring whether there is a string inside or some opaque bytes.


I think changing the AuthenticationSSPI case to use context.Host may break
the cases Brar's mentioned.
If this isn't necessary to fix the problem we should probably get some more instight to what really happens here before fixing one end and breaking the other.
I agree.


For now, Francisco may check in that part which fixes the bug due to encoding. And, address the later issue after further investigation.

 

Regards,

Brar


pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: Re: Ad hoc report writer
Next
From: "Francisco Figueiredo Jr."
Date:
Subject: Re: "could not accept SSPI security context"