Christian Ullrich wrote:
> The following bug has been logged online:
>
> Bug reference: 3750
> Logged by: Christian Ullrich
> Email address: chris@chrullrich.net
> PostgreSQL version: 8.3-beta2
> Operating system: Windows Server 2003
> Description: Invalid frontend message type 112
> Details:
>
> I'm running 8.3-beta2 (on WS2003, the client is XP Prof.) to experiment with
> SSPI auth against AD. There is a persistent problem when using SSPI:
> Authentication appears to work, but the connection fails at the first
> query.
>
> psql tells me about an "invalid frontend message type 112". Most of the
> time, that error comes as the first line of output from psql (above the
> "Welcome to" line), sometimes it is displayed later:
>
> Welcome to psql 8.3beta2, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> test=>
> test=> select 1;
> server closed the connection unexpectedly
> This probably means the server terminated abnormally before or while
> processing the request.
> The connection to the server was lost. Attempting reset: FATAL: invalid
> frontend message type 112
> Succeeded.
>
> When I use another authentication method, all is well.
>
> I can provide a network trace of the connection on request.
Strange, it's been running fine for me :-( Couple of questions:
Does it work if you run the client on the same machine as the server?
How's your AD set up - single domain, or multiple?
Do you get anything in the server logs (please check both eventlog and
the pg_log directory)
And yes, please send me a network trace off-list. (send the rest of the
responses on-list in case someone else has a good idea :-P)
//Magnus