<div>Postgres is running with the postmaster.</div>
<div> </div>
<div>When I try to connect access the database independent of mapserver there is the following error message:</div>
<div> </div>
<div>"Error connecting to the server: no se pudo conectar con el servidor: Connection refused (0x0000274D/10061)</div>
<div>¿Está el servidor en ejecución en el servidor <<***.***.**.*>> y aceptando conexiones TCP /IP en el puerto 5432?"</div>
<div> </div>
<div>The server is runing so I suppose that the problem is with TCP/IP connections but I´m not sure of this settings. How do i check the TCP/IP connection of 5432 port?<br><br>Thanks </div>
<div> </div>
<div> </div>
<div class="gmail_quote">On Jan 17, 2008 11:47 AM, Steven De Vriendt <<a href="mailto:gisaalter@gmail.com">gisaalter@gmail.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">So, is postgres up and running with the postmaster ?<br>Check if you can access the database independent of mapserver...
<br><br>Steven<br><br>
<div class="gmail_quote">On Jan 17, 2008 11:04 AM, SUBSCRIBE MAPSERVER-USERS Bego D. < <a href="mailto:begodom@gmail.com" target="_blank">begodom@gmail.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">Hello<br><br>We are new in Mapserver. <br><br>I have installed MapServer 4 Windows version 2.2.6
on my computer and in<br>another computer of my office we have installed Postgis 1.3.2. for 8.2<br>PostgreSQL.<br><br>Both works fine, we can work with Mapserver-Oracle Spatial or with .shp <br>or .tab, but now we want to connect MapServer with PostGis and we get this
<br>error:<br><br>msDrawMap(): Image handling error. Failed to draw layer named 'INFVIA'.<br>msPOSTGISLayerOpen(): Query error. couldnt make connection to DB with <br>connect string 'host=****** dbname=**** user=postgres
<br>password=****** port=5432'. Error reported was 'could not connect to<br>server: Connection refused (0x0000274D/10061) Is the server running on<br>host " <a href="http://192.168.0.3/" target="_blank">192.168.0.3
</a>" and accepting TCP/IP connections on port 5432? '. This<br>error occured when trying to make a connection to the specified postgresql<br>server. Most commonly this is caused by (1) incorrect connection string (2)
<br>you didnt specify a 'user=...' in your connection string (3) the postmaster<br>(postgresql server) isnt running (4) you are not allowing TCP/IP connection to<br>the postmaster (5) your postmaster is not running on the correct port - if its
<br>not on 5432 you must specify a 'port=...' (6) the security on your system<br>does not allow the webserver (usually user 'nobody') to make socket<br>connections to the postmaster (7) you forgot to specify a 'host=...' if the
<br>postmaster is on a different machine (8) you made a typo<br><br>My .map is:<br><br><br>CONNECTIONTYPE POSTGIS<br>CONNECTION "host=***.***.**.* dbname=**user=postgres password=***<br>port=5432"<br>DATA "the_geom geometry from INFVIA2"
<br><br>Any help will be appreciate.<br><font color="#888888"><br>Bego<br></font></blockquote></div><br></blockquote></div><br>