[mapserver-users] problem with shape files
Similar problem, though the image comes through when MODE = MAP in the call. If you solve this, I'd like to know. Good luck Richard MacNeill Spatial Information Coordinator Bush Heritage Australia PO Box 329 Flinders Lane, Melbourne Vic 8009 Level 5, 395 Collins Street, Melbourne Vic 3000 www.bushheritage.org.au http://www.bushheritage.org.au Part time (Monday to Wednesday) T: +61(0)3 8610 9110 F: +61(0)3 8610 9199 http://www.bushheritage.org.au/bush-heritage-turns-20.html image001.jpg___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] mapserver 6.0.1 and cairo SVG
Hello! Friends, I have some issues with getting SVG output working here... I have latest MS4W install: MapServer version 6.0.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=CAIRO SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS=FRIBIDI SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUPPORTS=GEOS INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE I don't see OUTPUT=SVG there, but I guess its normal, since this MS version has non-native (Cairo) SVG support. Well, but even if I have configured in my mapfile the outputformat like that: IMAGETYPE svg OUTPUTFORMAT NAME svg DRIVER CAIRO/SVG MIMETYPE image/svg+xml IMAGEMODE RGB EXTENSION svg END ...and get correct GetCapabilities request, where SVG format is listed as first, then I still cant see SVG format listed when using ArcMap as WMS-client (there are PNG24, JPEG and PNG8 listed though). Also when I send GetMap request (setting FORMAT=image/svg+xml) through browser, I get response: msWMSLoadGetMapParams(): Image handling error. Unsupported output format (image/svg xml). Where should I dig into? Thank you in advance, Raivo Alla, Estonia ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] GetFeatureInfo using MySQL join - additional info about segmentation fault
I tried debugging with gdb but only get this: Program received signal SIGTRAP, Trace/breakpoint trap. 0x7f8b8d76c8b7 in ?? () from /lib64/ld-linux-x86-64.so.2 and with backtrace (bt): #0 0x7f8b8d76c8b7 in ?? () from /lib64/ld-linux-x86-64.so.2 #1 0x7f8b8d75b1bc in ?? () from /lib64/ld-linux-x86-64.so.2 #2 0x7f8b8d76bb35 in ?? () from /lib64/ld-linux-x86-64.so.2 #3 0x7f8b8d75931b in ?? () from /lib64/ld-linux-x86-64.so.2 #4 0x7f8b8d758a68 in ?? () from /lib64/ld-linux-x86-64.so.2 #5 0x0002 in ?? () #6 0x7fff531bc8e2 in ?? () #7 0x in ?? () regards, dejan On 14. ruj. 2011., at 12:33, Dejan Gambin wrote: I have found Segmentation fault message in apache error.log each time I run GetFeatureInfo with MySQL join. No problem with PostgreSQL :-( Any clue? Should I report it as a bug? dejan On 13. ruj. 2011., at 22:51, Dejan Gambin wrote: Of course. And everything works when using ogrinfo for example dejan On 13. ruj. 2011., at 20:19, Carlos Ruiz wrote: Dejan, One question: If you look at the OGR supported formats, does MySQL appears ? Cheers from México IC Carlos Ruiz From: Dejan Gambin dejan.gam...@coin.hr To: mapserver-users@lists.osgeo.org Sent: Tuesday, September 13, 2011 8:13 AM Subject: Re: [mapserver-users] GetFeatureInfo using MySQL join - additional info I was finally successful with getting data from joined table through GetFeatureInfo. But: 1. It works only for PostgreSQL connection, not with MySQL - is it supposed to be so in MapServer 6? I saw the JOIN documentation changed and there is no MySQL mentioned any more/ 2. I get nicely returned data from one-to-many join, using templates (thanks to Ted Spradley post). But gml returns only the main data, not the joined data. Is it supposed to be so? Thanks very much regards, dejan On 13. ruj. 2011., at 09:00, Dejan Gambin wrote: Some additional info: Since I need this data only for GetFeatureRequest, it seems like I should use JOIN within a LAYER object. So I did the following: LAYER ... DATA my ... ... DUMP TRUE TEMPLATE template.html HEADER template_header.html FOOTER template_footer.html JOIN NAME test CONNECTION MySQL:gis,host=localhost,user=gis,password=gis,tables=katastar_vodnjan #CONNECTION PG:host=localhost user=postgres password=runda711 dbname=vodnjan port=5432 CONNECTIONTYPE ogr TABLE katastar_vodnjan FROM KO_KC TO broj_ko_kc TYPE ONE-TO-MANY TEMPLATE template_join.html # HEADER template_header.html # FOOTER template_footer.html END I tried this with joined data from MySQL and from Postgres. No success. The interesting thing is, when I do: shp2img -m my.map -o image.png -l mylayer -all_debug 3 I get: [Tue Sep 13 08:58:04 2011].271467 msLoadMap(): 0.029s [Tue Sep 13 08:58:04 2011].356888 msDrawMap(): Layer 0 (katastar_vodnjan_poligon), 0.083s [Tue Sep 13 08:58:04 2011].356943 msDrawMap(): Drawing Label Cache, 0.000s [Tue Sep 13 08:58:04 2011].356956 msDrawMap() total time: 0.085s [Tue Sep 13 08:58:04 2011].399386 msSaveImage() total time: 0.042s [Tue Sep 13 08:58:04 2011].402773 msPOSTGRESQLJoinClose() already close or never opened. [Tue Sep 13 08:58:04 2011].402821 shp2img total time: 0.161s Does anybody know what is it? It happens for MySQL and Postgres database join thanks very much dejan On 12. ruj. 2011., at 14:03, Dejan Gambin wrote: Hi, After solving my compile problem (thanks to thomas), I need to do GetFeatureInfo to a shape layer joined to MySQL table (non-spatial join). 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? Because - when I do this: 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 I get all the attributes from shape (dbf) and MySQL, so everything seems fine But using thi: LAYER # katastar vodnjan poligoni NAME mylayer STATUS ON CONNECTIONTYPE ogr CONNECTION /var/www/data/vodnjan/my.shp 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 TYPE POLYGON ... I don't get any information with GetFeatureInfo. The request is like: http://www.coin.hr/cgi-bin/mywms61?SERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoBBOX=5403800,4981350,5403980,4981460SRS=EPSG:31275WIDTH=400HEIGHT=300LAYERS=katastar_vodnjan_poligonSTYLES=FORMAT=image/pngTRANSPARENT=trueQUERY_LAYERS=mylayerINFO_FORMAT=gmlX=200Y=100 Using the same request with regular mapfile: LAYER # katastar vodnjan poligoni NAME mylayer STATUS ON DATA my TYPE POLYGON ...
Re: [mapserver-users] mapserver 6.0.1 and cairo SVG
Hi, Works as an url encoded format=image%2Fsvg%2Bxml from browser. I do not know if this is how it should be, though. -Jukka Rahkonen- Lähettäjä: mapserver-users-boun...@lists.osgeo.org [mapserver-users-boun...@lists.osgeo.org] käyttäjän Raivo Alla [snaper...@gmail.com] puolesta Lähetetty: 14. syyskuuta 2011 9:47 Vastaanottaja: mapserver-users@lists.osgeo.org Aihe: [mapserver-users] mapserver 6.0.1 and cairo SVG Hello! Friends, I have some issues with getting SVG output working here... I have latest MS4W install: MapServer version 6.0.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=CAIRO SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS=FRIBIDI SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUPPORTS=GEOS INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE I don't see OUTPUT=SVG there, but I guess its normal, since this MS version has non-native (Cairo) SVG support. Well, but even if I have configured in my mapfile the outputformat like that: IMAGETYPE svg OUTPUTFORMAT NAME svg DRIVER CAIRO/SVG MIMETYPE image/svg+xml IMAGEMODE RGB EXTENSION svg END ...and get correct GetCapabilities request, where SVG format is listed as first, then I still cant see SVG format listed when using ArcMap as WMS-client (there are PNG24, JPEG and PNG8 listed though). Also when I send GetMap request (setting FORMAT=image/svg+xml) through browser, I get response: msWMSLoadGetMapParams(): Image handling error. Unsupported output format (image/svg xml). Where should I dig into? Thank you in advance, Raivo Alla, Estonia ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] RE: mapserver 6.0.1 and cairo SVG
Thanks! A step forward! This way it suggest me to declare TEMPLATE in the WEB section. Hence the question: how should I put this SVG output file in html template? SVG file itself was generated in TMP folder, filename contains randomly generated numbers... I would like the browser to display the SVG output on the run. Thanks again, Raivo Hi, Works as an url encoded format=image%2Fsvg%2Bxml from browser. I do not know if this is how it should be, though. -Jukka Rahkonen- Lähettäjä: mapserver-users-bounces at lists.osgeo.org[mapserver-users-bounces at lists.osgeo.org] käyttäjän Raivo Alla [snaperski at gmail.com] puolesta Lähetetty: 14. syyskuuta 2011 9:47 Vastaanottaja: mapserver-users at lists.osgeo.org Aihe: [mapserver-users] mapserver 6.0.1 and cairo SVG Hello! Friends, I have some issues with getting SVG output working here... I have latest MS4W install: MapServer version 6.0.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=CAIRO SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS=FRIBIDI SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUPPORTS=GEOS INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE I don't see OUTPUT=SVG there, but I guess its normal, since this MS version has non-native (Cairo) SVG support. Well, but even if I have configured in my mapfile the outputformat like that: IMAGETYPE svg OUTPUTFORMAT NAME svg DRIVER CAIRO/SVG MIMETYPE image/svg+xml IMAGEMODE RGB EXTENSION svg END ...and get correct GetCapabilities request, where SVG format is listed as first, then I still cant see SVG format listed when using ArcMap as WMS-client (there are PNG24, JPEG and PNG8 listed though). Also when I send GetMap request (setting FORMAT=image/svg+xml) through browser, I get response: msWMSLoadGetMapParams(): Image handling error. Unsupported output format (image/svg xml). Where should I dig into? Thank you in advance, Raivo Alla, Estonia ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] GetLegendGraphic with SLD missing mandatroy layer parameter
hello i try to obtain legendgraphic from mapserv with a sld definition but it seems i forgot a parameter in my request http://192.168.12.60/cgi-bin/mapserv?map=/var/www/geomod/mapfile/29411.mapSLD=http://192.168.12.60/media/sld/29411.sldLAYERS=29411FORMAT=image/pngTRANSPARENT=trueVISIBILITY=trueSERVICE=WMSVERSION=1.1.1REQUEST=GetLegendGraphicWIDTH=200HEIGHT=100http://192.168.12.60/cgi-bin/mapserv?map=/var/www/geomod/mapfile/29411.mapSLD=http://192.168.12.60/media/sld/29411.sldLAYERS=29411FORMAT=image/pngTRANSPARENT=trueVISIBILITY=trueSERVICE=WMSVERSION=1.1.1REQUEST=GetLegendGraphicLAYERS=29411STYLES=EXCEPTIONS=application%2Fvnd.ogc.se_inimageSRS=EPSG%3A4326BBOX=4.760774711589825,45.72893975925065,4.974066894457241,45.78262308062963WIDTH=200HEIGHT=100 WMS server error. Mandatory LAYER parameter missing in GetLegendGraphic request does someone know about it ? regards T. attachment: mapserv.png___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] GetLegendGraphic with SLD missing mandatroy layer parameter
Just as the error says: you have to include the layer parameter, instead of the layerS parameter. So change layers to layer and you should be fine. Met vriendelijke groet, Meine Toonen B3Partners BV Tel: 030 214 2083 _ From: Tonton [mailto:to.ton...@gmail.com] To: mapserver-users [mailto:mapserver-users@lists.osgeo.org] Sent: Wed, 14 Sep 2011 16:57:20 +0200 Subject: [mapserver-users] GetLegendGraphic with SLD missing mandatroy layer parameter hello i try to obtain legendgraphic from mapserv with a sld definition but it seems i forgot a parameter in my request http://192.168.12.60/cgi-bin/mapserv?map=/var/www/geomod/mapfile/29411.mapSLD=http://192.168.12.60/media/sld/29411.sldLAYERS=29411FORMAT=image/pngTRANSPARENT=trueVISIBILITY=trueSERVICE=WMSVERSION=1.1.1REQUEST=GetLegendGraphicWIDTH=200HEIGHT=100 WMS server error. Mandatory LAYER parameter missing in GetLegendGraphic request does someone know about it ? regards T. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] msTileCacheLoadConfig(): config file (null) specified in MS_TILECACHE_CONFIG_FILE not found
I'm trying to suppress this error: [Wed Sep 14 10:51:38 2011] [error] [client 127.0.0.1] msTileCacheLoadConfig(): config file (null) specified in MS_TILECACHE_CONFIG_FILE not foundmsTileCacheLoadConfig(): no configuration file found.msTileCacheDispatchRequest(): failed to load tilecache configuration file., referer: http://localhost/map.html The MS4W list talks about getting rid of it here: http://osgeo-org.1803224.n2.nabble.com/MS4W-Users-msTileCache-problem-td5913256.htmlhttp://osgeo-org.1803224.n2.nabble.com/MS4W-Users-msTileCache-problem-td5913256.html but the implicit prescription, turning DEBUG off, isn't working for me. I have set DEBUG OFF in my mapfile, as well as set SetEnv MS_DEBUGLEVEL 0 in my apache conf. This error still gets thrown on every image draw. Does anybody have any ideas? I haven't set MS_TILECACHE_CONFIG_FILE anywhere. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] GetLegendGraphic with SLD missing mandatroy layer parameter
YES ! thanks you On Wed, Sep 14, 2011 at 5:01 PM, Meine Toonen meinetoo...@b3partners.nlwrote: ** Just as the error says: you have to include the layer parameter, instead of the layerS parameter. So change layers to layer and you should be fine. Met vriendelijke groet, Meine Toonen B3Partners BV Tel: 030 214 2083 -- *From:* Tonton [mailto:to.ton...@gmail.com] *To:* mapserver-users [mailto:mapserver-users@lists.osgeo.org] *Sent:* Wed, 14 Sep 2011 16:57:20 +0200 *Subject:* [mapserver-users] GetLegendGraphic with SLD missing mandatroy layer parameter hello i try to obtain legendgraphic from mapserv with a sld definition but it seems i forgot a parameter in my request http://192.168.12.60/cgi-bin/mapserv?map=/var/www/geomod/mapfile/29411.mapSLD=http://192.168.12.60/media/sld/29411.sldLAYERS=29411FORMAT=image/pngTRANSPARENT=trueVISIBILITY=trueSERVICE=WMSVERSION=1.1.1REQUEST=GetLegendGraphicWIDTH=200HEIGHT=100http://192.168.12.60/cgi-bin/mapserv?map=/var/www/geomod/mapfile/29411.mapSLD=http://192.168.12.60/media/sld/29411.sldLAYERS=29411FORMAT=image/pngTRANSPARENT=trueVISIBILITY=trueSERVICE=WMSVERSION=1.1.1REQUEST=GetLegendGraphicLAYERS=29411STYLES=EXCEPTIONS=application%2Fvnd.ogc.se_inimageSRS=EPSG%3A4326BBOX=4.760774711589825,45.72893975925065,4.974066894457241,45.78262308062963WIDTH=200HEIGHT=100 WMS server error. Mandatory LAYER parameter missing in GetLegendGraphic request does someone know about it ? regards T. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] RE: mapserver 6.0.1 and cairo SVG
Hi, This requests shows me a map on a browser: http://188.64.1.61/cgi-bin/ms_ows?REQUEST=GetMapSERVICE=WMSVERSION=1.1.1WIDTH=1059HEIGHT=653LAYERS=bordersTRANSPARENT=TRUEFORMAT=image%2Fsvg%2BxmlBBOX=2189023.591117917,6540740.0,4199096.408882082,7780190.0SRS=EPSG:2393STYLES= I do not have a template set anywhere in the corresponding mapfile. Doesn't a request like this work for you? -Jukka Rahkonen- Raivo Alla wrote: Thanks! A step forward! This way it suggest me to declare TEMPLATE in the WEB section. Hence the question: how should I put this SVG output file in html template? SVG file itself was generated in TMP folder, filename contains randomly generated numbers... I would like the browser to display the SVG output on the run. Thanks again, Raivo Hi, Works as an url encoded format=image%2Fsvg%2Bxml from browser. I do not know if this is how it should be, though. -Jukka Rahkonen- Lähettäjä: mapserver-users-bounces at lists.osgeo.orghttp://lists.osgeo.org [mapserver-users-bounces at lists.osgeo.orghttp://lists.osgeo.org] käyttäjän Raivo Alla [snaperski at gmail.comhttp://gmail.com] puolesta Lähetetty: 14. syyskuuta 2011 9:47 Vastaanottaja: mapserver-users at lists.osgeo.orghttp://lists.osgeo.org Aihe: [mapserver-users] mapserver 6.0.1 and cairo SVG Hello! Friends, I have some issues with getting SVG output working here... I have latest MS4W install: MapServer version 6.0.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=CAIRO SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS=FRIBIDI SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUPPORTS=GEOS INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE I don't see OUTPUT=SVG there, but I guess its normal, since this MS version has non-native (Cairo) SVG support. Well, but even if I have configured in my mapfile the outputformat like that: IMAGETYPE svg OUTPUTFORMAT NAME svg DRIVER CAIRO/SVG MIMETYPE image/svg+xml IMAGEMODE RGB EXTENSION svg END ...and get correct GetCapabilities request, where SVG format is listed as first, then I still cant see SVG format listed when using ArcMap as WMS-client (there are PNG24, JPEG and PNG8 listed though). Also when I send GetMap request (setting FORMAT=image/svg+xml) through browser, I get response: msWMSLoadGetMapParams(): Image handling error. Unsupported output format (image/svg xml). Where should I dig into? Thank you in advance, Raivo Alla, Estonia ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Yellow lines over generated image
Hi, I'm doing development using Mapserver in the following environment: * Mac OS X Lion * Mapserver 6.0.1 * PHP 5.3.6 (shipped with Mac OS X) My generated image, using PHP Mapscript to load a mapfile and adjust layer visibility, has vertical yellow lines overlaying it in seemingly random places. If I regenerate the image, the lines are rendered in different locations, sometimes completely covering the image in a yellow tint. An example can be seen at http://i.imgur.com/j2dNS.png (5.6 KB image) I've previously used a self-built PHP 5.3.8 on the same system, and have not seen the lines. They also do not appear on our production server which uses the same Mapserver, PHP 5.3.8, and CentOS Linux. Has anyone seen this before, and has an idea of how to remedy it? I can provide more information, build parameters, etc., if desired. Thanks! -- Pete Deffendol Senior Web Developer Multimedia Data Services Corp. p...@mdsc.com ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] MapServer tiles under Tux
hi there, has anyone tried to host MapServer generated tilesets using Tux http server instead of using Apache? The platform I was thinking is to use Apache for hosting server languages (PHP, Python, Java) + MapServer CGI/MapScripts + cache devices and Tux for hosting generated tilesets. thanks in advance -- *Eduardo Patto Kanegae* http://www.webmapit.com ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] GetFeatureInfo using MySQL join - additional info about segmentation fault
Another thing - I tried this on another machine. I get this: Program received signal EXC_BAD_ACCESS, Could not access memory. Reason: KERN_INVALID_ADDRESS at address: 0x 0x7fff88337c00 in strlen () (gdb) bt #0 0x7fff88337c00 in strlen () #1 0x0001cf77aa67 in msPOSTGRESQLJoinConnect () #2 0x0001cf6b578b in msReturnNestedTemplateQuery () #3 0x0001cf70bbd9 in msWMSFeatureInfo () #4 0x0001cf710584 in msWMSDispatch () #5 0x0001cf7389e3 in msOWSDispatch () #6 0x0001cf67728d in main () My question is - why msPOSTGRESQLJoinConnect is called if join is defined for MySQL: JOIN NAME test CONNECTIONTYPE ogr CONNECTION MySQL:gis,user=gis,password=gis,port=3306 TABLE katastar_vodnjan FROM KO_KC TO broj_ko_kc TYPE ONE-TO-MANY TEMPLATE template_join.html END regards, dejan On 14. ruj. 2011., at 13:05, Dejan Gambin wrote: I tried debugging with gdb but only get this: Program received signal SIGTRAP, Trace/breakpoint trap. 0x7f8b8d76c8b7 in ?? () from /lib64/ld-linux-x86-64.so.2 and with backtrace (bt): #0 0x7f8b8d76c8b7 in ?? () from /lib64/ld-linux-x86-64.so.2 #1 0x7f8b8d75b1bc in ?? () from /lib64/ld-linux-x86-64.so.2 #2 0x7f8b8d76bb35 in ?? () from /lib64/ld-linux-x86-64.so.2 #3 0x7f8b8d75931b in ?? () from /lib64/ld-linux-x86-64.so.2 #4 0x7f8b8d758a68 in ?? () from /lib64/ld-linux-x86-64.so.2 #5 0x0002 in ?? () #6 0x7fff531bc8e2 in ?? () #7 0x in ?? () regards, dejan On 14. ruj. 2011., at 12:33, Dejan Gambin wrote: I have found Segmentation fault message in apache error.log each time I run GetFeatureInfo with MySQL join. No problem with PostgreSQL :-( Any clue? Should I report it as a bug? dejan On 13. ruj. 2011., at 22:51, Dejan Gambin wrote: Of course. And everything works when using ogrinfo for example dejan On 13. ruj. 2011., at 20:19, Carlos Ruiz wrote: Dejan, One question: If you look at the OGR supported formats, does MySQL appears ? Cheers from México IC Carlos Ruiz From: Dejan Gambin dejan.gam...@coin.hr To: mapserver-users@lists.osgeo.org Sent: Tuesday, September 13, 2011 8:13 AM Subject: Re: [mapserver-users] GetFeatureInfo using MySQL join - additional info I was finally successful with getting data from joined table through GetFeatureInfo. But: 1. It works only for PostgreSQL connection, not with MySQL - is it supposed to be so in MapServer 6? I saw the JOIN documentation changed and there is no MySQL mentioned any more/ 2. I get nicely returned data from one-to-many join, using templates (thanks to Ted Spradley post). But gml returns only the main data, not the joined data. Is it supposed to be so? Thanks very much regards, dejan On 13. ruj. 2011., at 09:00, Dejan Gambin wrote: Some additional info: Since I need this data only for GetFeatureRequest, it seems like I should use JOIN within a LAYER object. So I did the following: LAYER ... DATA my ... ... DUMP TRUE TEMPLATE template.html HEADER template_header.html FOOTER template_footer.html JOIN NAME test CONNECTION MySQL:gis,host=localhost,user=gis,password=gis,tables=katastar_vodnjan #CONNECTION PG:host=localhost user=postgres password=runda711 dbname=vodnjan port=5432 CONNECTIONTYPE ogr TABLE katastar_vodnjan FROM KO_KC TO broj_ko_kc TYPE ONE-TO-MANY TEMPLATE template_join.html # HEADER template_header.html # FOOTER template_footer.html END I tried this with joined data from MySQL and from Postgres. No success. The interesting thing is, when I do: shp2img -m my.map -o image.png -l mylayer -all_debug 3 I get: [Tue Sep 13 08:58:04 2011].271467 msLoadMap(): 0.029s [Tue Sep 13 08:58:04 2011].356888 msDrawMap(): Layer 0 (katastar_vodnjan_poligon), 0.083s [Tue Sep 13 08:58:04 2011].356943 msDrawMap(): Drawing Label Cache, 0.000s [Tue Sep 13 08:58:04 2011].356956 msDrawMap() total time: 0.085s [Tue Sep 13 08:58:04 2011].399386 msSaveImage() total time: 0.042s [Tue Sep 13 08:58:04 2011].402773 msPOSTGRESQLJoinClose() already close or never opened. [Tue Sep 13 08:58:04 2011].402821 shp2img total time: 0.161s Does anybody know what is it? It happens for MySQL and Postgres database join thanks very much dejan On 12. ruj. 2011., at 14:03, Dejan Gambin wrote: Hi, After solving my compile problem (thanks to thomas), I need to do GetFeatureInfo to a shape layer joined to MySQL table (non-spatial join). 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? Because - when I do this: ogrinfo -sql SELECT * FROM my LEFT JOIN 'MYSQL:gis,host=localhost,user=gis,password=gis'.katastar_vodnjan ON
