Skip site navigation (1) Skip section navigation (2)

Re: odbc access and pg_hba.conf FIXED

From: Steve(dot)Toutant(at)inspq(dot)qc(dot)ca
To: rod(at)iol(dot)ie
Cc: Adrian Klaver <aklaver(at)comcast(dot)net>,pgsql-odbc(at)postgresql(dot)org,pgsql-odbc-owner(at)postgresql(dot)org
Subject: Re: odbc access and pg_hba.conf FIXED
Date: 2009-11-19 19:48:32
Message-ID: OFDA56D987.0F5E9000-ON85257673.006C8A09-85257673.006CD06E@ssss.gouv.qc.ca (view raw or flat)
Thread:
Lists: pgsql-odbc
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



In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2009-11-19 22:11:59
Subject: Re: declare/fetch problem with pgpool 2.2.3; Postgres 8.4; ODBC 8.03.04.00
Previous:From: Raymond O'DonnellDate: 2009-11-19 19:43:18
Subject: Re: odbc access and pg_hba.conf

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group