[postgis-users] PostGIS and Mapserver

[Ezequias Rodrigues da Rocha]

from ssh terminal.

Locally the problem does not occours too.

see my steps

ssh root at server
password
psql db1

the psql prompt appears.

Ezequias


david techer wrote:

> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>