Received: from orion3.ori-ind.com (IDENT:root@[206.81.197.190])
	by hub.org (8.9.3/8.9.3) with ESMTP id RAA65452
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 14 Sep 1999 17:47:34 -0400 (EDT) (envelope-from ken@ori-ind.com)
Received: from ken (stimpy.ori-ind.com [192.168.61.96])
	by orion3.ori-ind.com (8.8.7/8.8.7) with SMTP id PAA03167;
	Tue, 14 Sep 1999 15:14:59 -0700
Message-Id: <3.0.1.32.19990914144809.00a7d100@ori-ind.com>
X-Sender: ken@ori-ind.com
X-Mailer: Windows Eudora Pro Version 3.0.1 (32)
Date: Tue, 14 Sep 1999 14:48:09 -0700
To: Tom Lane <tgl@sss.pgh.pa.us>
From: "Ken J. Wright" <ken@ori-ind.com>
Subject: Re: [INTERFACES] firewall crashes backend 
Cc: pgsql-interfaces@postgreSQL.org
In-Reply-To: <1503.936831957@sss.pgh.pa.us>
References: <Your message of Wed, 08 Sep 1999 13:31:25 -0700
	<3.0.1.32.19990908133125.0095bb50@ori-ind.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

At 19:05 09/08/1999 -0400, Tom Lane wrote:
>"Ken J. Wright" <ken@ori-ind.com> writes:
>> When connecting to postgresql 6.5.1 through a socks5 firewall via ODBC, the
>> following error occurs:
>> ERROR: postmaster: StreamConnection: accept: No route to host
>> Then the backend crashes.
>
>Ken, here is a patch.  I can't test it very well since I don't have any
>easy way of provoking a failure at this stage of the connection.  Would
>you check it?
>
>Line numbers are for 6.5, but it should apply against current with a
>few lines' offset, if you are using current.
>
>			regards, tom lane
>
>
>*** src/backend/libpq/pqcomm.c.orig	Wed Jul  7 13:17:47 1999
>--- src/backend/libpq/pqcomm.c	Wed Sep  8 19:00:51 1999

Tom,

Yes! This did the trick. The postmaster stays up & spits out the proper
error. Thanks!!!

Ken