<div dir="ltr">PR is available to address the issue on GitHub.</div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Jan 8, 2018 at 11:23 AM, Eli Adam <span dir="ltr"><<a href="mailto:eadam@co.lincoln.or.us" target="_blank">eadam@co.lincoln.or.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">On Fri, Jan 5, 2018 at 9:52 AM, karsten <<a href="mailto:karsten@terragis.net">karsten@terragis.net</a>> wrote:<br>
> Thanks Eli.<br>
><br>
> I have set the MS debug = 5 in the map file and also enabled postgresql<br>
> logging.<br>
><br>
> In the mapserver log I get "No matching record(s) found":<br>
><br>
> ------------------<br>
> [Fri Jan 05 18:32:59 <a href="tel:2018%5D.645000" value="+12018645000">2018].645000</a> msWFSParseRequest(): WFS post request:<br>
> <GetFeature xmlns="<a href="http://www.opengis.net/wfs" rel="noreferrer" target="_blank">http://www.opengis.net/<wbr>wfs</a>" service="WFS" version="1.1.0"<br>
> outputFormat="text/xml; subtype=gml/2.1.2"<br>
> xsi:schemaLocation="<a href="http://www.opengis.net/wfs" rel="noreferrer" target="_blank">http://<wbr>www.opengis.net/wfs</a><br>
> <a href="http://schemas.opengis.net/wfs/1.1.0/wfs.xsd" rel="noreferrer" target="_blank">http://schemas.opengis.net/<wbr>wfs/1.1.0/wfs.xsd</a>"<br>
> xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance" rel="noreferrer" target="_blank">http://www.w3.org/<wbr>2001/XMLSchema-instance</a>"><<wbr>Query<br>
> typeName="ms:flurstueck_wfs" srsName="EPSG:4326"><Filter<br>
> xmlns="<a href="http://www.opengis.net/ogc" rel="noreferrer" target="_blank">http://www.opengis.net/<wbr>ogc</a>"><PropertyIsLike wildCard="*"<br>
> singleChar="." escapeChar="!"<br>
> matchCase="false"><<wbr>PropertyName>lagebezeichnung</<wbr>PropertyName><Literal>*Plat<br>
> ten*</Literal></<wbr>PropertyIsLike></Filter></<wbr>Query></GetFeature><br>
> [Fri Jan 05 18:32:59 <a href="tel:2018%5D.728000" value="+12018728000">2018].728000</a> FLTLayerApplyPlainFilterToLaye<wbr>r():<br>
> ("[lagebezeichnung]" ~* ".*Platten.*"),<br>
> rect=-7.34596005204958,60.<wbr>6642900785306,6.<wbr>38576697281957,66.<wbr>6415244533575<br>
> [Fri Jan 05 18:32:59 2018].758000 msQueryByFilter(): Search returned no<br>
> results. No matching record(s) found.<br>
> ------------------<br>
><br>
> and in the postgresql log I<br>
><br>
> PST ERROR: syntax error at or near "*" at character 514 PST STATEMENT:<br>
> SELECT gml_id, identifier, beginnt, advstandardmodell, anlass, land,<br>
> gemarkungsnummer, zaehler, flurstueckskennzeichen, gemarkung,<br>
><br>
> amtlicheflaeche, flurnummer, abweichenderrechtszustand,<br>
> rechtsbehelfsverfahren,<br>
> zeitpunktderentstehung, regierungsbezirk, kreis, gemeinde,<br>
> istgebucht,<br>
> zeigtauf, weistauf, nenner, zweifelhafterflurstuecksnachwe<wbr>is,<br>
><br>
> ogc_fid, fid, gid, wkb_geometry, fc, lagebezeichnung,<br>
> eigentuemer<br>
> FROM public.gm_ax_flurstueck_geo where lagebezeichnung ilike<br>
> *Platten*;<br>
><br>
> This seems to hint to that the query send via geomoose seems to have a<br>
> problem with the syntax. When I change it to ... FROM<br>
> public.gm_ax_flurstueck_geo where lagebezeichnung ilike '%Platten%'; and run<br>
> manually it is working ...<br>
><br>
> Not sure if there is a work around or other config for the postgis layer<br>
> that I can use in Geomoose ...<br>
<br>
</div></div>I opened an issue for discussion here,<br>
<a href="https://github.com/geomoose/gm3/issues/279" rel="noreferrer" target="_blank">https://github.com/geomoose/<wbr>gm3/issues/279</a>. That also suggests where<br>
to look if you want to fiddle with it.<br>
<br>
Best regards, Eli<br>
<div class="HOEnZb"><div class="h5"><br>
<br>
><br>
> Karsten<br>
><br>
> -----Original Message-----<br>
> From: Eli Adam [mailto:<a href="mailto:eadam@co.lincoln.or.us">eadam@co.lincoln.or.us</a><wbr>]<br>
> Sent: Freitag, 5. Januar 2018 18:08<br>
> To: karsten<br>
> Cc: <a href="mailto:geomoose-users@lists.osgeo.org">geomoose-users@lists.osgeo.org</a><br>
> Subject: Re: [Geomoose-users] debugging mapserver WFS layer search<br>
><br>
> Hi Karsten,<br>
><br>
> I'm not sure on this but have a few troubleshooting ideas that might help.<br>
><br>
> On Fri, Jan 5, 2018 at 7:53 AM, karsten <<a href="mailto:karsten@terragis.net">karsten@terragis.net</a>> wrote:<br>
>><br>
>> Hi All,<br>
>><br>
>> I have configured my first Geomoose v 3 pilot project and got all working<br>
> except a MapServer WFS layer search on a PostGIS layer. I am using ms4w v<br>
> 3.2.3 and the app package geomoose 3.1. I have successfully added a<br>
> firestation WFS search to the desktop demo<br>
> <a href="http://localhost/gm3/desktop/index.html" rel="noreferrer" target="_blank">http://localhost/gm3/desktop/<wbr>index.html</a> following the instructions at<br>
> <a href="http://geomoose.github.io/gm3/howto/add-search.html" rel="noreferrer" target="_blank">http://geomoose.github.io/gm3/<wbr>howto/add-search.html</a> .<br>
>> Now I have used MapServer WMS for many years but this is the first time I<br>
> am using WFS; so am a bit lost of how to debug my own custom layers search<br>
> in Geomoose.<br>
>> In a copy of the desktop app I added my own data and so on but the search<br>
> on one parcel layer I have added (a MapServer WFS layer drawn from PostGIS)<br>
> returns no errors but empty gml results.<br>
>><br>
>> The request I can see is<br>
>> <a href="http://localhost/cgi-bin/mapserv.exe?MAP=c:/data/mapfiles/mechernich.m" rel="noreferrer" target="_blank">http://localhost/cgi-bin/<wbr>mapserv.exe?MAP=c:/data/<wbr>mapfiles/mechernich.m</a><br>
>> ap&typename=ms:flurstueck_wfs<br>
>> plus the post params<br>
>> MAP c:/data/mapfiles/mechernich.<wbr>map<br>
>> typename ms:flurstueck_wfs<br>
>><br>
>> <GetFeature xmlns="<a href="http://www.opengis.net/wfs" rel="noreferrer" target="_blank">http://www.opengis.net/<wbr>wfs</a>" service="WFS"<br>
>> version="1.1.0" outputFormat="text/xml; subtype=gml/2.1.2"<br>
>> xsi:schemaLocation="<a href="http://www.opengis.net/wfs" rel="noreferrer" target="_blank">http://<wbr>www.opengis.net/wfs</a><br>
>> <a href="http://schemas.opengis.net/wfs/1.1.0/wfs.xsd" rel="noreferrer" target="_blank">http://schemas.opengis.net/<wbr>wfs/1.1.0/wfs.xsd</a>"<br>
>> xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance" rel="noreferrer" target="_blank">http://www.w3.org/<wbr>2001/XMLSchema-instance</a>"><<wbr>Query<br>
>> typeName="ms:flurstueck_wfs" srsName="EPSG:4326"><Filter<br>
>> xmlns="<a href="http://www.opengis.net/ogc" rel="noreferrer" target="_blank">http://www.opengis.net/<wbr>ogc</a>"><PropertyIsLike wildCard="*"<br>
>> singleChar="." escapeChar="!"<br>
>> matchCase="false"><<wbr>PropertyName>lagebezeichnung</<wbr>PropertyName><Literal<br>
>> >*Auf*</Literal></<wbr>PropertyIsLike></Filter></<wbr>Query></GetFeature><br>
>><br>
>><br>
>> The response gives me an empty bounding box and feature collection (when<br>
> there are many objects that should be found using the string "Auf" - tried<br>
> it with a postgres SQL query that gave me > 2200 results):<br>
>><br>
><br>
> You can turn on Postgresql logging to see what query is actually run on<br>
> Postgresql from MapServer/GeoMoose. Then read the logs and run that query<br>
> via psql or PGAdmin to see what it returns. That lets you know whether the<br>
> query getting passed in is bad or the correct results are returned and not<br>
> properly handled by MapServer/GeoMoose.<br>
> <a href="https://stackoverflow.com/questions/722221/how-to-log-postgresql-queries#722" rel="noreferrer" target="_blank">https://stackoverflow.com/<wbr>questions/722221/how-to-log-<wbr>postgresql-queries#722</a><br>
> 236<br>
><br>
><br>
>> <?xml version='1.0' encoding="UTF-8" ?> <wfs:FeatureCollection<br>
>> xmlns:ms="<a href="http://mapserver.gis.umn.edu/mapserver" rel="noreferrer" target="_blank">http://mapserver.<wbr>gis.umn.edu/mapserver</a>"<br>
>> xmlns:wfs="<a href="http://www.opengis.net/wfs" rel="noreferrer" target="_blank">http://www.opengis.<wbr>net/wfs</a>"<br>
>> xmlns:gml="<a href="http://www.opengis.net/gml" rel="noreferrer" target="_blank">http://www.opengis.<wbr>net/gml</a>"<br>
>> xmlns:ogc="<a href="http://www.opengis.net/ogc" rel="noreferrer" target="_blank">http://www.opengis.<wbr>net/ogc</a>"<br>
>> xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance" rel="noreferrer" target="_blank">http://www.w3.org/<wbr>2001/XMLSchema-instance</a>"<br>
>> xsi:schemaLocation="<a href="http://www.opengis.net/wfs" rel="noreferrer" target="_blank">http://<wbr>www.opengis.net/wfs</a><br>
> <a href="http://schemas.opengis.net/wfs/1.1.0/WFS-basic.xsd" rel="noreferrer" target="_blank">http://schemas.opengis.net/<wbr>wfs/1.1.0/WFS-basic.xsd</a><br>
>> <a href="http://mapserver.gis.umn.edu/mapserver" rel="noreferrer" target="_blank">http://mapserver.gis.umn.edu/<wbr>mapserver</a><br>
> <a href="http://localhost/cgi-bin/mapserv?map=C:/data/mapfiles/mechernich.map&SER" rel="noreferrer" target="_blank">http://localhost/cgi-bin/<wbr>mapserv?map=C:/data/mapfiles/<wbr>mechernich.map&SER</a><br>
> VICE=WFS&VERSION=1.1.0&<wbr>amp;REQUEST=<wbr>DescribeFeatureType&<wbr>TYPENAME=ms:f<br>
> lurstueck_wfs&<wbr>OUTPUTFORMAT=XMLSCHEMA"><br>
>> <gml:boundedBy><br>
>> <gml:null>missing</gml:null><br>
>> </gml:boundedBy><br>
>> </wfs:FeatureCollection><br>
>><br>
>> I have tried to include all that is needed in the mapsertver layers see<br>
> below (even changed the data tag to a sub select to make sure all atributes<br>
> are retrieved for sure ...<br>
>><br>
>><br>
>> Would anyone have suggestions how to debug this ?<br>
>><br>
>> Cheers<br>
>> Karsten<br>
>><br>
>> Karsten Vennemann<br>
>> Principal<br>
>><br>
>> Terra GIS LTD<br>
>> <a href="http://www.terragis.net" rel="noreferrer" target="_blank">www.terragis.net</a><br>
>><br>
>><br>
>> ------------------- in map file ---------------<br>
>><br>
>> LAYER<br>
>> CONNECTION "dbname='gisme' host=localhost port=5432 user='postgres'<br>
> password='postgres' sslmode=disable"<br>
>> CONNECTIONTYPE POSTGIS<br>
>> DATA 'wkb_geometry FROM (select * from<br>
> "public"."gm_ax_flurstueck_<wbr>geo") as foo USING UNIQUE fid USING srid=25832'<br>
>> EXTENT 324008.5625 5598582 <a href="tel:343287.6875" value="+13432876875">343287.6875</a> 5614541<br>
><br>
> Good that you have EXTENT on your PostGIS layer. That can be required.<br>
><br>
> Reviewing the mapbook.xml configuration for search might be helpful too.<br>
><br>
><br>
> Best regards, Eli<br>
><br>
><br>
>> METADATA<br>
>> "gml_include_items" "all"<br>
>> "ows_extent" "324008.5625 5598582.0 343287.6875 5614541.0"<br>
>> "ows_srs" "EPSG:25832 EPSG:3857 EPSG:900913 EPSG:4326"<br>
>> "ows_title" "flurstueck_wfs"<br>
>> "wms_bbox_extended" "true"<br>
>> "gml_include_items" "all"<br>
>> "wfs_title" "flusstuecke_wfs" ##REQUIRED<br>
>> "gml_featureid" "ogc_fid" ## REQUIRED<br>
>> "wfs_enable_request" "*"<br>
>> 'ows_srs' 'EPSG:25832 EPSG:4326 EPSG:3857 EPSG:900913'<br>
>> 'wfs_srs' 'EPSG:25832 EPSG:4326 EPSG:3857 EPSG:900913'<br>
>> 'wms_feature_info_mime_type' 'application/json'<br>
>> END # METADATA<br>
>> TEMPLATE 'dummy'<br>
>> NAME "flurstueck_wfs"<br>
>> PROJECTION<br>
>> "init=epsg:25832"<br>
>> END # PROJECTION<br>
>> STATUS OFF<br>
>> TILEITEM "location"<br>
>> TYPE POLYGON<br>
>> UNITS METERS<br>
>> CLASS<br>
>> NAME "Flurstueck"<br>
>> STYLE<br>
>> COLOR 249 250 255<br>
>> OPACITY 0<br>
>> END # STYLE<br>
>> STYLE<br>
>> OUTLINECOLOR 187 142 142<br>
>> WIDTH 0.982677<br>
>> END # STYLE<br>
>> END # CLASS<br>
>> END # LAYER<br>
>><br>
>><br>
>><br>
>><br>
>><br>
>> ______________________________<wbr>_________________<br>
>> Geomoose-users mailing list<br>
>> <a href="mailto:Geomoose-users@lists.osgeo.org">Geomoose-users@lists.osgeo.org</a><br>
>> <a href="https://lists.osgeo.org/mailman/listinfo/geomoose-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/geomoose-<wbr>users</a><br>
><br>
______________________________<wbr>_________________<br>
Geomoose-users mailing list<br>
<a href="mailto:Geomoose-users@lists.osgeo.org">Geomoose-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/geomoose-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/geomoose-<wbr>users</a></div></div></blockquote></div><br></div>