[mapserver-users] MapCache Time Dimensions Problem

[Stephan Meißl]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Mike,

did you try running the query directly in sqlite substituting :tileset,
:start_timestamp, and :end_timestamp with actual values? What schema
does your sqlite database have? Is the path to the dbfile absolute and
readable?

I could send you a working example if you want. Let me know.

cu
Stephan


On 06/07/2015 01:13 AM, Michael Smith wrote:
> I've created a timedimension tileset in MapCache and created the backend
> sqlite db that has the available times. The mapserver backend handles
> the WMS TIME requests without a problem.  And when I query mapcache
> without a &TIME=, I get my the default output. 
> 
> However, if I specify a &TIME= parameter to MapCache (as a WMS or WMTS
> request), I get 
> 
> no matching entry for given TIME dimension "TIME" in tileset "earthquakes"
> 
> I don't know what I need to change to get MapCache to recognize the TIME
> parameter. From the docs on RFC-96
> (http://mapserver.org/development/rfc/ms-rfc-96.html) I don't see what
> else to specify to set MapCache to understand TIME requests. 
> 
> I can see MapCache making the backend requests to generate images from
> the time values in the sqlite DB but only with the default specified in
> the <timedimension>. It never understands new ranges passed with &TIME=.
> 
> My tileset looks like
> 
> <tileset name="earthquakes">
>       <source>earthquakes</source>
>       <cache>sqlite</cache>
>       <grid>GoogleMapsCompatible</grid>
>       <format>PNG</format>
>       <metatile>5 5</metatile>
>       <metabuffer>10</metabuffer>
>       <expires>3600</expires>
>       <timedimension type="sqlite" default="2014-03-25T12Z" >
>        <dbfile>/u02/mapcache/dbtime2.db</dbfile>
>        <query>select
>  strftime('%Y-%m-%dT%H:%M:%SZ',start)||'/'||strftime('%Y-%m-%dT%H:%M:%SZ',end)
> from time
>               where source_id=:tileset
>                 and start_time>=datetime(:start_timestamp,'unixepoch')
>                 and end_time<=datetime(:end_timestamp,'unixepoch')
>                 order by end_time
>        </query>
>      </timedimension>
>    </tileset>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBAgAGBQJVd06lAAoJEKNQXeNWi+qta2kQAMVFCsQ95RFUQbe8h7AkpnZD
Io7OYrziPm7mx62F8OJmdaL4EQLVXIUqlNgxEDq4yu4phNr008mmyV26h4B1xcvA
7v3XHsw0Mm+rBbfdC+H110woUnfhNLjlO03sgd8MEpinrsxnhAi0RZOIbJpXQRyH
UiRTxtpnCKapeY1ApIORznf450GMrHx4rGAQ5DWUinnWFlKFuARwkyI+brLdae/j
gUXQYIyDzpaURCPDfaYPdUlNiKLM2GDeZY59WvBozU68LXKJS236DNXj0NBIuBal
Y4JD5DbwOYqYE5kA69cMDwOB5whNjkoQFvOUGS9mDB1Bn0mUBWUGI4alkTOIoBsl
St4QiX6CdcSkcN8c39ErR4C3b+oEbrWwEje0aAhNT7Bp9dOaRahcoSGcGXuIHnB9
VQ/efIbaVpeGnTYtV65VpKBNiy5iqcygig6a3y2fnMO4G3eQkLAA12GxoSJHv+Fl
ZqQmtUBFtdQUYb19E0MWJhjs06IX2lqh3uo9CcgDFygO5LJ4m6r096Bq7+dbbzOn
hWZCM1MtsQ31FGjAVcgKsmBPBamOqNuNi+X8YvH1nP2fjJx+0PIeYFzWRgAKuX3F
dehpryaXwAG3N8TDNYd/2lIucAsKowamEDcQ38k017vxl7q1/RflGcmveK0Xqe5B
Xyk+HREWcAb2B6oGFVro
=mBOf
-----END PGP SIGNATURE-----