[postgis-users] PostGIS and Mapserver

[Ezequias Rodrigues da Rocha]

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
>
>  
>