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

Fri May 11 13:22:27 EST 2012

Hi,

TinyOWS is not so wide spread program and I believe that there are very few using it on Windows and WSF-T is also rather uncommon. Thus the combination TinyOWS-MS4W-WFS-T can really make you desperate.

If you are in a need to get a working WFS-T easily on Windows - install Geoserver. However, as a MS4W user myself I appreciate your hard attempts. But if you do not get answers from the real TinyOWS developers through this mailing list soon then it could be better for yourself to look at other alternatives. I can not see anything obviously wrong in your configuration.

I will try to have a try during this weekend with MS4W too. I will report if it is successful or not.

-Jukka Rahkonen-

________________________________
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: 11. toukokuuta 2012 20:21
Vastaanottaja: tinyows-dev at lists.maptools.org
Aihe: Re: [TinyOWS-dev] Error when inserting new feature with TinyOWS

OK, maybe I should start from the beginning in the desperate need for some help, because I don't think it should be such a difficult situation for the experts. I'm not going to mention my failed attempts with OpenLayers, just with QGis and MS4W and TinyOWS

I have created one table in the database (schema: public) named olivestwo. This table has only two columns named fid (primary key, serial) and another one named geometry (geometry, type: POLYGON, srid: 32634). I have copied the XSD schema and everything else from the last release of TinyOWS. I have configured the config.xml like this:

<tinyows online_resource="http://127.0.0.1:81/cgi-bin/tinyows.exe"
  schema_dir="C:/ms4w/apps/tinyows/schema/"
  check_schema="0"
         log="C:/ms4w/apps/tinyows/tinyows.log"
         log_level="15">
  <pg host="127.0.0.1" user="postgres" password="olives001" 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:81/"
         name="olivestwo"
         schema="public"
         title="olives test test"/>
</tinyows>

I have configured the httpd_tinyows.conf within httpd.d folder, like this:

SetEnv TINYOWS_CONFIG_FILE "C:/ms4w/apps/tinyows/config.xml"
SetEnv TINYOWS_SCHEMA_DIR "C:/ms4w/apps/tinyows/schema/"

<Directory "C:/ms4w/apps/tinyows/">
  AllowOverride None
  Options Indexes FollowSymLinks Multiviews
  Order allow,deny
  Allow from all
</Directory>

The editing and deleting of existing features works very well.

If I try with this configuration, to insert a new feature from QGis, I get this from the log file:

[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://127.0.0.1:81/ http://127.0.0.1:81/cgi-bin/tinyows.exe?SERVICE=WFS&amp;VERSION=1.0.0&amp;REQUEST=DescribeFeatureType&amp;TYPENAME=tows:olivestwo&amp;SRSNAME=EPSG:32634" xmlns:tows="http://127.0.0.1:81/"><Insert xmlns="http://www.opengis.net/wfs"><olivestwo xmlns="http://127.0.0.1:81/"><geometry xmlns="http://127.0.0.1:81/"><Polygon xmlns="http://www.opengis.net/gml" srsName="EPSG:32634"><outerBoundaryIs xmlns="http://www.opengis.net/gml"><LinearRing xmlns="http://www.opengis.net/gml"><coordinates xmlns="http://www.opengis.net/gml" cs="," ts=" ">379105.5268,4513275.2700 378342.3352,4513020.8728 378342.3352,4513020.8728 378342.3352,4513020.8728 378482.2536,4512448.4791 378482.2536,4512448.4791 379041.9275,4512677.4366 379105.5268,4513275.2700</coordinates></LinearRing></outerBoundaryIs></Polygon></geometry></olivestwo></Insert></Transaction>
[SQL] BEGIN;
[SQL] SELECT nextval('public.olives2_fid_seq');
[SQL] SELECT ST_GeomFromGML('<Polygon xmlns="http://www.opengis.net/gml" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tows="http://127.0.0.1:81/" srsName="EPSG:32634"><outerBoundaryIs xmlns="http://www.opengis.net/gml"><LinearRing xmlns="http://www.opengis.net/gml"><coordinates xmlns="http://www.opengis.net/gml" cs="," ts=" ">379105.5268,4513275.2700 378342.3352,4513020.8728 378342.3352,4513020.8728 378342.3352,4513020.8728 378482.2536,4512448.4791 378482.2536,4512448.4791 379041.9275,4512677.4366 379105.5268,4513275.2700</coordinates></LinearRing></outerBoundaryIs></Polygon>')
[SQL] SELECT ST_IsValid('01030000207A7F000001000000080000008E75711B8623174114AE47D17E37514136AB3E579917174188F4DB373F37514136AB3E579917174188F4DB373F37514136AB3E579917174188F4DB373F375141E9B7AF03C91917410C93A91EB0365141E9B7AF03C91917410C93A91EB03651415C8FC2B5872217412041F15BE93651418E75711B8623174114AE47D17E375141')
[SQL]
[SQL] ROLLBACK;

If I try to run the ST_IsValid function from PostGIS, it returns 't', meaning that the geometry validates OK.
The transaction query seems to be well formed (at least from what I can see).

If in the config file I try to change the check_schema to "1", I get the following info from the log file:

[EVENT] == FCGI START ==
[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://127.0.0.1:81/ http://127.0.0.1:81/cgi-bin/tinyows.exe?SERVICE=WFS&amp;VERSION=1.0.0&amp;REQUEST=DescribeFeatureType&amp;TYPENAME=tows:olivestwo&amp;SRSNAME=EPSG:32634" xmlns:tows="http://127.0.0.1:81/"><Insert xmlns="http://www.opengis.net/wfs"><olivestwo xmlns="http://127.0.0.1:81/"><geometry xmlns="http://127.0.0.1:81/"><Polygon xmlns="http://www.opengis.net/gml" srsName="EPSG:32634"><outerBoundaryIs xmlns="http://www.opengis.net/gml"><LinearRing xmlns="http://www.opengis.net/gml"><coordinates xmlns="http://www.opengis.net/gml" cs="," ts=" ">375264.1291,4513249.8303 375391.3277,4512753.7557 376052.7604,4513364.3090 375264.1291,4513249.8303</coordinates></LinearRing></outerBoundaryIs></Polygon></geometry></olivestwo></Insert></Transaction>
[ERROR] Element '{http://www.w3.org/2001/XMLSchema}import': Failed to locate a schema at location 'http://127.0.0.1:81/cgi-bin/tinyows.exe?service=WFS&request=DescribeFeatureType&version=1.0.0'. Skipping the import.

[ERROR] Element '{http://127.0.0.1:81/}olivestwo': This element is not expected. Expected is one of ( {http://www.opengis.net/gml}_Feature, {http://www.opengis.net/wfs}FeatureCollection ).

[ERROR] XML request isn't valid

I have made several tries with different layers, even with the ones from the release and I always have had the same results. I have also changed the ns_uri in config.xml to http://tinyows.org/ and still the same results...

Can anyone tell me if I am doing something wrong? Has anyone made it work with the MS4W in Windows?