Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Open
ocourtin opened this issue Sep 7, 2012 · 2 comments
Open

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

ocourtin opened this issue Sep 7, 2012 · 2 comments
Milestone
1.1.0

Comments

@ocourtin
Copy link

ocourtin commented Sep 7, 2012

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
Copy link
Author

ocourtin commented Sep 7, 2012

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

@ocourtin
Copy link
Author

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
1.1.0
Development

No branches or pull requests
1 participant
@ocourtin