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

[Riccardo Gaeta]

Great!
The query send from TinyOws was (read it from tinyows.log file):
SELECT substr(postgis_full_version(), 10, 5);

And in fact for some odd reason I didn't have this function loaded on my
DB. I don't know why, perhaps because I've done an incomplete dump...
Anyway, I've copied the function "postgis_full_version()" from another DB
with Postgis well installed and created it in my current DB, et voilà!

Thanks a lot.
Riccardo

2012/5/2 Rahkonen Jukka <Jukka.Rahkonen at mmmtike.fi>

> **
> 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/20120503/13445c0d/attachment.htm>