Re: Please HELP ODBC connection problems

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