[postgis-users] Failing to connect to Postgis

Milo van der Linden mlinden at zeelandnet.nl
Wed Dec 19 13:19:10 PST 2007


host all all/32      md5


Steven De Vriendt schreef:
> thanks Guido, now I want to allow connection from all to this ip 
> 192.168.102.100 <http://192.168.102.100> How do I configure this in 
> pg_hba ?
> For now I have
>
> host all all      md5
>
> but that doesn't seem to work... Can you help me out ?
> thx
>
> Steven
>
> On Dec 19, 2007 2:12 PM, Guido Lemoine <guido.lemoine at jrc.it 
> <mailto:guido.lemoine at jrc.it>> wrote:
>
>     Steven,
>
>     This is a problem related to your PostgreSQL server set-up (i.e.
>     nothing
>     to do
>     with postgis). Looks like your client machine 192.168.102.100
>     <http://192.168.102.100> is not
>     listed in the pg_hba.conf
>     file on the postgres server, which defines the machines allowed to
>     make
>     connections.
>     Or they may be something wrong in the definition of your entry in that
>     file as it seems
>     to expect a connection using SSL.
>
>     Look for hints on postgres administration sites.
>
>     GL
>
>     Steven De Vriendt wrote:
>     >
>     > Hi list,
>     >
>     > I'm having this strange problem trying to connect to postgis.
>     > I'm trying to connect from qgis, I enter my connection parameters
>     > f.i.:
>     >
>     > I'm using 192.168.102.100 <http://192.168.102.100> <
>     http://192.168.102.100>, yet when I try
>     > Test Connect I get this
>     > errror:
>     >
>     > FATAL: no pg_hba.conf entry for host 192.168.102.1
>     <http://192.168.102.1>
>     > <http://192.168.102.1>, user "...", database ".....", SSL off
>     >
>     > How come ?
>     >
>     > Thanks
>     > Steven
>     >
>     >
>     >
>     >
>     ------------------------------------------------------------------------
>     >
>     > _______________________________________________
>     > postgis-users mailing list
>     > postgis-users at postgis.refractions.net
>     <mailto:postgis-users at postgis.refractions.net>
>     > http://postgis.refractions.net/mailman/listinfo/postgis-users
>     >
>
>     -- 
>     ----------------------------------------------------------------
>     Guido Lemoine
>     Joint Research Centre, European Commission
>     Institute for the Protection and Security of the Citizen (IPSC)
>     Support to External Security
>     Via E. Fermi, 2749 TP 267 Ispra 21027 (VA), Italy
>     Tel. +39 0332 786239 (direct line) Fax. +39 0332 785154
>     WWW: http://ses.jrc.it
>     ----------------------------------------------------------------
>     Disclaimer:
>     Views expressed are those of the individual and do not represent
>     the views of the European Commission
>
>
>     _______________________________________________
>     postgis-users mailing list
>     postgis-users at postgis.refractions.net
>     <mailto:postgis-users at postgis.refractions.net>
>     http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>   


-- 


	

Milo van der Linden
skype: milovanderlinden <skype:milovanderlinden?add>
mlinden at zeelandnet.nl <mailto:mlinden at zeelandnet.nl>
milovanderlinden at gmail.com <mailto:milovanderlinden at gmail.com>
milo at 3dsite.nl <mailto:milo at 3dsite.nl>
http://www.3dsite.nl

	  	

De informatie in dit bericht reflecteert mijn persoonlijke mening en 
niet die van een bedrijf of instantie. Aan de informatie kunnen geen 
rechten worden ontleend. Indien dit bericht onderdeel is van een forum, 
mailing-list of community dan gelden automatisch de bij het betreffende 
medium behorende voorwaarden. The information in this message reflects 
my personal opinion and not that of a company or public body. All rights 
reserved.If this message is contained in a mailing-list or community, 
the rights on the medium are automatically adapted.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071219/b2570f2f/attachment.html>


More information about the postgis-users mailing list