<div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:large">thanks for advice. WMS is back again, at last !</div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-11-23 16:55 GMT+01:00 Jeff McKenna <span dir="ltr"><<a href="mailto:jmckenna@gatewaygeomatics.com" target="_blank">jmckenna@gatewaygeomatics.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">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).<br>
<br>
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.<br>
<br>
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.<br>
<br>
Thanks again,<span class=""><br>
<br>
-jeff<br>
<br>
<br>
<br>
-- <br>
Jeff McKenna<br>
MapServer Consulting and Training Services<br>
<a href="http://www.gatewaygeomatics.com/" rel="noreferrer" target="_blank">http://www.gatewaygeomatics.co<wbr>m/</a><br>
<br>
<br>
<br>
<br></span><span class="">
On 2016-11-23 11:48 AM, mathias cunault wrote:<br>
</span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
I did what you said : I copy and paste layer by layer from the old<br>
mapfile to a new one, and test each time. I did not make any<br>
modification (as far as i know). Now I can get the capabilities in FF !<br>
Thanks.<br>
<br>
Now I have the list of layers in QGIS. But I can't load them : it seems<br>
to have a problem of connection with PostGIS. Log error says :<br>
Error executing SQL: (connection pointer is NULL<br>
) in msPostGISLayerGetExtent()[Wed Nov 23 16:33:27 2016].216000<br>
msPostGISLayerGetExtent(): General error message. Error executing SQL.<br>
Check server logs.<br>
I guess that the logs in the message are PostGIS ones ?<br>
<br>
<br>
2016-11-23 15:10 GMT+01:00 Jeff McKenna <<a href="mailto:jmckenna@gatewaygeomatics.com" target="_blank">jmckenna@gatewaygeomatics.com</a><br></span>
<mailto:<a href="mailto:jmckenna@gatewaygeomatics.com" target="_blank">jmckenna@gatewaygeomat<wbr>ics.com</a>>>:<span class=""><br>
<br>
In that tiny mapfile (one layer), I would also remove any special<br>
characters and numbers from any of your strings in that small<br>
mapfile (so no accents, numbers, spaces in any NAME parameters, and<br>
remove any special characters from the wms_title metadata or<br>
elsewhere). Working with that copied mapfile and removing all those<br>
things helps me debug always - then later I can go back to the full<br>
mapfile, get that working at the commandline, then test with a<br>
manual request in the browser, and finally test in a client such as<br>
QGIS or OpenLayers.<br>
<br>
-jeff<br>
<br>
<br>
<br>
--<br>
Jeff McKenna<br>
MapServer Consulting and Training Services<br></span>
<a href="http://www.gatewaygeomatics.com/" rel="noreferrer" target="_blank">http://www.gatewaygeomatics.co<wbr>m/</a> <<a href="http://www.gatewaygeomatics.com/" rel="noreferrer" target="_blank">http://www.gatewaygeomatics.c<wbr>om/</a>><div><div class="h5"><br>
<br>
<br>
<br>
On 2016-11-23 9:48 AM, Jeff McKenna wrote:<br>
<br>
Hi,<br>
<br>
Regarding your issue, here is my advice for how I always debug<br>
such a<br>
situation:<br>
<br>
- I narrow down the mapfile until I am able to have the<br>
smallest/shortest mapfile that still generates the error (one layer,<br>
simple classification)<br>
<br>
- once I have that tiny mapfile, then examine that one problem layer<br>
(most times I also change the data in that layer, from something<br>
like a<br>
PostGIS connection to a local shapefile, and see if that changes<br>
anything)<br>
<br>
- for OGC/WMS requests, I will run the request directly from the<br>
MS4W<br>
commandline, such as:<br>
<br>
setenv.bat<br>
mapserv -nh<br>
QUERY_STRING="map=D:\ms4w\blah<wbr>.map&SERVICE=wms&REQUEST=GetCa<wbr>pabilities"<br>
<br>
getcap.xml<br>
<br>
<br>
And open that generated xml file to check for any errors or<br>
"WARNING"s<br>
in the response.<br>
<br>
Thank you for the positive feedback from you that MS4W is<br>
working great<br>
for you and your clients.<br>
<br>
-jeff<br>
<br>
<br>
<br>
<br>
<br>
______________________________<wbr>_________________<br>
mapserver-users mailing list<br></div></div>
<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.or<wbr>g</a> <mailto:<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.<wbr>osgeo.org</a>><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman<wbr>/listinfo/mapserver-users</a><br>
<<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailma<wbr>n/listinfo/mapserver-users</a>><br>
<br>
<br>
<br>
<br>
--<br>
/----------/<br>
/Mathias Cunault/<br>
/chargé d’opération et de recherche<br>
///Inrap Tours - /148 av. Maginot<span class=""><br>
37000 TOURS<br>
06 32 05 98 96<br></span>
_<a href="mailto:mathias.cunault@inrap.fr" target="_blank">mathias.cunault@inrap.fr</a> <mailto:<a href="mailto:mathias.cunault@inrap.fr" target="_blank">mathias.cunault@inrap.<wbr>fr</a>>_/<br>
<a href="http://www.inrap.fr" rel="noreferrer" target="_blank">www.inrap.fr</a> <<a href="http://www.inrap.fr" rel="noreferrer" target="_blank">http://www.inrap.fr</a>><span class=""><br>
abonnez-vous à la lettre d'information de l'Inrap :<br>
<a href="http://www.inrap.fr/newsletter.php" rel="noreferrer" target="_blank">http://www.inrap.fr/newsletter<wbr>.php</a><br>
<br>
Darth Mathias : "Topology is a pathway to many abilities some consider<br>
to be unnatural"<br>
Padwan : "Is it possible to learn this power ?"<br>
Darth Mathias : "Not from an archaeologist !"<br>
</span></blockquote>
<br><div class="HOEnZb"><div class="h5">
______________________________<wbr>_________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.or<wbr>g</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman<wbr>/listinfo/mapserver-users</a></div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div><div><i style="font-size:small">----------</i></div><div><i style="font-size:small">Mathias Cunault</i><br></div></div></div><div><font size="2"><i>chargé d’opération et de recherche<br></i></font><font size="2"><i><font size="2"><i>Inrap Tours - </i></font>148 av. Maginot<br>37000 TOURS<br>06 32 05 98 96<br><u><a href="mailto:mathias.cunault@inrap.fr" target="_blank">mathias.cunault@inrap.fr</a></u></i></font></div><div><a href="http://www.inrap.fr" target="_blank">www.inrap.fr</a><br><font size="1">abonnez-vous à la lettre d'information de l'Inrap : <a href="http://www.inrap.fr/newsletter.php" target="_blank">http://www.inrap.fr/newsletter.php</a></font><br></div><div><br></div><div><div style="font-size:12.8000001907349px"><div><font color="#666666" size="1">Darth Mathias : "Topology is a pathway to many abilities some consider to be unnatural"<br></font></div><font color="#666666" size="1">Padwan : "Is it possible to learn this power ?"<br></font></div><font color="#666666" size="1">Darth Mathias : "Not from an archaeologist !"</font><br></div></div></div></div></div></div></div></div></div>
</div>