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

Re: odbc access and pg_hba.conf

From: Steve(dot)Toutant(at)inspq(dot)qc(dot)ca
To: Adrian Klaver <aklaver(at)comcast(dot)net>
Cc: pgsql-odbc(at)postgresql(dot)org,pgsql-odbc-owner(at)postgresql(dot)org
Subject: Re: odbc access and pg_hba.conf
Date: 2009-11-19 19:26:32
Message-ID: OF3C873F9F.379019B0-ON85257673.0069A7F6-85257673.006ACCC8@ssss.gouv.qc.ca (view raw or flat)
Thread:
Lists: pgsql-odbc
ok, done with thesse xxx, yyy I'm on a private network so here is the real 
content of hba.conf
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

Also, please find attached the screenshot of the odbc config of the 
client.

In this ODBC config of the client, if I change the User Name to test 
instead of dbaInspq, I get this error
FATAL: no pg_hba.conf entry for host "10.2.195.53", user "test", database 
"geo", SSL off

10.2.195.53 is the ipaddress of the client, and it is not in pg_hba.conf

The client has winXP and he's using the ODBC driver to access postgres 
with SAS.
Another information, the database geo is a postgis database.

thanks for helping me!
Steve






Adrian Klaver <aklaver(at)comcast(dot)net> 
19/11/2009 02:00 PM

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











----- "Steve Toutant" <Steve(dot)Toutant(at)inspq(dot)qc(dot)ca> wrote:

> the first line is host all all 127.0.0.1/32 md5
> 
> So the full hba.conf is
> 
> host all all 127.0.0.1/32 md5
> host all dba xxx.xxx.xxx.xxx 255.255.255.0 md5
> host all dba yyy.yyy.yyy.yyy 255.255.254.0 md5
> 
> 
> 
> xxx.xxx.xxx.xxx is the ip address of the server running postgres
> 
> 
> 
> 

> >
> > Thanks for your help,
> > steve
> 
> 

In addition to what Richard said, what is the network that the client is 
running on?

Adrian Klaver
aklaver(at)comcast(dot)net




Attachment: odbcConfig.gif
Description: image/gif (8.0 KB) (inlined above)

In response to

Responses

pgsql-odbc by date

Next:From: Steve.ToutantDate: 2009-11-19 19:33:03
Subject: Re: odbc access and pg_hba.conf
Previous:From: Raymond O'DonnellDate: 2009-11-19 19:02:40
Subject: Re: odbc access and pg_hba.conf

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