[postgis-users] RE:postgis and mapserver problem

[Jeremy Palmer]

Hi Jan,

Thanks for the reply. I tried setting STATUS DEFAULT and using
"&layer='node'" however I still get no image back? My apache log says:
"Premature end of script headers: mapserv" when I make the request.

Thanks

Jan Hartmann wrote:

Hi Jeremy,

This seems to be the eternal STATUS DEFAULT problem. STATUS ON means that
the calling URL has to indicate explicitly that the layer should be
displayed (http://...?map=...&layer=...). Only layers with STATUS DEFAULT
are always shown. It is confusing, and you are not the first one to have run
into this.

Jan

Jeremy Palmer wrote:


From: Jeremy Palmer [mailto:jpalmer at paradise.net.nz] 
Sent: Monday, 17 May 2004 11:00 p.m.
To: 'postgis-users at postgis.refractions.net'
Subject: postgis and mapserver problem

Hi I'm trying to display Postgis data through Mapserver but all I get back
is a blank image. I have got mapserver demo/samples working with shape
files.

The map file I'm using is:

NAME TEST
SIZE 400 300
# lat long extents
EXTENT 5 -48 24 -35
UNITS METERS
IMAGECOLOR 255 255 255
IMAGETYPE PNG

#NZGD2000 datum
PROJECTION
    "init=esri:104108"
END

LAYER
  CONNECTIONTYPE postgis
  NAME "node"
  # Trusted connection to db 'dblh' on host 'lh-deimos'
  CONNECTION "user=postgres dbname=dblh host=lh-deimos"
  # Select column shape from table node
  DATA "shape FROM node" 
  STATUS ON
  TYPE POINT
    CLASS
       COLOR 0 0 0
    END
 END

END # Map File

The http request I'm using is:

http://lh-deimos/cgi-bin/mapserv?map=/var/www/htdocs/map/test.map&mode=map

I'm using:
Postgresql 7.42
Postgis 0.81
Geos 1.0
Proj 4.47
mapserver 4.02

Thanks