Re: odbc access and pg_hba.conf FIXED

Setting this line
host all dbaInspq 10.2.195.37/32 md5
Only allow this computer to access the DB and Block my other client
If I add this line
host all dbaInspq 10.2.195.53/32 md5

It works
So the problem was using a netmask, that specify all host with the IP
10.2.195.*

So, ODBC works! My config didn't.

Thanks for your help,
steve

Raymond O'Donnell <rod(at)iol(dot)ie>
19/11/2009 02:37 PM
Veuillez répondre à
rod(at)iol(dot)ie

A
Steve(dot)Toutant(at)inspq(dot)qc(dot)ca
cc
Adrian Klaver <aklaver(at)comcast(dot)net>, pgsql-odbc(at)postgresql(dot)org,
pgsql-odbc-owner(at)postgresql(dot)org
Objet
Re: [ODBC] odbc access and pg_hba.conf

On 19/11/2009 19:26, Steve(dot)Toutant(at)inspq(dot)qc(dot)ca wrote:
> ok, done with thesse xxx, yyy I'm on a private network so here is the
real
> content of hba.conf

That's more like it! :-) The more detail you can give, the easier it is
for people to help you.

> host all all 127.0.0.1/32 md5
> host all dbaInspq 10.2.192.247 255.255.255.0 md5
> host all dbaInspq 10.2.195.37 255.255.254.0 md5
>
> 10.2.192.247 is the server running postgres/postgis
> 10.2.195.37 is my computer

I'm no whizz at working out IP addresses and masks, but if all these
machines are on the same network then they should be sharing the same
network mark. You've got two different ones there - is that correct?

Only a wild guess, but this *might* be the root of your trouble.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie