[postgis-users] PostGIS and Mapserver

[Randy James]

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/