[postgis-users] PostGIS and Mapserver

[Ezequias Rodrigues da Rocha]

i don't believe (and I checked) that there is a tcpip_socket on 
Posgresql 8.0 so I didn't find this item here.

Ezequias

Randy James wrote:

>in your pg_hba.conf you need to give permission to use the connection and example
>in the file is like this
>
># host    all         all         127.0.0.1         255.255.255.255   trust
>
>in the postgresql.conf file enable the tcpic connection like this:
>
>tcpip_socket = true
>
>Your problems are postres problems not postgis or mapserver, look in your
>posgresql documents.
>
>--- Ezequias Rodrigues da Rocha <ezequias at recife.pe.gov.br> 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
>>
>>    
>>
>
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam?  Yahoo! Mail has the best spam protection around 
>http://mail.yahoo.com 
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>  
>