[Mapserver-users] PostGIS blank error - bit of a newbie question....!

[Jan Hartmann]

Hi Matt, why do you have "STATUS OFF"? If you want to see something, you 
have to set "STATUS DEFAULT" (or "STATUS ON" with the layer's name given 
in the url). Apart from that, your setup looks OK.

Jan

Matt Hatcher wrote:

> Hi,
> 
> I'm trying to get a postgres connection working with Mapserver 4.0.1 on
> Mandrake 9.2. I'm using the Postgres and Postgis RPMs from the postgis
> site, and the stable 4.0.1 source compiled with the postgis option. My -v
> gives:
> 
> MapServer version 4.0.1 OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=PDF
> SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT
> SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT INPUT=JPEG INPUT=POSTGIS INPUT=OGR
> INPUT=GDAL INPUT=SHAPEFILE
> 
> 
> I've got a table that I loaded from a point shapefile using shp2pgsql
> which I can query quite happily from the psql command line. The data in
> there is in SRID 4326, e.g.:
> 
>  gid | id |     x     |     y     | height_m |  height_ft  | type  |
> name    |               the_geom
> -----+----+-----------+-----------+----------+-------------+-------+-----------+--------------------------------------
>     |  1 | -5.003492 | 56.796264 | 1343.798 | 4408.786096 | Munro | Ben
> Nevis | SRID=4326;POINT(-5.003492 56.796264)
> 
> 
> When I try and get the data through Mapserver I get the following
> unhelpful "blank" error message:
> 
> msDrawMap(): Image handling error. Failed to draw layer named 'peaks'. 
> prep_DB(): Query error. Error executing POSTGIS DECLARE (the actual query)
> statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
> asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from
> mountains WHERE the_geom && setSRID('BOX3D(-10.5612147941099
> 48.9367546675052,6.81724902590237 55.7611851275149)'::BOX3D,
> find_srid('','mountains','the_geom') )'
> 
> Postgresql reports the error ''
> 
> More Help:
> 
> Error with POSTGIS data variable. You specified '<check your .map file>'.
> Standard ways of specifiying are :
> (1) 'geometry_column from geometry_table'
> (2) 'geometry_column from (<sub query>) as foo using unique <column name>
> using SRID=<srid#>'
> 
> Make sure you put in the 'using unique <column name>' and 'using SRID=#'
> clauses in.
> 
> For more help, please see http://postgis.refractions.net/documentation.php
> 
> 
> Mappostgis.c - version of June 12/2003.
> 
> 
> My map file has:
> 
> LAYER
>   NAME "peaks"
>   TYPE POINT
>   STATUS OFF
>   CONNECTIONTYPE POSTGIS
>   CONNECTION "user=apache dbname=geo"
>   DATA "the_geom from mountains"
> 
>   PROJECTION
>     "init=epsg:4326"
>   END
> 
>   CLASS
>     SYMBOL 'circle'
>     SIZE 4
>     COLOR   0
>   END
> END
> 
> 
> Any suggestions would be gratefully received!
> 
> Cheers, Matt.
> 
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>