Another step in my debugging is always, for problem database layers, is to add an EXTENT parameter inside that same layer (which you get from an ogrinfo command).

Also, if everything works (commandline, manual requests in browser), then I always use a tool like Fiddler to get the exact (problem) request that is being generated by QGIS.

Anyway, thanks again for using MS4W for sharing your spatial information. Be sure to contact me and help support MS4W, as I see that it is very important for your needs.

Thanks again,

-jeff



--
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/




On 2016-11-23 11:48 AM, mathias cunault wrote:
I did what you said : I copy and paste layer by layer from the old
mapfile to a new one, and test each time. I did not make any
modification (as far as i know). Now I can get the capabilities in FF !
Thanks.

Now I have the list of layers in QGIS. But I can't load them : it seems
to have a problem of connection with PostGIS. Log error says :
Error executing SQL: (connection pointer is NULL
) in msPostGISLayerGetExtent()[Wed Nov 23 16:33:27 2016].216000
msPostGISLayerGetExtent(): General error message. Error executing SQL.
Check server logs.
I guess that the logs in the message are PostGIS ones ?


2016-11-23 15:10 GMT+01:00 Jeff McKenna <[email protected]
<mailto:[email protected]>>:

    In that tiny mapfile (one layer), I would also remove any special
    characters and numbers from any of your strings in that small
    mapfile (so no accents, numbers, spaces in any NAME parameters, and
    remove any special characters from the wms_title metadata or
    elsewhere).  Working with that copied mapfile and removing all those
    things helps me debug always - then later I can go back to the full
    mapfile, get that working at the commandline, then test with a
    manual request in the browser, and finally test in a client such as
    QGIS or OpenLayers.

    -jeff



    --
    Jeff McKenna
    MapServer Consulting and Training Services
    http://www.gatewaygeomatics.com/ <http://www.gatewaygeomatics.com/>



    On 2016-11-23 9:48 AM, Jeff McKenna wrote:

        Hi,

        Regarding your issue, here is my advice for how I always debug
        such a
        situation:

        - I narrow down the mapfile until I am able to have the
        smallest/shortest mapfile that still generates the error (one layer,
        simple classification)

        - once I have that tiny mapfile, then examine that one problem layer
        (most times I also change the data in that layer, from something
        like a
        PostGIS connection to a local shapefile, and see if that changes
        anything)

        - for OGC/WMS requests, I will run the request directly from the
        MS4W
        commandline, such as:

           setenv.bat
           mapserv -nh
        QUERY_STRING="map=D:\ms4w\blah.map&SERVICE=wms&REQUEST=GetCapabilities"

            getcap.xml


        And open that generated xml file to check for any errors or
        "WARNING"s
        in the response.

        Thank you for the positive feedback from you that MS4W is
        working great
        for you and your clients.

        -jeff





    _______________________________________________
    mapserver-users mailing list
    [email protected] <mailto:[email protected]>
    http://lists.osgeo.org/mailman/listinfo/mapserver-users
    <http://lists.osgeo.org/mailman/listinfo/mapserver-users>




--
/----------/
/Mathias Cunault/
/chargé d’opération et de recherche
///Inrap Tours - /148 av. Maginot
37000 TOURS
06 32 05 98 96
[email protected] <mailto:[email protected]>_/
www.inrap.fr <http://www.inrap.fr>
abonnez-vous à la lettre d'information de l'Inrap :
http://www.inrap.fr/newsletter.php

Darth Mathias : "Topology is a pathway to many abilities some consider
to be unnatural"
Padwan : "Is it possible to learn this power ?"
Darth Mathias : "Not from an archaeologist !"

_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to