Re: [mapserver-users] PostGIS query problem

2020-06-29 Thread Carlos Ruiz
Hola, Fernando, I don't know what's really going on but despite if this is a GDAL error or something else, I suggest you to try the following in the MAP file LAYER section: PROCESSING "CLOSE_CONNECTION=DEFER" Another question: does PostgreSQL server is running in another machine ? MSc. Carlos

Re: [mapserver-users] PostGIS query problem

2020-06-29 Thread Fernando Martins Pimenta
ata in EPSG:3857 > (Rousseau Lambert2, Louis-Philippe (EC)) >5. Problem with Python MapScript queryByRect (Just van den Broecke) > > > ------ > > Message: 1 > Date: Thu, 25 Jun 2020 17:16:33 -0300 > From

Re: [mapserver-users] PostGIS query problem

2020-06-25 Thread Jeff McKenna
Hi Fernando, I would try using the shp2img utility at the commandline, and set CONFIG "CPL_DEBUG" "ON" in your mapfile (see https://mapserver.org/optimization/debugging.html#step-3-turn-on-cpl-debug-optional) and then execute: shp2img -m mymap.map -o ttt.png -all_debug 5 The full query

Re: [mapserver-users] PostGIS query problem

2020-06-25 Thread Seth G
Hi, What client are you using? How long does the query take to complete? It is likely the client stops waiting for a response. Seth -- web:http://geographika.co.uk twitter: @geographika On Thu, Jun 25, 2020, at 10:16 PM, Fernando Martins Pimenta wrote: > Hi, > > I am using the query below to

[mapserver-users] PostGIS query problem

2020-06-25 Thread Fernando Martins Pimenta
Hi, I am using the query below to return a hydrograph of a region (using POSTGIS). This query works perfectly when I use it in pgadmin. With the mapserver, the connection with the client is lost. It records a query that shows no errors in SQL, just shows that the connection has lost. Why is that?