Perhaps the problem comes from the HTTP server (wrong (Fast)CGI config, ...) ? Take a look at your your error.log

On 08/10/2011 14:35, Bryan Hempen wrote:
Hi David,

I enabled debugging using the following settings:

     CONFIG "MS_ERRORFILE" "/home/bhempen/ms_error.txt"
     DEBUG 5
     CONFIG "CPL_DEBUG" "ON"
     CONFIG "PROJ_DEBUG" "ON"

The only line that shows up after I got an error 500 using the spatial
filter is:

[Wed Aug 10 14:30:46 2011].451858 CGI Request 1 on process 21100

Not really helpful, right?

Regards,
Bryan

On 09/08/2011 15:38, Fawcett, David (MPCA) wrote:

Bryan,

For testing, I would enable debugging at the MAP or LAYER level.  If
you set DEBUG 5, I think that you should be able to see the query that
MapServer is crafting.

More on debugging here:
http://mapserver.org/optimization/debugging.html#debugging

David.

*From:*mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] *On Behalf Of *Bryan
Hempen
*Sent:* Tuesday, August 09, 2011 4:15 AM
*Cc:* mapserver-users@lists.osgeo.org
*Subject:* Re: [mapserver-users] WFS Spatial Filter Problem

Dear Kai and Assefa,



After you two guys requested me to send you my setup, I exported the
content in the databasetable to a shapefile so you can test it. When I
tested the spatial filter right after that, it suddenly worked ! This
narrows down the possibilities:

- The request I send is definitely not the problem anymore. It works
with MapServer + shapefile and with GeoServer.

- I exported only the geometries to the shapefile in the table with
geometrytype = POLYGON because from ~8000 geometries ~10 are
linestrings. So I investigated possible problems with the linestring
geometries by telling the MapServer not to serve them using a subquery
in the mapfile:

DATA "the_geom from (select * from alldata where
geometrytype(the_geom) = 'POLYGON') as subquery using unique
product_id using SRID=4326"

Error 500 still occured. Therefore, the data can't be the problem
neither, right?

- Since I didn't change anything else MapServer must have problems
communicating with the PostGIS database, but why Error 500 then?

Here is my mapfile:


MAP
    NAME "WFS Server"
    STATUS ON
    SIZE 600 400
    SYMBOLSET
"/var/www/html/psa/bhempen/mapservertest/symbols/symbols.sym"
    EXTENT -180 -90 180 90
    UNITS DD
    SHAPEPATH "/var/www/html/psa/bhempen/mapservertest/data/"
    IMAGECOLOR 255 255 255
    FONTSET "/var/www/html/psa/bhempen/mapservertest/fonts/fonts.list"
    MAXSIZE 4096 # needs to be set because otherwise an error will
appear when rendering images on large screens


#IMAGECOLOR     200 200 200 #commented out for WFS

PROJECTION
       'init=epsg:4326'
END

    WEB
    TEMPLATE  '/var/www/html/psa/bhempen/mapservertest/template.html'
    IMAGEPATH '/var/www/html/psa/bhempen/tmp/'
    IMAGEURL  '/psa/bhempen/tmp/'
      METADATA
            "wfs_title"                  "WFS Demo Server for
MapServer" ## REQUIRED
            "wfs_onlineresource"
"http://localhost/cgi-bin/psa/mapserv?map=/home/bhempen/wfs.map&";
<http://localhost/cgi-bin/psa/mapserv?map=/home/bhempen/wfs.map&;> ##
Recommended
            "wfs_srs"                    "EPSG:4326" ## Recommended
            "wfs_abstract"               "This text describes my WFS
service." ## Recommended
      END
    END

LAYER
    NAME   "omega"
    STATUS       DEFAULT
    TYPE         POLYGON
    METADATA
        "wfs_title"             "omega footprints" ##REQUIRED
        "wfs_srs"               "EPSG:4326" ## REQUIRED
       "gml_include_items"     "all" ## Optional (serves all
attributes for layer)
        "gml_featureid"         "product_id" ## REQUIRED
    END
    PROJECTION
        "init=epsg:4326"
    END
    CONNECTIONTYPE POSTGIS
    CONNECTION "host=localhost port=xxx dbname=xxx user=xxx password=xxx"
    DATA "the_geom from alldata using unique product_id using SRID=4326"
    CLASS
        STYLE
            OUTLINECOLOR    125 0 0
        END
    END
    DUMP TRUE             ## REQUIRED
END # layer

END


Does anyone see a problem with the setup?

Many thanks to Kai and Assefa for the help so far! I am going to send
you the shapefile (which you could import into the database with
pgsql2shp), the mapfile, and my client.

Kind regards,
Bryan

================================================================================================
This message and any attachments are intended for the use of the addressee or 
addressees only. The unauthorised disclosure,

use, dissemination or copying (either in whole or in part) of its content is 
not permitted. If you received this message in

error, please notify the sender and delete it from your system. Emails can be 
altered and their integrity cannot be guaranteed by

the sender.

Please consider the environment before printing this email.
=================================================================================================

================================================================================================
This message and any attachments are intended for the use of the addressee or 
addressees only. The unauthorised disclosure,

use, dissemination or copying (either in whole or in part) of its content is 
not permitted. If you received this message in

error, please notify the sender and delete it from your system. Emails can be 
altered and their integrity cannot be guaranteed by

the sender.

Please consider the environment before printing this email.
=================================================================================================



_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


--
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.

<<attachment: jcigar.vcf>>

_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to