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">begodom@gmail.com</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;">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>