Christian Ullrich wrote: > The following bug has been logged online: > > Bug reference: 3750 > Logged by: Christian Ullrich > Email address: [EMAIL PROTECTED] > 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
