[postgis-users] help with WMS query Mapserver and postgis

[Steven De Vriendt]

Edu,

Have you declared the WEB-parameter in your map-file ?
Should be something like this:

WEB
  IMAGEPATH "c:/ms4w/tmp/ms_tmp/"
  IMAGEURL "/ms_tmp/"
 METADATA
  "wms_title" "Aalter_WMS"
  "wms_onlineresource"
"http://localhostcgi-bin/mapserv.exe?map=/ms4w/apps/chameleon/samples/map/wmsserver.map&"
  "wms_srs" "EPSG:31300"
 END
END

You have to define this before using mapserver as WMS-server.

Regards,
Steven

On 3/10/07, Edu Montaña <edumon20 at hotmail.com> wrote:
> Hello, I'm newbie in mapserver and postgis, and I have a problem that I
> don't know how to fix it. I have installed mapserver in a debian system with
> postgis, but when I make a request WMS I obtain the following error:
>
> msDrawMap(): Image handling error. Failed to draw layer named 'layer_07'.
> prepare_database(): Query error. Error executing POSTGIS DECLARE (the actual
> query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
> asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from layer_07
> WHERE the_geom && setSRID('BOX3D(63208.0999421528
> 4203763.49990343,404291.899999981 4487999.99999998)'::BOX3D,
> find_srid('','layer_07','the_geom') )' Postgresql reports the error as
> 'ERROR: function setsrid(box3d, integer) does not exist HINT: No function
> matches the given name and argument types. You may need to add explicit type
> casts. ' 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/ Mappostgis.c - version of Jan
> 23/2004.
>
> I don't understand this error because I have defined in my database the
> function setsrid.
> I tried to define in the data declaration in my .map file the following:
>         DATA "the_geom from layer_07 using unique the_geom using SRID=23030"
> but it doesn't work.
> My WMS query is:
> http://192.168.0.66:80/cgi-bin/mapserv40/mapserv?map=/usr/local/apache2/htdocs/mapservertest.mapSERVICE=WMS&Request=GetMap&LAYERS=layer_07&format=image/jpeg&bbox=222966.0,4416557.0,223027.0,4416597.0&srs=EPSG:23030&styles=default&VERSION=1.1.1&Height=600&Width=500
> My layer declaration on the .map file is the following:
>
>         LAYER
>                 NAME "layer_07"
>                 TYPE POLYGON
>                 STATUS ON
>                 CONNECTIONTYPE POSTGIS
>                 CONNECTION "host=192.168.0.147 dbname=testdb user=postgres
> password=postgres port=5432"
>                 DATA "the_geom from layer_07"
>                 TRANSPARENCY 25
>
>                 CLASS
>                         NAME 'layer_07'
>                         COLOR           188 229 193
>                         OUTLINECOLOR    0 0 0
>                 END
>
>                 METADATA
>                         "wms_name" "layer_07"
>                         "wms_title" "Layer 07."
>                 END
>
>                 PROJECTION
>                         "init=epsg:23030"
>                 END
>         END
>
>
> I hope that your can help me, it very urgent.
>
> Thanks in advance
>
> P.D.: Sorry for my poor english
>
> _________________________________________________________________
> Acepta el reto MSN Premium: Protección para tus hijos en internet.
> Descárgalo y pruébalo 2 meses gratis.
> http://join.msn.com?XAPID=1697&DI=1055&HL=Footer_mailsenviados_proteccioninfantil
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>