[postgis-users] [OT] Allowing network client connections

[John Cole]

Robert, check the tcpip_socket = false line and make sure it's true.  See
http://archives.postgresql.org/pgsql-cygwin/2004-06/msg00060.php for more
detail.

Hope that helps...

John


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Robert
Aldridge
Sent: Thursday, April 07, 2005 1:43 PM
To: postgis-users at postgis.refractions.net
Subject: Re: [postgis-users] [OT] Allowing network client connections

Thanks for the replies.  But, my problem must be
deeper.  Changing the pg_hba.conf file doesn't seem to
make any difference.  Even if I have either

'host all 192.168.0.0 255.255.255.0 trust'

or

'host all 192.168.1.0/24 trust'

I still get:

'no pg_hba.conf entry for host "192.168.1.101", user
"postgres", database "mydatabase"'

when trying to connect from a network client.  It's as
if the pg_hba.conf file that I'm editing isn't even
the one it's using.

I thought it may be my firewall/proxy, but the request
seems to be reaching the postgres server because the
logfile on the postgres server shows:

'FATAL: no pg_hba.conf entry for host "192.168.1.101",
user "postgres", database "mydatabase"'

Thanks for your suggestions.  Any others?

Robert


Date: Thu, 7 Apr 2005 16:51:03 +0200
From: "TECHER Jean David" <davidtecher at yahoo.fr>
Subject: Re: [postgis-users] [OT] Allowing network
client connections
To: "PostGIS Users Discussion"
<postgis-users at postgis.refractions.net>
Message-ID: <004601c53b81$38afc330$117fa8c0 at jenna>
Content-Type: text/plain;	charset="iso-8859-1"

Hi Robert

it's

host all 192.168.0.0 255.255.255.0 trust

not

host all 192.168.0.0 255.255.0.0 trust

U did a error in SubNet: 255.255.255.0 and not
255.255.0.0

Date: Thu, 7 Apr 2005 11:20:44 -0400 
From: "Obe, Regina     DND\\MIS"
<robe.dnd at cityofboston.gov>
Subject: RE: [postgis-users] [OT] Allowing network
client connections
To: 'PostGIS Users Discussion'
<postgis-users at postgis.refractions.net>
Message-ID:
<B318FD8D29DCD411BD0500D0B7A91C6704103DDB at jupiter>
Content-Type: text/plain

Your

host all 192.168.1.0/24  trust

Looks right.  

Your 
host mydatabase 192.168.1.0/24

I would get rid of as it doesn't even designate the
method of trust.  
I'm
not sure what happens in that case or put trust at the
end of it.

What does your "Reject all other connections look
like?" Not sure why 
you
would need such a line unless you are rejecting a
subset of your 
subnet. 

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------------------------------
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.