Re: Please HELP ODBC connection problems - Mailing list 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@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@pdlap data]# more postmaster.opts
/usr/bin/postmaster '-D' '/var/lib/pgsql/data' '-i'

[root@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@pdlap data]# more postmaster.opts
>/usr/bin/postmaster '-D' '/var/lib/pgsql/data' '-i'
>[root@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