Windows ODBC and a Router obstacle?

This is a multi-part message in MIME format.

------=_NextPart_000_0070_01CBDD90.FD02CF40
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

I am trying to connect to my PG 8.2 db server from MS Access from a remote
location.

I had configured PG to trust all connections from this location.

i.e. in PG_HBA.conf I added a line containing:
host all all ip-address/32 trust

(and restarted the server)

But I cannot get a connection.

Could there be a problem with the local router in this location? What
should I look for in the router set-up?

JPD657



------=_NextPart_000_0070_01CBDD90.FD02CF40
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable




charset=3Dus-ascii">
08.00.0681.000">

I am trying to =
connect to my PG 8.2 db FACE=3D"Calibri">server FACE=3D"Calibri">from MS Access FACE=3D"Calibri"> from FACE=3D"Calibri">a remote location.

I had =
configured PG =
to trust all connections from this location.

i.e. in =
PG_HBA.conf I =
added a line containing:

FACE=3D"Calibri">host    all    =
all    ip-address/32   trust

(and restarted =
the server)

But I cannot =
get a connection.

Could there be =
a problem with the local router in this location?  What should I =
look for in the router set-up?

FACE=3D"Calibri">JPD657

Re: Windows ODBC and a Router obstacle?

On 03/08/2011 10:01 AM, Joseph Doench wrote:
> I am trying to connect to my PG 8.2 dbserverfrom MS Accessfroma remote
> location.
>
> I had configured PG to trust all connections from this location.
>
> i.e. in PG_HBA.confI added a line containing:
>
> host all all ip-address/32 trust
>
> (and restarted the server)
>
> But I cannot get a connection.
>
> Could there be a problem with the local router in this location? What
> should I look for in the router set-up?
>
> JPD657
>

A couple of questions:

What does the Postgres log show when you try to connect?
Do you have another way to connect to the Postgres server from the
Access machine and have you tried it?
Specifically have you tried using psql to connect?


--
Adrian Klaver
adrian.klaver@gmail.com

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: Windows ODBC and a Router obstacle?

I see this in the PG log:

unexpected EOF on client connection
could not receive data from client: No connection could be made because the
target machine actively refused it.

JPD657


> I am trying to connect to my PG 8.2 dbserverfrom MS Accessfroma remote
> location.
>
> I had configured PG to trust all connections from this location.
>
> i.e. in PG_HBA.confI added a line containing:
>
> host all all ip-address/32 trust
>
> (and restarted the server)
>
> But I cannot get a connection.
>
> Could there be a problem with the local router in this location? What
> should I look for in the router set-up?
>
> JPD657
>

A couple of questions:

What does the Postgres log show when you try to connect?
Do you have another way to connect to the Postgres server from the
Access machine and have you tried it?
Specifically have you tried using psql to connect?


--
Adrian

--


--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: Windows ODBC and a Router obstacle?

On Tuesday, March 08, 2011 4:25:31 pm Joseph Doench wrote:
> I see this in the PG log:
>
> unexpected EOF on client connection
> could not receive data from client: No connection could be made because the
> target machine actively refused it.
>
> JPD657

So Access/ODBC is getting out but the Postgres server cannot get back to the
Windows machine. First I do not use Windows much any more, so my suggestions
will be general. I would start by taking a look at the Windows Firewall program
and see if is blocking incoming connections for non standard ports. What sort of
router are we talking about, home type(Netgear,Linksys,etc) or enterprise type?
I have not a home type block returning data from an established connection,
mainly because they are fairly open.

--
Adrian Klaver
adrian.klaver@gmail.com

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: Windows ODBC and a Router obstacle?

The router is a 'home' type... less than 2 or 3 years old... has 802.11n

I'll have to take a look into it tomorrow.



> I see this in the PG log:
>
> unexpected EOF on client connection
> could not receive data from client: No connection could be made because
the
> target machine actively refused it.
>
> JPD657

So Access/ODBC is getting out but the Postgres server cannot get back to the

Windows machine. First I do not use Windows much any more, so my suggestions

will be general. I would start by taking a look at the Windows Firewall
program
and see if is blocking incoming connections for non standard ports. What
sort of
router are we talking about, home type(Netgear,Linksys,etc) or enterprise
type?
I have not a home type block returning data from an established connection,
mainly because they are fairly open.

--
Adrian


--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: Windows ODBC and a Router obstacle?

--PGP_Universal_AFF6DAFA_2EDA38B8_F8876D99_12F20F01
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: QUOTED-PRINTABLE

Hi,

Is your router configured with NAT maybe? If yes, the source IP of your pac=
kets is the one of the router, not the remote location.

Try trusting everything from everywhere in your pg_hba.conf file, just to m=
ake sure it's a network problem...

------------------------------------------------------------ -
Attik System web : http://www.attiksystem.ch
Philippe Lang phone : +41 26 422 13 75
rte de la Fonderie 2 gsm : +41 79 351 49 94
1700 Fribourg twitter: @philippelang
pgp : http://keyserver.pgp.com=20


> -----Message d'origine-----
> De : pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-
> owner@postgresql.org] De la part de Joseph Doench
> Envoyé : mardi 8 mars 2011 19:02
> À : pgsql-odbc@postgresql.org
> Objet : [ODBC] Windows ODBC and a Router obstacle?
>=20
> I am trying to connect to my PG 8.2 db server from MS Access from a
> remote location.
>=20
> I had configured PG to trust all connections from this location.
>=20
> i.e. in PG_HBA.conf I added a line containing:
>=20
> host all all ip-address/32 trust
>=20
> (and restarted the server)
>=20
> But I cannot get a connection.
>=20
> Could there be a problem with the local router in this location? What
> should I look for in the router set-up?
>=20
> JPD657


--PGP_Universal_AFF6DAFA_2EDA38B8_F8876D99_12F20F01
Content-Type: application/pgp-signature; name="PGP.sig"
Content-Transfer-Encoding: 7BIT
Content-Disposition: attachment; filename="PGP.sig"

-----BEGIN PGP SIGNATURE-----
Version: 10.1.1 (Build 10)

iQEVAwUBTYi3S1Vut9/n/zM8AQhD/Qf/Z0WkXYeQbB4ZwqGgvDBh9shgWrCH fJMo
E6aUKk3XdLd8EIp72quHjabhS9nbdirjau2mwITQ9A+I4KA24N2t8vUk3ED6 Nk3k
b0lectB3JTwkp1J8I2ELTaOebdLf1M50jkrL3GZ6/tUaExLE+paAHY+klUor WZR/
CmsFk/uZpBh+yBIsGIFW1CLqdZ1kE7x04PngVmRcs1RyboplzuP4yDTQhdip 0J0o
SgmmhbryVyabIBL3u/n2TlhVGq/8MItprFxXI+yuJONaR437VMKIMsJYDVYK ySlS
vJIhxTkN0A6WpzeYr0z/1PByAnXV9VFYimJzffHBqQIk/aQp1bMFpA==
=gV0y
-----END PGP SIGNATURE-----

--PGP_Universal_AFF6DAFA_2EDA38B8_F8876D99_12F20F01--

Re: Windows ODBC and a Router obstacle?

Problem resolved.

DOH !

Overlooked a silly mistake - a firewall setting.

Thanks for you time,
JPD


-----Original Message-----
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.o=
rg] On Behalf Of Philippe Lang
Sent: Tuesday, March 22, 2011 10:51 AM
To: Joseph Doench; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Windows ODBC and a Router obstacle?

Hi,

Is your router configured with NAT maybe? If yes, the source IP of your pac=
kets is the one of the router, not the remote location.

Try trusting everything from everywhere in your pg_hba.conf file, just to m=
ake sure it's a network problem...

------------------------------------------------------------ -
Attik System web : http://www.attiksystem.ch
Philippe Lang phone : +41 26 422 13 75
rte de la Fonderie 2 gsm : +41 79 351 49 94
1700 Fribourg twitter: @philippelang
pgp : http://keyserver.pgp.com=20


> -----Message d'origine-----
> De : pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-=20
> owner@postgresql.org] De la part de Joseph Doench Envoyé : mardi 8=
=20
> mars 2011 19:02 À : pgsql-odbc@postgresql.org Objet : [ODBC] Windows=
=20
> ODBC and a Router obstacle?
>=20
> I am trying to connect to my PG 8.2 db server from MS Access from a=20
> remote location.
>=20
> I had configured PG to trust all connections from this location.
>=20
> i.e. in PG_HBA.conf I added a line containing:
>=20
> host all all ip-address/32 trust
>=20
> (and restarted the server)
>=20
> But I cannot get a connection.
>=20
> Could there be a problem with the local router in this location? What=20
> should I look for in the router set-up?
>=20
> JPD657



--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc