I tried debugging with gdb but only get this: Program received signal SIGTRAP, Trace/breakpoint trap. 0x00007f8b8d76c8b7 in ?? () from /lib64/ld-linux-x86-64.so.2
and with backtrace (bt): #0 0x00007f8b8d76c8b7 in ?? () from /lib64/ld-linux-x86-64.so.2 #1 0x00007f8b8d75b1bc in ?? () from /lib64/ld-linux-x86-64.so.2 #2 0x00007f8b8d76bb35 in ?? () from /lib64/ld-linux-x86-64.so.2 #3 0x00007f8b8d75931b in ?? () from /lib64/ld-linux-x86-64.so.2 #4 0x00007f8b8d758a68 in ?? () from /lib64/ld-linux-x86-64.so.2 #5 0x0000000000000002 in ?? () #6 0x00007fff531bc8e2 in ?? () #7 0x0000000000000000 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 <[email protected]> >>> To: [email protected] >>> 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=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 >>>>> >>>>> Using the same request with regular mapfile: >>>>> >>>>> LAYER # katastar vodnjan poligoni >>>>> NAME "mylayer" >>>>> STATUS ON >>>>> DATA "my" >>>>> TYPE POLYGON >>>>> ... >>>>> >>>>> returns one feature and its attributes from the dbf (tha is OK) >>>>> >>>>> 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? >>>>> >>>>> regards, dejan >>>>> _______________________________________________ >>>>> mapserver-users mailing list >>>>> [email protected] >>>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users >>>> >>>> _______________________________________________ >>>> mapserver-users mailing list >>>> [email protected] >>>> http://lists.osgeo.org/mailman/listinfo/mapserver-users >>> >>> >>> _______________________________________________ >>> mapserver-users mailing list >>> [email protected] >>> http://lists.osgeo.org/mailman/listinfo/mapserver-users >>> >>> >> >> _______________________________________________ >> mapserver-users mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/mapserver-users > > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
