<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <font face="Helvetica, Arial, sans-serif">Dear Daniel and Jukka,<br>
      <br>
      following your advice I changed my setup as follows:<br>
      """<br>
      LAYER<br>
          NAME "TestLayer"<br>
          CONNECTION "<external-url>?"<br>
          EXTENT -47443 5145172 1187852 6158846<br>
          CONNECTIONTYPE WFS<br>
          STATUS ON<br>
          DEBUG 5<br>
          METADATA<br>
            "wfs_typename" <a class="moz-txt-link-rfc2396E" href="info:dop">"info:dop"</a><br>
            "wfs_request_method"   "GET"<br>
            "wfs_version"    "1.0.0"<br>
            "wfs_srs" "EPSG:25832"<br>
            "wfs_title"    "dop"<br>
            "wfs_connectiontimeout" "60"<br>
            "wfs_maxfeatures" "500"<br>
            "gml_include_items" "all"<br>
            "gml_featureid"     "ID"<br>
      <br>
          END # METADATA<br>
          PROJECTION<br>
            "init=epsg:25832"<br>
          END # PROJECTION<br>
          TYPE POLYGON<br>
          CLASS<br>
            NAME "aerial_image_footprint"<br>
            STYLE<br>
              OUTLINECOLOR 255 0 0<br>
              WIDTH 0.7<br>
            END # STYLE<br>
          END # CLASS<br>
        END # LAYER<br>
      <br>
      """<br>
      What shall I say, it does not work. The strange things I am
      noticing are as follows:<br>
      1) If I make a call with a bbox in EPSG: 3857 Mapserver first
      sends my map-extent as bbox to the external server as EPSG:3857,
      not using the layers extent that is in EPSG:25832 as is the source
      server. However , it does not send the srs to the external server:
      <br>
      """<br>
REQUEST=GetFeature&VERSION=1.0.0&SERVICE=WFS&TYPENAME=<a class="moz-txt-link-freetext" href="info:dop&BBOX=-3161903.14172725,2675231.21277502,4977362.15235668,7973075.36166411&MAXFEATURES=500">info:dop&BBOX=-3161903.14172725,2675231.21277502,4977362.15235668,7973075.36166411&MAXFEATURES=500</a><br>
      """<br>
      2) Besides the wrong srs, since the map extent is used instead of
      the bbox in my request, I obviously would end up by getting some
      500 objects back that may or may not be in my bbox. I verified
      this by putting the correct srs into the CONNECTION (I think this
      is deprecated).<br>
      <br>
      Now I also checked the Mapserver Version is 7.4 and I am basing on
      this repo: <br>
      <a class="moz-txt-link-freetext" href="https://github.com/camptocamp/docker-mapserver/tree/7.4">https://github.com/camptocamp/docker-mapserver/tree/7.4</a><br>
      Is this Version too outdated (sorry for not mentioning the
      version)? I do not have any issues with my other WFS layers based
      on OGR connection ( I need WFS beyond 1.0.0)<br>
      <br>
      Just in case it matters, the external server I am calling is
      public so I might as well name it:<br>
      <a class="moz-txt-link-rfc2396E" href="http://sg.geodatenzentrum.de/wfs_info?">"http://sg.geodatenzentrum.de/wfs_info?"</a><br>
      The layer is <a class="moz-txt-link-rfc2396E" href="info:dop">"info:dop"</a><br>
      <br>
      Thanks for all your help.<br>
      <br>
      Best<br>
      Lars<br>
    </font>
    <div class="moz-signature">
      <meta charset="utf-8">
      <title>SkenData Email Signatur</title>
      <div><br>
      </div>
      <div>
        <br>
      </div>
    </div>
    <div class="moz-cite-prefix">Am 27.05.21 um 21:36 schrieb Daniel
      Morissette:<br>
    </div>
    <blockquote type="cite"
      cite="mid:64c9652a-95c4-f42a-0729-18e6f940fac4@mapgears.com">Since
      you use CONNECTIONTYPE OGR, none of the MapServer WFS Client logic
      takes place.  Is there any reason why you cannot use
      CONNECTIONTYPE WFS as documented here:
      <br>
      <br>
      <a class="moz-txt-link-freetext" href="https://mapserver.org/ogc/wfs_client.html">https://mapserver.org/ogc/wfs_client.html</a>
      <br>
      <br>
      <br>
      <br>
      On 2021-05-27 02:51, Lars Fricke wrote:
      <br>
      <blockquote type="cite">Dear All,
        <br>
        <br>
        as this list is a source of much deeper insight than I have into
        Mapserver, I would like to ask about a very strange issue I am
        facing.
        <br>
        <br>
        I am calling on a public WFS server I can query "by hand" fast
        and successfully every single time. Now I defined a Mapserver
        layer (see below) as an OGR layer in my WFS map-file and it does
        - on the same call - return data. But not reliably, more at
        random. I played with the connection-timeout and the maxfeatures
        and it seemed to have some influence but again, not reliably.
        I'll post the relevant parts of my mapfile (all my other layers
        with other sources are working fine):
        <br>
        """
        <br>
        MAP
        <br>
           NAME "WFS_Test"
        <br>
           SHAPEPATH "/data"
        <br>
           STATUS ON
        <br>
           UNITS METERS
        <br>
           EXTENT -2851663 2776500 5630523 9970363
        <br>
        <br>
           PROJECTION
        <br>
             "init=epsg:3857"
        <br>
           END # PROJECTION
        <br>
        <br>
           WEB
        <br>
             FOOTER "TestServer"
        <br>
             IMAGEPATH "/tmp/"
        <br>
             TEMPPATH "/tmp/"
        <br>
             IMAGEURL "/tmp/"
        <br>
             METADATA
        <br>
               "wfs_title"          "Test"
        <br>
               "ows_onlineresource"
        <a class="moz-txt-link-rfc2396E" href="http://my_server.de/cgi-bin/mapserv?map=/var/www/html/wfs.map">"http://my_server.de/cgi-bin/mapserv?map=/var/www/html/wfs.map"</a>
        <br>
               "ows_enable_request"    "*"
        <br>
               "ows_srs"    "EPSG:3857 EPSG:4326 EPSG:25832"
        <br>
               "wfs_srs"    "EPSG:3857 EPSG:4326 EPSG:25832"
        <br>
               "wfs_getfeature_formatlist" "jsonp,ogrgml"
        <br>
               "wfs_encoding" "UTF-8"
        <br>
               "wfs_connectiontimeout" "20"
        <br>
               #"wfs_request_method"   "GET"
        <br>
             END # METADATA
        <br>
             VALIDATION
        <br>
                 callback ".*"
        <br>
             END
        <br>
           END # WEB
        <br>
        <br>
           OUTPUTFORMAT
        <br>
            NAME "jsonp"
        <br>
            DRIVER "OGR/GEOJSON"
        <br>
            MIMETYPE "application/json; subtype=geojson; charset=utf-8"
        <br>
            FORMATOPTION "STORAGE=stream"
        <br>
            FORMATOPTION "FORM=SIMPLE"
        <br>
            FORMATOPTION "LCO:COORDINATE_PRECISION=10"
        <br>
            FORMATOPTION "JSONP=%callback%"
        <br>
           END
        <br>
        <br>
           OUTPUTFORMAT
        <br>
            NAME "OGRGML"
        <br>
            DRIVER "OGR/GML"
        <br>
            FORMATOPTION "STORAGE=filesystem"
        <br>
            FORMATOPTION "FORM=multipart"
        <br>
            FORMATOPTION "FILENAME=result.gml"
        <br>
           END
        <br>
        <br>
           SYMBOL
        <br>
             NAME "circle_filled"
        <br>
             TYPE ELLIPSE
        <br>
             FILLED TRUE
        <br>
             POINTS
        <br>
               1 1
        <br>
             END
        <br>
           END
        <br>
        <br>
           LAYER
        <br>
             NAME "TestLayer"
        <br>
             CONNECTION "wfs-request-testlayer.xml"
        <br>
             EXTENT 84710 5210905 1163008 6125425
        <br>
             CONNECTIONTYPE OGR
        <br>
             STATUS ON
        <br>
             DATA "dop"
        <br>
             METADATA
        <br>
               "wfs_version"    "2.0.0"
        <br>
               "wfs_title"    "TestLayer_WFS"
        <br>
               "wfs_connectiontimeout" "100"
        <br>
               "wfs_typename"    "TestLayer_WFS_int"
        <br>
               "wfs_maxfeatures"       "600"
        <br>
        <br>
             END # METADATA
        <br>
             PROJECTION
        <br>
               "init=epsg:25832"
        <br>
             END # PROJECTION
        <br>
             TYPE POLYGON
        <br>
             CLASS
        <br>
               NAME "aerial_image_footprint"
        <br>
               STYLE
        <br>
                 OUTLINECOLOR 255 0 0
        <br>
                 WIDTH 0.7
        <br>
               END # STYLE
        <br>
             END # CLASS
        <br>
           END # LAYER
        <br>
        """
        <br>
        I made the xml-file wit ogrinfo as I did for many other layers
        that work.
        <br>
        The call is:
        <br>
        """
        <br>
<a class="moz-txt-link-freetext" href="http://localhost:8181/cgi-bin/mapserv?map=/var/www/html/wfs.map&">http://localhost:8181/cgi-bin/mapserv?map=/var/www/html/wfs.map&</a>
        <br>
SERVICE=WFS&VERSION=2.0.0&REQUEST=GetFeature&SRSNAME=EPSG:3857&BBOX=1292610.86313433,6822730.62911591,1293128.57472490,6823169.70765144&TYPENAME=TestLayer
        <br>
        """
        <br>
        If I replace the Server name with the public server, it works
        like a breeze (even it is 3857).
        <br>
        The public server has:
        <br>
        """
        <br>
<DefaultCRS>urn:ogc:def:crs:EPSG:6.9:25832</DefaultCRS>
        <br>
        <OtherSRS>urn:ogc:def:crs:EPSG:6.9:4326</OtherSRS>
        <br>
        """
        <br>
        <br>
        I see the following response in the browser:
        <br>
        """
        <br>
<wfs:FeatureCollectionxmlns:ms=<a class="moz-txt-link-rfc2396E" href="http://mapserver.gis.umn.edu/mapserver">"http://mapserver.gis.umn.edu/mapserver"</a>xmlns:gml=<a class="moz-txt-link-rfc2396E" href="http://www.opengis.net/gml/3.2">"http://www.opengis.net/gml/3.2"</a>xmlns:wfs=<a class="moz-txt-link-rfc2396E" href="http://www.opengis.net/wfs/2.0">"http://www.opengis.net/wfs/2.0"</a>xmlns:xsi=<a class="moz-txt-link-rfc2396E" href="http://www.w3.org/2001/XMLSchema-instance">"http://www.w3.org/2001/XMLSchema-instance"</a>xsi:schemaLocation=<a class="moz-txt-link-rfc2396E" href="http://mapserver.gis.umn.edu/mapserverhttp://wfs/cgi-bin/mapserv?map=/var/www/html/wfs.map&SERVICE=WFS&VERSION=2.0.0&REQUEST=DescribeFeatureType&TYPENAME=DOP_AGE_DE&OUTPUTFORMAT=application%2Fgml%2Bxml%3B%20version%3D3.2http://www.opengis.net/wfs/2.0http://schemas.opengis.net/wfs/2.0/wfs.xsdhttp://www.opengis.net/gml/3.2http://schemas.opengis.net/gml/3.2.1/gml.xsd">"http://mapserver.gis.umn.edu/mapserver
http://wfs/cgi-bin/mapserv?map=/var/www/html/wfs.map&SERVICE=WFS&VERSION=2.0.0&REQUEST=DescribeFeatureType&TYPENAME=DOP_AGE_DE&OUTPUTFORMAT=application%2Fgml%2Bxml%3B%20version%3D3.2
        http://www.opengis.net/wfs/2.0
        http://schemas.opengis.net/wfs/2.0/wfs.xsd
        http://www.opengis.net/gml/3.2
http://schemas.opengis.net/gml/3.2.1/gml.xsd"</a>timeStamp="2021-05-27T06:30:38"numberMatched="0"numberReturned="0"></wfs:FeatureCollection><br>
        """
        <br>
        And in the log:
        <br>
        """
        <br>
        [warn] [pid 26] mod_fcgid: stderr: msQueryByRect(): Search
        returned no results. No matching record(s) found.
        <br>
          [warn] [pid 26] mod_fcgid: stderr: freeLayer(): freeing layer
        at 0x131f120.
        <br>
        3169463 - 172.17.0.1 - - [27/May/2021:06:30:35 +0000] "GET
/cgi-bin/mapserv?map=/var/www/html/wfs.map&SERVICE=WFS&VERSION=2.0.0&REQUEST=GetFeature&SRSNAME=EPSG:3857&BBOX=1292610.86313433,6822730.62911591,1293128.57472490,6823169.70765144&TYPENAME=TestLayer
        HTTP/1.1" 200 793 "-" "Mozilla/5.0 (X11; Linux x86_64)
        AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212
        Safari/537.36"
        <br>
        330 - 172.17.0.1 - - [27/May/2021:06:30:38 +0000] "GET
        /favicon.ico HTTP/1.1" 200 414
<a class="moz-txt-link-rfc2396E" href="http://localhost:8181/cgi-bin/mapserv?map=/var/www/html/wfs.map&SERVICE=WFS&VERSION=2.0.0&REQUEST=GetFeature&SRSNAME=EPSG:3857&BBOX=1292610.86313433,6822730.62911591,1293128.57472490,6823169.70765144&TYPENAME=TestLayer">"http://localhost:8181/cgi-bin/mapserv?map=/var/www/html/wfs.map&SERVICE=WFS&VERSION=2.0.0&REQUEST=GetFeature&SRSNAME=EPSG:3857&BBOX=1292610.86313433,6822730.62911591,1293128.57472490,6823169.70765144&TYPENAME=TestLayer"</a>
        "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
        Gecko) Chrome/90.0.4430.212 Safari/537.36"
        <br>
        """
        <br>
        I will be grateful for any clue on what is going on. Thank you
        for your trouble!
        <br>
        <br>
        Best
        <br>
        <br>
        Lars
        <br>
        SkenData Email Signatur
        <br>
        <br>
        _______________________________________________
        <br>
        mapserver-users mailing list
        <br>
        <a class="moz-txt-link-abbreviated" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>
        <br>
        <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/mapserver-users">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a>
        <br>
        <br>
      </blockquote>
      <br>
      <br>
    </blockquote>
    <br>
  </body>
</html>