search

MapServer / tinyows

Source code of the TinyOWS project. Please submit pull requests to the 'main' branch.
https://mapserver.org/tinyows/
MIT License
59 stars 29 forks source link

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

Open ocourtin opened 12 years ago

ocourtin commented 12 years ago

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 commented 12 years ago

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

ocourtin commented 12 years ago

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