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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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 | Content-Type | Size |
---|---|---|
image/gif | 8.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Steve.Toutant | 2009-11-19 19:33:03 | Re: odbc access and pg_hba.conf |
Previous Message | Raymond O'Donnell | 2009-11-19 19:02:40 | Re: odbc access and pg_hba.conf |