What does the postgres log say ? ... work through each of the 8 points that mapserever helpfully spits out and post the results back if you can't find an answer.
Greg W. -----Original Message----- From: UMN MapServer Users List on behalf of Ezequias Rodrigues da Rocha Sent: Thu 11/3/2005 8:54 AM To: [email protected] Cc: Subject: [UMN_MAPSERVER-USERS] Mapserver and Postgis 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 !DSPAM:436a43f4170219854820122!
