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

[Riccardo Gaeta]

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/29103515/attachment.html