[mapserver-users] data parameter in tileindex

[Zmitser Kozhukh]

Dear Carlos, it is not about mapfile, it is in location cell of tileindex. It is one cell in table (database table, dbf file etc.), and I need to put there both connection and data details. The question is how to make it so that mapserver parses it correctly.
Sincerely, Zmitser
>Среда, 24 марта 2021, 6:53 +03:00 от Carlos Ruiz <boolean10001 at yahoo.com>:
> 
>Zmitser,
> 
>You have to have the following on a MAP file:
> 
>LAYER
> 
>...
> 
>CONNECTION "host=<HOST> ... password=<PASSWORD>"
>CONNECTIONTYPE <CONNECTION_TYPE>
>DATA "<GEOM_COLUMN> FROM <TABLE NAME> USING UNIQUE <ID> USING SRID=<SRID>"
> 
>...
> 
>END
> 
>On DATA you must specify the name of the geometry column and the table, if you're using a database. If you are using a shape file you just have to include the DATA keyword with the path and the name of the SHP file.
> 
> 
>On Tuesday, March 23, 2021, 2:34:48 AM CST, Zmitser Kozhukh via mapserver-users < mapserver-users at lists.osgeo.org > wrote:
> 
> 
>Dear mapserver users, I need to specify data parameter at the location item of tileindex.
>So far, I have tried many possibilities but none works:
>‘host=127.0.0.1 dbname=database user=admin password=admin DATA "geom from table using unique id using srid=4326"’
>or
>host=127.0.0.1 dbname=database user=admin password=admin data="geom from table using unique id using srid=4326"
>etc.
>Still I get an error :
>msDrawMap(): Image handling error. Failed to draw layer named 'layer'. msPostGISLayerOpen(): Query error. Nothing specified in DATA statement.
>Could someone please tell in which format data statement should be?
>In documentation it is written vaguely:
>Normally the location should contain the path to the tile file relative to the shapepath, not relative to the tileindex itself. If the DATA parameter contains a value then it is added to the end of the location.
> 
>--
>Zmitser Kozhukh _______________________________________________
>mapserver-users mailing list
>mapserver-users at lists.osgeo.org
>https://lists.osgeo.org/mailman/listinfo/mapserver-users 
 
 
--
Zmitser Kozhukh
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20210324/ff90ae51/attachment.html>