So, is postgres up and running with the postmaster ? Check if you can access the database independent of mapserver...
Steven On Jan 17, 2008 11:04 AM, SUBSCRIBE MAPSERVER-USERS Bego D. < [EMAIL PROTECTED]> wrote: > Hello > > We are new in Mapserver. > > I have installed MapServer 4 Windows version 2.2.6 on my computer and in > another computer of my office we have installed Postgis 1.3.2. for 8.2 > PostgreSQL. > > Both works fine, we can work with Mapserver-Oracle Spatial or with .shp > or .tab, but now we want to connect MapServer with PostGis and we get this > error: > > msDrawMap(): Image handling error. Failed to draw layer named 'INFVIA'. > msPOSTGISLayerOpen(): Query error. couldnt make connection to DB with > connect string 'host=****** dbname=**** user=postgres > password=****** port=5432'. Error reported was 'could not connect to > server: Connection refused (0x0000274D/10061) Is the server running on > host "192.168.0.3" and accepting TCP/IP connections on port 5432? '. This > error occured when trying to make a connection to the specified postgresql > server. Most commonly this is caused by (1) incorrect connection string > (2) > you didnt specify a 'user=...' in your connection string (3) the > postmaster > (postgresql server) isnt running (4) you are not allowing TCP/IP > connection to > the postmaster (5) your postmaster is not running on the correct port - if > its > not on 5432 you must specify a 'port=...' (6) the security on your system > does not allow the webserver (usually user 'nobody') to make socket > connections to the postmaster (7) you forgot to specify a 'host=...' if > the > postmaster is on a different machine (8) you made a typo > > My .map is: > > > CONNECTIONTYPE POSTGIS > CONNECTION "host=***.***.**.* dbname=**user=postgres password=*** > port=5432" > DATA "the_geom geometry from INFVIA2" > > Any help will be appreciate. > > Bego >
