[postgis-users] PostGIS and Mapserver

[Ezequias Rodrigues da Rocha]

# psql -d dbpotgis -U postgres -h myserver.mydomain

no problem here

Ezequias

Ethan Alpert wrote:

>Try to connect to the postgres server manually with psql:
>
>psql -U postgres -h myserver.mydomain
>
>If you can't connect then the host you are connecting from is not
>allowed. Look at the file $PG_HOME/pg_hba.conf and make sure
>$PG_HOME/postgresql.conf has networking set up.
>
>-----Original Message-----
>From: postgis-users-bounces at postgis.refractions.net
>[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
>Ezequias Rodrigues da Rocha
>Sent: Friday, September 16, 2005 11:04 AM
>To: PostGIS Users Discussion
>Subject: [postgis-users] PostGIS and Mapserver 
>
>
>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
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>  
>