<html><head></head><body 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></body></html>