Mapserver and Postgis

Ezequias Rodrigues da Rocha ezequias at RECIFE.PE.GOV.BR
Thu Nov 3 11:54:45 EST 2005


Hi list,

I am starting with mapserver, but have a very important error and I have 
no idea how to put it to work. I doesn't even know if I did it before 
but here is the problem:

I am trying to access a postgis layer with the mapserver 4.4.2 and via 
browser the return of server was:

msDrawMap(): Image handling error. Failed to draw layer named 'bairros'.
msPOSTGISLayerOpen(): Query error. couldnt make connection to DB with 
connect string 'user=postgres password=post dbname=dbpotgis 
host=192.168.0.15 port=5432'.
Error reported was 'could not create socket: Permission denied '.
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


I hope someone could help me. Nobody did before.

Sincerely
Ezequias



More information about the mapserver-users mailing list