odbc access and pg_hba.conf

odbc access and pg_hba.conf

am 19.11.2009 19:25:31 von Steve.Toutant

Message en plusieurs parties au format MIME
--=_alternative 006536C185257673_=
Content-Type: text/plain; charset="US-ASCII"

Hi,
I installed the odbc driver (psqlodbc v08_03_0400) on a computer. I
configured the odbc connection and the connection test was succesfull.
That surprised me since this computer is not yet in my pg_hba.conf

Is the odbc driver supposed to "bypass" the pg_hba.conf?

I don't know much about the admin side of postgres. I don't know which
information could be useful to you.
Please ask for any information that would help

Here is the content of my pg_hba.conf
host all dba xxx.xxx.xxx.xxx 255.255.255.0 md5
host all dba yyy.yyy.yyy.yyy 255.255.254.0 md5


Thanks for your help,
steve
--=_alternative 006536C185257673_=
Content-Type: text/html; charset="US-ASCII"



Hi,

I installed the odbc driver (psqlodbc
v08_03_0400) on a computer. I configured the odbc connection and the connection
test was succesfull.

That surprised me since this computer
is not yet in my pg_hba.conf



Is the odbc driver supposed to "bypass"
the pg_hba.conf?



I don't know much about the admin side
of postgres. I don't know which information could be useful to you.

Please ask for any information that
would help



Here is the content of my pg_hba.conf

host        all
       dba        xxx.xxx.xxx.xxx
255.255.255.0        md5

host        all
       dba        yyy.yyy.yyy.yyy
255.255.254.0        md5




Thanks for your help,

steve
--=_alternative 006536C185257673_=--

Re: odbc access and pg_hba.conf

am 19.11.2009 19:48:30 von Adrian Klaver

----- "Steve Toutant" wrote:

> Hi,
> I installed the odbc driver (psqlodbc v08_03_0400) on a computer. I
> configured the odbc connection and the connection test was succesfull.
> That surprised me since this computer is not yet in my pg_hba.conf
>
> Is the odbc driver supposed to "bypass" the pg_hba.conf?
>
> I don't know much about the admin side of postgres. I don't know which
> information could be useful to you.
> Please ask for any information that would help
>
> Here is the content of my pg_hba.conf
> host all dba xxx.xxx.xxx.xxx 255.255.255.0 md5
> host all dba yyy.yyy.yyy.yyy 255.255.254.0 md5

Is this your entire pg_hba.conf? Remember the first match wins, so if there is a more permissive line above these it will take precendence.

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


Adrian Klaver
aklaver@comcast.net

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: odbc access and pg_hba.conf

am 19.11.2009 19:50:12 von Rod

On 19/11/2009 18:25, Steve.Toutant@inspq.qc.ca wrote:

> I installed the odbc driver (psqlodbc v08_03_0400) on a computer. I
> configured the odbc connection and the connection test was succesfull.
> That surprised me since this computer is not yet in my pg_hba.conf
>
> Is the odbc driver supposed to "bypass" the pg_hba.conf?

No, not at all - ODBC is client-side, while the pg_hba.conf file is
server-side.

> I don't know much about the admin side of postgres. I don't know which
> information could be useful to you.
> Please ask for any information that would help
>
> Here is the content of my pg_hba.conf
> host all dba xxx.xxx.xxx.xxx 255.255.255.0 md5
> host all dba yyy.yyy.yyy.yyy 255.255.254.0 md5

Are you sure that (a) the client machine's IP address doesn't match
these rules, and (b) there isn't another rule elsewhere in the file that
grants it access? Check also that the user as which you're connecting is
what you expect.

I know these are obvious things, but without further details it's hard
to tell what the problem is.

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: odbc access and pg_hba.conf

am 19.11.2009 19:51:54 von Steve.Toutant

Message en plusieurs parties au format MIME
--=_alternative 0067A13885257673_=
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="ISO-8859-1"

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




Adrian Klaver @postgresql.org=20
Envoy=E9 par : pgsql-odbc-owner@postgresql.org
19/11/2009 01:48 PM

A
Steve Toutant
cc
pgsql-odbc@postgresql.org
Objet
Re: [ODBC] odbc access and pg=5Fhba.conf









----- "Steve Toutant" wrote:

> Hi,
> I installed the odbc driver (psqlodbc v08=5F03=5F0400) on a computer. I
> configured the odbc connection and the connection test was succesfull.
> That surprised me since this computer is not yet in my pg=5Fhba.conf
>=20
> Is the odbc driver supposed to "bypass" the pg=5Fhba.conf?
>=20
> I don't know much about the admin side of postgres. I don't know which
> information could be useful to you.
> Please ask for any information that would help
>=20
> Here is the content of my pg=5Fhba.conf
> host all dba xxx.xxx.xxx.xxx 255.255.255.0 md5
> host all dba yyy.yyy.yyy.yyy 255.255.254.0 md5

Is this your entire pg=5Fhba.conf? Remember the first match wins, so if=20
there is a more permissive line above these it will take precendence.

>=20
>=20
>=20
>=20
> Thanks for your help,
> steve


Adrian Klaver
aklaver@comcast.net

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc




--=_alternative 0067A13885257673_=
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="ISO-8859-1"



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 tt>
is the ip address of the server running postgres










Adrian Klaver <akl=
aver@comcast.net>@postgresql.org


Envoy=E9 par : pgsql-odbc-owner@post=
gresql.org

19/11/2009 01:48 PM







A

Steve Toutant <Steve.Toutant@insp=
q.qc.ca>

cc

pgsql-odbc@postgresql.org

Objet

Re: [ODBC] odbc access and pg=5Fhba.=
conf




















----- "Steve Toutant" <Steve.Toutant@inspq.qc.ca> wrote:



> Hi,

> I installed the odbc driver (psqlodbc v08=5F03=5F0400) on a computer.
I

> configured the odbc connection and the connection test was succesfull.=


> That surprised me since this computer is not yet in my pg=5Fhba.conf r>
>

> Is the odbc driver supposed to "bypass" the pg=5Fhba.conf? r>
>

> I don't know much about the admin side of postgres. I don't know which=


> information could be useful to you.

> Please ask for any information that would help

>

> Here is the content of my pg=5Fhba.conf

> host all dba xxx.xxx.xxx.xxx 255.255.255.0 md5

> host all dba yyy.yyy.yyy.yyy 255.255.254.0 md5



Is this your entire pg=5Fhba.conf? Remember the first match wins, so if the=
re
is a more permissive line above these it will take precendence.



>

>

>

>

> Thanks for your help,

> steve





Adrian Klaver

aklaver@comcast.net



--

Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)

To make changes to your subscription:

http://www.postgresql.org/mailpref/pgsql-odbc








--=_alternative 0067A13885257673_=--

Re: odbc access and pg_hba.conf

am 19.11.2009 19:54:06 von Richard Broersma

On Thu, Nov 19, 2009 at 10:25 AM, wrote:

> Here is the content of my pg_hba.conf
> host =A0 =A0 =A0 =A0all =A0 =A0 =A0 =A0dba =A0 =A0 =A0 =A0xxx.xxx.xxx.xxx=
255.255.255.0 =A0 =A0 =A0 =A0md5
> host =A0 =A0 =A0 =A0all =A0 =A0 =A0 =A0dba =A0 =A0 =A0 =A0yyy.yyy.yyy.yyy=
255.255.254.0 =A0 =A0 =A0 =A0md5

There is one point that may or may not be the cause of your problem.
The pg_hba.conf file can be altered any way you want. But the changes
don't take affect until the PostgreSQL server reload the config files.

--=20
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: odbc access and pg_hba.conf

am 19.11.2009 19:57:42 von Steve.Toutant

Message en plusieurs parties au format MIME
--=_alternative 0068292585257673_=
Content-Type: text/plain; charset="US-ASCII"

I didn't modify the hba.conf yet.
The user has access without his IP address in it.

thanks!





Richard Broersma
19/11/2009 01:54 PM

A
Steve.Toutant@inspq.qc.ca
cc
pgsql-odbc@postgresql.org
Objet
Re: [ODBC] odbc access and pg_hba.conf








On Thu, Nov 19, 2009 at 10:25 AM, wrote:

> Here is the content of my pg_hba.conf
> host all dba xxx.xxx.xxx.xxx 255.255.255.0
md5
> host all dba yyy.yyy.yyy.yyy 255.255.254.0
md5

There is one point that may or may not be the cause of your problem.
The pg_hba.conf file can be altered any way you want. But the changes
don't take affect until the PostgreSQL server reload the config files.

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug




--=_alternative 0068292585257673_=
Content-Type: text/html; charset="US-ASCII"



I didn't modify the hba.conf yet.

The user has access without his IP address
in it.



thanks!











Richard Broersma <richard.broersma@gmail.com>

19/11/2009 01:54 PM







A

Steve.Toutant@inspq.qc.ca

cc

pgsql-odbc@postgresql.org

Objet

Re: [ODBC] odbc access and pg_hba.conf


















On Thu, Nov 19, 2009 at 10:25 AM,  <Steve.Toutant@inspq.qc.ca>
wrote:



> Here is the content of my pg_hba.conf

> host        all        dba
       xxx.xxx.xxx.xxx 255.255.255.0    
   md5

> host        all        dba
       yyy.yyy.yyy.yyy 255.255.254.0    
   md5



There is one point that may or may not be the cause of your problem.

The pg_hba.conf file can be altered any way you want.  But the changes

don't take affect until the PostgreSQL server reload the config files.



--

Regards,

Richard Broersma Jr.



Visit the Los Angeles PostgreSQL Users Group (LAPUG)

http://pugs.postgresql.org/lapug








--=_alternative 0068292585257673_=--

Re: odbc access and pg_hba.conf

am 19.11.2009 20:00:47 von Adrian Klaver

----- "Steve Toutant" 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@comcast.net

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: odbc access and pg_hba.conf

am 19.11.2009 20:02:40 von Rod

On 19/11/2009 18:51, Steve.Toutant@inspq.qc.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

And what's yyy.yyy.yyy.yyy?

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: odbc access and pg_hba.conf

am 19.11.2009 20:26:32 von Steve.Toutant

--=_mixed 006ACCC585257673_=
Content-Type: multipart/alternative; boundary="=_alternative 006ACCC585257673_="


--=_alternative 006ACCC585257673_=
Content-Type: text/plain; charset="US-ASCII"

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
19/11/2009 02:00 PM

A
Steve Toutant
cc
pgsql-odbc@postgresql.org, pgsql-odbc-owner@postgresql.org
Objet
Re: [ODBC] odbc access and pg_hba.conf











----- "Steve Toutant" 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@comcast.net




--=_alternative 006ACCC585257673_=
Content-Type: text/html; charset="US-ASCII"



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@comcast.net>

19/11/2009 02:00 PM







A

Steve Toutant <Steve.Toutant@inspq.qc.ca>

cc

pgsql-odbc@postgresql.org, pgsql-odbc-owner@postgresql.org

Objet

Re: [ODBC] odbc access and pg_hba.conf
























----- "Steve Toutant" <Steve.Toutant@inspq.qc.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@comcast.net








--=_alternative 006ACCC585257673_=--

--=_mixed 006ACCC585257673_=
Content-Type: image/gif; name="odbcConfig.gif"
Content-Disposition: attachment; filename="odbcConfig.gif"
Content-Transfer-Encoding: base64

R0lGODlhxgH+APcAAAAAAIAAAACAAICAAAAAgIAAgACAgMDAwMDcwKbK8AAA
AAAQiAAYoAAY0AAwmABI8ABQ4ABY4ABY6ABg8ABg+ABo+BhAoBhQuBhQwFiY
+GhwyGiA2GiI2GiI4HBoYHCQ4HCYwHCY4HhQMHiAqHiQ2HiY2HiY4Hig4IAA
AIBYEICg4ICo6IgwIIio6Iiw6JBAQJBoMJCISJCQcJhgAJiw6Ji46KC4yKio
mKjA0KjA2LDI4LjI4LjI8MDQ+MjY6NDY6NDY8NDg8NjYuNjg6Njg8Njg+ODY
yODo8Ojg0Ojo2Ojo8Ojw+PDo2PDo4PDw+Pj48P///wAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP/78KCgpICAgP8AAAD/
AP//AAAA//8A/wD//////yH5BAAAAAAALAAAAADGAf4AhwAAAIAAAACAAICA
AAAAgIAAgACAgMDAwMDcwKbK8AAAAAAQiAAYoAAY0AAwmABI8ABQ4ABY4ABY
6ABg8ABg+ABo+BhAoBhQuBhQwFiY+GhwyGiA2GiI2GiI4HBoYHCQ4HCYwHCY
4HhQMHiAqHiQ2HiY2HiY4Hig4IAAAIBYEICg4ICo6IgwIIio6Iiw6JBAQJBo
MJCISJCQcJhgAJiw6Ji46KC4yKiomKjA0KjA2LDI4LjI4LjI8MDQ+MjY6NDY
6NDY8NDg8NjYuNjg6Njg8Njg+ODYyODo8Ojg0Ojo2Ojo8Ojw+PDo2PDo4PDw
+Pj48P///wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAP/78KCgpICAgP8AAAD/AP//AAAA//8A/wD//////wj+ACUIFFih
oMGDCBMqXMiwocOHECNKnEixosWLGDNq3Mixo8ePGilUmDBhoASSJgdCEBih
ZYSBFEnKnEmzps2bOHPq3Mmzp8+fQIMKHUq0qNGjSJMqXYoypUsIUKNKnQrB
ZUoJB69q3cq1q9evYMOKHUu2rNmzaNOqXcu2rdu3Z13KhfrhCJS7ePPqhdIB
qtWxcgMLHky4sOHDiBMrXsy4sePHkCNLnky5suXLmJ9SpctERowYMEKLDi2i
9AsWIpD4bfl18ObXsGPLnk27tu3buHPr3s27t+/fwIMLHw4ciowbyGUo/8wc
NGkWL1a/9CqYuPXr2LNr3869u/fv3aH+xEB+Q/ny5qNPV2UNNjD49/Djy59P
v7592+KTn3c+GoYI9VWF5d59BBZooHAhHKjggrpBAYN5Rogn2guhQSGEaSz4
lVcRLmw1YHBA3FVEVCcUIeIJUN0lGw9Q8BAVFDVIpSIEIUIxYopQUBWCiTai
CEFeQLyIlxNBRlXjEi5MBWRsSywhXA05+mYXVDueiONdRf44ZJY03oVkij5O
VeONDJapoIPm4RUahSLghSFUEty1gAZKwEhdBFD14ERvdplQAhREpKjEBXRC
8YGWC8Rm4hBCtiDkAn3+GSiiSi5xwQJDGIqoBk5EKecCOUBxBI4mMDCED0pC
MWensC2hhAP+wYnKgG93zQqFpZhqKiennqoKqqikmooqBFNOFSmgsOlp5rLg
oelZDGpWeBdq/2W4kpwSrADFnndqCetuckLFwAU9QEEDrFD+QClseF1wpY9y
hgvBuOvmaS6sJ0ChbrjprnsXuVDsMCsEF2Ago6oQ9PuaA9/6BqUO7vYmZ7nn
QpDvvgj3K++/5QoMVcEQsLhDqonOGzFVdzXM7MrYOYiemnixIHO108lZUsoS
BHFXEALVsMS2K8SJF1R23doDjkDs2SUURXaqblSdlvyjExjIu5kL20IBAo4/
KIHjAk6TLFXUL1K9sdkIl+sE2FCMwC7CUxuM5Z5D/4xivk7WmOX+3FSFuLWW
nY6a8M9O+FjiXcXKSXaKaJe8bdVpb8u221NhLTjU+oqJ5ZW94ohj4CyHfpvL
zEnrpsyoZyiQzRc7EGIONjAtNAdK6HCtr3apAAKwQuNwrs46xA6EBFBuW8Pq
qg6UMrZbdRzw7QsocYTQCxTvxPHIL2AS80I7wPzyeuHgPcJbfQ+FA71XLCeU
I5eLQ4jBM42j7ypDsLicOsh/1wa1Q/XzDgsIV7zg5q2NnW8v4rPawU6WsLtc
DyrwE97XEiVAhOFPfqLLYGwcBIPSma40IkhBClCnPFWd4GcagBwFc9SprcGK
etTT0gViSKm7YEACdblLDmCYPe5d5Wf+I4CC16gXAqZhK4dQ2CEPs1fCACaP
ep/aARQY5cOUmE978oKhiga4whtmcXtPxJYNWwgBWGnLgsnjYhOvGMUpIkor
VUTiDivoxTCm8Y5YhMIN4cLHPvpxKw8I5ANkJIIOfsZ0dymNCEfIghKKqAQO
mIDNarWCThUhaDBsIdaUkEftCS0vDBDI0uwHBQ0IpIhrqyIYnThDbGGNeaNc
ogSiprxUJk9bnDQfBmhZvlsKsZNNlEC5fhAwBuwllKrkoRihwIBK2ihorwSm
4p4YJ1tqD5dO9OQYqbnKq4zymMrEoxaZ+cdymtOPggwkFCg0GphB4QkhXGQj
s7eABdywAnL+wqeqSpI/KJzEZmcU1QguIMl9FrSeCJ1Jrdx3Ehb9YHwLuEnx
8GKDg5KERQYlSa0sKhOdVXQC7IPoBER2AZsdVGc4wInNSGpRJmYALxpAFEKB
eZUrwhAC/YTAGaWpKo/2LGAQlQBJr4hSOHITjMb0FULDyVOanvOpUFWLIKHA
gnbeRTR4kec8D4qQEOGgYw44Qg8oUCuyqooCPwNBPW9o1gVQgAIdY9FYg7AE
CmjrB27dFgQy0KmYyumtgAUsSheAg8z99a0mWgBd7aqvvJ4VsC/1GlrRuABt
LWGFbtXZEBbwUieEgAJFCEJg22rZRLUVsIfVGV6FGTC5vvWwo/3+mVvb6lAG
iNWsDKBAp3JwWjlFFgKTxWxpEUUBzXJ2W58NLWo5GdjF3nUBcYXCWE+r27YV
z7ELqO1ot8vd7nr3u+ANr3jHS97ydncg6qyq6fqT1RnI7CRc7SqWEoXRJYwg
txgFbV6cwAPqUgCjTiCBTosGBNOuoGhQKAEy9TLavu5Vr7ClACcPPF/gRtiu
dbIRB3I7pB6My6x4KTAG7EoEL9EAuKh1oIcv8NrHUhdrW3srgAXs3+ZqrcWd
KnDIvHRfDGftrFDi7QoyXIQNg9gJKwbxfEe8ghLf6sQUwNoPWAxYCjPNtDMG
bn7/K6K/OvDKKDavmMdM5jKbecxxQk3+aITAwdGkwEIzcG8ATiKSeioEAvWE
QEEiUE+C7rmeK8hBPYMIhQhUwM4GKeMCLDCBkWBgAbAyyAQwoIGANfrQM10A
QiwQ0ZEsGtMIuYCjIa3ngiD6IBO4lD0vjVALlBrT9Yx0QSbdZ6wcpNWvBrVB
Ti0B7SXaAYtmtaYTAiUcYEVOnC41nxfg55FcKp8VkIADDJ3qtQp70a+eqaxH
zWyssMgGuR71thXN6D8POwLAfrSm5QTsMJ/53fCOt7zDS1U194c0i4wzCwJA
EpFwxC4uqEC5XrWRDBATCiBJuMIXXhAnHMHQ0IZIxBlekCOszdYJnzjFN85x
j3C33i8Aocj+45mCOMtZJh3JQI2cEARmdwTPw+64zGeukEpiQJ8xf4jGGe4E
E1iA4TunudCHvpDtHuE0qUu6CJPeyH77WyMTIHe4iU71qsfk57qOyKk5Xm6G
b93qYJ85dzOABKQzPekBCAALjDAQlIf97XA/yLznTve62/3ueM/7uyXw0r34
HXEZWI9J3M4QvRv+8IhPvOIXz/jGOx6wAnlA5NNJ+cqnswEazLzmN8/5zr8H
854PvehHT/rSUyUJqE+96lfP+ta7/vWwj73sZ0/72tv+9rjPve53z/ve+/73
wA++8IdP/OIb//jIT77yl8/85jv/+dCPvvSnT/3qW//62M++9rf+z/3ue//7
4A+/+MdP/vKb//zoT7/618/+9rv//fCPv/znT//62//++M+//vfP//77//8A
GIACOIAEWIAGeIAImIAKuIAM2IAO+IAQGIESOIEUWIEWeIEYmIEauIEc2IEe
+IEgGIIiOIIkWIImeIIomIIquIIs2IIu+IIwGIMyOIM0WIM2eIM4mIM6uIM8
2IM++INAGIRCOIREWIRGeIRImIRKuIRM2IRO+IRQGIVSOIVUWIVWeIVYmIVa
uIVGSB5e+IVgGIZiOIZkWIZmeIZomIZquIZfCAVcqIE34AFyOId0WId2eId4
mId6uId82Id++IeAGIhN4IZviIFx+Hf+iJiIiriIjNiIjviIkBiJiDiIBsiG
lniJmJiJYUiIAniIkviJoBiKojiKoUiJBRiHgZiKqriKrJiHptiJHkCKsjiL
tFiLkPiKA+iJtriLvDiJnIh8ABCMAOB7w/h6xVh7nggAiKiMesGMvfiM0EiL
uAiL0ViNuziNxneMxyh822h7ybiMe+GM1jiO5LiI2Ph7wtiNuCeMyaeL5fiO
kXiOxLeN6kiMuveNfyeOd6GP8NiP5CiPvaeNxhh7Anl87piI4piQeKGQC+mP
nwiQ3Kh62hiMqUeRqMeOSUCRw5iOF7mRHVmMG6mOySiMC0mSUBCM+3iSzmiS
yoiSJ6mSJcn+jC3Jjw5ZkxC5e/ToevUokcx3kODYkCq5kiu5jy5Zk494k8CX
kxlZkUu5lAIJkk3plBcZlSE5laqHjy85lDIJky+ZFzOZki7Zkg0ZlkZZllCA
lLmnlBlpkWxpkUzJehj5lCDplhi5ej6Zj16Zl0QJlClplo2Ilvb4lukIlVYp
mFTZlB45lQWZelgpln05lI9Jklo5lpTZl37pj4B5e2rJlOrYjXX5lJxZmIkZ
lYwZi0EplCjJkJbpmKp5mYmYmbynlPVImIYJmlKpmG9ZmqvZlby5lWBZmVkJ
nI7Jm675jrBZe2rJkRPplqtHm6OZmJ7JkXZpmpMJloOpl8FJnDT+WZx5cZy6
t5i2+ZyIeZhQaZukmQSN2ZtdOZzsqZ7VmZ3EyZ3j6J2zJ5uheZit55zkWZj8
yXrp+Z7aCZTDGZ/y2Z2/eHzSWZF0uZxWGZJ0iZhsmZuoN5JFmY57qZ6n6Z4C
SpaWWaDWSJ+yB573uZj4GZ7QeZ/niZ7UKZwBypdCiZ0eaqDpt5O4d5cxeqOy
CKIEWZcfSZgJ+pESuaC3uZYM6p8r+ptI2qGQyZUdiqM6Sn00ens2iqNUCopP
Cn8UipoDqpqtuZ0FeqXtN6VVOqZHeaABiJXhSKY5aqb+J6Zq+qa+WIlHGpNe
CqeOCKbsdwNNsKd82qd++qeAGqiCOqj+hFqohnqoiJqoioqnYWqadtqLjKp+
jzqpjiinlMqLkVqILaini9qpnvqpoOqnbKqpQHip0EiqqFqFmriqrNqqrvqq
yDGqqcqAqNiKtnqruJqrukqHmTqr9+empmqWieoBveqr9QeswWqUg8iIcVis
6Aer0Bqtayir+4esyeqQaNms1Mp/tbqr3vqtf+is5Wet19qP2Uqs21qtjlqu
oiiu5HeXA4qXMMqu7ZquKuqu47qu9PqQ9vqr+tqkP8mX+1qK9qqt0/ejyBl8
5Dqwfoev+cmcn6mTzRmisQevjaiPdcqwjHiuDgt7JDqx+amw/6qxf9mvSWmY
DSqxPEmQFbv+rhYqk6hJlBxqkiRbsgo6mKXZsQMpoSsLlyJbs/FosujosyAL
lxNJsbCni5PpmyzankBrjr+IszkrtMOXnG0JpERapGt5s623sE+rszybojsp
pFibtWWrm7vJtBm6tBb6tIo4jTx6r1QbkWE7mijqmeP5sSpKpzIbkzULtlwb
uCmKmyeKm4Z7nkrLohr6mxnrtjJatFN7sD2rnDcrnmZLlQi7t4sLn417qYAL
uSkbsh6pn3IZt4nLuEnank7ruH/HsXMbfPZpuOZpueP5ev/5sgK7r5/bsyhL
tD56t4M7oS4rmRe6tizZt6wbp7JnsNInorILvOGJn1c5p/G6pAP++7kFmb0q
+7uHS7vCm7zw6LoHG7fSOZca+ZlxqbXTm7aKy7C7y6PoC79FG7/ma6Tga5wF
i66WKrMwG7Mku7vb57X3O4pNkIb6e4r/2rkaC8DaJ8ADHIqC+Lrzl6UPfBcM
nH2cGqoavMEc3MEdLMHy58D/C8LvV8Exur8m/LjG+oMZ7MEu/MKJSsIrrIIp
jIgzfMM4nMM6vMM83MM+/MNAHMRCPHzSWsRGLIYyHKZHbIlJLIXdCq5QHMV1
eMHY98RS7IdU3IMivMBNvH5bfI1d3IJx+7M1jBdZbH1fbItnfIF6+3tprLth
nH5vLI1xrIJR6sYu65VF6bdpysdBGY7+e7yebfuhdfx8Uiul1DnIvVmhgVyv
RjibV5u9VzudyIuhu+nH78mlJdnHhMx+m0m0lEygXJnJs7jGbPygz9u9g+uO
S7qd/NjKzSivTAqw0GjKOMm7oLy+otzIGFvKhcyC5quRI0q59uuiuXvMsDyv
AhqfCuzLnryy6bu1oTzI8crMzpyEtCmatRu2mnvJu+x3CUmzory54/yMtvyd
5TuiXUu9STrL5SyJ5zyB2nu40mu3aOvNryzL2OnKy3zM0RjP6wjKhRvKeam2
3rymRwi/ESqhcbnO+5y7XkqTBi2w1/nOkPrLzdeZ6lzMBa3I66nGGK2ErGzM
/kzS8BnL4Fz+0rUc0sun0ak8zRTNviCdwyPNx/2bmjDKkrh7mpqMv89stPpJ
0OK8yDfdzFBL0yNbwQD9fHN8zTfc1OW61M4H1aQo1TNI1clq1T2Z1ObK0kiI
1cGq1csH1gRL0zB81mg9qF4dfi2c1jGcw2XsdwQon0Nc13Z913id13q913wN
gkv810a81n2NwFdc2FEs1oPtfmTtuYL9fYD92NDa2BC42Ixo1D6di4ad2d+K
2LCLy7T3ybxH2Yto2eXI2cgn2o9q2kPLzSHaxveYwBZN2pzMnaptfKhtp7Ud
kJ5dn66dez5ZzSgdirI9n5LdfbcNp7kdm5NbpBC7zelblWd7z8D+qc+fONyd
DH2HrHwiydUDnNy3jLLiibfZnMre+738m6HIu5WMfN78a93VyMCgnY3FLJb0
HZz1fd/2nd9U6t3fObmVa8/lWbm166DMad6kXNAXypqb28iXCd+7XXzbbdLJ
bMkT7qTFDaW8O95425Ha/LtR+p8bitMYCssv+qUXzp/1y+Eqzr3RfLm6jN8w
nt8xXt/7feLNC82qvOHSHL1DGuELvrjJnMnu/c82nt3PG+B5u9Epetxvyt/o
DLHMDbnLWbgpDtOpC+SVqbqbbOLRB8kL3eFSyeNLzt336+Qh7KgvS7M7DZlh
qeYe7ZoOPr8MTbg97twcXcZmHn+iHdH+Q77SXS7QSW7n+ym90l3DeY6lZC6K
fO6hcd6cLS7N9fzlmcvkanro70fpZGrpoZ3oyavpjRrXFmzjGMzprOvpeerW
qO7Wol7FpO64pr5+oK4XBIjpY/rqiR3AqZ7rMLzqt55/sZ4XvR7swj7sxF7s
xn7syJ7syr7szN7szv7s0B7t0j7t1F7t1n7t2J7t2r7t3N7t3v7t4B7u4j7u
5F7u5n7u6J7u6r7u7N7u7v7u8B7v8j7v9F7v9n7v+O5+mZvL+S6E8R28/Q6E
/37HAR9+ZOoBq92g0Zzi0A3pBV99Z6nroRqHyAiGcz7o4Y3kxQjZHN/xHv/x
SByBZ/muCE/+ezewFxcfvbPLn7/e8ntx8iLfBCSPjKMau7cZ3rlJ8HYN8xA4
8uNH8SZf8zh+5NDbn3zN8w/o8+IH9LOH9EA95cMc1AXe107fgErP1iXf9EKr
881e9Qx49Zq570Sc9cu79dru9QsI9gH92ZtO8+uO9gqo9pqZsLvH9GX/9rw+
fnJve9F5tA6PyG6v7nCfgHtP92A+pL5N9hWb91TP+AYv88r939pc94qftI6/
14OPgIXP9tw83oAf9Hgf87qd84H+2oGf7pl/gJtfn47u9wC/vJVvu5ev16lv
gKs/6qeP7rVfgLfP6rmveqYa+0kQ/K13rcLPmLPvfb1/fXa/+K7+F/ES/8LN
n3rQH/0ePP3Db/1ojf1Xmfzdt/xofPz+Oarg733cX/7GHfvo79jij57ez33r
L33c37XkD/leLPzx38Dqb/+N6vw9z/8AkUTgQIIFDR5EmFDhwBseFhK8AQUh
lCYPLV7EmDFJw4kVNX4EmZGjQYohTZ5cODJhRJQtXb5MCOXGTJo1bd7EmVPn
Tp0OL7I8WBLmUIwqCwolmlSh0YFIlT5FyNQgUKhVrQ70kFXrVq5dvX4FG1Zs
UYlBPR4EkBbA1ZNSBTr9qHatwLkF6yK8q9Et3Lx5k8q1m3bgXb9uIZZlm1jx
4qdUj541WNfvYMZTfZKErJEwXbQLJ//+vEyQr12rkilzTiIYNcTQBx1Xhh1b
9lLEjxNu7jzbMNyMk317Nrk3s+rUn2Hi9ku8cOuptWc/hw77ddPMBHEXn6ta
7WDJ2ilrV07cckeTv7HT3Y4+e3DmSfh2574+fHfwfa2v/o5foGGGzqP/BxCq
6d6q7jT9UkOQNPny42y9Bg0saLcCL8rOO9NMu8+4h4RTEMHkitNvrQshvC49
Dw/kbz//AmSxRZQGdG/CBFcDjD4HZxSRwb4Ac629GMu778QHUauRPbM6zFG9
JBMsskEe8fuQyRkZ8rE/F6/EMiQYeSORRim9xDHMGw8c78iQkBOTQSFB4jBI
B0cccs0lSYP+kEjuylxpxZbk4rNPP/8ENFBB+1QICkMPRTRRRRdltFFHHa2y
OfLwMhBOS9ME8cYlP5MQSPTi3BRTNtsb7Us45RS1xEppXC4lPVEC4FFZZ6V1
Vg80pKgJXXfltVdffwU2WGF/TTFCPblUMjDvsKswvjs3nW8lH5GlULA367Nx
Sr1IHY5OZsP8NlwTk7VOuSBZc1WpWIdlt113h20IVxlZLPawSbNMadp58d2P
26s0hKlYGGGlFsB4C93X4EiNvZffqPR1eCl/1R23KoFfPWldfg+OKeH/6rXS
zIh7bHhkdDEzWeJ0/yr441sRjhhkFUtOeSOIaz7ZNpzxjArj8lr+jo5jmq+U
eaNjPc6y0537FXlppmlTF2i0xLP45Y57q9hTi4reEmkslV66TaefzjNqr1e9
SuimgavzzKIWtjconuamu267c5r2br335psmUvsGPHC6Fx44Y6m9TUxtlCn8
622yEBIrcsknpzwsyCvHPHPNtzpoc88/p3xlojTWbGpN1RtVXox8s5A+Z7VV
+Sefx6a9dqsK//ns1zsE9SPFdbZIQxEX7B3gnDec3Xbll3cJ9zMPp5TcJPn0
3eqho1c21B23M57Kx5kHP/yAk48L+twwnL4t69dWKEpU7Tt3Q7hDFr9++/Ui
XzPzwcQQXNjlVx3j1KS9Af7vYd+7XwLbFdgzs4FkXE8iDNVAE8BqzSdU50Gd
AUkmuwV20INGayC+fica3cmGa/n7YAp35jwH7k8661vcxuY3MxXWEHwsLF8J
KzNC6sRshiC0YRBth0P96ZAxPCSQDxEoRCauEIWrc+EOYQg8Ef5QcFfEYha1
uEUudtGLgXsihWTyRS5OkYRKvEit1LhGNrbRjW+EYxzlOEc6ulFdoMMj5nBF
Ri/+sIl/BGR8BjVIQhYSUArJYyJDF0hGNtKRj4RkJCU5SUpW0pKXxGQmNblJ
TnbSk58EZShFOUpSltKUBwkIADs=

--=_mixed 006ACCC585257673_=
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

--=_mixed 006ACCC585257673_=--

Re: odbc access and pg_hba.conf

am 19.11.2009 20:33:03 von Steve.Toutant

Message en plusieurs parties au format MIME
--=_alternative 006B65BE85257673_=
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="ISO-8859-1"

I I remove this line the client doesn't have access.
host all dbaInspq 10.2.195.37 255.255.254.0 md5

But I don't understand why. Maybe because of 255.255.254.0

I probably misunderstood the option I should put in this hba.conf

what do you think?
thanks
steve

Steve Toutant, M. Sc.
Analyste en g=E9omatique
Secteur environnement
Direction de la sant=E9 environnementale et de la toxicologie
Institut national de sant=E9 publique du Qu=E9bec
945, avenue Wolfe
Qu=E9bec, Qc G1V 5B3=20
T=E9l.: (418) 650-5115 #5281
Fax.: (418) 654-3144
steve.toutant@inspq.qc.ca
http://www.inspq.qc.ca
=20




Adrian Klaver =20
19/11/2009 02:00 PM

A
Steve Toutant
cc
pgsql-odbc@postgresql.org, pgsql-odbc-owner@postgresql.org
Objet
Re: [ODBC] odbc access and pg=5Fhba.conf











----- "Steve Toutant" wrote:

> the first line is host all all 127.0.0.1/32 md5
>=20
> So the full hba.conf is
>=20
> 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
>=20
>=20
>=20
> xxx.xxx.xxx.xxx is the ip address of the server running postgres
>=20
>=20
>=20
>=20

> >
> > Thanks for your help,
> > steve
>=20
>=20

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

Adrian Klaver
aklaver@comcast.net




--=_alternative 006B65BE85257673_=
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="ISO-8859-1"



I I remove this line the client does=
n't
have access.

host        all
       dbaInspq        10.2.195.37
255.255.254.0        md5



But I don't understand why. Maybe be=
cause
of 255.255.254.0



I probably misunderstood the option
I should put in this hba.conf



what do you think?

thanks

steve



Steve Toutant, M. Sc. ont size=3D3>

Analyste en g=E9omatique

Secteur environnement

Direction de la sant=E9 environnementale et de la toxicologie

Institut national de sant=E9 publique du Qu=E9bec

945, avenue Wolfe

Qu=E9bec, Qc G1V 5B3

T=E9l.: (418) 650-5115 #5281

Fax.: (418) 654-3144

 =3Dblue>steve.toutant@inspq.qc.ca lue>

 >http://www.inspq.qc.ca

 










Adrian Klaver <akl=
aver@comcast.net>

19/11/2009 02:00 PM







A

Steve Toutant <Steve.Toutant@insp=
q.qc.ca>

cc

pgsql-odbc@postgresql.org, pgsql-odb=
c-owner@postgresql.org

Objet

Re: [ODBC] odbc access and pg=5Fhba.=
conf
























----- "Steve Toutant" <Steve.Toutant@inspq.qc.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@comcast.net








--=_alternative 006B65BE85257673_=--

Re: odbc access and pg_hba.conf

am 19.11.2009 20:37:50 von Rod

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

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: odbc access and pg_hba.conf

am 19.11.2009 20:43:18 von Rod

On 19/11/2009 19:37, Raymond O'Donnell wrote:

> network mark. You've got two different ones there - is that correct?

Whoops - s/mark/mask/

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: odbc access and pg_hba.conf FIXED

am 19.11.2009 20:48:32 von Steve.Toutant

Message en plusieurs parties au format MIME
--=_alternative 006CD06E85257673_=
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="ISO-8859-1"

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=20
10.2.195.*

So, ODBC works! My config didn't.

Thanks for your help,
steve






Raymond O'Donnell =20
19/11/2009 02:37 PM
Veuillez r=E9pondre =E0
rod@iol.ie


A
Steve.Toutant@inspq.qc.ca
cc
Adrian Klaver , pgsql-odbc@postgresql.org,=20
pgsql-odbc-owner@postgresql.org
Objet
Re: [ODBC] odbc access and pg=5Fhba.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=20
real=20
> 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
>=20
> 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.

--=20
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie




--=_alternative 006CD06E85257673_=
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="ISO-8859-1"



Setting this line

host        all
       dbaInspq        10.2.195.37/=
32
               
       md5

Only allow this computer to access t=
he
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. ont>



Thanks for your help,

steve













Raymond O'Donnell <=
;rod@iol.ie>

19/11/2009 02:37 PM




Veuillez r=E9pondre =
=E0

rod@iol.ie









A

Steve.Toutant@inspq.qc.ca

cc

Adrian Klaver <aklaver@comcast.ne=
t>,
pgsql-odbc@postgresql.org, pgsql-odbc-owner@postgresql.org

Objet

Re: [ODBC] odbc access and pg=5Fhba.=
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








--=_alternative 006CD06E85257673_=--