[postgis-users] PostGIS and Mapserver

[david techer]

Hum!

do you use and type the command

psql -d dbpostgis -U ....

to the ssh connection (terminal) or from your local machine?

if U want to find pg_ctl path do

which pg_ctl

or

pg_config --bindir


Ezequias Rodrigues da Rocha wrote:

> but I can enter on the db via ssh connection.
>
> This have any difference from entering via apache ?
>
> Ezequias
>
> Randy James wrote:
>
>> looks like the error for the fix listed as number 4
>>
>> --- Ezequias Rodrigues da Rocha <ezequias at recife.pe.gov.br> 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
>>>
>>>   
>>
>>
>>
>>
>>        
>> __________________________________ Yahoo! Mail - PC Magazine Editors' 
>> Choice 2005 http://mail.yahoo.com
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>  
>>
> _______________________________________________
> 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