<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Some additional info:<div><br></div><div>Since I need this data only for GetFeatureRequest, it seems like I should use JOIN within a LAYER object. So I did the following:</div><div><br></div><div>LAYER</div><div>...</div><div> DATA "my"</div><div> ...</div><div> ...</div><div><div><div> DUMP TRUE</div><div> TEMPLATE "template.html"</div><div> HEADER "template_header.html"</div><div> FOOTER "template_footer.html"</div></div><div> JOIN</div><div> NAME "test"</div><div> CONNECTION "MySQL:gis,host=localhost,user=gis,password=gis,tables=katastar_vodnjan"</div><div># CONNECTION "PG:host=localhost user=postgres password=runda711 dbname=vodnjan port=5432" </div><div> CONNECTIONTYPE ogr</div><div> TABLE "katastar_vodnjan"</div><div> FROM "KO_KC"</div><div> TO "broj_ko_kc"</div><div> TYPE ONE-TO-MANY</div><div> TEMPLATE "template_join.html"</div><div>#<span class="Apple-tab-span" style="white-space:pre"> </span>HEADER "template_header.html"</div><div>#<span class="Apple-tab-span" style="white-space:pre"> </span>FOOTER "template_footer.html" </div><div> END </div><div><br></div><div>I tried this with joined data from MySQL and from Postgres. No success. The interesting thing is, when I do:</div><div><br></div><div>shp2img -m my.map -o image.png -l "mylayer" -all_debug 3</div><div><br></div><div>I get:</div><div><br></div><div><div>[Tue Sep 13 08:58:04 2011].271467 msLoadMap(): 0.029s</div><div>[Tue Sep 13 08:58:04 2011].356888 msDrawMap(): Layer 0 (katastar_vodnjan_poligon), 0.083s</div><div>[Tue Sep 13 08:58:04 2011].356943 msDrawMap(): Drawing Label Cache, 0.000s</div><div>[Tue Sep 13 08:58:04 2011].356956 msDrawMap() total time: 0.085s</div><div>[Tue Sep 13 08:58:04 2011].399386 msSaveImage() total time: 0.042s</div><div>[Tue Sep 13 08:58:04 2011].402773 msPOSTGRESQLJoinClose() already close or never opened.</div><div>[Tue Sep 13 08:58:04 2011].402821 shp2img total time: 0.161s</div></div><div><br></div><div>Does anybody know what is it? It happens for MySQL and Postgres database join</div><div><br></div><div>thanks very much</div><div><br></div><div>dejan</div><div><br></div><div><br></div><div><div>On 12. ruj. 2011., at 14:03, Dejan Gambin wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi,<div><br></div><div>After solving my compile problem (thanks to thomas), I need to do GetFeatureInfo to a shape layer joined to MySQL table (non-spatial join).</div><div><br></div><div>I compiled MapServer with MySQL support and everything seems ok, but "mapserv -v" doesn't return "INPUT=MYSQL". Is it supposed to anyway? Or it is enough to be compiled with gdal/ogr that supports MySQL?</div><div><br></div><div>Because - when I do this:</div><div><br></div><div>ogrinfo -sql "SELECT * FROM my LEFT JOIN 'MYSQL:gis,host=localhost,user=gis,password=gis'.katastar_vodnjan ON my.KO_KC=katastar_vodnjan.broj_ko_kc" /var/www/data/vodnjan/my.shp</div><div><br></div><div>I get all the attributes from shape (dbf) and MySQL, so everything seems fine</div><div><br></div><div>But using thi:</div><div><br></div><div><div>LAYER # katastar vodnjan poligoni</div><div> NAME "mylayer"</div><div> STATUS ON</div><div> CONNECTIONTYPE ogr </div><div> CONNECTION "/var/www/data/vodnjan/my.shp"</div><div> DATA "SELECT * FROM my LEFT JOIN 'MYSQL:gis,host=localhost,user=gis,password=gis'.katastar_vodnjan ON my.KO_KC=katastar_vodnjan.broj_ko_kc"</div><div> TYPE POLYGON </div></div><div>...</div><div><br></div><div>I don't get any information with GetFeatureInfo. The request is like:</div><div><br></div><div><a href="http://www.coin.hr/cgi-bin/mywms61?SERVICE=WMS&VERSION=1.1.1&REQUEST=GetFeatureInfo&BBOX=5403800,4981350,5403980,4981460&SRS=EPSG:31275&WIDTH=400&HEIGHT=300&LAYERS=katastar_vodnjan_poligon&STYLES=&FORMAT=image/png&TRANSPARENT=true&QUERY_LAYERS=mylayer&INFO_FORMAT=gml&X=200&Y=100">http://www.coin.hr/cgi-bin/mywms61?SERVICE=WMS&VERSION=1.1.1&REQUEST=GetFeatureInfo&BBOX=5403800,4981350,5403980,4981460&SRS=EPSG:31275&WIDTH=400&HEIGHT=300&LAYERS=katastar_vodnjan_poligon&STYLES=&FORMAT=image/png&TRANSPARENT=true&QUERY_LAYERS=mylayer&INFO_FORMAT=gml&X=200&Y=100</a></div><div><br></div><div>Using the same request with regular mapfile:</div><div><br></div><div><div><div>LAYER # katastar vodnjan poligoni</div><div> NAME "mylayer"</div><div> STATUS ON</div><div> DATA "my"</div><div> TYPE POLYGON </div></div><div>...</div></div><div><br></div><div>returns one feature and its attributes from the dbf (tha is OK)</div><div><br></div><div>I have also tried with JOIN clause in LAYER part, but this doesn't work either. Do I have to use owf? Am I doing something wrong?</div><div><br></div><div>regards, dejan</div></div>_______________________________________________<br>mapserver-users mailing list<br><a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>http://lists.osgeo.org/mailman/listinfo/mapserver-users<br></blockquote></div><br></div></body></html>