Hi Every body,
I'm trying to configure tinyows On Ubuntu Quantal from several days but there is a problem with frida's data inside postgis.
It doesn't display through openlayers. Here is more informations so that you might help me.
When I make the check on my terminal from tinyows directory, here is what i get:
<pre><b>root@webxxxxxxxxx:~# /usr/lib/cgi-bin/tinyows --check
TinyOWS version: 1.1.0
FCGI support: <b>No</b>
Config File Path: /etc/tinyows.xml (TinyOWS XML)
PostGIS Version: 1.5.3
PostGIS dsn: host=localhost user=nico password=xxxxxxxx dbname=tinyows port=5432
Output Encoding: UTF-8
Database Encoding: UTF8
Schema dir: /usr/local/share/tinyows/schema/
Log file: /var/log/tinyows2.log
Display bbox: Yes
Estimated extent: No
Check schema: Yes
Check valid geoms: Yes
Available layers:
- public.frida (31467) -> frida:frida [R]</b></pre>
First question is FCGI is compulsory for tinyows to work ?
secondly, why the terminal can show me the layer frida and openlayers cannot do so in the web client ?
FYI, I manage to display frida's data stored in postgis with qgis desktop
Here is the result of the log while accessing the web client to look at OpenLayers :
<pre>[Wed Apr 17 11:33:05 2013] [EVENT] == TINYOWS STARTUP ==
[Wed Apr 17 11:33:05 2013] [SQL] SELECT substr(postgis_full_version(), 10, 5)
[Wed Apr 17 11:33:05 2013] [EVENT] == Connection PostGIS ==
[Wed Apr 17 11:33:05 2013] [SQL] SELECT DISTINCT f_table_schema, f_table_name FROM geometry_columns
[Wed Apr 17 11:33:05 2013] [SQL] SELECT DISTINCT f_table_schema, f_table_name FROM geography_columns
[Wed Apr 17 11:33:05 2013] [SQL] SELECT srid, f_geometry_column FROM geometry_columns WHERE f_table_schema='public' AND f_table_name='frida';
[Wed Apr 17 11:33:05 2013] [SQL] SELECT * FROM spatial_ref_sys WHERE srid=31467 AND proj4text like '%%units=m%%'
[Wed Apr 17 11:33:05 2013] [SQL] SELECT c.column_name FROM information_schema.constraint_column_usage c, pg_namespace n WHERE n.nspname = 'public' AND c.table_name = 'frida' AND c.constraint_name = (SELECT c.conname FROM pg_class r, pg_constraint c, pg_namespace n WHERE r.oid = c.conrelid AND relname = 'frida' AND r.relnamespace = n.oid AND n.nspname = 'public' AND c.contype = 'p')
[Wed Apr 17 11:33:05 2013] [SQL] SELECT a.attnum FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n WHERE a.attrelid = c.oid AND a.atttypid = t.oid AND n.nspname='public' AND c.relname='frida' AND a.attname='gid'
[Wed Apr 17 11:33:05 2013] [SQL] SELECT pg_get_serial_sequence('public."frida"', 'gid');
[Wed Apr 17 11:33:05 2013] [SQL] SELECT column_default FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'frida' AND column_name = 'gid' AND table_catalog = current_database();
[Wed Apr 17 11:33:05 2013] [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 = 'frida' AND c.relnamespace = n.oid AND a.attrelid = c.oid AND a.atttypid = t.oid AND a.attnum > 0;
[Wed Apr 17 11:33:05 2013] [SQL] SELECT type from geometry_columns where f_table_schema='public' and f_table_name='frida' and f_geometry_column='geom';
[Wed Apr 17 11:33:05 2013] [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 = 'frida' AND c.relnamespace = n.oid AND a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid AND a.attnotnull = 't'
[Wed Apr 17 11:33:05 2013] [EVENT] == Filling Storage ==
[Wed Apr 17 11:33:05 2013] [QUERY] (null)
[Wed Apr 17 11:33:05 2013] [EVENT] == TINYOWS SHUTDOWN ==
</pre>
Last but not least, here is the XML file that we have according to all the tutorial that I found on the websites:
<pre><tinyows online_resource="http://127.0.0.1/cgi-bin/tinyows"
schema_dir="/usr/local/share/tinyows/schema/" log="/var/log/tinyows2.log" log_level="15">
<pg host="localhost"
user="nico"
password="xxxxxxx"
dbname="tinyows"
port="5432" />
<metadata name="TinyOWS Server"
title="TinyOWS Server - WFS-T Frida Service" />
<contact name="TinyOWS Server"
site="http://www.tinyows.org/"
email="tinyows-users@lists.maptools.org" />
<layer retrievable="1"
queryable="1"
writable="0"
ns_prefix="frida"
server="localhost"
ns_uri="http://localhost:8080/"
name="frida"
title="Frida Parks"
schema="public"
srid="31467"
/>
</tinyows></pre>
I think that the openlayer doesn't have a problem because I can display the OSM layer, and the controls are activated, except the "save" button. Just so you can see my result, you can look at the screen shot below:
<img src="http://osgeo-org.1560.x6.nabble.com/file/n5047842/screenshot.png" border="0"/>
Hope you guys can help, its been very hard to work by myself.
Best regards to all and thanks in advance.
Nicolas
<br/><hr align="left" width="300" />
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Tinyows-shutdown-Frida-doesn-t-display-tp5047842.html">Tinyows shutdown Frida doesn't display</a><br/>
Sent from the <a href="http://osgeo-org.1560.x6.nabble.com/Mapserver-User-f4226646.html">Mapserver - User mailing list archive</a> at Nabble.com.<br/>