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

Stephen Woodbridge woodbri at swoodbridge.com
Thu Apr 7 12:54:15 PDT 2005


Seems like you are on the wrong sub-net try:

host all 192.168.1.0 255.255.255.0 trust

-Steve W.

Robert Aldridge wrote:
> 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
> 




More information about the postgis-users mailing list