From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Reto Schöning <reto(dot)schoening(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: "could not accept SSPI security context" |
Date: | 2010-11-22 12:43:14 |
Message-ID: | AANLkTim9VD+7mrq=S4U2yLfPpC3WqujW7Lt9pA2vTNsX@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hmm. That's a simple SEC_E_LOGON_DENIED. Simply meaning
usedname/password is incorrect. The security eventlog on the server
(or domain controller) might have more information around it. If not,
I'm not sure what's wrong there - if it happens only in npgsql it must
be related to that. Or perhaps - based on your reproduction - the .net
app is running with a different user than you think?
//Magnus
On Mon, Nov 22, 2010 at 13:31, Reto Schöning <reto(dot)schoening(at)gmail(dot)com> wrote:
> Here's the log output for a failed connection:
> 2010-11-22 13:25:54 CET FATAL: could not accept SSPI security context
> 2010-11-22 13:25:54 CET DETAIL: The logon attempt failed
> (8009030c)
>
> 2010/11/22 Magnus Hagander <magnus(at)hagander(dot)net>
>>
>> Plase don't drop the mailinglist from the thread.
>>
>>
>> On Mon, Nov 22, 2010 at 11:57, Reto Schöning <reto(dot)schoening(at)gmail(dot)com>
>> wrote:
>> > Thanks for the hint. The full error message from npgsql including that
>> > detail row is
>> > Npgsql.NpgsqlException was unhandled
>> > Message="FATAL: XX000: could not accept SSPI security context"
>> > Source="Npgsql"
>> > ErrorCode=-2147467259
>> > BaseMessage="could not accept SSPI security context"
>> > Code="XX000"
>> > Detail="The logon attempt failed\r\n (8009030c)"
>> > ErrorSql=""
>> > File=".\\src\\backend\\libpq\\auth.c"
>> > Hint=""
>> > Line="648"
>> > Position=""
>> > Routine="pg_SSPI_error"
>> > Severity="FATAL"
>> > Where=""
>> > StackTrace:
>> > at
>> > Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
>> > in C:\projects\Npgsql2\src\Npgsql\NpgsqlState.cs:line 686
>> > at Npgsql.NpgsqlState.IterateThroughAllResponses(IEnumerable`1
>> > ienum)
>> > in C:\projects\Npgsql2\src\Npgsql\NpgsqlState.cs:line 319
>> > at Npgsql.NpgsqlState.ProcessBackendResponses(NpgsqlConnector
>> > context) in C:\projects\Npgsql2\src\Npgsql\NpgsqlState.cs:line 314
>> > at Npgsql.NpgsqlConnectedState.Startup(NpgsqlConnector context)
>> > in
>> > C:\projects\Npgsql2\src\Npgsql\NpgsqlConnectedState.cs:line 52
>> > at Npgsql.NpgsqlConnector.Open() in
>> > C:\projects\Npgsql2\src\Npgsql\NpgsqlConnector.cs:line 656
>> > at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection
>> > Connection) in
>> > C:\projects\Npgsql2\src\Npgsql\NpgsqlConnectorPool.cs:line
>> > 423
>> > at
>> >
>> > Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection
>> > Connection) in
>> > C:\projects\Npgsql2\src\Npgsql\NpgsqlConnectorPool.cs:line
>> > 226
>> > at
>> > Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection
>> > Connection) in
>> > C:\projects\Npgsql2\src\Npgsql\NpgsqlConnectorPool.cs:line
>> > 178
>> > at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection
>> > Connection) in
>> > C:\projects\Npgsql2\src\Npgsql\NpgsqlConnectorPool.cs:line
>> > 158
>> > at Npgsql.NpgsqlConnection.Open() in
>> > C:\projects\Npgsql2\src\Npgsql\NpgsqlConnection.cs:line 543
>> > at NpgsqlTest.Program.Main(String[] args) in C:\Documents and
>> > Settings\rsc\My Documents\Visual Studio
>> > 2005\Projects\NpgsqlTest\NpgsqlTest\Program.cs:line 17
>> > I found a way to reproduce the same message in psql: when creating a
>> > local
>> > user with the same name as a domain user, the connection attempt when
>> > logged
>> > in as that user fails with the same message (rightly so, of course).
>> > I've posted that in the npgsql forum also, no response yet.
>>
>> The details row you're looking for is in the *server* side log.
>>
>> --
>> Magnus Hagander
>> Me: http://www.hagander.net/
>> Work: http://www.redpill-linpro.com/
>
>
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2010-11-22 14:05:50 | Re: Fwd: Postgres forums ... take 2 |
Previous Message | Reto Schöning | 2010-11-22 12:31:08 | Re: "could not accept SSPI security context" |