[postgis-users]CONNECTION to database thru Mapserver

[pram at pramcentral.com]

If the webserver and the postgreSQL server are on the same box, try specifying the with localhost or 127.0.0.1 in ur mapfile

ie. the mapfile should be something like:
 LAYER
        NAME major_roads
        STATUS DEFAULT

        CONNECTIONTYPE postgis
        CONNECTION "dbname=tiger host=localhost user=username password=password"
      ...

-Prashanth

P.S I don't think this is a postgis issue anymore. I think it's a mapserver/mapfile issue. Please consider moving it to the mapserver mailing list.
--
<a href="HTMLX.com">HTMLX.com</A>
Mapserver Hosting, Mapscript Hosting, PHP Hosting
PostgreSQL w/PostGIS extension enabled Hosting



----- Original Message -----
From: "w m" <wokar1 at yahoo.com>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Subject: Re: [postgis-users]CONNECTION to database thru Mapserver
Date: Mon, 14 Mar 2005 13:32:47 -0800 (PST)

> 
> the configuration files are fine and they allow the 
> connections....but  still to no avail after changing STATUS to 
> DEFAULT i still get the same errors.  if i change STATUS to ON i 
> dont see the points on the map but tehre are no errors.....
> 
> Doug_Newcomb at fws.gov wrote:
> Wokar,
> Check your postgresql.conf file to see if you are allowing tcp/ip
> connections and your pg_hba.conf file to see if you are allowing
> connections from 132.205.108.60
> 
> Doug
> 
> Doug Newcomb
> USFWS
> Raleigh, NC
> 919-856-4520 ext. 14 doug_newcomb at fws.gov
> ---------------------------------------------------------------------------------------------------------
> 
> The opinions I express are my own and are not representative of the
> official policy of the U.S.Fish and Wildlife Service or Dept. of Interior.
> I left my signature file in /dev/null
> 
>