Hi,<br>You are right. :)<br><br>I don't set the environment forward the tinyows.xml.<br>after this set.<br>The response of apache is changed.<br><br><ows:ExceptionReport xsi:schemaLocation="<a href="http://www.opengis.net/ows">http://www.opengis.net/ows</a> <a href="http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd">http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd</a>" version="1.1.0" language="en"><ows:Exception exceptionCode="InvalidParameterValue" locator="service"><ows:ExceptionText>Service Unknown</ows:ExceptionText></ows:Exception></ows:ExceptionReport><br>
<br>At this point I try sending a real request:<br>like this<br><br><a href="http://server:8081/cgi-bin/tinyows?service=wfs&request=GetCapabilities&version=1.0.0">http://server:8081/cgi-bin/tinyows?service=wfs&request=GetCapabilities&version=1.0.0</a><br>
<br>And the new response if this:<br><br>Internal Server Error<br>The server encountered an internal error or misconfiguration and was unable to complete your request.<br>Please contact the server administrator, <a href="mailto:you@example.com">you@example.com</a> and inform them of the time the error occurred, and anything you might have done that may have caused the error.<br>
More information about this error may be available in the server error log.<br><br>I see also the log of tinyows but there is nothing useful :(<br><br>----------------<br>[Wed Aug 31 21:01:48 2011] [EVENT] == TINYOWS STARTUP ==<br>
[Wed Aug 31 21:01:48 2011] [SQL] SELECT substr(postgis_full_version(), 10, 5)<br>[Wed Aug 31 21:01:48 2011] [EVENT] == Connection PostGIS ==<br>[Wed Aug 31 21:01:48 2011] [SQL] SELECT DISTINCT f_table_schema, f_table_name FROM geometry_columns<br>
[Wed Aug 31 21:01:48 2011] [SQL] SELECT DISTINCT f_table_schema, f_table_name FROM geography_columns<br>[Wed Aug 31 21:01:48 2011] [SQL] SELECT srid, f_geometry_column FROM geometry_columns WHERE f_table_schema='caricamento' AND f_table_name='am_com_region_am_com'<br>
[Wed Aug 31 21:01:48 2011] [SQL] SELECT * FROM spatial_ref_sys WHERE srid=3003 AND proj4text like '%%units=m%%'<br>[Wed Aug 31 21:01:48 2011] [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 = 'caricamento' AND c.relname = 'am_com_region_am_com' AND c.relnamespace = n.oid AND a.attnum > 0 AND a.attrelid = c.oid AND a.atttypid = t.oid<br>
[Wed Aug 31 21:01:48 2011] [SQL] SELECT type from geometry_columns where f_table_schema='caricamento' and f_table_name='am_com_region_am_com' and f_geometry_column='geom';<br>[Wed Aug 31 21:01:48 2011] [SQL] SELECT a.attname AS field FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n WHERE n.nspname = 'caricamento' AND c.relname = 'am_com_region_am_com' 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'<br>
[Wed Aug 31 21:01:48 2011] [SQL] SELECT c.column_name FROM information_schema.constraint_column_usage c, pg_namespace n WHERE n.nspname = 'caricamento' AND c.table_name = 'am_com_region_am_com' AND c.constraint_name = (SELECT c.conname FROM pg_class r, pg_constraint c, pg_namespace n WHERE r.oid = c.conrelid AND relname = 'am_com_region_am_com' AND r.relnamespace = n.oid AND n.nspname = 'caricamento' AND c.contype = 'p')<br>
[Wed Aug 31 21:01:48 2011] [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='caricamento' AND c.relname='am_com_region_am_com' AND a.attname='gid'<br>
[Wed Aug 31 21:01:48 2011] [SQL] SELECT pg_get_serial_sequence('caricamento."am_com_region_am_com"', 'gid');<br>[Wed Aug 31 21:01:48 2011] [EVENT] == Filling Storage ==<br>[Wed Aug 31 21:01:48 2011] [QUERY] service=wfs&request=GetCapabilities&version=1.0.0<br>
------<br><br>The apache log report this:<br><br>[Wed Aug 31 21:01:48 2011] [error] [client 159.213.22.55] Premature end of script headers: tinyows<br><br><br><br><div class="gmail_quote">2011/8/31 Olivier Courtin <span dir="ltr"><<a href="mailto:olivier.courtin@gmail.com">olivier.courtin@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">On Wed, Aug 31, 2011 at 6:24 PM, Andrea Peri <<a href="mailto:aperi2007@gmail.com">aperi2007@gmail.com</a>> wrote:<br>
<br>
> For Apache could be an issue.<br>
> Infact Apache run by default with a nobody user.<br>
><br>
> However I change this setting to run Apache with the same user that I use<br>
> for all the files , but nothing change.<br>
<br>
</div>Ok the other point could be related to the config file path itself.<br>
By default it's /etc/tinyows.xml<br>
<br>
But if you change the path (in your home),<br>
you must have something like that in your apache config file:<br>
<br>
ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/<br>
<Directory "/usr/lib/cgi-bin"><br>
[...]<br>
SetEnv TINYOWS_CONFIG_FILE /your_path_to/tinyows.xml<br>
</Directory><br>
<div class="im"><br>
<br>
> I'm using postgres 9.0.<br>
> Could this be an issue ?<br>
<br>
</div>Nope.<br>
<font color="#888888"><br>
--<br>
</font><div><div></div><div class="h5">Olivier<br>
_______________________________________________<br>
TinyOWS-users mailing list<br>
<a href="mailto:TinyOWS-users@lists.maptools.org">TinyOWS-users@lists.maptools.org</a><br>
<a href="http://lists.maptools.org/mailman/listinfo/tinyows-users" target="_blank">http://lists.maptools.org/mailman/listinfo/tinyows-users</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>-----------------<br>Andrea Peri<br>. . . . . . . . . <br>qwerty àèìòù<br>-----------------<br><br>