[mapserver-users] WMS-TIME with mysql-database

[Katharina Sambs]

Hi list,

I would like to visualize spatial *mySQL* data through a wms-time service.
*It is possible to visualize the data without the time parameters.*
But as soon as I add the following parameters to the mapfile, my result 
contains only a white picture:
LAYER
....
    METADATA
    ....
        WMS_TIMEEXTENT   "2010-01-10T00:00:00Z"
        WMS_TIMEITEM   "column_name"
        WMS_TIMEDEFAULT   "2010-01-10T00:00:00Z"

There is no error message.
*The same request works fine, while I use a shapefile as data source.*

My second question:
Shouldn't be there a 'where'-clause in the database selection, which 
contain the time parameter?
Or works the wms-time like a Filter, which always ask all data from the 
database.
Only in the second step, the data is filtered for the desired time?

Did anyone has an idea?

The type of the time data in the mySQL database is "DATETIME".

mysql.log
111014 13:27:45     4 Connect  user at server on database
      4 Query DESCRIBE `table`
      4 Query SELECT type, coord_dimension FROM geometry_columns WHERE 
f_table_name='table'
      4 Query SELECT srid FROM geometry_columns WHERE f_table_name = 'table'
      4 Query SELECT column1, column2 FROM table
      4 Query SELECT type FROM geometry_columns WHERE f_table_name='table'
      4 Query SELECT srid FROM geometry_columns WHERE f_table_name = 'table'
      4 Query SELECT column1, column2 FROM table
      4 Quit

mapserv.log:
[Fri Oct  7 16:05:42 2011].982953 CGI Request 1 on process 18953
[Fri Oct  7 16:05:42 2011].983461 msWMSLoadGetMapParams(): enabling 
non-square pixels.
[Fri Oct  7 16:05:42 2011].990638 msDrawMap(): kicking into non-square 
pixel preserving mode.
[Fri Oct  7 16:05:42 2011].991160 
msOGRFileOpen(MYSQL:tabelle,host=host,user=user,password=passwort,port=port)...
[Fri Oct  7 16:05:42 2011].991205 
OGROPen(MYSQL:tabelle,host=host,user=readonly,password=readonly,port=port)
[Fri Oct  7 16:05:43 2011].20413 
msConnPoolRegister(layer,MYSQL:tabelle,host=host,user=readonly,password=passwort,port=port,0x5417290)
[Fri Oct  7 16:05:43 2011].67656 
msOGRLayerClose(MYSQL:tabelle,host=host,user=readonly,password=passwort,port=port).
[Fri Oct  7 16:05:43 2011].67662 
msOGRFileClose(MYSQL:tabelle,host=host,user=readonly,password=readonly,port=port,-1).
[Fri Oct  7 16:05:43 2011].67672 
msConnPoolRelease(layer,MYSQL:tabelle,host=host,user=readonly,password=passwort,port=port,0x5417290)
[Fri Oct  7 16:05:43 2011].67675 
msConnPoolClose(MYSQL:tabelle,host=host,user=readonly,password=passwort,port=port,0x5417290)
[Fri Oct  7 16:05:43 2011].67849 msDrawMap(): Layer 2 (layer), 0.077s
[Fri Oct  7 16:05:43 2011].67867 msDrawMap(): Drawing Label Cache, 0.000s
[Fri Oct  7 16:05:43 2011].67871 msDrawMap() total time: 0.084s
[Fri Oct  7 16:05:43 2011].170031 msSaveImage() total time: 0.102s
[Fri Oct  7 16:05:43 2011].170228 mapserv request processing time 
(msLoadMap not incl.): 0.187s
[Fri Oct  7 16:05:43 2011].170234 msFreeMap(): freeing map at 0x4f6cf30.

getCapabilities:
<Layer queryable="0" opaque="0" cascaded="0">
<Name>layer</Name>
<Title>title</Title>
<Abstract>abstract</Abstract>
<CRS>EPSG:4326</
<EX_GeographicBoundingBox>
<westBoundLongitude>5.18808</westBoundLongitude>
<eastBoundLongitude>15</eastBoundLongitude>
<southBoundLatitude>46.5582</southBoundLatitude>
<northBoundLatitude>55.8653</northBoundLatitude>
</EX_GeographicBoundingBox>
<BoundingBox CRS="EPSG:4326" minx="46.5582" miny="5.18808" 
maxx="55.8653" maxy="15"/>
<Dimension name="time" units="ISO8601" default="2010-01-10T00:00:00Z" 
nearestValue="0">2010-01-10T00:00:00Z</Dimension>
</Layer>


mysql version: 5.5.10-log
MapServer version 5.6.5


-- 
Mit freundlichen Grüßen

Katharina Sambs