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

Re: Can't connect Win XP client to Linux server

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Geoff Lane <geoff(at)gjctech(dot)co(dot)uk>
Cc: PostgreSQL ODBC <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Can't connect Win XP client to Linux server
Date: 2009-05-19 20:12:42
Message-ID: 4A1312BA.5040601@iol.ie (view raw or flat)
Thread:
Lists: pgsql-odbc
On 19/05/2009 20:48, Geoff Lane wrote:
> I can telnet onto the server and run the psql client in a telnet
> session as the user I'm trying to connect as. I suspected I needed to
> tweak the server to permit connections from remote clients but had no
> idea how to do that other than set listen_addresses = '*' in

Yes, that's exactly it - it listens only on localhost out of the box.

> postgresql.conf. Having done that, I got another error message telling
> me there wasn't an entry in pg_hba.conf. So to that file, I added the
> line:

That trips most people new to Postgres. :-)

>     host  all  all  192.168.42.0/24  md5
> and after rebooting the server got the error:
>   FATAL: password authentication failed for user "geoff"
> I changed "md5" to "password" and rebooted the server but to no avail.
> However, connection was successful when I changed "password" to
> "trust" - but I'm uneasy about that level of security and would prefer
> full authentication.

Are you supplying the correct username/password combination in the ODBC
connection? - It sounds like this sort of a problem.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

In response to

Responses

pgsql-odbc by date

Next:From: Tom LaneDate: 2009-05-19 23:05:40
Subject: Re: Can't connect Win XP client to Linux server
Previous:From: Geoff LaneDate: 2009-05-19 19:48:31
Subject: Can't connect Win XP client to Linux server

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