[postgis-users] PostGIS and Mapserver

[Randy James]

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