Re: Remote Connection

Hi Bill

Thanks for answering.

The problem turned out to be the excessive permissions required in Windows 7
Firewall.

It appears to be working now.

Bob

-----Original Message-----
From: Bill Moran
Sent: Monday, January 10, 2011 5:55 AM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL] Remote Connection

In response to "Bob Pawley" <rjpawley(at)shaw(dot)ca>:

> Hi
>
> I am attempting to connect from two local interfaces to a remote database.
>
> With one interface (SharpMap developed in C#) I have no problems.
>
> With the other interface (Delphi) I have no problem connecting in design
> mode.
>
> However when I compile Delphi it just hangs, until timeout, without
> opening.
>
> The postgresql log follows. Can someone please interpret it for me?
>
> Bob
>
> 2011-01-07 09:03:55 PSTERROR: unrecognized configuration parameter
> "ssl_renegotiation_limit"
> 2011-01-07 09:03:55 PSTSTATEMENT: SET ssl_renegotiation_limit=0
> 2011-01-07 09:04:08 PSTLOG: could not receive data from client: No
> connection could be made because the target machine actively refused it.
>
>
> 2011-01-07 09:04:08 PSTLOG: unexpected EOF on client connection
> 2011-01-07 09:22:58 PSTLOG: could not receive data from client: No
> connection could be made because the target machine actively refused it.
>
>
> 2011-01-07 09:22:58 PSTLOG: unexpected EOF on client connection

What version of PostgreSQL are you using and what version does Delphi
think you're using? It seems to me that the Delphi IDE is connecting
differently than the app it compiles for you, and that said app is
trying to set a configuration parameter that doesn't exist, then aborting
when that fails.

Can't imagine what version you'd be using ... that option seems to have
been around since 8.0 at least.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/