PostGIS connection
SUBSCRIBE MAPSERVER-USERS Bego D.
begodom at GMAIL.COM
Thu Jan 17 02:04:53 PST 2008
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
More information about the MapServer-users
mailing list