<!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>