Mapserver and Postgis

[Ezequias Rodrigues da Rocha]

I didn't find nothing on the /usr/local/pgsql/data/pg_log files.

Could you mention another file I can see ?

Sincerley
Ezequias

Gregory S. Williamson wrote:

>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:	MAPSERVER-USERS at LISTS.UMN.EDU
>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!
>
>
>
>
>
>  
>

-- 
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com
msn:ezequias at hotmail.com