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

Search Discussions

  • Bill Moran at Jan 10, 2011 at 1:55 pm

    In response to "Bob Pawley" <rjpawley@shaw.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.
  • Bob Pawley at Jan 10, 2011 at 4:21 pm
    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@shaw.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/

    --
    Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
    To make changes to your subscription:
    http://www.postgresql.org/mailpref/pgsql-general

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedJan 7, '11 at 6:52p
activeJan 10, '11 at 4:21p
posts3
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Bob Pawley: 2 posts Bill Moran: 1 post

People

Translate

site design / logo © 2021 Grokbase