Re: Connection error - Mailing list pgsql-general

From WA Pennant & Flag Displays - Darren
Subject Re: Connection error
Date
Msg-id 20050722095810.1FA59529B4@svr1.postgresql.org
Whole thread Raw
In response to Re: Connection error  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Thanks for your advice:

Do you get different messages with SSL disabled?
Yes - "Error connecting to the server: server closed the connection
unexpectedly.  This probably means the server terminated abnormally before
or while processing the request."
Can you connect with psql locally?
No
Can you connect with psql via localhost?
No

The program installed was a web excelerator.  I think the Windows Firewall
exceptions were turned off for PG and the program calling it.  They are now
on.

Will try the ethereal option.

All recommended Windows updates are installed.

Darren Meerwald
FlagDisplays.com
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Richard Huxton
Sent: Friday, 22 July 2005 15:31
To: Richard Sydney-Smith
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Connection error

Richard Sydney-Smith wrote:
> An associate is using Postgresql 8 on a windows xp system. The
> installation has been operating for several months and he has recently
> tried installing some software and postgresql has begun refusing
> connection " could not receive server response to SSL negotiation packet".
>
> Unfortunately he is unable to tell me what was done! We have tried
> turning off the firewall, opening connections to "trust" but so far have
> not been able to connect.

Do you get different messages with SSL disabled?
Can you connect with psql locally?
Can you connect with psql via localhost?

Quickest solution is probably to run ethereal on each end (I think
there's a Windows version) and see what messages are going back and
fore. I'd still suspect a firewall or client library problem.

--
   Richard Huxton
   Archonet Ltd

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.9.2/55 - Release Date: 21/07/05



pgsql-general by date:

Previous
From: Mario Guenterberg
Date:
Subject: Re: Connection error
Next
From: Richard Huxton
Date:
Subject: Re: Connection error