thanks Guido, now I want to allow connection from all to this ip <a 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 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 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 href="http://192.168.102.100" target="_blank">192.168.102.100</a> <<a 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 href="http://192.168.102.1" target="_blank">192.168.102.1
</a><br></div>> <<a 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 href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br>> <a 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 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 href="mailto:postgis-users@postgis.refractions.net">
postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></blockquote></div>
<br>