From: | Peter Drahos <pdrahos(at)mediaone(dot)net> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Cc: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
Subject: | Re: Please HELP ODBC connection problems |
Date: | 2001-10-07 15:01:42 |
Message-ID: | 5.1.0.14.2.20011007104024.00ad50b0@pop.ne.mediaone.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hello again,
>What hostname/ip address are you specifying in the pgAdmin logon dialogue -
>is it definitely a match for one of your pg_hba.conf entries?
below is My pg_hba.conf and in the dialog box for Connect to Server
I am using server 192.168.0.5 port 5432 Username postgres
I have no password setup at this point.
As far as I understand the pg_hba.conf file my setting right now should let
all the connections in.
Please correct me if I am wrong. Tx
>Also, does netstat -a on the server indicate that a process is listening on
>port 5432?
[root(at)pdlap init.d]# netstat -a
I just cut out some of the lines from the netstat output
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0
*:1024 *:* LISTEN
tcp 0 0
*:sunrpc *:* LISTEN
tcp 0 0
*:http *:* LISTEN
tcp 0 0
*:x11 *:* LISTEN
tcp 0 0
*:ssh *:* LISTEN
tcp 0 0
*:postgres *:* LISTEN
tcp 0 0 localhost.mediaone:smtp
*:* LISTEN
tcp 0 0
192.168.0.5:ssh 192.168.0.2:1429 ESTABLISHED
tcp 0 256
192.168.0.5:ssh 192.168.0.2:1428 ESTABLISHED
udp 0 0
*:1024 *:*
udp 0 0
*:690 *:*
udp 0 0 *:sunrpc *:*
unix 2 [ ACC ] STREAM LISTENING 417288477 /tmp/.s.PGSQL.5432
unix 3 [ ] STREAM CONNECTED 417301504 /tmp/.s.PGSQL.5432
>If not, try starting the postmaster with the -i option incase
>it's not picking up the default options for some reason.
I believe that I am starting postmaster with -i settings config files and
and ps output below
[root(at)pdlap data]# more postmaster.opts
/usr/bin/postmaster '-D' '/var/lib/pgsql/data' '-i'
[root(at)pdlap data]# more postmaster.opts.default
-i
postgres 4625 0.0 1.0 5140 1304 pts/2 S 10:30 0:00
/usr/bin/postmaster -D /var/lib/pgsql/data -i
postgres 4645 0.0 1.0 3404 1324 pts/3 S 10:31 0:00 psql i-com
postgres 4646 0.0 2.6 6240 3324 pts/2 S 10:31 0:00 postgres:
postgres i-com [local] idle
Next suggestion was
>Go into postgresql.conf , uncomment the "tcpip_socket=false" line and set
>it to true
tcpip_socket was already set to true so I just uncommented the line.
Still no connection.
Any further help will be appreciated. Thank you to all who responded.
Peter
>*******************************************************************************************************
>Hello all,
>
>I have been trying to get this ODBC working already for some time with no
>success. I can ping the machine that is hosting the database I wrote some
>php tests to make sure I get some results and that works fine, but when I
>try to connect from my NT 4.0 machine I get Could not connect to the
>server; Could not connect to remote socket. Following is an error message
>from pgAdmin connecting.
>
>Can anybody please shed some light on this? Should I upgrade to the latest
>version of Postgresql???
>
>Thank you for your help.
>
>Peter
>
>10/7/01 3:40:35 AM - Error in pgAdmin II:frmConnect.cmdConnect_Click:
>-2147467259 - Could not connect to the server; Could not connect to remote
>socket.
>
>Win ODBC driver 7.01.00.07
>
>postgresql-7.1-1
>
>[root(at)pdlap data]# more postmaster.opts
>/usr/bin/postmaster '-D' '/var/lib/pgsql/data' '-i'
>[root(at)pdlap data]# more postmaster.opts.default
>-i
>
>My pg_hba.conf
># host all 192.168.0.0 255.255.255.0 trust
>local all trust
># host all 127.0.0.1 255.255.255.255 trust
>host all 0.0.0.0 0.0.0.0 trust
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2001-10-07 16:32:27 | Re: Please HELP ODBC connection problems |
Previous Message | Dave Page | 2001-10-07 09:04:47 | Re: Please HELP ODBC connection problems |