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 <boolean10...@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@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@lists.osgeo.org >https://lists.osgeo.org/mailman/listinfo/mapserver-users -- Zmitser Kozhukh
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users