[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