Search Postgresql Archives

Npgsql Integrated Authentication Problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi; 

I have set up a windows domain trying to run Postgres client using SSPI. I've reached a point that I can use psql to login from my client machine without specifying username and password. But everytime I ran my .NET client program on a domain computer other than the database server itself, I got following error messages. And the program works without error on the database server itself. Any help is much appreciated! 

Ying 

Message:FATAL: XX000: could not accept SSPI security context 
BaseMessage:could not accept SSPI security context 
Detail:The token supplied to the function is invalid 
 (80090308) 
Source:Npgsql 
TargetSite:Boolean MoveNext() 

My code is very simple: 

NpgsqlEventLog.Level = LogLevel.Debug; 
NpgsqlEventLog.LogName = "NpgsqlEventLog.txt"; 
NpgsqlConnectionStringBuilder pgsqlCSB = new NpgsqlConnectionStringBuilder(); 
pgsqlCSB.Database = "test"; 
pgsqlCSB.IntegratedSecurity = true; 
pgsqlCSB.Host = "VM-WIN2008"; 
pgsqlCSB.Port = 5432; 
NpgsqlConnection pgsqlConn = new NpgsqlConnection(pgsqlCSB.ConnectionString); 
pgsqlConn.Open(); 
DataTable dt = pgsqlConn.GetSchema(); 

More log message from NpgsqlEventLog.txt: 

3/20/2013 10:31:38 AM 1316 Debug Entering NpgsqlClosedState.Open() 
3/20/2013 10:31:38 AM 1316 Debug Attempt to connect to '192.168.73.141'. 
3/20/2013 10:31:38 AM 1316 Normal Connected to: VM-WIN2008:5432. 
3/20/2013 10:31:38 AM 1316 Debug Entering NpgsqlStartupPacket.NpgsqlStartupPacket() 
3/20/2013 10:31:38 AM 1316 Debug Entering NpgsqlStartupPacket.WriteToStream() 
3/20/2013 10:31:38 AM 1316 Debug Entering NpgsqlStartupPacket.WriteToStream_Ver_3() 
3/20/2013 10:31:38 AM 1316 Debug Entering PGUtil.WriteString() 
3/20/2013 10:31:38 AM 1316 Debug String written: user. 
3/20/2013 10:31:38 AM 1316 Debug Entering PGUtil.WriteString() 
3/20/2013 10:31:38 AM 1316 Debug String written: ylu. 
3/20/2013 10:31:38 AM 1316 Debug Entering PGUtil.WriteString() 
3/20/2013 10:31:38 AM 1316 Debug String written: database. 
3/20/2013 10:31:38 AM 1316 Debug Entering PGUtil.WriteString() 
3/20/2013 10:31:38 AM 1316 Debug String written: test. 
3/20/2013 10:31:38 AM 1316 Debug Entering PGUtil.WriteString() 
3/20/2013 10:31:38 AM 1316 Debug String written: DateStyle. 
3/20/2013 10:31:38 AM 1316 Debug Entering PGUtil.WriteString() 
3/20/2013 10:31:38 AM 1316 Debug String written: ISO. 
3/20/2013 10:31:38 AM 1316 Debug Entering NpgsqlState.ProcessBackendResponses() 
3/20/2013 10:31:38 AM 1316 Debug AuthenticationRequest message received from server. 
3/20/2013 10:31:38 AM 1316 Debug Entering NpgsqlStartupState.Authenticate() 
3/20/2013 10:31:38 AM 1316 Debug Entering NpgsqlPasswordPacket.NpgsqlPasswordPacket() 
3/20/2013 10:31:38 AM 1316 Debug Entering NpgsqlPasswordPacket.WriteToStream() 
3/20/2013 10:31:38 AM 1316 Debug Entering PGUtil.WriteBytes() 
3/20/2013 10:31:38 AM 1316 Debug Unable to find resource string Log_BytesWritten for class PGUtil 
3/20/2013 10:31:38 AM 1316 Debug AuthenticationRequest message received from server. 
3/20/2013 10:31:38 AM 1316 Debug Entering NpgsqlStartupState.Authenticate() 
3/20/2013 10:31:38 AM 1316 Debug Entering NpgsqlPasswordPacket.NpgsqlPasswordPacket() 
3/20/2013 10:31:38 AM 1316 Debug Entering NpgsqlPasswordPacket.WriteToStream() 
3/20/2013 10:31:38 AM 1316 Debug Entering PGUtil.WriteBytes() 
3/20/2013 10:31:38 AM 1316 Debug Unable to find resource string Log_BytesWritten for class PGUtil 
3/20/2013 10:31:38 AM 1316 Debug Entering PGUtil.ReadString() 
3/20/2013 10:31:38 AM 1316 Debug Get NpgsqlEventLog.LogLevel 
3/20/2013 10:31:38 AM 1316 Debug String read: FATAL. 
3/20/2013 10:31:38 AM 1316 Debug Entering PGUtil.ReadString() 
3/20/2013 10:31:38 AM 1316 Debug Get NpgsqlEventLog.LogLevel 
3/20/2013 10:31:38 AM 1316 Debug String read: XX000. 
3/20/2013 10:31:38 AM 1316 Debug Entering PGUtil.ReadString() 
3/20/2013 10:31:38 AM 1316 Debug Get NpgsqlEventLog.LogLevel 
3/20/2013 10:31:38 AM 1316 Debug String read: could not accept SSPI security context. 
3/20/2013 10:31:38 AM 1316 Debug Entering PGUtil.ReadString() 
3/20/2013 10:31:38 AM 1316 Debug Get NpgsqlEventLog.LogLevel 
3/20/2013 10:31:38 AM 1316 Debug String read: The token supplied to the function is invalid 
 (80090308). 
3/20/2013 10:31:38 AM 1316 Debug Entering PGUtil.ReadString() 
3/20/2013 10:31:38 AM 1316 Debug Get NpgsqlEventLog.LogLevel 
3/20/2013 10:31:38 AM 1316 Debug String read: src\backend\libpq\auth.c. 
3/20/2013 10:31:38 AM 1316 Debug Entering PGUtil.ReadString() 
3/20/2013 10:31:38 AM 1316 Debug Get NpgsqlEventLog.LogLevel 
3/20/2013 10:31:38 AM 1316 Debug String read: 1220. 
3/20/2013 10:31:38 AM 1316 Debug Entering PGUtil.ReadString() 
3/20/2013 10:31:38 AM 1316 Debug Get NpgsqlEventLog.LogLevel 
3/20/2013 10:31:38 AM 1316 Debug String read: pg_SSPI_error. 
3/20/2013 10:31:38 AM 1316 Debug ErrorResponse message from Server: could not accept SSPI security context. 
3/20/2013 10:31:38 AM 1316 Normal An NpgsqlException occured: FATAL: XX000: could not accept SSPI security context.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux