Thread: Please HELP ODBC connection problems
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
> -----Original Message----- > From: Peter Drahos [mailto:pdrahos@mediaone.net] > Sent: 07 October 2001 09:00 > To: pgsql-odbc@postgresql.org > Subject: [ODBC] Please HELP ODBC connection problems > > > Hello all, Hello, > 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??? That will probably not fix this problem. 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? Also, does netstat -a on the server indicate that a process is listening on port 5432? If not, try starting the postmaster with the -i option incase it's not picking up the default options for some reason. Regards, Dave.
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
> -----Original Message----- > From: Peter Drahos [mailto:pdrahos@mediaone.net] > Sent: 07 October 2001 16:02 > To: pgsql-odbc@postgresql.org > Cc: Dave Page > Subject: RE: [ODBC] 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 That looks OK to me. > >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 Again, that looks OK. > >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 Plenty of -i's there! > Any further help will be appreciated. Thank you to all who responded. I'm all out of suggestions I'm afraid - everything sounds just right. The only other thing I can think to suggest is that you didn't make any typos in the pgAdmin logon dialogue, but I assume you've already done this. One last thought, if you're on a network with other users, check that none of them have setup another machine using the same IP address as one of your machines. Regards, Dave.