[postgis-users] PostGIS and Mapserver

[Ezequias Rodrigues da Rocha]

Nice tip =-O

Randy James wrote:

>hmm well best bet is to read the manual at:
>
>http://www.postgresql.org/docs/8.0/interactive/index.html
>
>--- Ezequias Rodrigues da Rocha <ezequias at recife.pe.gov.br> wrote:
>
>  
>
>>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
>>>
>>> 
>>>
>>>      
>>>
>>_______________________________________________
>>postgis-users mailing list
>>postgis-users at postgis.refractions.net
>>http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>    
>>
>
>
>
>	
>		
>______________________________________________________ 
>Yahoo! for Good 
>Donate to the Hurricane Katrina relief effort. 
>http://store.yahoo.com/redcross-donate3/ 
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>  
>