Hello,
I have a very principal question.
Is it possible to setup a WMS-Time service with Mapserver, OGR and a
MySQL database?
I have read the documentation, and the example shows, that it possible
with a Postgres database.
I have tried it with a MySQL database, and I didn't get it work (at
least I think, that it doesn't work as it should).
I have heard, that there are some limitations in OGR supporting MySQL,
there was nothing concrete.
There is a part of the mapfile:
LAYER
NAME "odl_wmst"
TYPE POINT
STATUS ON
INCLUDE "../../include/general/debug_layer.map" #2 Zeilen
DEBUG ON
DUMP TRUE
TOLERANCE 3
PROCESSING "CLOSE_CONNECTION=DEFER"
CONNECTIONTYPE OGR
CONNECTION
"MYSQL:onmon,host=10.130.63.11,user=user,password=password,port=3306,tables=result_current;locality"
DATA "SELECT value AS wert, end_measure, locality.geom
FROM result_current JOIN locality ON
result_current.locality_code = locality.locality_code"
WHERE end_measure = '%time%' "
METADATA
WMS_TITLE "ODL_WMS-T"
WMS_ABSTRACT "ODL_Paragraph2"
INCLUDE
"../../include/general/standard_extent_germany_4326.map"
"wms_timeextent" "2011-10-01/2011-12-31"
"wms_timeitem" "end_measure"
"wms_timedefault" "2011-12-21"
"wms_timeformat" "YYYY-MM-DD"
gml_include_items "all"
END
VALIDATION
'time'
'^((((19|20)(([02468][048])|([13579][26]))-02-29))|((20[0-9][0-9])|(19[0-9][0-9]))-((((0[1-9])|(1[0-2]))-((0[1-9])|(1\d)|(2[0-8])))|((((0[13578])|(1[02]))-31)|(((0[1,3-9])|(1[0-2]))-(29|30)))))$'
END
...
END #LAYER
I 've tried it with MapServer 5.6.5 (OGR 1.8), 6.0.1 (OGR 1.7).
I don't get any errors. The only thing is, that i get a white picture.
But if I remove the parameter "wms_timeitem" "end_measure", it works,
though the dokumentation tells, that the parameter "wms_timeitem" is
mandatory.
Is my WMS-Time service a really WMS-Time-Service without the
"wms_timeitem" parameter?
Has anybody a working WMS-Time service with MySQL?
Thank you, Best regards und Merry Christmas!
Stefan
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
