[TinyOWS-dev] Error when inserting new feature with TinyOWS

Thu May 10 17:12:23 EST 2012

Hi,

The schema must come from tinyows source http://www.tinyows.org/release/tinyows-1.0.0.tar.bz2

-Jukka-
________________________________
Lähettäjä: tinyows-dev-bounces at lists.maptools.org [tinyows-dev-bounces at lists.maptools.org] käyttäjän Ermond Parllaku [erndal02 at hotmail.com] puolesta
Lähetetty: 10. toukokuuta 2012 23:28
Vastaanottaja: tinyows-dev at lists.maptools.org
Aihe: Re: [TinyOWS-dev] Error when inserting new feature with TinyOWS

> And your request was
>
> [Thu May 10 21:39:39 2012] [QUERY] <Transaction xmlns="http://www.opengis.net/wfs" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0.0" service="WFS" xsi:schemaLocation="http://www.tinyows.org/ http://188.64.1.61/cgi-bin/tinyows?SERVICE=WFS&amp;VERSION=1.0.0&amp;REQUEST=DescribeFeatureType&amp;TYPENAME=tows:world&amp;SRSNAME=EPSG:4326" xmlns:tows="http://www.tinyows.org/"><Insert xmlns="http://www.opengis.net/wfs"><world xmlns="http://www.tinyows.org/"><the_geom xmlns="http://www.tinyows.org/"><MultiPolygon xmlns="http://www.opengis.net/gml" srsName="EPSG:4326"><polygonMember xmlns="http://www.opengis.net/gml"><Polygon xmlns="http://www.opengis.net/gml"><outerBoundaryIs xmlns="http://www.opengis.net/gml"><LinearRing xmlns="http://www.opengis.net/gml"><coordinates xmlns="http://www.opengis.net/gml" cs="," ts=" ">-38.85115395,50.30210923 -35.47280069,42.79465755 -29.09146676,51.42822698 -38.85115395,50.30210923</coordinates></LinearRing></outerBoundaryIs></Polygon></polygonMember></MultiPolygon></the_geom></world></Insert></Transaction>
>
> Notice that in your error DescribeFeatureType is withour typeName
> > [ERROR] Element '{http://www.w3.org/2001/XMLSchema}import': Failed to locate a schema at location 'http://localhost:81/cgi-bin/tinyows.exe?service=WFS&request=DescribeFeatureType&version=1.0.0'. Skipping the import.

Yes, I noticed that too.

But I think the error should be in the server side, not in the client side, since this result is produced by calling it from html and by calling it from the QGis too. The only thing that I see suspicious has to do with the xsd schemas inside the tinyows folder. Can you please upload or maybe tell me a link where to download the correct and working versions of xsd schemas, at least for version 1.0.0?

The database is found within the public schema, if this could give a clue for an error..

Thanks a lot

> From: Jukka.Rahkonen at mmmtike.fi
> To: tinyows-dev at lists.maptools.org
> Date: Thu, 10 May 2012 19:10:00 +0000
> Subject: Re: [TinyOWS-dev] Error when inserting new feature with TinyOWS
>
> Hi,
>
> It is the TinyOWS demo layer. Layer definition from tinyows.xml
> <layer retrievable="1"
> writable="1"
> ns_prefix="tows"
> ns_uri="http://www.tinyows.org/"
> name="france"
> title="French Administrative Sub Boundaries (IGN - GeoFLA Departements)" />
>
> And general settings:
> <tinyows online_resource="http://188.64.1.61/cgi-bin/tinyows"
> schema_dir="/usr/local/share/tinyows/schema/"
> check_schema="0"
> log="/usr/log/tinyows.log"
> log_level="4"
> estimated_extent="1"
> meter_precision="2"
> display_bbox="1">
>
> And your request was
>
> [Thu May 10 21:39:39 2012] [QUERY] <Transaction xmlns="http://www.opengis.net/wfs" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0.0" service="WFS" xsi:schemaLocation="http://www.tinyows.org/ http://188.64.1.61/cgi-bin/tinyows?SERVICE=WFS&amp;VERSION=1.0.0&amp;REQUEST=DescribeFeatureType&amp;TYPENAME=tows:world&amp;SRSNAME=EPSG:4326" xmlns:tows="http://www.tinyows.org/"><Insert xmlns="http://www.opengis.net/wfs"><world xmlns="http://www.tinyows.org/"><the_geom xmlns="http://www.tinyows.org/"><MultiPolygon xmlns="http://www.opengis.net/gml" srsName="EPSG:4326"><polygonMember xmlns="http://www.opengis.net/gml"><Polygon xmlns="http://www.opengis.net/gml"><outerBoundaryIs xmlns="http://www.opengis.net/gml"><LinearRing xmlns="http://www.opengis.net/gml"><coordinates xmlns="http://www.opengis.net/gml" cs="," ts=" ">-38.85115395,50.30210923 -35.47280069,42.79465755 -29.09146676,51.42822698 -38.85115395,50.30210923</coordinates></LinearRing></outerBoundaryIs></Polygon></polygonMember></MultiPolygon></the_geom></world></Insert></Transaction>
>
> Notice that in your error DescribeFeatureType is withour typeName
> > [ERROR] Element '{http://www.w3.org/2001/XMLSchema}import': Failed to locate a schema at location 'http://localhost:81/cgi-bin/tinyows.exe?service=WFS&request=DescribeFeatureType&version=1.0.0'. Skipping the import.
>
> -Jukka-
>
> ________________________________
> Lähettäjä: tinyows-dev-bounces at lists.maptools.org [tinyows-dev-bounces at lists.maptools.org] käyttäjän Ermond Parllaku [erndal02 at hotmail.com] puolesta
> Lähetetty: 10. toukokuuta 2012 21:56
> Vastaanottaja: tinyows-dev at lists.maptools.org
> Aihe: Re: [TinyOWS-dev] Error when inserting new feature with TinyOWS
>
> Hi,
>
> I just tried the service that you gave to me and it works also for inserting. I created the table france in postgis, but is it possible to have also the configuration that you have made in config.xml for this layer? And maybe some data from this layer to insert, as SQL query?
>
> Thanks
>
>
> > From: Jukka.Rahkonen at mmmtike.fi
> > To: tinyows-dev at lists.maptools.org
> > Date: Thu, 10 May 2012 18:26:51 +0000
> > Subject: Re: [TinyOWS-dev] Error when inserting new feature with TinyOWS
> >
> > Hi,
> >
> > This table is editable at http://188.64.1.61/cgi-bin/tinyows. I believe it is possible to do inserts too. Feel free to have a try.
> >
> > Table SQL is as follows.
> >
> > -- Table: france
> >
> > -- DROP TABLE france;
> >
> > CREATE TABLE france
> > (
> > gid serial NOT NULL,
> > id_geofla numeric(10,0),
> > code_chf_l character varying(3),
> > nom_chf_l character varying(50),
> > x_chf_lieu integer,
> > y_chf_lieu integer,
> > x_centroid integer,
> > y_centroid integer,
> > nom_dept character varying(30),
> > code_reg character varying(2),
> > nom_region character varying(30),
> > code_dept character varying(3),
> > the_geom geometry,
> > CONSTRAINT france_pkey PRIMARY KEY (gid ),
> > CONSTRAINT enforce_dims_the_geom CHECK (st_ndims(the_geom) = 2),
> > CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTIPOLYGON'::text OR the_geom IS NULL),
> > CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 27582)
> > )
> > WITH (
> > OIDS=FALSE
> > );
> > ALTER TABLE france
> > OWNER TO datamgr;
> >
> > -- Index: france_the_geom_gist
> >
> > -- DROP INDEX france_the_geom_gist;
> >
> > CREATE INDEX france_the_geom_gist
> > ON france
> > USING gist
> > (the_geom );
> >
> > -Jukka-
> >
> >
> > ________________________________
> > Lähettäjä: tinyows-dev-bounces at lists.maptools.org [tinyows-dev-bounces at lists.maptools.org] käyttäjän Ermond Parllaku [erndal02 at hotmail.com] puolesta
> > Lähetetty: 10. toukokuuta 2012 21:05
> > Vastaanottaja: tinyows-dev at lists.maptools.org
> > Aihe: Re: [TinyOWS-dev] Error when inserting new feature with TinyOWS
> >
> > It is looking like a monologue to me, but I still have hopes that I will find or get a solution for my issue, since I am having deadlines too...
> >
> > Anyway from what I have been reading about similar issues to mine, it looks like I have troubles in configuring the config.xml within tinyows.
> >
> > > <tinyows online_resource="http://localhost:81/cgi-bin/tinyows.exe"
> > > schema_dir="C:/ms4w/apps/tinyows/schema/"
> > > log="C:/ms4w/apps/tinyows/tinyows.log"
> > > log_level="15">
> > > <pg host="127.0.0.1" user="postgres" password="***" dbname="olives_gis1" port="5432"/>
> > > <metadata name="Olives WFST Server"
> > > title="WFST Olives" />
> > >
> > > <layer retrievable="1"
> > > writable="1"
> > > ns_prefix="tows"
> > > ns_uri="http://127.0.0.1/"
> > > //srid="EPSG:32634"
> > > name="olives"
> > > title="olives"/>
> > > </tinyows>
> >
> > I made in postgis another table which has only the fid (primary key) column and the geometry column, so that to make sure it is not an issue with the plain data. The name of the postgis table is olives2.
> >
> > But I am still having the same error from the logs...
> >
> > [ERROR] Element '{http://www.w3.org/2001/XMLSchema}import': Failed to locate a schema at location 'http://localhost:81/cgi-bin/tinyows.exe?service=WFS&request=DescribeFeatureType&version=1.0.0'. Skipping the import.
> >
> > I also tried the wfs-t with QGIS so that to make sure it is not an issue with the configuration in client side, but still the same error, which is only in inserting. The update and delete work like a charm...
> >
> > Now I am feeling too dummy and desperate since all the previous posts say that the error is in configuration, but the config.xml seems OK to me. The only thing I can think is that I have issues with the schemas defined in tinyows, although I have replaced them several times with other versions found in github and elsewhere in internet...
> >
> >
> >
> > ________________________________
> > From: erndal02 at hotmail.com
> > To: tinyows-dev at lists.maptools.org
> > Subject: RE: [TinyOWS-dev] Error when inserting new feature with TinyOWS
> > Date: Wed, 9 May 2012 21:35:30 +0200
> >
> > By the way, I am using PostGIS 1.5.3 version, installed with PostgreSQL 9.1
> >
> > The 2.0.0. version of PostGIS I read that it officially came out on May 2012. I don't think I need to upgrade the version of PostGIS, but may it be this the case of my errors?
> >