tinyows icon indicating copy to clipboard operation
tinyows copied to clipboard

Published 20 hours ago • verified publisher icon MapServer

TinyOWS 1.0.0rc3 didn't works on INSERT query - Win32 package issue

Open ocourtin opened this issue 12 years ago • 2 comments

Same requests on latest trunk on Unix works fine, But was wrong too, on 1.0.0rc3 on Unix.

So imply to update Win32 package version

################################################################
# tinyows.exe --help
################################################################
TinyOWS version:   1.0.0rc3
FCGI support:      Yes
Config File Path:  D:\Program\Tinyows\_TinyOWS.xml (TinyOWS XML)
PostGIS Version:   2.0.1
PostGIS dsn:       host=bdusrv18 port=5433 dbname=SIG user=utiltiny password=utiltiny
Output Encoding:   UTF-8
Database Encoding: UTF8
Schema dir:        d:/Program/tinyows/schema/
Log file:          d:/Program/tinyows/tinyows.log
Log level:         ERROR EVENT QUERY SQL
Display bbox:      Yes
Estimated extent:  No
Check schema:      Yes
Check valid geoms: Yes
Available layers:
 - public.pdv_evenements (3946) -> VCF.Evenements [RW]
----------------------------------------------------------------------------------------------------------------

 <layer name="Evenements"
        title="Evenements"
        ns_prefix="VCF"
        ns_uri="http://bdusrv18/"
        table="pdv_evenements"
        schema="public"
        srid="3946"        
        retrievable="1"
        writable="1" />

CREATE TABLE public.pdv_evenements (
  ident SERIAL, 
  type TEXT, 
  description TEXT, 
  date_evenement DATE, 
  date_visi_debut DATE, 
  date_visi_fin DATE, 
  geom public.geometry, 
  CONSTRAINT pdv_evenements_pkey PRIMARY KEY(ident)
) WITH OIDS;

======
[Wed Sep 05 08:56:32 2012] [EVENT] == TINYOWS STARTUP ==
[Wed Sep 05 08:56:32 2012] [SQL] SELECT substr(postgis_full_version(), 10, 5)
[Wed Sep 05 08:56:32 2012] [EVENT] == Connection PostGIS ==
[Wed Sep 05 08:56:32 2012] [SQL] SELECT DISTINCT f_table_schema, f_table_name FROM geometry_columns
[Wed Sep 05 08:56:32 2012] [SQL] SELECT DISTINCT f_table_schema, f_table_name FROM geography_columns
[Wed Sep 05 08:56:32 2012] [SQL] SELECT srid, f_geometry_column FROM geometry_columns WHERE f_table_schema='public' AND f_table_name='pdv_evenements'
[Wed Sep 05 08:56:32 2012] [SQL] SELECT * FROM spatial_ref_sys WHERE srid=3946 AND proj4text like '%%units=m%%'
[Wed Sep 05 08:56:32 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 = 'pdv_evenements' AND c.relnamespace = n.oid AND a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid
[Wed Sep 05 08:56:32 2012] [SQL] SELECT type from geometry_columns where f_table_schema='public' and f_table_name='pdv_evenements' and f_geometry_column='geom';
[Wed Sep 05 08:56:32 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 = 'pdv_evenements' 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 05 08:56:32 2012] [SQL] SELECT c.column_name FROM information_schema.constraint_column_usage c, pg_namespace n WHERE n.nspname = 'public' AND c.table_name = 'pdv_evenements' AND c.constraint_name = (SELECT c.conname FROM pg_class r, pg_constraint c, pg_namespace n WHERE r.oid = c.conrelid AND relname = 'pdv_evenements' AND r.relnamespace = n.oid AND n.nspname = 'public' AND c.contype = 'p')
[Wed Sep 05 08:56:32 2012] [SQL] SELECT a.attnum FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n WHERE a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid AND n.nspname='public' AND c.relname='pdv_evenements' AND a.attname='ident'
[Wed Sep 05 08:56:32 2012] [SQL] SELECT pg_get_serial_sequence('public."pdv_evenements"', 'ident');
[Wed Sep 05 08:56:32 2012] [EVENT] == Filling Storage ==
[Wed Sep 05 08:56:32 2012] [EVENT] == FCGI START ==
[Wed Sep 05 08:56:32 2012] [QUERY] <wfs:Transaction 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 http://bdusrv18/ http://www.bdusrv18/WS/tinyows.exe?service=wfs&amp;request=DescribeFeatureType&amp;version=1.1.0&amp;typename=VCF:Evenements" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><wfs:Insert><feature:Evenements xmlns:feature="http://bdusrv18/"><feature:geom><gml:Point xmlns:gml="http://www.opengis.net/gml" srsName="EPSG:3946"><gml:coordinates decimal="." cs="," ts=" ">1703417.4222222,5176797.1333333</gml:coordinates></gml:Point></feature:geom></feature:Evenements></wfs:Insert></wfs:Transaction>
[Wed Sep 05 08:56:32 2012] [EVENT] == TINYOWS STARTUP ==
[Wed Sep 05 08:56:32 2012] [SQL] SELECT substr(postgis_full_version(), 10, 5)
[Wed Sep 05 08:56:32 2012] [EVENT] == Connection PostGIS ==
[Wed Sep 05 08:56:32 2012] [SQL] SELECT DISTINCT f_table_schema, f_table_name FROM geometry_columns
[Wed Sep 05 08:56:32 2012] [SQL] SELECT DISTINCT f_table_schema, f_table_name FROM geography_columns
[Wed Sep 05 08:56:32 2012] [SQL] SELECT srid, f_geometry_column FROM geometry_columns WHERE f_table_schema='public' AND f_table_name='pdv_evenements'
[Wed Sep 05 08:56:32 2012] [SQL] SELECT * FROM spatial_ref_sys WHERE srid=3946 AND proj4text like '%%units=m%%'
[Wed Sep 05 08:56:32 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 = 'pdv_evenements' AND c.relnamespace = n.oid AND a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid
[Wed Sep 05 08:56:32 2012] [SQL] SELECT type from geometry_columns where f_table_schema='public' and f_table_name='pdv_evenements' and f_geometry_column='geom';
[Wed Sep 05 08:56:32 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 = 'pdv_evenements' 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 05 08:56:32 2012] [SQL] SELECT c.column_name FROM information_schema.constraint_column_usage c, pg_namespace n WHERE n.nspname = 'public' AND c.table_name = 'pdv_evenements' AND c.constraint_name = (SELECT c.conname FROM pg_class r, pg_constraint c, pg_namespace n WHERE r.oid = c.conrelid AND relname = 'pdv_evenements' AND r.relnamespace = n.oid AND n.nspname = 'public' AND c.contype = 'p')
[Wed Sep 05 08:56:32 2012] [SQL] SELECT a.attnum FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n WHERE a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid AND n.nspname='public' AND c.relname='pdv_evenements' AND a.attname='ident'
[Wed Sep 05 08:56:32 2012] [SQL] SELECT pg_get_serial_sequence('public."pdv_evenements"', 'ident');
[Wed Sep 05 08:56:32 2012] [EVENT] == Filling Storage ==
[Wed Sep 05 08:56:32 2012] [EVENT] == FCGI START ==
[Wed Sep 05 08:56:32 2012] [QUERY] service=WFS&request=DescribeFeatureType&version=1.0.0
[Wed Sep 05 08:56:32 2012] [EVENT] == FCGI SHUTDOWN ==
[Wed Sep 05 08:56:32 2012] [EVENT] == TINYOWS SHUTDOWN ==
[Wed Sep 05 08:56:32 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 'd:///Program/tinyows/schema/gml/2.1.2/feature.xsd'.

[Wed Sep 05 08:56:32 2012] [SQL] BEGIN;
[Wed Sep 05 08:56:32 2012] [SQL] SELECT ST_GeomFromGML('<gml:Point xmlns:gml="http://www.opengis.net/gml" xmlns:feature="http://bdusrv18/" xmlns:wfs="http://www.opengis.net/wfs" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" srsName="EPSG:3946"><gml:coordinates decimal="." cs="," ts=" ">1703417.4222222,5176797.1333333</gml:coordinates></gml:Point>',0)
[Wed Sep 05 08:56:32 2012] [SQL] SELECT ST_IsValid('01010000206A0F00000DC1166CF9FD39416588884877BF5341')
[Wed Sep 05 08:56:32 2012] [SQL] 
[Wed Sep 05 08:56:32 2012] [SQL] ROLLBACK;
====

====
[Wed Sep 05 09:06:36 2012] [EVENT] == TINYOWS STARTUP ==
[Wed Sep 05 09:06:36 2012] [SQL] SELECT substr(postgis_full_version(), 10, 5)
[Wed Sep 05 09:06:36 2012] [EVENT] == Connection PostGIS ==
[Wed Sep 05 09:06:36 2012] [SQL] SELECT DISTINCT f_table_schema, f_table_name FROM geometry_columns
[Wed Sep 05 09:06:36 2012] [SQL] SELECT DISTINCT f_table_schema, f_table_name FROM geography_columns
[Wed Sep 05 09:06:36 2012] [SQL] SELECT srid, f_geometry_column FROM geometry_columns WHERE f_table_schema='public' AND f_table_name='pdv_evenements'
[Wed Sep 05 09:06:36 2012] [SQL] SELECT * FROM spatial_ref_sys WHERE srid=3946 AND proj4text like '%%units=m%%'
[Wed Sep 05 09:06:36 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 = 'pdv_evenements' AND c.relnamespace = n.oid AND a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid
[Wed Sep 05 09:06:36 2012] [SQL] SELECT type from geometry_columns where f_table_schema='public' and f_table_name='pdv_evenements' and f_geometry_column='geom';
[Wed Sep 05 09:06:36 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 = 'pdv_evenements' 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 05 09:06:36 2012] [SQL] SELECT c.column_name FROM information_schema.constraint_column_usage c, pg_namespace n WHERE n.nspname = 'public' AND c.table_name = 'pdv_evenements' AND c.constraint_name = (SELECT c.conname FROM pg_class r, pg_constraint c, pg_namespace n WHERE r.oid = c.conrelid AND relname = 'pdv_evenements' AND r.relnamespace = n.oid AND n.nspname = 'public' AND c.contype = 'p')
[Wed Sep 05 09:06:36 2012] [SQL] SELECT a.attnum FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n WHERE a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid AND n.nspname='public' AND c.relname='pdv_evenements' AND a.attname='ident'
[Wed Sep 05 09:06:36 2012] [SQL] SELECT pg_get_serial_sequence('public."pdv_evenements"', 'ident');
[Wed Sep 05 09:06:36 2012] [EVENT] == Filling Storage ==
[Wed Sep 05 09:06:36 2012] [EVENT] == FCGI START ==
[Wed Sep 05 09:06:36 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://bdusrv18/ http://bdusrv18/wfst/?SERVICE=WFS&amp;VERSION=1.0.0&amp;REQUEST=DescribeFeatureType&amp;TYPENAME=VCF:Evenements&amp;SRSNAME=EPSG:3946" xmlns:VCF="http://bdusrv18/"><Insert xmlns="http://www.opengis.net/wfs"><Evenements xmlns="http://bdusrv18/"><type xmlns="http://bdusrv18/">test</type><description xmlns="http://bdusrv18/">Donnee test</description><geom xmlns="http://bdusrv18/"><Point xmlns="http://www.opengis.net/gml" srsName="EPSG:3946"><coordinates xmlns="http://www.opengis.net/gml" cs="," ts=" ">1704171.7219,5172372.9801</coordinates></Point></geom></Evenements></Insert></Transaction>
[Wed Sep 05 09:06:36 2012] [EVENT] == TINYOWS STARTUP ==
[Wed Sep 05 09:06:36 2012] [SQL] SELECT substr(postgis_full_version(), 10, 5)
[Wed Sep 05 09:06:36 2012] [EVENT] == Connection PostGIS ==
[Wed Sep 05 09:06:36 2012] [SQL] SELECT DISTINCT f_table_schema, f_table_name FROM geometry_columns
[Wed Sep 05 09:06:36 2012] [SQL] SELECT DISTINCT f_table_schema, f_table_name FROM geography_columns
[Wed Sep 05 09:06:36 2012] [SQL] SELECT srid, f_geometry_column FROM geometry_columns WHERE f_table_schema='public' AND f_table_name='pdv_evenements'
[Wed Sep 05 09:06:36 2012] [SQL] SELECT * FROM spatial_ref_sys WHERE srid=3946 AND proj4text like '%%units=m%%'
[Wed Sep 05 09:06:36 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 = 'pdv_evenements' AND c.relnamespace = n.oid AND a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid
[Wed Sep 05 09:06:36 2012] [SQL] SELECT type from geometry_columns where f_table_schema='public' and f_table_name='pdv_evenements' and f_geometry_column='geom';
[Wed Sep 05 09:06:36 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 = 'pdv_evenements' 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 05 09:06:36 2012] [SQL] SELECT c.column_name FROM information_schema.constraint_column_usage c, pg_namespace n WHERE n.nspname = 'public' AND c.table_name = 'pdv_evenements' AND c.constraint_name = (SELECT c.conname FROM pg_class r, pg_constraint c, pg_namespace n WHERE r.oid = c.conrelid AND relname = 'pdv_evenements' AND r.relnamespace = n.oid AND n.nspname = 'public' AND c.contype = 'p')
[Wed Sep 05 09:06:36 2012] [SQL] SELECT a.attnum FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n WHERE a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid AND n.nspname='public' AND c.relname='pdv_evenements' AND a.attname='ident'
[Wed Sep 05 09:06:36 2012] [SQL] SELECT pg_get_serial_sequence('public."pdv_evenements"', 'ident');
[Wed Sep 05 09:06:36 2012] [EVENT] == Filling Storage ==
[Wed Sep 05 09:06:36 2012] [EVENT] == FCGI START ==
[Wed Sep 05 09:06:36 2012] [QUERY] service=WFS&request=DescribeFeatureType&version=1.0.0
[Wed Sep 05 09:06:36 2012] [EVENT] == FCGI SHUTDOWN ==
[Wed Sep 05 09:06:36 2012] [EVENT] == TINYOWS SHUTDOWN ==
[Wed Sep 05 09:06:36 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 'd:///Program/tinyows/schema/gml/2.1.2/feature.xsd'.

[Wed Sep 05 09:06:36 2012] [SQL] BEGIN;
[Wed Sep 05 09:06:36 2012] [SQL] SELECT ST_GeomFromGML('<Point xmlns="http://www.opengis.net/gml" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:VCF="http://bdusrv18/" srsName="EPSG:3946"><coordinates xmlns="http://www.opengis.net/gml" cs="," ts=" ">1704171.7219,5172372.9801</coordinates></Point>',0)
[Wed Sep 05 09:06:36 2012] [SQL] SELECT ST_IsValid('01010000206A0F00003B70CEB8EB003A415AF5B93E25BB5341')
[Wed Sep 05 09:06:36 2012] [SQL] 
[Wed Sep 05 09:06:36 2012] [SQL] ROLLBACK;
=====

ocourtin avatar Sep 07 '12 17:09 ocourtin

Tks to Jérémie Lebouvier for the very detailled report !

ocourtin avatar Sep 07 '12 17:09 ocourtin

I don't plan to package for Win32 by myself, any help (or funding) on this is very welcome.

This link could (maybe) be helpfull: http://gis-lab.info/qa/tinyows-compile-vce-eng.html

ocourtin avatar Nov 14 '12 21:11 ocourtin