[mapserver-users] Limitation of WMS-Time with MySql or Documentation Error?

[Stefan Schantz]

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