[mapserver-users] [TinyOWS] Broken config using a MAPFILE?
Richard Turner
richard.turner at mediatelgroup.co.uk
Wed Sep 26 05:53:05 PDT 2012
Hi Oliver,
Thanks for your help with this. I've been busy with other stuff, hence
the delay.
I've tweaked my map file a little and enabled TinyOWS logging. Still no
good.
I couldn't see what you changed in the request that would make it work
when you tried; it doesn't look significantly different from the one
OpenLayers is generating for me, except that the namespace is different.
This shouldn't matter though, should it?
Cheers,
R
Map file:
MAP
NAME "postcodes"
STATUS ON
EXTENT -20037508.34, -20037508.34, 20037508.34, 20037508.34
UNITS M
WEB
METADATA
"tinyows_schema_dir" "/usr/local/share/tinyows/schema/"
"tinyows_onlineresource"
"http://richardt.gis.mediatel.co.uk/wfs"
"tinyows_log" "/var/log/tinyows.log"
"tinyows_log_level" "15"
"wfs_title" "Postcode Data"
"wfs_enable_request" "*"
"wfs_namespace_uri" "http://richardt.gis.mediatel.co.uk"
"wfs_namespace_prefix" "mtl"
END
END
PROJECTION
"init=epsg:3857"
END
LAYER
NAME "areas"
METADATA
"wfs_name" "areas"
"wfs_title" "Postcode Areas"
"gml_featureid" "ogc_fid"
"gml_include_items" "all"
"wfs_enable_request" "*"
"tinyows_table" "postcode_area_boundaries"
"tinyows_retrievable" "1"
"tinyows_writable" "1"
"wfs_srs" "EPSG:3857"
END
TYPE POLYGON
STATUS DEFAULT
CONNECTIONTYPE postgis
CONNECTION "host=localhost dbname=osm user=osm password=osm"
DATA "wkb_geometry FROM postcode_area_boundaries"
DUMP TRUE
END
LAYER
NAME "sectors"
METADATA
"wfs_name" "sectors"
"wfs_title" "Postcode Sectors"
"gml_featureid" "ogc_fid"
"gml_include_items" "all"
"wfs_enable_request" "*"
"tinyows_table" "postcode_sector_boundaries"
"tinyows_retrievable" "1"
"tinyows_writable" "1"
"wfs_srs" "EPSG:3857"
END
TYPE POLYGON
STATUS DEFAULT
CONNECTIONTYPE postgis
CONNECTION "host=localhost dbname=osm user=osm password=osm"
DATA "wkb_geometry FROM postcode_sector_boundaries"
DUMP TRUE
END
END
TinyOWS log:
[Wed Sep 26 13:23:27 2012] [EVENT] == TINYOWS STARTUP ==
[Wed Sep 26 13:23:27 2012] [SQL] SELECT substr(postgis_full_version(),
10, 5)
[Wed Sep 26 13:23:28 2012] [EVENT] == Connection PostGIS ==
[Wed Sep 26 13:23:28 2012] [SQL] SELECT DISTINCT f_table_schema,
f_table_name FROM geometry_columns
[Wed Sep 26 13:23:28 2012] [SQL] SELECT DISTINCT f_table_schema,
f_table_name FROM geography_columns
[Wed Sep 26 13:23:28 2012] [SQL] SELECT srid, f_geometry_column FROM
geometry_columns WHERE f_table_schema='public' AND
f_table_name='postcode_area_boundaries'
[Wed Sep 26 13:23:28 2012] [SQL] SELECT * FROM spatial_ref_sys WHERE
srid=3857 AND proj4text like '%%units=m%%'
[Wed Sep 26 13:23:28 2012] [SQL] SELECT a.attname AS field, t.typname AS
type FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n WHERE
n.nspname = 'public' AND c.relname = 'postcode_area_boundaries' AND
c.relnamespace = n.oid AND a.attrelid = c.oid AND a.atttypid = t.oid AND
a.attname IN ('all', '');
[Wed Sep 26 13:23:28 2012] [SQL] SELECT a.attname AS field FROM pg_class
c, pg_attribute a, pg_type t, pg_namespace n WHERE n.nspname = 'public'
AND c.relname = 'postcode_area_boundaries' AND c.relnamespace = n.oid
AND a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid AND
a.attnotnull = 't' AND a.atthasdef='f'
[Wed Sep 26 13:23:28 2012] [SQL] SELECT c.column_name FROM
information_schema.constraint_column_usage c, pg_namespace n WHERE
n.nspname = 'public' AND c.table_name = 'postcode_area_boundaries' AND
c.constraint_name = (SELECT c.conname FROM pg_class r, pg_constraint c,
pg_namespace n WHERE r.oid = c.conrelid AND relname =
'postcode_area_boundaries' AND r.relnamespace = n.oid AND n.nspname =
'public' AND c.contype = 'p')
[Wed Sep 26 13:23:28 2012] [SQL] SELECT a.attnum FROM pg_class c,
pg_attribute a, pg_type t, pg_namespace n WHERE a.attrelid = c.oid AND
a.atttypid = t.oid AND n.nspname='public' AND
c.relname='postcode_area_boundaries' AND a.attname='ogc_fid'
[Wed Sep 26 13:23:28 2012] [SQL] SELECT
pg_get_serial_sequence('public."postcode_area_boundaries"', 'ogc_fid');
[Wed Sep 26 13:23:28 2012] [SQL] SELECT column_default FROM
information_schema.columns WHERE table_schema = 'public' AND table_name
= 'postcode_area_boundaries' AND column_name = 'ogc_fid' AND
table_catalog = current_database();
[Wed Sep 26 13:23:28 2012] [SQL] SELECT srid, f_geometry_column FROM
geometry_columns WHERE f_table_schema='public' AND
f_table_name='postcode_sector_boundaries'
[Wed Sep 26 13:23:28 2012] [SQL] SELECT * FROM spatial_ref_sys WHERE
srid=900914 AND proj4text like '%%units=m%%'
[Wed Sep 26 13:23:28 2012] [SQL] SELECT a.attname AS field, t.typname AS
type FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n WHERE
n.nspname = 'public' AND c.relname = 'postcode_sector_boundaries' AND
c.relnamespace = n.oid AND a.attrelid = c.oid AND a.atttypid = t.oid AND
a.attname IN ('all', '');
[Wed Sep 26 13:23:28 2012] [SQL] SELECT a.attname AS field FROM pg_class
c, pg_attribute a, pg_type t, pg_namespace n WHERE n.nspname = 'public'
AND c.relname = 'postcode_sector_boundaries' AND c.relnamespace = n.oid
AND a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid AND
a.attnotnull = 't' AND a.atthasdef='f'
[Wed Sep 26 13:23:28 2012] [SQL] SELECT c.column_name FROM
information_schema.constraint_column_usage c, pg_namespace n WHERE
n.nspname = 'public' AND c.table_name = 'postcode_sector_boundaries' AND
c.constraint_name = (SELECT c.conname FROM pg_class r, pg_constraint c,
pg_namespace n WHERE r.oid = c.conrelid AND relname =
'postcode_sector_boundaries' AND r.relnamespace = n.oid AND n.nspname =
'public' AND c.contype = 'p')
[Wed Sep 26 13:23:28 2012] [SQL] SELECT a.attnum FROM pg_class c,
pg_attribute a, pg_type t, pg_namespace n WHERE a.attrelid = c.oid AND
a.atttypid = t.oid AND n.nspname='public' AND
c.relname='postcode_sector_boundaries' AND a.attname='ogc_fid'
[Wed Sep 26 13:23:28 2012] [SQL] SELECT
pg_get_serial_sequence('public."postcode_sector_boundaries"',
'ogc_fid');
[Wed Sep 26 13:23:28 2012] [SQL] SELECT column_default FROM
information_schema.columns WHERE table_schema = 'public' AND table_name
= 'postcode_sector_boundaries' AND column_name = 'ogc_fid' AND
table_catalog = current_database();
[Wed Sep 26 13:23:28 2012] [EVENT] == Filling Storage ==
[Wed Sep 26 13:23:28 2012] [QUERY] <wfs:GetFeature
xmlns:wfs="http://www.opengis.net/wfs" service="WFS" version="1.0.0"
xsi:schemaLocation="http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><wfs:Query
typeName="feature:areas"
xmlns:feature="http://richardt.gis.mediatel.co.uk"><ogc:Filter
xmlns:ogc="http://www.opengis.net/ogc"><ogc:BBOX><ogc:PropertyName>wkb_geometry</ogc:PropertyName><gml:Box xmlns:gml="http://www.opengis.net/gml" srsName="EPSG:3857"><gml:coordinates decimal="." cs="," ts=" ">-417651.92249206,6625221.1068455 417651.92249206,6795217.0577279</gml:coordinates></gml:Box></ogc:BBOX></ogc:Filter></wfs:Query></wfs:GetFeature>
[Wed Sep 26 13:23:28 2012] [EVENT] == TINYOWS STARTUP ==
[Wed Sep 26 13:23:28 2012] [SQL] SELECT substr(postgis_full_version(),
10, 5)
[Wed Sep 26 13:23:28 2012] [EVENT] == Connection PostGIS ==
[Wed Sep 26 13:23:28 2012] [SQL] SELECT DISTINCT f_table_schema,
f_table_name FROM geometry_columns
[Wed Sep 26 13:23:28 2012] [SQL] SELECT DISTINCT f_table_schema,
f_table_name FROM geography_columns
[Wed Sep 26 13:23:28 2012] [SQL] SELECT srid, f_geometry_column FROM
geometry_columns WHERE f_table_schema='public' AND
f_table_name='postcode_area_boundaries'
[Wed Sep 26 13:23:28 2012] [SQL] SELECT * FROM spatial_ref_sys WHERE
srid=3857 AND proj4text like '%%units=m%%'
[Wed Sep 26 13:23:28 2012] [SQL] SELECT a.attname AS field, t.typname AS
type FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n WHERE
n.nspname = 'public' AND c.relname = 'postcode_area_boundaries' AND
c.relnamespace = n.oid AND a.attrelid = c.oid AND a.atttypid = t.oid AND
a.attname IN ('all', '');
[Wed Sep 26 13:23:28 2012] [SQL] SELECT a.attname AS field FROM pg_class
c, pg_attribute a, pg_type t, pg_namespace n WHERE n.nspname = 'public'
AND c.relname = 'postcode_area_boundaries' AND c.relnamespace = n.oid
AND a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid AND
a.attnotnull = 't' AND a.atthasdef='f'
[Wed Sep 26 13:23:28 2012] [SQL] SELECT c.column_name FROM
information_schema.constraint_column_usage c, pg_namespace n WHERE
n.nspname = 'public' AND c.table_name = 'postcode_area_boundaries' AND
c.constraint_name = (SELECT c.conname FROM pg_class r, pg_constraint c,
pg_namespace n WHERE r.oid = c.conrelid AND relname =
'postcode_area_boundaries' AND r.relnamespace = n.oid AND n.nspname =
'public' AND c.contype = 'p')
[Wed Sep 26 13:23:28 2012] [SQL] SELECT a.attnum FROM pg_class c,
pg_attribute a, pg_type t, pg_namespace n WHERE a.attrelid = c.oid AND
a.atttypid = t.oid AND n.nspname='public' AND
c.relname='postcode_area_boundaries' AND a.attname='ogc_fid'
[Wed Sep 26 13:23:28 2012] [SQL] SELECT
pg_get_serial_sequence('public."postcode_area_boundaries"', 'ogc_fid');
[Wed Sep 26 13:23:28 2012] [SQL] SELECT column_default FROM
information_schema.columns WHERE table_schema = 'public' AND table_name
= 'postcode_area_boundaries' AND column_name = 'ogc_fid' AND
table_catalog = current_database();
[Wed Sep 26 13:23:28 2012] [SQL] SELECT srid, f_geometry_column FROM
geometry_columns WHERE f_table_schema='public' AND
f_table_name='postcode_sector_boundaries'
[Wed Sep 26 13:23:28 2012] [SQL] SELECT * FROM spatial_ref_sys WHERE
srid=900914 AND proj4text like '%%units=m%%'
[Wed Sep 26 13:23:28 2012] [SQL] SELECT a.attname AS field, t.typname AS
type FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n WHERE
n.nspname = 'public' AND c.relname = 'postcode_sector_boundaries' AND
c.relnamespace = n.oid AND a.attrelid = c.oid AND a.atttypid = t.oid AND
a.attname IN ('all', '');
[Wed Sep 26 13:23:28 2012] [SQL] SELECT a.attname AS field FROM pg_class
c, pg_attribute a, pg_type t, pg_namespace n WHERE n.nspname = 'public'
AND c.relname = 'postcode_sector_boundaries' AND c.relnamespace = n.oid
AND a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid AND
a.attnotnull = 't' AND a.atthasdef='f'
[Wed Sep 26 13:23:28 2012] [SQL] SELECT c.column_name FROM
information_schema.constraint_column_usage c, pg_namespace n WHERE
n.nspname = 'public' AND c.table_name = 'postcode_sector_boundaries' AND
c.constraint_name = (SELECT c.conname FROM pg_class r, pg_constraint c,
pg_namespace n WHERE r.oid = c.conrelid AND relname =
'postcode_sector_boundaries' AND r.relnamespace = n.oid AND n.nspname =
'public' AND c.contype = 'p')
[Wed Sep 26 13:23:28 2012] [SQL] SELECT a.attnum FROM pg_class c,
pg_attribute a, pg_type t, pg_namespace n WHERE a.attrelid = c.oid AND
a.atttypid = t.oid AND n.nspname='public' AND
c.relname='postcode_sector_boundaries' AND a.attname='ogc_fid'
[Wed Sep 26 13:23:28 2012] [SQL] SELECT
pg_get_serial_sequence('public."postcode_sector_boundaries"',
'ogc_fid');
[Wed Sep 26 13:23:28 2012] [SQL] SELECT column_default FROM
information_schema.columns WHERE table_schema = 'public' AND table_name
= 'postcode_sector_boundaries' AND column_name = 'ogc_fid' AND
table_catalog = current_database();
[Wed Sep 26 13:23:28 2012] [EVENT] == Filling Storage ==
[Wed Sep 26 13:23:28 2012] [QUERY]
service=WFS&request=DescribeFeatureType&version=1.0.0
[Wed Sep 26 13:23:28 2012] [EVENT] == TINYOWS SHUTDOWN ==
[Wed Sep 26 13:23:28 2012] [ERROR] Element
'{http://www.w3.org/2001/XMLSchema}import': Skipping import of schema
located at 'http://schemas.opengis.net/gml/2.1.2/feature.xsd' for the
namespace 'http://www.opengis.net/gml', since this namespace was already
imported with the schema located at
'/usr/local/share/tinyows/schema/gml/2.1.2/feature.xsd'.
[Wed Sep 26 13:23:28 2012] [SQL] SELECT auth_name, auth_srid,
position('+units=m ' in proj4text), (position('AXIS["X",NORTH]]' in
srtext) + position('AXIS["Easting",EAST]]' in srtext)) FROM
spatial_ref_sys WHERE srid = '3857'
[Wed Sep 26 13:23:28 2012] [ERROR] Filter parameter doesn't validate WFS
Schema
[Wed Sep 26 13:23:28 2012] [EVENT] == TINYOWS SHUTDOWN ==
On Wed, 2012-09-19 at 10:27 +0200, Olivier Courtin wrote:
>
>
> On Wed, Sep 19, 2012 at 9:43 AM, Richard Turner
> <richard.turner at mediatelgroup.co.uk> wrote:
>
>
> Hi Richard
>
>
> I've since set-up a new server and installed the trunk version
> of tinyows on it and found that instead of working fine
> tinyows returns the following error:
>
> <ows:ExceptionText>Filter parameter doesn't validate WFS
> Schema</ows:ExceptionText>
>
>
>
>
>
>
> I've slightly changed the request you provided, to make it works with
> a TinyOWS trunk (i use TinyOWS XML config file here):
>
>
> <wfs:GetFeature xmlns:wfs="http://www.opengis.net/wfs"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" service="WFS"
> version="1.0.0" xsi:schemaLocation="http://www.opengis.net/wfs
> http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd">
> <wfs:Query xmlns:tows="http://www.tinyows.org/"
> typeName="tows:france">
> <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
> <ogc:BBOX>
> <ogc:PropertyName>geom</ogc:PropertyName>
> <gml:Box xmlns:gml="http://www.opengis.net/gml"
> srsName="EPSG:3857">
> <gml:coordinates decimal="." cs="," ts="
> ">-417651.92249206,6609322.2049643
> 417651.92249206,6811115.9596091</gml:coordinates>
> </gml:Box>
> </ogc:BBOX>
> </ogc:Filter>
> </wfs:Query>
> </wfs:GetFeature>
>
>
>
>
>
>
> To go further in debug, could you activate log
> (or recompile tinyows with --enable-debug option)
> and send the whole log here.
>
>
> Thanks.
>
>
>
> --
> Olivier
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120926/b6ed3932/attachment-0001.html>
More information about the mapserver-users
mailing list