[TinyOWS-users] trouble with tinyows

[Andrea Peri]

Hi,
You are right. :)

I don't set the environment forward the tinyows.xml.
after this set.
The response of apache is changed.

<ows:ExceptionReport xsi:schemaLocation="http://www.opengis.net/ows
http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd" version="1.1.0"
language="en"><ows:Exception exceptionCode="InvalidParameterValue"
locator="service"><ows:ExceptionText>Service
Unknown</ows:ExceptionText></ows:Exception></ows:ExceptionReport>

At this point I try sending a real request:
like this

http://server:8081/cgi-bin/tinyows?service=wfs&request=GetCapabilities&version=1.0.0

And the new response if this:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable
to complete your request.
Please contact the server administrator, you at example.com and inform them of
the time the error occurred, and anything you might have done that may have
caused the error.
More information about this error may be available in the server error log.

I see also the log of tinyows but there is nothing useful :(

----------------
[Wed Aug 31 21:01:48 2011] [EVENT] == TINYOWS STARTUP ==
[Wed Aug 31 21:01:48 2011] [SQL] SELECT substr(postgis_full_version(), 10,
5)
[Wed Aug 31 21:01:48 2011] [EVENT] == Connection PostGIS ==
[Wed Aug 31 21:01:48 2011] [SQL] SELECT DISTINCT f_table_schema,
f_table_name FROM geometry_columns
[Wed Aug 31 21:01:48 2011] [SQL] SELECT DISTINCT f_table_schema,
f_table_name FROM geography_columns
[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'
[Wed Aug 31 21:01:48 2011] [SQL] SELECT * FROM spatial_ref_sys WHERE
srid=3003 AND proj4text like '%%units=m%%'
[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
[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';
[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'
[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')
[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'
[Wed Aug 31 21:01:48 2011] [SQL] SELECT
pg_get_serial_sequence('caricamento."am_com_region_am_com"', 'gid');
[Wed Aug 31 21:01:48 2011] [EVENT] == Filling Storage ==
[Wed Aug 31 21:01:48 2011] [QUERY]
service=wfs&request=GetCapabilities&version=1.0.0
------

The apache log report this:

[Wed Aug 31 21:01:48 2011] [error] [client 159.213.22.55] Premature end of
script headers: tinyows



2011/8/31 Olivier Courtin <olivier.courtin at gmail.com>

> On Wed, Aug 31, 2011 at 6:24 PM, Andrea Peri <aperi2007 at gmail.com> wrote:
>
> > For Apache could be an issue.
> > Infact Apache run by default with a nobody user.
> >
> > However I change this setting to run Apache with the same user that I use
> > for all the files , but nothing change.
>
> Ok the other point could be related to the config file path itself.
> By default it's /etc/tinyows.xml
>
> But if you change the path (in your home),
> you must have something like that in your apache config file:
>
>        ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/
>        <Directory "/usr/lib/cgi-bin">
>                [...]
>                SetEnv TINYOWS_CONFIG_FILE  /your_path_to/tinyows.xml
>        </Directory>
>
>
> > I'm using postgres 9.0.
> > Could this be an issue ?
>
> Nope.
>
> --
> Olivier
> _______________________________________________
> TinyOWS-users mailing list
> TinyOWS-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/tinyows-users
>



-- 
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/tinyows-users/attachments/20110831/4d289e75/attachment.htm