Re: [mapserver-users] [EXTERNAL] Re: MapCache Time Dimensions Problem
Stephan, Yes, I've even used the value I have as the Default value which does fetch things properly. I suppose it could be something in the specific branch I'm using. Its the animation branch from RFC-111 (http://mapserver.org/development/rfc/ms-rfc-111.html) and (https://github.com/jlarouche/mapcache/tree/animated-gif). But I tried this also with master to test it non-animated and got the same error. Mike -- Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers On 6/10/15, 8:28 AM, Stephan Meißl step...@meissl.name wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mike, strange, did you try a time interval or simply a bigger time e.g. a whole day like TIME=2014-03-06? Maybe you can narrow it down this way. cu Stephan On 06/10/2015 01:22 PM, Michael Smith wrote: Stephan, Yes I did run directly on the sqlite file and its got an absolute path. I get all the responses back I think I should get eg: Select strftime('%Y-%m-%dT%H:%M:%SZ',start_time)||'/'||strftime('%Y-%m-%dT%H:%M: %S Z',end_time) from time where source_id='earthquakes'; .. 2014-03-03T23:41:21Z/2014-03-03T23:41:21Z 2014-03-07T23:47:22Z/2014-03-07T23:47:22Z 2014-03-07T00:53:09Z/2014-03-07T00:53:09Z 2014-03-06T02:51:31Z/2014-03-06T02:51:31Z ... and it all seems to work with default values. Its only when I try to pass a TIME value on the URL that I get an error. GET /gridvm1mc/mapcache/?LAYERS=earthquakesSERVICE=WMSVERSION=1.1.1REQUEST =G etMapSTYLES=SRS=EPSG%3A3857BBOX=-28119042.469324,-9960050.5336716,28119 0 42.469324,9960050.5336716WIDTH=1437HEIGHT=509 HTTP/1.1 200 34113 GET /gridvm1mc/mapcache/?LAYERS=earthquakesSERVICE=WMSVERSION=1.1.1REQUEST =G etMapSTYLES=SRS=EPSG%3A3857BBOX=-28119042.469324,-9960050.5336716,28119 0 42.469324,9960050.5336716WIDTH=1437HEIGHT=509TIME=2014-03-06T02:51:31Z HTTP/1.1 404 244 And the error is no matching entry for given TIME dimension TIME in tileset earthquakes Michael Smith US Army Corps Remote Sensing GIS/Center michael.sm...@usace.army.mil -Original Message- From: Stephan Meißl step...@meissl.name Date: Tuesday, June 9, 2015 at 4:37 PM To: mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org Subject: [EXTERNAL] Re: [mapserver-users] MapCache Time Dimensions Problem Resent-From: Michael Smith michael.sm...@usace.army.mil Hi Mike, did you try running the query directly in sqlite substituting :tileset, :start_timestamp, and :end_timestamp with actual values? What schema does your sqlite database have? Is the path to the dbfile absolute and readable? I could send you a working example if you want. Let me know. cu Stephan On 06/07/2015 01:13 AM, Michael Smith wrote: I've created a timedimension tileset in MapCache and created the backend sqlite db that has the available times. The mapserver backend handles the WMS TIME requests without a problem. And when I query mapcache without a TIME=, I get my the default output. However, if I specify a TIME= parameter to MapCache (as a WMS or WMTS request), I get no matching entry for given TIME dimension TIME in tileset earthquakes I don't know what I need to change to get MapCache to recognize the TIME parameter. From the docs on RFC-96 (http://mapserver.org/development/rfc/ms-rfc-96.html) I don't see what else to specify to set MapCache to understand TIME requests. I can see MapCache making the backend requests to generate images from the time values in the sqlite DB but only with the default specified in the timedimension. It never understands new ranges passed with TIME=. My tileset looks like tileset name=earthquakes sourceearthquakes/source cachesqlite/cache gridGoogleMapsCompatible/grid formatPNG/format metatile5 5/metatile metabuffer10/metabuffer expires3600/expires timedimension type=sqlite default=2014-03-25T12Z dbfile/u02/mapcache/dbtime2.db/dbfile queryselect strftime('%Y-%m-%dT%H:%M:%SZ',start)||'/'||strftime('%Y-%m-%dT%H:%M:%S Z', end) from time where source_id=:tileset and start_timegt;=datetime(:start_timestamp,'unixepoch') and end_timelt;=datetime(:end_timestamp,'unixepoch') order by end_time /query /timedimension /tileset -BEGIN PGP SIGNATURE- Version: GnuPG v1 iQIcBAEBAgAGBQJVeC17AAoJEKNQXeNWi+qtuwQQAJUF2EFcQw1m7f6OjY4Nkx+e wy7HrtNdL0NjvFKgzXMRA88o19E4snr+KhelYLicDJY2vp26Dk5ctuuZRfEig+HK ZUyklvSyfuG7VZPs3/7VYMcHgF+DfkbqZohhDsLXN1ZobEAl1PlxdrZulexTbmG+ O2p81d9p7qBFLgYDPT6WxW43lkLpuPIR1JYc2iT9CeBVvJ33QRF05taVVBkj+5ze mwJQdRBAT3GcK/cJSgVN1pxvUBkq4C40p84EulAERX7XTkQWnClSFSJBuyON+B3q KFnCWFxDip7zly2uwYyvJMJdkwLvJbp5UhJ/uYlDd82EODd+D4m1l//wAKsu5ZDZ f+olnKtkiMHUc2s7OwjwYYTIvYSvA9bwIHDgmAMVCyQLZEk/Wr5Jbgi8sLxid45s /A9j64nPSj/Ar9Kw9AbX+vyupT2iTiQyigKiA+OBhejX52d+rj6y4mEIS757NLTg hnBrbry1LoWQjr7/XAmdGahusCF/wp6mmb0YoWFoQI+cuFJ39iIPvWXScIvUkLG9 Qj6iw4wj8WwZ2Fe2V4QbqPs5/kPY+iriZ3hTISaqdlNCP3ZWR4OSd/DcIIf68OEE
Re: [mapserver-users] Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ?
Hi Michael, thx for your hint. I do some test. The right final sintax is this: PROCESSING NATIVE_FILTER=(ANNO = 2006) and (CODICE_UNIVOCO like '%idtpn%' ) Thx2all again. Andrea. 2015-06-10 12:27 GMT+02:00 Michael Smith michael.smith.e...@gmail.com: Andrea, You can always use your existing filters with PROCESSING NATIVE_FILTER=WHERE (ANNO = 2006) and (CODICE_UNIVOCO like '%idtpn%' ) Or you can use a MapServer expression which are documented here: http://mapserver.org/mapfile/expressions.html#mapserver-expressions Mike Michael Smith US Army Corps Remote Sensing GIS/Center michael.sm...@usace.army.mil -Original Message- From: Andrea Peri aperi2...@gmail.com Date: Wednesday, June 10, 2015 at 5:41 AM To: Lime, Steve D (MNIT) steve.l...@state.mn.us Cc: mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ? Hi steve, this new sintax will allow the AND operator ? I have a filter like this: FILTER WHERE (ANNO = 2006) and (CODICE_UNIVOCO like '%idtpn%' ) and don't know how to transform it with the new sintax. Is this kind of filter supported ? Thx, A. 2015-06-09 19:05 GMT+02:00 Lime, Steve D (MNIT) steve.l...@state.mn.us: As of MapServer 7.0 FILTERS must be given using MapServer syntax - this is a regression noted in the Migration Guide, see http://mapserver.org/MIGRATION_GUIDE.html#migration. There's an OGR example right towards the top of that document. Basically: FILTER WHERE ([CODICE] = 107) FILTERITEM CODICE Becomes: PROCESSING 'NATIVE_FILTER=CODICE=107' Steve -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Andrea Peri Sent: Tuesday, June 09, 2015 3:45 AM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ? Hi, I have just update my mapserver to the last mapserver-dev . After this update, I see an error on the filtering. In my mapfile the data configuration was originally this: CONNECTION /path-to-spatialite-db/zz_db_tematici.sqlite CONNECTIONTYPE OGR DATA IFT2009 EXTENT 1554650.74 4678225.52 1771822.76 4924891.9 FILTER WHERE ([CODICE] = 107) FILTERITEM CODICE The log report this error: [Tue Jun 9 10:39:46 2015].153296 msDrawMap(): rendering using outputformat named AGGA (AGG/PNG). [Tue Jun 9 10:39:46 2015].154698 msDrawMap(): WMS/WFS set-up and query, 0.001s [Tue Jun 9 10:39:46 2015].262330 LayerDefaultTranslateFilter(): General error message. This data driver does not implement filter translation support [Tue Jun 9 10:39:46 2015].282402 msDrawMap(): Layer 239 (rt_ucs.idift.rt.107), 0.128s [Tue Jun 9 10:39:46 2015].282550 msDrawMap(): Drawing Label Cache, 0.000s I'm using spatialite as db. After this error, I read this RFC: http://www.mapserver.org/ru/development/rfc/ms-rfc-91.html And try the new settings, FILTER (([FILTERITEM[ = string) AND (CODICE = 107)) but it seem don't work. I don't understand if this is an issue of the new settings with spatialite or I'm wrong something. Thx, -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] [EXTERNAL] Re: MapCache Time Dimensions Problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mike, strange, did you try a time interval or simply a bigger time e.g. a whole day like TIME=2014-03-06? Maybe you can narrow it down this way. cu Stephan On 06/10/2015 01:22 PM, Michael Smith wrote: Stephan, Yes I did run directly on the sqlite file and its got an absolute path. I get all the responses back I think I should get eg: Select strftime('%Y-%m-%dT%H:%M:%SZ',start_time)||'/'||strftime('%Y-%m-%dT%H:%M:%S Z',end_time) from time where source_id='earthquakes'; .. 2014-03-03T23:41:21Z/2014-03-03T23:41:21Z 2014-03-07T23:47:22Z/2014-03-07T23:47:22Z 2014-03-07T00:53:09Z/2014-03-07T00:53:09Z 2014-03-06T02:51:31Z/2014-03-06T02:51:31Z ... and it all seems to work with default values. Its only when I try to pass a TIME value on the URL that I get an error. GET /gridvm1mc/mapcache/?LAYERS=earthquakesSERVICE=WMSVERSION=1.1.1REQUEST=G etMapSTYLES=SRS=EPSG%3A3857BBOX=-28119042.469324,-9960050.5336716,281190 42.469324,9960050.5336716WIDTH=1437HEIGHT=509 HTTP/1.1 200 34113 GET /gridvm1mc/mapcache/?LAYERS=earthquakesSERVICE=WMSVERSION=1.1.1REQUEST=G etMapSTYLES=SRS=EPSG%3A3857BBOX=-28119042.469324,-9960050.5336716,281190 42.469324,9960050.5336716WIDTH=1437HEIGHT=509TIME=2014-03-06T02:51:31Z HTTP/1.1 404 244 And the error is no matching entry for given TIME dimension TIME in tileset earthquakes Michael Smith US Army Corps Remote Sensing GIS/Center michael.sm...@usace.army.mil -Original Message- From: Stephan Meißl step...@meissl.name Date: Tuesday, June 9, 2015 at 4:37 PM To: mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org Subject: [EXTERNAL] Re: [mapserver-users] MapCache Time Dimensions Problem Resent-From: Michael Smith michael.sm...@usace.army.mil Hi Mike, did you try running the query directly in sqlite substituting :tileset, :start_timestamp, and :end_timestamp with actual values? What schema does your sqlite database have? Is the path to the dbfile absolute and readable? I could send you a working example if you want. Let me know. cu Stephan On 06/07/2015 01:13 AM, Michael Smith wrote: I've created a timedimension tileset in MapCache and created the backend sqlite db that has the available times. The mapserver backend handles the WMS TIME requests without a problem. And when I query mapcache without a TIME=, I get my the default output. However, if I specify a TIME= parameter to MapCache (as a WMS or WMTS request), I get no matching entry for given TIME dimension TIME in tileset earthquakes I don't know what I need to change to get MapCache to recognize the TIME parameter. From the docs on RFC-96 (http://mapserver.org/development/rfc/ms-rfc-96.html) I don't see what else to specify to set MapCache to understand TIME requests. I can see MapCache making the backend requests to generate images from the time values in the sqlite DB but only with the default specified in the timedimension. It never understands new ranges passed with TIME=. My tileset looks like tileset name=earthquakes sourceearthquakes/source cachesqlite/cache gridGoogleMapsCompatible/grid formatPNG/format metatile5 5/metatile metabuffer10/metabuffer expires3600/expires timedimension type=sqlite default=2014-03-25T12Z dbfile/u02/mapcache/dbtime2.db/dbfile queryselect strftime('%Y-%m-%dT%H:%M:%SZ',start)||'/'||strftime('%Y-%m-%dT%H:%M:%SZ', end) from time where source_id=:tileset and start_timegt;=datetime(:start_timestamp,'unixepoch') and end_timelt;=datetime(:end_timestamp,'unixepoch') order by end_time /query /timedimension /tileset -BEGIN PGP SIGNATURE- Version: GnuPG v1 iQIcBAEBAgAGBQJVeC17AAoJEKNQXeNWi+qtuwQQAJUF2EFcQw1m7f6OjY4Nkx+e wy7HrtNdL0NjvFKgzXMRA88o19E4snr+KhelYLicDJY2vp26Dk5ctuuZRfEig+HK ZUyklvSyfuG7VZPs3/7VYMcHgF+DfkbqZohhDsLXN1ZobEAl1PlxdrZulexTbmG+ O2p81d9p7qBFLgYDPT6WxW43lkLpuPIR1JYc2iT9CeBVvJ33QRF05taVVBkj+5ze mwJQdRBAT3GcK/cJSgVN1pxvUBkq4C40p84EulAERX7XTkQWnClSFSJBuyON+B3q KFnCWFxDip7zly2uwYyvJMJdkwLvJbp5UhJ/uYlDd82EODd+D4m1l//wAKsu5ZDZ f+olnKtkiMHUc2s7OwjwYYTIvYSvA9bwIHDgmAMVCyQLZEk/Wr5Jbgi8sLxid45s /A9j64nPSj/Ar9Kw9AbX+vyupT2iTiQyigKiA+OBhejX52d+rj6y4mEIS757NLTg hnBrbry1LoWQjr7/XAmdGahusCF/wp6mmb0YoWFoQI+cuFJ39iIPvWXScIvUkLG9 Qj6iw4wj8WwZ2Fe2V4QbqPs5/kPY+iriZ3hTISaqdlNCP3ZWR4OSd/DcIIf68OEE WpTq4NxDR3NKFn5RKiekPixpppUcDtU7GnwYNPwNDVkhiVLEf6tmD32bBeXSrTG6 8QZlOVjwUHAMAmxToXXP =uGbf -END PGP SIGNATURE- ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ?
Hi steve, this new sintax will allow the AND operator ? I have a filter like this: FILTER WHERE (ANNO = 2006) and (CODICE_UNIVOCO like '%idtpn%' ) and don't know how to transform it with the new sintax. Is this kind of filter supported ? Thx, A. 2015-06-09 19:05 GMT+02:00 Lime, Steve D (MNIT) steve.l...@state.mn.us: As of MapServer 7.0 FILTERS must be given using MapServer syntax - this is a regression noted in the Migration Guide, see http://mapserver.org/MIGRATION_GUIDE.html#migration. There's an OGR example right towards the top of that document. Basically: FILTER WHERE ([CODICE] = 107) FILTERITEM CODICE Becomes: PROCESSING 'NATIVE_FILTER=CODICE=107' Steve -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Andrea Peri Sent: Tuesday, June 09, 2015 3:45 AM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ? Hi, I have just update my mapserver to the last mapserver-dev . After this update, I see an error on the filtering. In my mapfile the data configuration was originally this: CONNECTION /path-to-spatialite-db/zz_db_tematici.sqlite CONNECTIONTYPE OGR DATA IFT2009 EXTENT 1554650.74 4678225.52 1771822.76 4924891.9 FILTER WHERE ([CODICE] = 107) FILTERITEM CODICE The log report this error: [Tue Jun 9 10:39:46 2015].153296 msDrawMap(): rendering using outputformat named AGGA (AGG/PNG). [Tue Jun 9 10:39:46 2015].154698 msDrawMap(): WMS/WFS set-up and query, 0.001s [Tue Jun 9 10:39:46 2015].262330 LayerDefaultTranslateFilter(): General error message. This data driver does not implement filter translation support [Tue Jun 9 10:39:46 2015].282402 msDrawMap(): Layer 239 (rt_ucs.idift.rt.107), 0.128s [Tue Jun 9 10:39:46 2015].282550 msDrawMap(): Drawing Label Cache, 0.000s I'm using spatialite as db. After this error, I read this RFC: http://www.mapserver.org/ru/development/rfc/ms-rfc-91.html And try the new settings, FILTER (([FILTERITEM[ = string) AND (CODICE = 107)) but it seem don't work. I don't understand if this is an issue of the new settings with spatialite or I'm wrong something. Thx, -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] on the fly projection
thank you all I was really a solution with (* powerful *) mapserver. On Mon, Jun 8, 2015 at 3:10 PM, Jeff McKenna jmcke...@gatewaygeomatics.com wrote: On 2015-06-08 6:08 AM, Ahmet Temiz wrote: hello I am wondering if a map file enables us to on the fly projection. I have input raster data in epsg :4326 storing in postgis but output raster map should be in epsg:3857 as tif. A nice explanation of projection use in MapServer can be found at: http://www.mapserver.org/mapfile/projection.html Pay attention to the Important Notes section of that page, which contains very useful tips. -jeff -- Jeff McKenna MapServer Consulting and Training Services http://www.gatewaygeomatics.com/ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Ahmet Temiz Jeoloji Müh. Afet ve Acil Durum Yönetimi Başkanlığı Bilgi İşlem Dairesi Başkanlığı-CBS Grubu Ahmet Temiz Geological Eng. Information Systems - GIS Group Disaster and Emergency Management of Presidency ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ?
It seems the filter expression must not be given as string. So you should use FILTER ([CODICE] = 107) Otherwise MapServer will read the filter as string value to be used in combination with FILTERITEM. -Ursprüngliche Nachricht- Von: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users- boun...@lists.osgeo.org] Im Auftrag von Andrea Peri Gesendet: Dienstag, 9. Juni 2015 23:40 An: Schylberg Lars; Havard Tveite Cc: mapserver-users@lists.osgeo.org Betreff: Re: [mapserver-users] Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ? Unfortunately no. Its only a typo in e-mail. The bracket in the mapfile was correct close. Thx 2015-06-09 12:15 GMT+02:00 Schylberg Lars lars.schylb...@saabgroup.com: It seems like You have a typing error. FILTER ([CODICE[ = 107) Should be: FILTER ([CODICE] = 107) /Lars -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users- boun...@lists.osgeo.org] On Behalf Of Andrea Peri Sent: den 9 juni 2015 11:34 To: Eichner, Andreas - SID Cc: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ? Thx for response. I try this, FILTER (CODICE = 107) and also this FILTER ([CODICE[ = 107) and removing the filteritem, but still go in error: :( The log report this: [Tue Jun 9 11:29:53 2015].880265 LayerDefaultTranslateFilter(): General error message. This data driver does not implement filter translation support [Tue Jun 9 11:29:53 2015].955070 msEvalExpression(): General error message. Cannot evaluate expression, no item index defined. 2015-06-09 11:06 GMT+02:00 Eichner, Andreas - SID andreas.eich...@sid.sachsen.de: I think you should use FILTER ([CODICE] = 107) i.e. without using FILTERITEM and the leading WHERE -Ursprüngliche Nachricht- Von: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users- boun...@lists.osgeo.org] Im Auftrag von Andrea Peri Gesendet: Dienstag, 9. Juni 2015 10:45 An: mapserver-users@lists.osgeo.org Betreff: [mapserver-users] Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ? Hi, I have just update my mapserver to the last mapserver-dev . After this update, I see an error on the filtering. In my mapfile the data configuration was originally this: CONNECTION /path-to-spatialite-db/zz_db_tematici.sqlite CONNECTIONTYPE OGR DATA IFT2009 EXTENT 1554650.74 4678225.52 1771822.76 4924891.9 FILTER WHERE ([CODICE] = 107) FILTERITEM CODICE The log report this error: [Tue Jun 9 10:39:46 2015].153296 msDrawMap(): rendering using outputformat named AGGA (AGG/PNG). [Tue Jun 9 10:39:46 2015].154698 msDrawMap(): WMS/WFS set-up and query, 0.001s [Tue Jun 9 10:39:46 2015].262330 LayerDefaultTranslateFilter(): General error message. This data driver does not implement filter translation support [Tue Jun 9 10:39:46 2015].282402 msDrawMap(): Layer 239 (rt_ucs.idift.rt.107), 0.128s [Tue Jun 9 10:39:46 2015].282550 msDrawMap(): Drawing Label Cache, 0.000s I'm using spatialite as db. After this error, I read this RFC: http://www.mapserver.org/ru/development/rfc/ms-rfc-91.html And try the new settings, FILTER (([FILTERITEM[ = string) AND (CODICE = 107)) but it seem don't work. I don't understand if this is an issue of the new settings with spatialite or I'm wrong something. Thx, -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] no result with getFeatureInfo text/plain
Hello, in my WMS getFeatureInfo works fine with info_format html [1] and gml, but I don't get a result with text/plain [2]. And I found similar a example on mapserver.org... [3] [4]. Why does getFeaturInfo for text/plain not work? [1] http://geoportal.luckau.de/ows/flaechennutzungsplaene?VERSION=1.1.1REQUEST=GetFeatureInfoSERVICE=WMSLAYERS=FNP10_GrenzeQUERY_LAYERS=FNP10_GrenzeWIDTH=650HEIGHT=450SRS=EPSG:25833BBOX=392406,5730396.807692308,434593,5759603.192307692STYLES=FORMAT=image/pngINFO_FORMAT=text/htmlEXCEPTIONS=application/vnd.ogc.se_xmlX=369Y=359FEATURE_COUNT=100; [2] http://geoportal.luckau.de/ows/flaechennutzungsplaene?VERSION=1.1.1REQUEST=GetFeatureInfoSERVICE=WMSLAYERS=FNP10_GrenzeQUERY_LAYERS=FNP10_GrenzeWIDTH=650HEIGHT=450SRS=EPSG:25833BBOX=392406,5730396.807692308,434593,5759603.192307692STYLES=FORMAT=image/pngINFO_FORMAT=text/plainEXCEPTIONS=application/vnd.ogc.se_xmlX=369Y=359FEATURE_COUNT=100; [3] http://demo.mapserver.org/cgi-bin/wms?SERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoBBOX=-11.332970,24.121208,47.584718,57.965035SRS=EPSG:4326WIDTH=1001HEIGHT=575LAYERS=citiesSTYLES=FORMAT=image/pngTRANSPARENT=trueQUERY_LAYERS=citiesINFO_FORMAT=text/plainX=229Y=280 [4] http://demo.mapserver.org/cgi-bin/wms?SERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoBBOX=-11.332970,24.121208,47.584718,57.965035SRS=EPSG:4326WIDTH=1001HEIGHT=575LAYERS=citiesSTYLES=FORMAT=image/pngTRANSPARENT=trueQUERY_LAYERS=citiesINFO_FORMAT=text/htmlX=229Y=280 Jörg and here's my mapfile: WEB IMAGEPATH '/tmp/' IMAGEURL '/tmp/' METADATA 'ows_title' 'Flächennutzungsplan der Stadt Luckau und seinen Ortsteilen' 'ows_onlineresource' 'http://geoportal.luckau.de/ows/flaechennutzungsplaene' 'ows_srs' 'EPSG:4326 EPSG:25832 EPSG:25833 EPSG:325833 EPSG:4528 EPSG:4839' 'ows_abstract''WMS-Dienst zur Dartellung von Flächennutzungspläne im Stadtgebiet Luckau mit seinen Ortsteilen' 'ows_accessconstraints' 'none' 'ows_fees' 'none' 'ows_keywordlist' 'Luckau, Flächennutzungspläne, WMS' 'ows_include_items' 'all' 'ows_encoding' 'ISO-8859-1' 'WMS_FEATURE_INFO_MIME_TYPE' 'text/html' 'gml_include_items' 'all' include './includes/contact_information.inc.map' END END ### Layer LAYER NAME 'FNP01_Grenze' CLASS NAME 'plan_grenze' STYLE SYMBOL 0 width 3 OUTLINECOLOR 0 0 255 #COLOR 220 54 199 END END DATA 'raster/fnp_luckau/grenzen_umring/plan_01_grenze.shp' METADATA 'ows_title' 'FNP 01 Grenze' 'ows_abstract' 'Umring Flächennuntzungsplan Luckau, Teil 1, Kümmritz, Uckro, Paserin' 'ows_srs' 'EPSG:4326 EPSG:25833 EPSG:325833 EPSG:4528 EPSG:4839' gml_include_items all gml_featureid ID ows_enable_request * END STATUS ON PROJECTION init=epsg:325833 END TYPE POLYGON DUMP true HEADER './templates/fnp_legende_header.html' TEMPLATE './templates/fnp_legende.html' FOOTER './templates/footer.html' END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] db connection through Mapserver fails
hello My postgis raster db connection through Mapserver fails. here is the message coming from WildFly: db connection data PG: dbname=tr22 host=localhost user=orkun password=22 port=5432 schema=public table=o_4_trdem2where= ST_Intersects(rast, ST_MakeEnvelope( 29.90 , 40.42 , 31.49 , 40.99, 4326 )) mode=2 ERROR 1: PQconnectdb failed: FATAL: remaining connection slots are reserved for non-replication superuser connections Can you tell me why ? regards -- Ahmet Temiz Jeoloji Müh. Afet ve Acil Durum Yönetimi Başkanlığı Bilgi İşlem Dairesi Başkanlığı-CBS Grubu Ahmet Temiz Geological Eng. Information Systems - GIS Group Disaster and Emergency Management of Presidency ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] no result with getFeatureInfo text/plain
I think You should have a wms_include_items all in the LAYER METADATA section. Same comment as I had last week. /Lars Jörg Thomsen skrev den 2015-06-10 16:00: Hello, in my WMS getFeatureInfo works fine with info_format html [1] and gml, but I don't get a result with text/plain [2]. And I found similar a example on mapserver.org... [3] [4]. Why does getFeaturInfo for text/plain not work? [1] http://geoportal.luckau.de/ows/flaechennutzungsplaene?VERSION=1.1.1REQUEST=GetFeatureInfoSERVICE=WMSLAYERS=FNP10_GrenzeQUERY_LAYERS=FNP10_GrenzeWIDTH=650HEIGHT=450SRS=EPSG:25833BBOX=392406,5730396.807692308,434593,5759603.192307692STYLES=FORMAT=image/pngINFO_FORMAT=text/htmlEXCEPTIONS=application/vnd.ogc.se_xmlX=369Y=359FEATURE_COUNT=100; [2] http://geoportal.luckau.de/ows/flaechennutzungsplaene?VERSION=1.1.1REQUEST=GetFeatureInfoSERVICE=WMSLAYERS=FNP10_GrenzeQUERY_LAYERS=FNP10_GrenzeWIDTH=650HEIGHT=450SRS=EPSG:25833BBOX=392406,5730396.807692308,434593,5759603.192307692STYLES=FORMAT=image/pngINFO_FORMAT=text/plainEXCEPTIONS=application/vnd.ogc.se_xmlX=369Y=359FEATURE_COUNT=100; [3] http://demo.mapserver.org/cgi-bin/wms?SERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoBBOX=-11.332970,24.121208,47.584718,57.965035SRS=EPSG:4326WIDTH=1001HEIGHT=575LAYERS=citiesSTYLES=FORMAT=image/pngTRANSPARENT=trueQUERY_LAYERS=citiesINFO_FORMAT=text/plainX=229Y=280 [4] http://demo.mapserver.org/cgi-bin/wms?SERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoBBOX=-11.332970,24.121208,47.584718,57.965035SRS=EPSG:4326WIDTH=1001HEIGHT=575LAYERS=citiesSTYLES=FORMAT=image/pngTRANSPARENT=trueQUERY_LAYERS=citiesINFO_FORMAT=text/htmlX=229Y=280 Jörg and here's my mapfile: WEB IMAGEPATH '/tmp/' IMAGEURL '/tmp/' METADATA 'ows_title' 'Flächennutzungsplan der Stadt Luckau und seinen Ortsteilen' 'ows_onlineresource' 'http://geoportal.luckau.de/ows/flaechennutzungsplaene' 'ows_srs' 'EPSG:4326 EPSG:25832 EPSG:25833 EPSG:325833 EPSG:4528 EPSG:4839' 'ows_abstract''WMS-Dienst zur Dartellung von Flächennutzungspläne im Stadtgebiet Luckau mit seinen Ortsteilen' 'ows_accessconstraints' 'none' 'ows_fees' 'none' 'ows_keywordlist' 'Luckau, Flächennutzungspläne, WMS' 'ows_include_items' 'all' 'ows_encoding' 'ISO-8859-1' 'WMS_FEATURE_INFO_MIME_TYPE' 'text/html' 'gml_include_items' 'all' include './includes/contact_information.inc.map' END END ### Layer LAYER NAME 'FNP01_Grenze' CLASS NAME 'plan_grenze' STYLE SYMBOL 0 width 3 OUTLINECOLOR 0 0 255 #COLOR 220 54 199 END END DATA 'raster/fnp_luckau/grenzen_umring/plan_01_grenze.shp' METADATA 'ows_title' 'FNP 01 Grenze' 'ows_abstract' 'Umring Flächennuntzungsplan Luckau, Teil 1, Kümmritz, Uckro, Paserin' 'ows_srs' 'EPSG:4326 EPSG:25833 EPSG:325833 EPSG:4528 EPSG:4839' gml_include_items all gml_featureid ID ows_enable_request * END STATUS ON PROJECTION init=epsg:325833 END TYPE POLYGON DUMP true HEADER './templates/fnp_legende_header.html' TEMPLATE './templates/fnp_legende.html' FOOTER './templates/footer.html' END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] no result with getFeatureInfo text/plain
Am 10.06.2015 um 16:22 schrieb Lars Schylberg: I think You should have a wms_include_items all in the LAYER METADATA section. yeees, thanks! I thought 'ows_include_items' 'all' in the header should be enough. Same comment as I had last week. for last weeks problem this was not the solution. Jörg /Lars Jörg Thomsen skrev den 2015-06-10 16:00: Hello, in my WMS getFeatureInfo works fine with info_format html [1] and gml, but I don't get a result with text/plain [2]. And I found similar a example on mapserver.org... [3] [4]. Why does getFeaturInfo for text/plain not work? [1] http://geoportal.luckau.de/ows/flaechennutzungsplaene?VERSION=1.1.1REQUEST=GetFeatureInfoSERVICE=WMSLAYERS=FNP10_GrenzeQUERY_LAYERS=FNP10_GrenzeWIDTH=650HEIGHT=450SRS=EPSG:25833BBOX=392406,5730396.807692308,434593,5759603.192307692STYLES=FORMAT=image/pngINFO_FORMAT=text/htmlEXCEPTIONS=application/vnd.ogc.se_xmlX=369Y=359FEATURE_COUNT=100; [2] http://geoportal.luckau.de/ows/flaechennutzungsplaene?VERSION=1.1.1REQUEST=GetFeatureInfoSERVICE=WMSLAYERS=FNP10_GrenzeQUERY_LAYERS=FNP10_GrenzeWIDTH=650HEIGHT=450SRS=EPSG:25833BBOX=392406,5730396.807692308,434593,5759603.192307692STYLES=FORMAT=image/pngINFO_FORMAT=text/plainEXCEPTIONS=application/vnd.ogc.se_xmlX=369Y=359FEATURE_COUNT=100; [3] http://demo.mapserver.org/cgi-bin/wms?SERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoBBOX=-11.332970,24.121208,47.584718,57.965035SRS=EPSG:4326WIDTH=1001HEIGHT=575LAYERS=citiesSTYLES=FORMAT=image/pngTRANSPARENT=trueQUERY_LAYERS=citiesINFO_FORMAT=text/plainX=229Y=280 [4] http://demo.mapserver.org/cgi-bin/wms?SERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoBBOX=-11.332970,24.121208,47.584718,57.965035SRS=EPSG:4326WIDTH=1001HEIGHT=575LAYERS=citiesSTYLES=FORMAT=image/pngTRANSPARENT=trueQUERY_LAYERS=citiesINFO_FORMAT=text/htmlX=229Y=280 Jörg and here's my mapfile: WEB IMAGEPATH '/tmp/' IMAGEURL '/tmp/' METADATA 'ows_title' 'Flächennutzungsplan der Stadt Luckau und seinen Ortsteilen' 'ows_onlineresource' 'http://geoportal.luckau.de/ows/flaechennutzungsplaene' 'ows_srs' 'EPSG:4326 EPSG:25832 EPSG:25833 EPSG:325833 EPSG:4528 EPSG:4839' 'ows_abstract''WMS-Dienst zur Dartellung von Flächennutzungspläne im Stadtgebiet Luckau mit seinen Ortsteilen' 'ows_accessconstraints' 'none' 'ows_fees' 'none' 'ows_keywordlist' 'Luckau, Flächennutzungspläne, WMS' 'ows_include_items' 'all' 'ows_encoding' 'ISO-8859-1' 'WMS_FEATURE_INFO_MIME_TYPE' 'text/html' 'gml_include_items' 'all' include './includes/contact_information.inc.map' END END ### Layer LAYER NAME 'FNP01_Grenze' CLASS NAME 'plan_grenze' STYLE SYMBOL 0 width 3 OUTLINECOLOR 0 0 255 #COLOR 220 54 199 END END DATA 'raster/fnp_luckau/grenzen_umring/plan_01_grenze.shp' METADATA 'ows_title' 'FNP 01 Grenze' 'ows_abstract' 'Umring Flächennuntzungsplan Luckau, Teil 1, Kümmritz, Uckro, Paserin' 'ows_srs' 'EPSG:4326 EPSG:25833 EPSG:325833 EPSG:4528 EPSG:4839' gml_include_items all gml_featureid ID ows_enable_request * END STATUS ON PROJECTION init=epsg:325833 END TYPE POLYGON DUMP true HEADER './templates/fnp_legende_header.html' TEMPLATE './templates/fnp_legende.html' FOOTER './templates/footer.html' END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] no result with getFeatureInfo text/plain
Hello Jukka, it is definitely a feature. It's nice to define different outputs, all items for text/plain an only a formatted subset in html. But wouldn't it be nice too, if we only had to configure it in the header with an overwrite-option in the layer-section? Jörg Am 10.06.2015 um 16:26 schrieb Rahkonen Jukka (MML): Hi, You must have either wms_include_items or ows_include_items in the LAYER-METADATA. Now you have only gml_include_items at LAYER level. You do have ows_include_items at MAP level but it does not have any effect there. On the other hand, ows_include_items does not have any effect on the text/html output but that can only be adjusted by editing the template. For sending out the same information with text/plain and text/html the Mapserver admin must make edits in two different places - ows_include_items and the template. I am not sure if this should be considered as a bug or a feature but at least it is confusing. Tested with Mapserver 7.0-beta1. -Jukka Rahkonen- Jörg Thomsen wrote: Hello, in my WMS getFeatureInfo works fine with info_format html [1] and gml, but I don't get a result with text/plain [2]. And I found similar a example on mapserver.org... [3] [4]. Why does getFeaturInfo for text/plain not work? [1] http://geoportal.luckau.de/ows/flaechennutzungsplaene?VERSION=1.1.1REQUEST=GetFeatureInfoSERVICE=WMSLAYERS=FNP10_GrenzeQUERY_LAYERS=FNP10_GrenzeWIDTH=650HEIGHT=450SRS=EPSG:25833BBOX=392406,5730396.807692308,434593,5759603.192307692STYLES=FORMAT=image/pngINFO_FORMAT=text/htmlEXCEPTIONS=application/vnd.ogc.se_xmlX=369Y=359FEATURE_COUNT=100; [2] http://geoportal.luckau.de/ows/flaechennutzungsplaene?VERSION=1.1.1REQUEST=GetFeatureInfoSERVICE=WMSLAYERS=FNP10_GrenzeQUERY_LAYERS=FNP10_GrenzeWIDTH=650HEIGHT=450SRS=EPSG:25833BBOX=392406,5730396.807692308,434593,5759603.192307692STYLES=FORMAT=image/pngINFO_FORMAT=text/plainEXCEPTIONS=application/vnd.ogc.se_xmlX=369Y=359FEATURE_COUNT=100; [3] http://demo.mapserver.org/cgi-bin/wms?SERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoBBOX=-11.332970,24.121208,47.584718,57.965035SRS=EPSG:4326WIDTH=1001HEIGHT=575LAYERS=citiesSTYLES=FORMAT=image/pngTRANSPARENT=trueQUERY_LAYERS=citiesINFO_FORMAT=text/plainX=229Y=280 [4] http://demo.mapserver.org/cgi-bin/wms?SERVICE=WMSVERSION=1.1.1REQUEST=GetFeatureInfoBBOX=-11.332970,24.121208,47.584718,57.965035SRS=EPSG:4326WIDTH=1001HEIGHT=575LAYERS=citiesSTYLES=FORMAT=image/pngTRANSPARENT=trueQUERY_LAYERS=citiesINFO_FORMAT=text/htmlX=229Y=280 Jörg and here's my mapfile: WEB IMAGEPATH '/tmp/' IMAGEURL '/tmp/' METADATA 'ows_title' 'Flächennutzungsplan der Stadt Luckau und seinen Ortsteilen' 'ows_onlineresource' 'http://geoportal.luckau.de/ows/flaechennutzungsplaene' 'ows_srs' 'EPSG:4326 EPSG:25832 EPSG:25833 EPSG:325833 EPSG:4528 EPSG:4839' 'ows_abstract''WMS-Dienst zur Dartellung von Flächennutzungspläne im Stadtgebiet Luckau mit seinen Ortsteilen' 'ows_accessconstraints' 'none' 'ows_fees' 'none' 'ows_keywordlist' 'Luckau, Flächennutzungspläne, WMS' 'ows_include_items' 'all' 'ows_encoding' 'ISO-8859-1' 'WMS_FEATURE_INFO_MIME_TYPE' 'text/html' 'gml_include_items' 'all' include './includes/contact_information.inc.map' END END ### Layer LAYER NAME 'FNP01_Grenze' CLASS NAME 'plan_grenze' STYLE SYMBOL 0 width 3 OUTLINECOLOR 0 0 255 #COLOR 220 54 199 END END DATA 'raster/fnp_luckau/grenzen_umring/plan_01_grenze.shp' METADATA 'ows_title' 'FNP 01 Grenze' 'ows_abstract' 'Umring Flächennuntzungsplan Luckau, Teil 1, Kümmritz, Uckro, Paserin' 'ows_srs' 'EPSG:4326 EPSG:25833 EPSG:325833 EPSG:4528 EPSG:4839' gml_include_items all gml_featureid ID ows_enable_request * END STATUS ON PROJECTION init=epsg:325833 END TYPE POLYGON DUMP true HEADER './templates/fnp_legende_header.html' TEMPLATE './templates/fnp_legende.html' FOOTER './templates/footer.html' END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ?
Correct. Filters specified in this manner are passed directly to the underlying driver. My goal was to remove ambiguity with the FILTER keyword itself since it could take both MapServer syntax and native driver syntax - depending on context. --Steve -Original Message- From: Michael Smith [mailto:michael.smith.e...@gmail.com] Sent: Wednesday, June 10, 2015 5:28 AM To: Andrea Peri; Lime, Steve D (MNIT) Cc: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ? Andrea, You can always use your existing filters with PROCESSING NATIVE_FILTER=WHERE (ANNO = 2006) and (CODICE_UNIVOCO like '%idtpn%' ) Or you can use a MapServer expression which are documented here: http://mapserver.org/mapfile/expressions.html#mapserver-expressions Mike Michael Smith US Army Corps Remote Sensing GIS/Center michael.sm...@usace.army.mil -Original Message- From: Andrea Peri aperi2...@gmail.com Date: Wednesday, June 10, 2015 at 5:41 AM To: Lime, Steve D (MNIT) steve.l...@state.mn.us Cc: mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ? Hi steve, this new sintax will allow the AND operator ? I have a filter like this: FILTER WHERE (ANNO = 2006) and (CODICE_UNIVOCO like '%idtpn%' ) and don't know how to transform it with the new sintax. Is this kind of filter supported ? Thx, A. 2015-06-09 19:05 GMT+02:00 Lime, Steve D (MNIT) steve.l...@state.mn.us: As of MapServer 7.0 FILTERS must be given using MapServer syntax - this is a regression noted in the Migration Guide, see http://mapserver.org/MIGRATION_GUIDE.html#migration. There's an OGR example right towards the top of that document. Basically: FILTER WHERE ([CODICE] = 107) FILTERITEM CODICE Becomes: PROCESSING 'NATIVE_FILTER=CODICE=107' Steve -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Andrea Peri Sent: Tuesday, June 09, 2015 3:45 AM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] Incompatibility at Filter - level between mapserver 6.x and the last mapserver-dev ? Hi, I have just update my mapserver to the last mapserver-dev . After this update, I see an error on the filtering. In my mapfile the data configuration was originally this: CONNECTION /path-to-spatialite-db/zz_db_tematici.sqlite CONNECTIONTYPE OGR DATA IFT2009 EXTENT 1554650.74 4678225.52 1771822.76 4924891.9 FILTER WHERE ([CODICE] = 107) FILTERITEM CODICE The log report this error: [Tue Jun 9 10:39:46 2015].153296 msDrawMap(): rendering using outputformat named AGGA (AGG/PNG). [Tue Jun 9 10:39:46 2015].154698 msDrawMap(): WMS/WFS set-up and query, 0.001s [Tue Jun 9 10:39:46 2015].262330 LayerDefaultTranslateFilter(): General error message. This data driver does not implement filter translation support [Tue Jun 9 10:39:46 2015].282402 msDrawMap(): Layer 239 (rt_ucs.idift.rt.107), 0.128s [Tue Jun 9 10:39:46 2015].282550 msDrawMap(): Drawing Label Cache, 0.000s I'm using spatialite as db. After this error, I read this RFC: http://www.mapserver.org/ru/development/rfc/ms-rfc-91.html And try the new settings, FILTER (([FILTERITEM[ = string) AND (CODICE = 107)) but it seem don't work. I don't understand if this is an issue of the new settings with spatialite or I'm wrong something. Thx, -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] db connection through Mapserver fails
hello, I hope you did not provide your real connection params? It is a PG-'poblem', try to close some open connections (old and still running ms-processes, PG-Admin, ..) or increase the max_connections configuration of your PostgreS. Jörg Am 10.06.2015 um 16:18 schrieb Ahmet Temiz: hello My postgis raster db connection through Mapserver fails. here is the message coming from WildFly: db connection data PG: dbname=tr22 host=localhost user=orkun password=22 port=5432 schema=public table=o_4_trdem2where= ST_Intersects(rast, ST_MakeEnvelope( 29.90 , 40.42 , 31.49 , 40.99, 4326 )) mode=2 ERROR 1: PQconnectdb failed: FATAL: remaining connection slots are reserved for non-replication superuser connections Can you tell me why ? regards -- Ahmet Temiz Jeoloji Müh. Afet ve Acil Durum Yönetimi Başkanlığı Bilgi İşlem Dairesi Başkanlığı-CBS Grubu Ahmet Temiz Geological Eng. Information Systems - GIS Group Disaster and Emergency Management of Presidency ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Is this a CGI problem?
Hello, I just installed MapServer 6.4.1 in Linux Mint and got this error (Opera dragonify) after passing an url in my localhost: url: localhost/ms?LAYERS=Temp2014TRANSPARENT=TRUEFORMAT=image%2FpngSERVICE=WMSVERSION=1.1.1REQUEST=GetMapSTYLES=SRS=EPSG%3A900913BBOX=-10635414.142106,-2285406.7635122,-6619106.9284492,160578.14127299WIDTH=821HEIGHT=500 PNG IHDR5ôÇÔNIDATxíÁ1 õOm O àc{÷C·IEND®B` http://osgeo-org.1560.x6.nabble.com/file/n5210276/11.png I use gdal-1.11.2 (installed from source) and MapServer was installed with apt-get (UbuntuGis stable). In my Synaptic Package Manager I found 'libgdal1h', not sure if this would be related. Apache version here: ii apache2 2.4.7-1ubuntu4.4 amd64Apache HTTP Server ii apache2-bin 2.4.7-1ubuntu4.4 amd64Apache HTTP Server (binary files and modules) ii apache2-data2.4.7-1ubuntu4.4 all Apache HTTP Server (common files) ii apache2-utils 2.4.7-1ubuntu4.4 amd64Apache HTTP Server (utility programs for web servers) ii libapache2-mod-mapcache 1.2.1-2 amd64tile caching server - Apache module ii libapache2-mod-perl2 2.0.8+httpd24-r1449661-6ubuntu2 amd64Integration of perl with the Apache2 web server ii libapache2-mod-php5 5.5.9+dfsg-1ubuntu4.9 amd64server-side, HTML-embedded scripting language (Apache 2 module) ii libapr1:amd64 1.5.0-1 amd64Apache Portable Runtime Library ii libaprutil1:amd64 1.5.3-1 amd64Apache Portable Runtime Utility Library ii libaprutil1-dbd-sqlite3:amd64 1.5.3-1 amd64Apache Portable Runtime Utility Library - SQLite3 Driver ii libaprutil1-ldap:amd64 1.5.3-1 amd64Apache Portable Runtime Utility Library - LDAP Driver ii libsvn1:amd64 1.8.8-1ubuntu3.1 amd64Shared libraries used by Apache Subversion Any hints are appreciated, thanks in advance, -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Is-this-a-CGI-problem-tp5210276.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Memory leak
Posting to mapserver users as well as dev list. Folks, We have a php application which renders a new map every few seconds and with any of the versions with the refactored label font support we see what appears to be a memory leak. When our application exits the error is 'Freetype was unable to load font file'. This is from fontcache.c and occurs in our case after around 130 calls to the msGetFontFace function. I will look into this further but from a quick look it seems that the FT_New_Face is being called every time. Our application uses only one font so our assumption is that this should not need to be called every time. Any help appreciated. Thanks Ian ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Is this a CGI problem?
Btw, if I use shp2img I get an empty PNG, so this would tell me that CGI may not be the issue, I am wondering if my postgis connection would be the problem here, any ideas are appreciated. -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Is-this-a-CGI-problem-tp5210276p5210291.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] no result with getFeatureInfo text/plain
Hi, Definitely, not sure about that. It can be a feature if you are both configuring Mapserver and building/controlling the applications which are using the service. If you just offer a WMS service for the public your users can't imagine that changing info_format in the client settings may have an effect on the data that is returned with GetFeatureInfo. Consider GetMaps with image/png vs. image/jpeg or WFS GetFeature output as GML vs. GeoJSON. Because attributes are different then MAP level setting could only have options all or none. Current situation means practically having none as a default for all layers. So the advantage would be an option to set the default to all for every layer in the service and Mapserver admin should remember to think if GetFeatureInto output should be restricted somehow for the new layers. That does not feel like a big saving in labour. What could save labour would be to generate automatically a template that would show all the fields which are listed in the ows_include_items in a simple default html table. Keyword for activating it could be TEMPLATE AUTO or something like that. I suppose that Geoserver is doing it that way http://docs.geoserver.org/latest/en/user/tutorials/GetFeatureInfo/index.html -Jukka Rahkonen- Jörg Thomsen wrote: Hello Jukka, it is definitely a feature. It's nice to define different outputs, all items for text/plain an only a formatted subset in html. But wouldn't it be nice too, if we only had to configure it in the header with an overwrite-option in the layer-section? Jörg Am 10.06.2015 um 16:26 schrieb Rahkonen Jukka (MML): Hi, You must have either wms_include_items or ows_include_items in the LAYER-METADATA. Now you have only gml_include_items at LAYER level. You do have ows_include_items at MAP level but it does not have any effect there. On the other hand, ows_include_items does not have any effect on the text/html output but that can only be adjusted by editing the template. For sending out the same information with text/plain and text/html the Mapserver admin must make edits in two different places - ows_include_items and the template. I am not sure if this should be considered as a bug or a feature but at least it is confusing. Tested with Mapserver 7.0-beta1. -Jukka Rahkonen- Jörg Thomsen wrote: Hello, in my WMS getFeatureInfo works fine with info_format html [1] and gml, but I don't get a result with text/plain [2]. And I found similar a example on mapserver.org... [3] [4]. Why does getFeaturInfo for text/plain not work? [1] http://geoportal.luckau.de/ows/flaechennutzungsplaene?VERSION=1.1.1RE QUEST=GetFeatureInfoSERVICE=WMSLAYERS=FNP10_GrenzeQUERY_LAYERS=FNP1 0_GrenzeWIDTH=650HEIGHT=450SRS=EPSG:25833BBOX=392406,5730396.80769 2308,434593,5759603.192307692STYLES=FORMAT=image/pngINFO_FORMAT=tex t/htmlEXCEPTIONS=application/vnd.ogc.se_xmlX=369Y=359FEATURE_COUNT =100 [2] http://geoportal.luckau.de/ows/flaechennutzungsplaene?VERSION=1.1.1RE QUEST=GetFeatureInfoSERVICE=WMSLAYERS=FNP10_GrenzeQUERY_LAYERS=FNP1 0_GrenzeWIDTH=650HEIGHT=450SRS=EPSG:25833BBOX=392406,5730396.80769 2308,434593,5759603.192307692STYLES=FORMAT=image/pngINFO_FORMAT=tex t/plainEXCEPTIONS=application/vnd.ogc.se_xmlX=369Y=359FEATURE_COUN T=100 [3] http://demo.mapserver.org/cgi-bin/wms?SERVICE=WMSVERSION=1.1.1REQUES T=GetFeatureInfoBBOX=-11.332970,24.121208,47.584718,57.965035SRS=EPS G:4326WIDTH=1001HEIGHT=575LAYERS=citiesSTYLES=FORMAT=image/pngTR ANSPARENT=trueQUERY_LAYERS=citiesINFO_FORMAT=text/plainX=229Y=280 [4] http://demo.mapserver.org/cgi-bin/wms?SERVICE=WMSVERSION=1.1.1REQUES T=GetFeatureInfoBBOX=-11.332970,24.121208,47.584718,57.965035SRS=EPS G:4326WIDTH=1001HEIGHT=575LAYERS=citiesSTYLES=FORMAT=image/pngTR ANSPARENT=trueQUERY_LAYERS=citiesINFO_FORMAT=text/htmlX=229Y=280 Jörg and here's my mapfile: WEB IMAGEPATH '/tmp/' IMAGEURL '/tmp/' METADATA 'ows_title' 'Flächennutzungsplan der Stadt Luckau und seinen Ortsteilen' 'ows_onlineresource' 'http://geoportal.luckau.de/ows/flaechennutzungsplaene' 'ows_srs' 'EPSG:4326 EPSG:25832 EPSG:25833 EPSG:325833 EPSG:4528 EPSG:4839' 'ows_abstract''WMS-Dienst zur Dartellung von Flächennutzungspläne im Stadtgebiet Luckau mit seinen Ortsteilen' 'ows_accessconstraints' 'none' 'ows_fees' 'none' 'ows_keywordlist' 'Luckau, Flächennutzungspläne, WMS' 'ows_include_items' 'all' 'ows_encoding' 'ISO-8859-1' 'WMS_FEATURE_INFO_MIME_TYPE' 'text/html' 'gml_include_items' 'all' include './includes/contact_information.inc.map' END END ### Layer LAYER NAME 'FNP01_Grenze' CLASS NAME 'plan_grenze' STYLE SYMBOL 0 width 3 OUTLINECOLOR 0 0 255 #COLOR 220 54 199 END END DATA