Hi,
i will do so on Monday. Is it possible that the fact that we use a tiny map
script wrapper to avoid the map file in the url have something to do with
it.
By the way i tried the leaving away of the single ' ' already but it just
fails again because the parameter name doesn't get replaced. Thanks for all
of your hints.
Just to complete the circumstances. The map file uses the include mechanism
to get the layer definitions and the layer which needs the substitutions is
only referenced by a raster layer as an tile index. Don't know if this have
something to do with it. If i use static values everything is working fine.
Kind regards,
--
Peter Freimuth
On 2013-08-22, at 3:17 AM, thomas bonfort <[email protected]> wrote:
Peter,
can you email me your full mapfile, with the snippets you provided I
can't see anything wrong and would therefore need to see any
side-effects from the rest of the mapfile, and/or run it through a
debugger to see where it's failing.
--
thomas
On 21 August 2013 01:26, Peter Freimuth <[email protected]> wrote:
Hi,
i am trying to get the dynamic variable substitution work on Mapserver
6.3dev but somehow it does'nt work as it worked before and as documented.
When i execute
http://10.10.4.18/cgi-bin/LI_USA-MT.cgi?SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&BBOX=48.046271,-115.929840,48.198407,-115.666914&CRS=EPSG:4326&WIDTH=1647&HEIGHT=953&LAYERS=data_view&STYLES=&FORMAT=image/png&DPI=96&TRANSPARENT=TRUE&STARTDATE=2011-01-01&ENDDATE=2013-09-01
or
http://10.10.4.18/cgi-bin/LI_USA-MT.cgi?SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&BBOX=48.046271,-115.929840,48.198407,-115.666914&CRS=EPSG:4326&WIDTH=1647&HEIGHT=953&LAYERS=data_view&STYLES=&FORMAT=image/png&DPI=96&TRANSPARENT=TRUE
I get an error in
msDrawMap(): Image handling error. Failed to draw layer named 'data_view'.
msPostGISLayerWhichShapes(): Query error. Error executing query: ERROR:
invalid input syntax for type date: "%STARTDATE%"
LINE 8: ... (((acquisition_date >= date_trunc('day',date '%STARTDAT...
^
So the substitution does not happen or the default is not applied.
Any hint on what i am doing wrong would be great.
See below the components from the mapfile:
MAP
.....
#
# Start of web interface definition
#
DATAPATTERN '^[a-zA-Z0-9\-\_\,]+$'
WEB
IMAGEPATH "/mnt/mapserver/mapserver_wms/geocloud_config/image_path"
METADATA
.....
'PRODUCTID_validation_pattern' '^[a-zA-Z0-9\-\_\,]+$'
'default_PRODUCTID' '1234567'
'CONTRACTIDS_validation_pattern' '^[a-zA-Z0-9\-\_\,]+$'
'default_CONTRACT_IDS' '0000'
'STARTDATE_validation_pattern'
'^([0-9]{4})-([0-9]{2})-([0-9]{2})$'
'default_STARTDATE' '2011-01-01'
'ENDDATE_validation_pattern'
'^([0-9]{4})-([0-9]{2})-([0-9]{2})$'
'default_END_DATE' '2013-09-01'
END
VALIDATION
'PRODUCTID' '^[a-zA-Z0-9\-\_\,]+$'
'CONTRACTIDS' '^[a-zA-Z0-9\-\_\,]+$'
'STARTDATE' '^([0-9]{4})-([0-9]{2})-([0-9]{2})$'
'ENDDATE' '^([0-9]{4})-([0-9]{2})-([0-9]{2})$'
END
END
.....
LAYER
# this is the tileindex that aggregates the single image products
together and makes them accessible for the RASTER LAYER "data_view" and
"data_raw" for rendering
NAME "data_idx"
STATUS ON
DEBUG 5
UNITS dd
TYPE POLYGON
EXTENT -116.364631680367 44.1932837062986 -103.698350095065
49.1892799088128
PROCESSING "CLOSE_CONNECTION=DEFER"
CONNECTIONTYPE POSTGIS
CONNECTION "user=***** password=***** dbname=***** host='*****'
port=5432"
DATA "wkb_geom FROM (SELECT t1.* FROM (SELECT re3aip.cat_id as
archived_in_archiving_identifier, ico.image_id, ico.acquisition_date,
re3aip.tile_id,
ico.product_provider_image_identifier, re3aip.ohs_order_id,
re3aip.imagetake_cat_id, ico.epsg_code,
re3aip.ohs_contract_id, ico.service_name,
ico.footprint_poly::geometry as wkb_geom, ico.image_location,
ico.vrt_location
FROM ows.imagepool_catalogue_ows ico
JOIN ows.re_l3a_imagepool re3aip ON (re3aip.image_id=ico.image_id)
WHERE ico.service_name in ('LI_USA-MT') AND
(((acquisition_date >= date_trunc('day',date '%STARTDATE%') AND
acquisition_date < date_trunc('day',date '%ENDDATE%') + interval '1 day')))
AND
re3aip.ohs_contract_id in ('%CONTRACTID%')
) t1
LEFT OUTER JOIN
(SELECT ico.image_id, ico.acquisition_date, re3aip.tile_id
FROM ows.imagepool_catalogue_ows ico
JOIN ows.re_l3a_imagepool re3aip ON (re3aip.image_id=ico.image_id)
WHERE ico.service_name in ('LI_USA-MT') AND
(((acquisition_date >= date_trunc('day',date
'%STARTDATE%') AND
acquisition_date < date_trunc('day',date '%ENDDATE%') + interval '1 day')))
AND
re3aip.ohs_contract_id in ('%CONTRACTID%')
) t2
ON
t1.tile_id = t2.tile_id AND
((t1.acquisition_date < t2.acquisition_date) OR
(t1.acquisition_date = t2.acquisition_date AND t1.image_id < t2.image_id))
WHERE t2.tile_id is NULL
ORDER BY t1.ohs_contract_id, t1.tile_id
) foo USING UNIQUE image_id USING
SRID=4326"
#FILTER ( '[product_provider_image_identifier]'='%PRODUCTID%')
PROJECTION
"init=epsg:4326"
END
METADATA
"ows_title" "Data Index"
"ows_extent" "-116.364631680367 44.1932837062986
-103.698350095065 49.1892799088128"
#'PRODUCTID_validation_pattern' '^[a-zA-Z0-9\-\_\,]+$'
#'default_PRODUCTID' '1234567'
'CONTRACTIDS_validation_pattern' '^[a-zA-Z0-9\-\_\,]+$'
'default_CONTRACTIDS' '0000'
'STARTDATE_validation_pattern'
'^([0-9]{4})-([0-9]{2})-([0-9]{2})$'
'default_STARTDATE' '2011-01-01'
'ENDDATE_validation_pattern'
'^([0-9]{4})-([0-9]{2})-([0-9]{2})$'
'default_ENDDATE' '2013-09-01'
#disable explicitly everything that shall not be supported for
this Layer
"wms_enable_request" "!GetCapabilities !GetMap
!GetLegendgraphic"
"wcs_enable_request" "!GetCapabilities !GetCoverage
!DescribeCoverage"
"wfs_enable_request" "!GetCapabilities !GetFeature
!DescribeFeatureType"
END
VALIDATION
'PRODUCTID' '^[a-zA-Z0-9\-\_\,]+$'
'CONTRACT_IDS' '^[a-zA-Z0-9\-\_\,]+$'
'STARTDATE' '^([0-9]{4})-([0-9]{2})-([0-9]{2})$'
'END_DATE' '^([0-9]{4})-([0-9]{2})-([0-9]{2})$'
END
END
....
END
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
