[mapserver-users] Can't get capabilities xml error message

[Jeff McKenna]

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 <jmckenna at gatewaygeomatics.com
> <mailto:jmckenna at gatewaygeomatics.com>>:
>
>     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
>     mapserver-users at lists.osgeo.org <mailto:mapserver-users at lists.osgeo.org>
>     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
> _mathias.cunault at inrap.fr <mailto:mathias.cunault at inrap.fr>_/
> 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 !"