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

Sat May 12 02:14:33 EST 2012

Hi,
I think I will opt for the GeoServer, although I have a lot of uncertainties if I can integrate geoserver with asp.net. With TinyOWS I created a nice application with ASP.NET, which is supposed to handle all the interface of the portal and editing of the plain data, and as for the mapviewer it connects with a proxy in IIS directly to Apache, and then with OpenLayers and TinyOWS. Before saving the feature I updated the feature also with the plain data (other columns of the table in PostGIS) taken from the interface in ASP.NET
In the MS4W mailing list, there was already a question like the mine and the user had never got an answer. I wrote him directly and he told me that he couldn't make it work with Windows, so he had configured the MapServer in a Linux Virtual Machine. But since I have no experience in Linux, I find it too risky to go for that.
The deadline is at the end of this month, I don't know if I can reach it, but this is life...
Thanks a lot for your attempts and your help

> From: Jukka.Rahkonen at mmmtike.fi
> To: tinyows-dev at lists.maptools.org
> Date: Fri, 11 May 2012 20:26:35 +0000
> Subject: Re: [TinyOWS-dev] Error when inserting new feature with TinyOWS
> 
> Hi,
> 
> I installed MS4W-dev and TinyOWS package from MS4W site. Installation is ridiculously easy, as usual. And I do get the same error than you.
> 
> 
> [Fri May 11 23:16:58 2012] [SQL] BEGIN;
> [Fri May 11 23:16:58 2012] [SQL] SELECT nextval('public.osm_motorway_id_seq');
> [Fri May 11 23:16:58 2012] [SQL] SELECT ST_GeomFromGML('<LineString xmlns="http://www.opengis.net/gml" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tows="http://www.tinyows.org" srsName="EPSG:3067"><coordinates xmlns="http://www.opengis.net/gml" cs="," ts=" ">311899.3423,6897735.8910 348346.7571,6930133.5931 324048.4806,6971643.1489 347334.3290,6994928.9973 347334.3290,6994928.9973 364545.6082,6962531.2952</coordinates></LineString>')
> [Fri May 11 23:16:58 2012] [SQL] SELECT ST_IsValid('0102000020FB0B00000600000026E4835E6D091341DD2406F911505A41EF384507EB421541B459F565B56F5A410A6822EC41C71341DE9387C93E985A414260E5501933154161C3D33FFCAE5A414260E5501933154161C3D33FFCAE5A4116FBCB6E064016418A8EE4D2588F5A41')
> 
> At this step tinyows process dies and QGis gives an error.
> Because you were able to edit features on my Linux server it makes me to think that the problem is in the MS4W version of TinyOWS. I suggest you to write to MS4W mailing list and tell that we both have the same issue with inserts.
> 
> -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 21:48
> Vastaanottaja: tinyows-dev at lists.maptools.org
> Aihe: Re: [TinyOWS-dev] Error when inserting new feature with TinyOWS
> 
> Hi,
> 
> Thanks a lot for your attempts, I mean it. I guess now I am too late to stick on another technology... I thought TinyOWS would have worked, but from what I have seen, it looks like it doesn't. I have searched a lot these days for this insert issue, and as far as I have seen other people using MS4W have had these issues, and I couldn't read any positive feedback...
> 
> However I will make another desperate attempt to try with Geoserver. I hope it will be easy to integrate it with my website and so to reach the deadline. I put lot of efforts on it but it looks like they were unsuccessful...
> 
> 
> > From: Jukka.Rahkonen at mmmtike.fi
> > To: tinyows-dev at lists.maptools.org
> > Date: Fri, 11 May 2012 18:22:27 +0000
> > Subject: Re: [TinyOWS-dev] Error when inserting new feature with TinyOWS
> >
> > 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?
> >
> >
> > _______________________________________________
> > TinyOWS-dev mailing list
> > TinyOWS-dev at lists.maptools.org
> > http://lists.maptools.org/mailman/listinfo/tinyows-dev
> _______________________________________________
> TinyOWS-dev mailing list
> TinyOWS-dev at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/tinyows-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/tinyows-dev/attachments/20120512/6177a28c/attachment-0001.htm 