[postgis-users] PostGIS and Mapserver

[david techer]

Hi Ezequias

It seems that there is no TCP/IP available..

Who do u launch PostgreSQL?

Two solutions?

solution 1:

With pg_ctl do

pg_ctl -o -i start

to able tcp/ip connexion

solution 2:

or open postgresql.conf from your PostgreSQL data directory

and replace listen_addresses = 'localhost' by

listen_addresses = '*'

then pg_ctl restart


Ezequias Rodrigues da Rocha wrote:

> Hi list,
>
> I am trying to access postgis via mapserver (a cgi server) but the 
> resoult is allways a problem. Could anobody take a look on my problem ?
>
> the stack trace is shown below:
>
> msDrawMap(): Image handling error. Failed to draw layer named 'bairros'.
> msPOSTGISLayerOpen(): Query error. couldnt make connection to DB with 
> connect string 'user=postgres password=pt dbname=db1 
> host=myserver.mydomain 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
>
> My best regards
> Ezequias
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>


	

	
		
___________________________________________________________________________ 
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger 
Téléchargez cette version sur http://fr.messenger.yahoo.com