From: | Charles Tassell <ctassell(at)isn(dot)net> |
---|---|
To: | "Stuart Grimshaw" <stuart(at)smgsys(dot)fsnet(dot)co(dot)uk> |
Cc: | "Postgres-General" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: ODBC |
Date: | 2000-05-29 17:47:29 |
Message-ID: | 4.2.0.58.20000529144629.00b35570@mailer.isn.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
If it's the connect is failing, have you checked to make sure you have
started postmaster with the -i option to allow TCP/IP connections?
At 02:21 PM 5/29/00, Tom Lane wrote:
>"Stuart Grimshaw" <stuart(at)smgsys(dot)fsnet(dot)co(dot)uk> writes:
> > I'm having a problem connecting to my Postgres server with ODBC.
> > When I try and connect I get the error :
>
> > Could not connect to the server;
> > Could not connect to remote socket
>
> > I'm using Postgres v7.0, and I've allowed my local network
> > (10.0.0.0/255.0.0.0) access through pg_hba.conf with :
>
> > host all 10.0.0.0 255.0.0.0 trust
>
> > the IP of the machine I'm connecting from is 10.0.0.2, so that's covered.
>
>That pg_hba.conf entry looks OK, but I suspect that you are not getting
>as far as having the postmaster consult that file. Looking at the code
>of our ODBC driver, I see that the error message "Could not connect to
>remote socket." is issued in only one place, namely if the connect()
>kernel call fails. That means that you are unable to open a channel to
>the postmaster at all, let alone try to be authenticated as an allowed
>host/user. I suspect network-level problems, or possibly specification
>of the wrong port number for the postmaster (though you say you checked
>that).
>
>Unfortunately the ODBC code neglects to notice exactly why the connect()
>call failed --- it'd be mighty useful here to know what errno code the
>kernel returned. I'd suggest trying it with a libpq-based client,
>which will include the kernel error code in its error message in this
>situation, or else altering the ODBC code to print out errno when it
>gets this failure. That'd give us something more to go on.
>
> regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Diego Schvartzman | 2000-05-29 19:21:20 | pg_dump |
Previous Message | Tom Lane | 2000-05-29 17:29:24 | Re: postdrv & 'query string to long' revisted |