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@iol.ie>
19/11/2009 02:37 PM
Veuillez répondre à rod@iol.ie
A
Steve.Toutant@inspq.qc.ca
cc
Adrian Klaver <aklaver@comcast.net>, pgsql-odbc@postgresql.org, pgsql-odbc-owner@postgresql.org
Objet
Re: [ODBC] odbc access and pg_hba.conf
On 19/11/2009 19:26, Steve.Toutant@inspq.qc.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@iol.ie