Обсуждение: odbc access and pg_hba.conf

Thanks for your help,
steve

----- "Steve Toutant" <Steve.Toutant@inspq.qc.ca> 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
willtake precendence. 

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


Adrian Klaver
aklaver@comcast.net

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

  xxx.xxx.xxx.xxx is the ip address of the server running postgres

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

----- "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

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

Tél.: (418) 650-5115 #5281
Fax.: (418) 654-3144
steve.toutant@inspq.qc.ca
http://www.inspq.qc.ca

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

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