[mapserver-users] [TinyOWS] No PostGIS available in database

[Rahkonen Jukka]

Hi,

Increase the log_level to 8 and see from the log file which SQL queries TinyOWS is sending. You can test them with psql for comparison.
And I suppose it would be better to remove server="http://127.0.0.1/" because it is not used any more.

-Jukka Rahkonen-

________________________________
Lähettäjä: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] Puolesta Riccardo Gaeta
Lähetetty: 2. toukokuuta 2012 14:28
Vastaanottaja: mapserver-users at lists.osgeo.org
Aihe: [mapserver-users] [TinyOWS] No PostGIS available in database

Hi all,
I'm using Tinyows 1.0.0 on redhat machine, postgresql 8.4 and postgis 1.5.3. I've checked all these on the database:
SELECT PostGIS_Lib_Version();
SELECT PostGIS_LibXML_Version();
SELECT PostGIS_GEOS_Version();
SELECT PostGIS_PROJ_Version();

And all seems to answer good.
But when I check the tinyows I get this error:

Content-Type: application/xml

<?xml version='1.0' encoding='UTF-8'?>
<ows:ExceptionReport
 xmlns='http://www.opengis.net/ows'
 xmlns:ows='http://www.opengis.net/ows'
 xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
 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='ConnectionFailed' locator='init_OWS'>
  <ows:ExceptionText>No PostGIS available in database</ows:ExceptionText>
 </ows:Exception>
</ows:ExceptionReport>

I've found an old post about this, date 28 Mar 2012 by Neelima Emmani, but with no rposecution.

Anyone could help me please?

Thanks to all,
Riccardo

P.S.: My tinyows.xml look like this:

<tinyows online_resource="http://127.0.0.1/cgi-bin/tinyows"  schema_dir="/usr/local/share/tinyows/schema/" log="/tmp/tinyows.log" log_level="1" >

  <pg host="localhost" user="user" password="pwd" dbname="dbname" port="5432"/>

  <metadata name="TinyOWS Server" title="TinyOWS Server - Demo Service" />

  <layer retrievable="1"
         queryable="1"
         writable="0"
         ns_prefix="tows"
         ns_uri="http://127.0.0.1/"
         server="http://127.0.0.1/"
         name="mytable"
         schema="myschema"
         srid="900913,3785"
         title="mylayer_tiny"
         abstract="test"
  />

</tinyows>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120502/721adb0f/attachment-0001.html