[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Failing to connect to Postgis
From: Milo van der Linden <mlinden () zeelandnet ! nl>
Date: 2007-12-19 21:19:10
Message-ID: 47698ACE.2020009 () zeelandnet ! nl
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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@jrc.it
> <mailto:guido.lemoine@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@postgis.refractions.net
> <mailto:postgis-users@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@postgis.refractions.net
> <mailto:postgis-users@postgis.refractions.net>
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
--
Milo van der Linden
skype: milovanderlinden <skype:milovanderlinden?add>
mlinden@zeelandnet.nl <mailto:mlinden@zeelandnet.nl>
milovanderlinden@gmail.com <mailto:milovanderlinden@gmail.com>
milo@3dsite.nl <mailto:milo@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.
[Attachment #5 (text/html)]
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
host all all/32 md5<br>
<br>
<br>
Steven De Vriendt schreef:
<blockquote
cite="mid:8d2ea9d70712190615q136ffe11h2cd1c1216e209775@mail.gmail.com"
type="cite">thanks Guido, now I want to allow connection from all to
this ip <a moz-do-not-send="true" href="http://192.168.102.100">192.168.102.100</a>
How do I configure this in pg_hba ?<br>
For now I have <br>
<br>
host all all md5<br>
<br>
but that doesn't seem to work... Can you help me out ?
<br>
thx<br>
<br>
Steven<br>
<br>
<div class="gmail_quote">On Dec 19, 2007 2:12 PM, Guido Lemoine <<a
moz-do-not-send="true" \
href="mailto:guido.lemoine@jrc.it">guido.lemoine@jrc.it</a>> wrote:<br>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; \
padding-left: 1ex;">Steven,<br> <br>
This is a problem related to your PostgreSQL server set-up (i.e. nothing<br>
to do<br>
with postgis). Looks like your client machine <a moz-do-not-send="true"
href="http://192.168.102.100" target="_blank">192.168.102.100</a> is
not
<br>
listed in the pg_hba.conf<br>
file on the postgres server, which defines the machines allowed to make<br>
connections.<br>
Or they may be something wrong in the definition of your entry in that<br>
file as it seems<br>
to expect a connection using SSL.
<br>
<br>
Look for hints on postgres administration sites.<br>
<br>
GL<br>
<div class="Ih2E3d"><br>
Steven De Vriendt wrote:<br>
><br>
> Hi list,<br>
><br>
> I'm having this strange problem trying to connect to postgis.
<br>
> I'm trying to connect from qgis, I enter my connection parameters<br>
> f.i.:<br>
><br>
</div>
> I'm using <a moz-do-not-send="true" href="http://192.168.102.100"
target="_blank">192.168.102.100</a> <<a moz-do-not-send="true"
href="http://192.168.102.100" target="_blank">
http://192.168.102.100</a>>, yet when I try<br>
<div class="Ih2E3d">> Test Connect I get this<br>
> errror:<br>
><br>
> FATAL: no pg_hba.conf entry for host <a moz-do-not-send="true"
href="http://192.168.102.1" target="_blank">192.168.102.1
</a><br>
</div>
> <<a moz-do-not-send="true" href="http://192.168.102.1"
target="_blank">http://192.168.102.1</a>>, user "...", database
".....", SSL off<br>
><br>
> How come ?<br>
><br>
> Thanks<br>
> Steven
<br>
><br>
><br>
><br>
>
------------------------------------------------------------------------<br>
><br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a moz-do-not-send="true"
href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>
> <a moz-do-not-send="true"
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
><br>
<br>
--
<br>
----------------------------------------------------------------<br>
Guido Lemoine<br>
Joint Research Centre, European Commission<br>
Institute for the Protection and Security of the Citizen (IPSC)<br>
Support to External Security
<br>
Via E. Fermi, 2749 TP 267 Ispra 21027 (VA), Italy<br>
Tel. +39 0332 786239 (direct line) Fax. +39 0332 785154<br>
WWW: <a moz-do-not-send="true" href="http://ses.jrc.it" \
target="_blank">http://ses.jrc.it</a><br>
----------------------------------------------------------------
<br>
Disclaimer:<br>
Views expressed are those of the individual and do not represent<br>
the views of the European Commission<br>
<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a moz-do-not-send="true"
href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</blockquote>
</div>
<br>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" \
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" \
href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<title>3DSite</title>
<meta http-equiv="Content-Type" content="text/html; ">
<style type="text/css">
<!--
body {
background-color: #FFFFFF;
margin-left: 5px;
margin-top: 5px;
margin-right: 5px;
margin-bottom: 5px;
}
body,td,th {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
color: #333333;
}
.style4 {font-size: 9px; }
.style5 {font-size: 9px; color: #CCCCCC; }
-->
</style>
<meta content="MSHTML 6.00.2900.2912" name="GENERATOR">
<br>
<table border="0" cellpadding="0" cellspacing="0" width="400">
<tbody>
<tr>
<td rowspan="3" align="left" height="0" valign="bottom" width="15"><br>
</td>
<td colspan="2" align="left" height="78" valign="top" width="0">
<p class="style4">Milo van der Linden
<br>
<a href="skype:milovanderlinden?add">skype: milovanderlinden</a><br>
<a href="mailto:mlinden@zeelandnet.nl">mlinden@zeelandnet.nl</a><br>
<a href="mailto:milovanderlinden@gmail.com">milovanderlinden@gmail.com</a><br>
<a href="mailto:milo@3dsite.nl">milo@3dsite.nl</a><br>
<a href="http://www.3dsite.nl">http://www.3dsite.nl</a><br>
</p>
</td>
<td rowspan="3" align="left" height="0" valign="top" width="15"> </td>
<td valign="top" width="300">
<p class="style5"><span lang="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.</span>
<span lang="EN">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.</span></p>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic