[FWTools] problem connecting to postgis from mapserver fwtools 1.12 postgis 1.20 postgres 8.1.6

[Frank Warmerdam]

Dave Potts wrote:
> I get the following error attempting to connect to localhost on a windoz 
> xp machine
> 
>    "msDrawMap(): Image handling error. Failed to draw layer named 
> 'castles'.
>    msPOSTGISLayerOpen(): Query error. couldnt make connection to DB with
>    connect string 'host=localhost user=dave password=*******
>    dbname=castle'.Error reported was 'unknown host name: localhost'.This

Dave,

I don't know this doesn't work.  I would suggest trying host=127.0.0.1
as an alternative, but perhaps test is already addressed by your
try against 10.1.1.8.

Have you tried connecting with ogrinfo to help rule out permissions related
issues for the web user?

FWTools for windows appears to be built with client libraries for Postgres 7.4
but they should be compatiable with any newer version of Postgres as far as
I know.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGeo, http://osgeo.org