Thread: Windows ODBC connection trouble? ISP issue?
I have set up a pg database server for my organization on a cloud server using PG 8.2;
I am trying to provide connections to the db for some members using MS Access. I developed a small MS Access application using Windows ODBC – it works fine from my house.
I have this line in pg_hba.conf:
Host all mydbuserID 0.0.0.0/0 password
BUT… I cannot re-create the ODBC connection in our organization’s offices!
I have de-bugged by taking my laptop to the office – it will not connect to the db there – but is ok at my house.
(I have also checked 2 other locations with public wi-fi; could not connect from either of them)
This seems to be related to the ISP blocking data – I have ruled out the router in the office.
Is this a common SNAFU to encounter?
I spent an hour on the phone with tech support for the office’s ISP; the guy insisted it could not be a problem on their side!
Is there something I could be overlooking?
Any help or guidance would be greatly appreciated.
Regards,
JPD
On 03/17/11 2:29 PM, Joseph Doench wrote: > > I have setup a pg database server formy organizationon a cloud > serverusing PG 8.2; > > I am trying to provide connections to the db for somemembers using MS > Access. I developed a small MS Access application using Windows > ODBC–it works fine from myhouse. > > I havethisline in pg_hba.conf: > > Host all mydbuserID 0.0.0.0/0 password > > BUT…I cannot re-create the ODBC connection in our organization’s offices! > > I have de-bugged by taking my laptop to the office–it will not > connectto the db there–but is ok at my house. > > (I have also checked 2 other locations with public wi-fi; could not > connect from either of them) > > This seems to berelated to the ISP blockingdata–I have ruled out the > router in the office. > > is your home behind a home internet sharing router ? (this might be built into whatever 'modem' your ISP provided). is the Postgres port forwarded from the outside world to your server? in general if your home server is on a private local network address like 192.168.x.y or 10.x.y.z, then it can't be directly reached from the internet unless the internet gateway is configured to forward the service port in question from real.ip.addr:port to local.ip.addr:port (Postgres uses port 5432/tcp by default)
On Thursday, March 17, 2011 2:29:00 pm Joseph Doench wrote: > I have set up a pg database server for my organization on a cloud server > using PG 8.2; > > I am trying to provide connections to the db for some members using MS > Access. I developed a small MS Access application using Windows ODBC - it > works fine from my house. > > I have this line in pg_hba.conf: > > Host all mydbuserID 0.0.0.0/0 password > > BUT. I cannot re-create the ODBC connection in our organization's offices! > > > I have de-bugged by taking my laptop to the office - it will not connect > to the db there - but is ok at my house. > (I have also checked 2 other locations with public wi-fi; could not connect > from either of them) > > This seems to be related to the ISP blocking data - I have ruled out the > router in the office. When you say ISP do you mean the cloud provider or the service provider(s) from the various sites? I am assuming that that your home, office and the public Wi-Fi locations are not all using the same ISP. > > Is this a common SNAFU to encounter? My guess is that the firewall rules on your cloud server is only allowing connections from your home site. > > I spent an hour on the phone with tech support for the office's ISP; the > guy insisted it could not be a problem on their side! > > Is there something I could be overlooking? > > Any help or guidance would be greatly appreciated. > > > Regards, > > JPD -- Adrian Klaver adrian.klaver@gmail.com
My home ISP, our cloud server, and the office ISP are all separate entities. I infer that the problem is with the office ISP - DSL provided by a phone company. Regards, JPD -----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@gmail.com] Sent: Thursday, March 17, 2011 5:44 PM To: pgsql-general@postgresql.org Cc: Joseph Doench Subject: Re: [GENERAL] Windows ODBC connection trouble? ISP issue? On Thursday, March 17, 2011 2:29:00 pm Joseph Doench wrote: > I have set up a pg database server for my organization on a cloud server > using PG 8.2; > > I am trying to provide connections to the db for some members using MS > Access. I developed a small MS Access application using Windows ODBC - it > works fine from my house. > > I have this line in pg_hba.conf: > > Host all mydbuserID 0.0.0.0/0 password > > BUT. I cannot re-create the ODBC connection in our organization's offices! > > > I have de-bugged by taking my laptop to the office - it will not connect > to the db there - but is ok at my house. > (I have also checked 2 other locations with public wi-fi; could not connect > from either of them) > > This seems to be related to the ISP blocking data - I have ruled out the > router in the office. When you say ISP do you mean the cloud provider or the service provider(s) from the various sites? I am assuming that that your home, office and the public Wi-Fi locations are not all using the same ISP. > > Is this a common SNAFU to encounter? My guess is that the firewall rules on your cloud server is only allowing connections from your home site. > > I spent an hour on the phone with tech support for the office's ISP; the > guy insisted it could not be a problem on their side! > > Is there something I could be overlooking? > > Any help or guidance would be greatly appreciated. > > > Regards, > > JPD -- Adrian Klaver adrian.klaver@gmail.com
On Thursday, March 17, 2011 2:50:18 pm Joseph Doench wrote: > My home ISP, our cloud server, and the office ISP are all separate > entities. > > I infer that the problem is with the office ISP - DSL provided by a phone > company. But you could not connect from two Wi-Fi locations either, that tends to rule out the office ISP as root of problem. The common point in all the connections is the cloud server. You can connect from home but not any where else. Would seem to indicate that your cloud server(the server itself,not the Postgres server) is only taking connections from your home. > > > > Regards, > > JPD > -- Adrian Klaver adrian.klaver@gmail.com
I cannot think of any special reason why the cloud server would allow a connection from my home versus any other location. I will test another location or two. Regards, JPD -----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@gmail.com] Sent: Thursday, March 17, 2011 6:00 PM To: pgsql-general@postgresql.org Cc: Joseph Doench Subject: Re: [GENERAL] Windows ODBC connection trouble? ISP issue? On Thursday, March 17, 2011 2:50:18 pm Joseph Doench wrote: > My home ISP, our cloud server, and the office ISP are all separate > entities. > > I infer that the problem is with the office ISP - DSL provided by a phone > company. But you could not connect from two Wi-Fi locations either, that tends to rule out the office ISP as root of problem. The common point in all the connections is the cloud server. You can connect from home but not any where else. Would seem to indicate that your cloud server(the server itself,not the Postgres server) is only taking connections from your home. > > > > Regards, > > JPD > -- Adrian Klaver adrian.klaver@gmail.com
On Thursday, March 17, 2011 3:20:16 pm Joseph Doench wrote: > I cannot think of any special reason why the cloud server would allow a > connection from my home versus any other location. I do, it is called a firewall:) I would highly suggest checking what your firewall rules on your cloud server are. I use AWS and the rules are accessed from the Management Console as Security Groups as a for instance. > > I will test another location or two. > > > Regards, > -- Adrian Klaver adrian.klaver@gmail.com