Thread: ODBC from win2k to postgres on Linux HELL

ODBC from win2k to postgres on Linux HELL

From
Eric Webber
Date:
ODBC from win2k to postgres on Linux HELL

I get the following error message:

 no pg_hba.conf entry for host 192.168.0.4 user postgres database gims_dev

despite the following line is in the pg_hba.conf file.

 host    all     192.168.0.4     255.255.255.255 trust

I restarted the server too.

Very frustrated...



________________________________________________
Get your own "800" number
Voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag


---- On Wed, 6 Mar 2002, Patrick Welche (prlw1@newn.cam.ac.uk) wrote:

> On Wed, Mar 06, 2002 at 12:30:20PM -0500, Eric Webber wrote:
> >
> > I just now added a line which reads:
> >
> > host all 192.168.0.0 255.255.255.0 trust
> >
> > do I have to restart the server ?
>
> At least kill -HUP it - can always restart to be on the safe side..
>
> > I believe I compiled with ODBC support, but how do I check
> > for sure ?
>
> I don't think you need to compile in ODBC support - what you installed
> is on the windoze box, and it talks directly to the postmaster..
>
> BTW remember the -i flag..
>
> Patrick
>
>


Re: ODBC from win2k to postgres on Linux HELL

From
Dave Page
Date:

> -----Original Message-----
> From: Eric Webber [mailto:streethockey@ureach.com]
> Sent: 06 March 2002 20:28
> To: Patrick Welche; pgsql-general@postgresql.org;
> pgsql-odbc@postgresql.org
> Subject: [ODBC] ODBC from win2k to postgres on Linux HELL
>
>
>
> ODBC from win2k to postgres on Linux HELL
>
> I get the following error message:
>
>  no pg_hba.conf entry for host 192.168.0.4 user postgres
> database gims_dev
>
> despite the following line is in the pg_hba.conf file.
>
>  host    all     192.168.0.4     255.255.255.255 trust
>
> I restarted the server too.
>
> Very frustrated...

Do you have any entries in the file _before_ this one that might reject your
connection? The entries are tried sequentially, so the first match will be
used.

Regards, Dave.

Re: ODBC from win2k to postgres on Linux HELL

From
Dave Page
Date:
[please keep replies on list]

> -----Original Message-----
> From: Eric Webber [mailto:streethockey@ureach.com]
> Sent: 06 March 2002 21:50
> To: Dave Page
> Subject: Re: RE: [ODBC] ODBC from win2k to postgres on Linux HELL
>
>
> these are my enrties
>
>
>
> local        all                                           trust
> host         all         127.0.0.1     255.255.255.255     trust
> host    all     192.168.0.4     255.255.255.255 trust

That looks OK. I did chat to one person recently who got in a mess because
his linux distribution had come with an older version of PostgreSQL
preinstalled, and unaware of this he had installed a new copy, but in a
different location - end result was; he had 2 data directories (and was
editting the wrong pg_hba.conf file) and 2 copies of the libraries and
binaries etc.

Could this be the case on your system?

Regards, Dave.

Re: [GENERAL] ODBC from win2k to postgres on Linux HELL

From
Jean-Michel POURE
Date:
Did you fix the problem? If not,
1) Which Linux distro do you use?
2) What is your PostgreSQL version?
/Jean-Michel POURE