Thread: PostgreSQL on Cobalt Raq and Cold Fusion on NT using ODBC?

Hi Everyone,

I've got PostgreSQL running on a Cobalt Raq3 (linux) and I'd like to be able
to access my databases via Cold Fusion running on NT but I can't seem to
connect. Here's what I've done:

Edit pg_hba.conf to allow remote NT host.
Added -i to allow postmaster to allow TCP connections.
Installed ODBC on NT and configured it to use PostgreSQL on raq.

This is the error I get:
ODBC Error Code = S1000 (General error)
Could not connect to the server; Could not connect to remote socket.

Any thoughts?

Thanks in advance,

Randy Smith
Tiger Mountain Technologies

forhire@lewiscounty.com (Randall Smith) writes:
> This is the error I get:
> ODBC Error Code = S1000 (General error)
> Could not connect to the server; Could not connect to remote socket.

> Any thoughts?

DNS problems?  Firewall packet filtering?  It sounds like you're never
getting as far as talking to the postmaster.

            regards, tom lane

The machines are on the same subnet, nearly side by side. I thought maybe I
could telnet into port 5432 but still no luck... it's as if postmaster isn't
taking tcp connections of any kind. Both machines have proper
forward/reverse dns and no packet filtering exists between them. How can I
verify postmaster is accepting tcp connections?

Randy Smith
Tiger Mountain Technologies

----- Original Message -----
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Randall Smith <forhire@lewiscounty.com>
Cc: <pgsql-general@postgresql.org>
Sent: Monday, September 25, 2000 1:06 PM
Subject: Re: [GENERAL] PostgreSQL on Cobalt Raq and Cold Fusion on NT using
ODBC?


> forhire@lewiscounty.com (Randall Smith) writes:
> > This is the error I get:
> > ODBC Error Code = S1000 (General error)
> > Could not connect to the server; Could not connect to remote socket.
>
> > Any thoughts?
>
> DNS problems?  Firewall packet filtering?  It sounds like you're never
> getting as far as talking to the postmaster.
>
> regards, tom lane
>
>

Did you start postmaster with the -i option?

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "Randall Smith" <forhire@lewiscounty.com>
To: <pgsql-general@postgresql.org>
Sent: Monday, September 25, 2000 4:51 PM
Subject: Re: [GENERAL] PostgreSQL on Cobalt Raq and Cold Fusion on NT using
ODBC?


> The machines are on the same subnet, nearly side by side. I thought maybe
I
> could telnet into port 5432 but still no luck... it's as if postmaster
isn't
> taking tcp connections of any kind. Both machines have proper
> forward/reverse dns and no packet filtering exists between them. How can I
> verify postmaster is accepting tcp connections?
>
> Randy Smith
> Tiger Mountain Technologies
>
> ----- Original Message -----
> From: Tom Lane <tgl@sss.pgh.pa.us>
> To: Randall Smith <forhire@lewiscounty.com>
> Cc: <pgsql-general@postgresql.org>
> Sent: Monday, September 25, 2000 1:06 PM
> Subject: Re: [GENERAL] PostgreSQL on Cobalt Raq and Cold Fusion on NT
using
> ODBC?
>
>
> > forhire@lewiscounty.com (Randall Smith) writes:
> > > This is the error I get:
> > > ODBC Error Code = S1000 (General error)
> > > Could not connect to the server; Could not connect to remote socket.
> >
> > > Any thoughts?
> >
> > DNS problems?  Firewall packet filtering?  It sounds like you're never
> > getting as far as talking to the postmaster.
> >
> > regards, tom lane
> >
> >
>

Try "netstat -nap" on the PostgreSQL box and see if the postmaster is
listening to requests at all.

HTH,
Poul L. Christiansen

Randall Smith wrote:
>
> The machines are on the same subnet, nearly side by side. I thought maybe I
> could telnet into port 5432 but still no luck... it's as if postmaster isn't
> taking tcp connections of any kind. Both machines have proper
> forward/reverse dns and no packet filtering exists between them. How can I
> verify postmaster is accepting tcp connections?
>
> Randy Smith
> Tiger Mountain Technologies
>
> ----- Original Message -----
> From: Tom Lane <tgl@sss.pgh.pa.us>
> To: Randall Smith <forhire@lewiscounty.com>
> Cc: <pgsql-general@postgresql.org>
> Sent: Monday, September 25, 2000 1:06 PM
> Subject: Re: [GENERAL] PostgreSQL on Cobalt Raq and Cold Fusion on NT using
> ODBC?
>
> > forhire@lewiscounty.com (Randall Smith) writes:
> > > This is the error I get:
> > > ODBC Error Code = S1000 (General error)
> > > Could not connect to the server; Could not connect to remote socket.
> >
> > > Any thoughts?
> >
> > DNS problems?  Firewall packet filtering?  It sounds like you're never
> > getting as far as talking to the postmaster.
> >
> > regards, tom lane
> >
> >

Thanks for everyone who helped. I'm making progress. A quick port scan
revealed that postmaster was running on 5583. I guess Cobalt in
non-standard. I can now talk to postmaster but I'm getting an authenication
error like:
ODBC Error Code = S1000 (General error)
The database does not exist on the server or user authentication failed.

I suspect that I need to review the permissions of the database but I'm
stuck again.

Thanks in advance,

Randy Smith
Tiger Mountain Technologies