Skip site navigation (1) Skip section navigation (2)

Re: Please HELP ODBC connection problems

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 (view raw or flat)
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



pgsql-odbc by date

Next:From: Dave PageDate: 2001-10-07 16:32:27
Subject: Re: Please HELP ODBC connection problems
Previous:From: Dave PageDate: 2001-10-07 09:04:47
Subject: Re: Please HELP ODBC connection problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group