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: 0x0000000000000000
0x00007fff88337c00 in strlen ()
(gdb) bt
#0 0x00007fff88337c00 in strlen ()
#1 0x00000001cf77aa67 in msPOSTGRESQLJoinConnect ()
#2 0x00000001cf6b578b in msReturnNestedTemplateQuery ()
#3 0x00000001cf70bbd9 in msWMSFeatureInfo ()
#4 0x00000001cf710584 in msWMSDispatch ()
#5 0x00000001cf7389e3 in msOWSDispatch ()
#6 0x00000001cf67728d 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.
> 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
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
