Great!<div>The query send from TinyOws was (read it from tinyows.log file):</div><div>SELECT substr(postgis_full_version(), 10, 5);</div><div><br></div><div>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...</div>
<div>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à!</div><div><br></div><div>Thanks a lot.</div><div>Riccardo<br>
<br><div class="gmail_quote">2012/5/2 Rahkonen Jukka <span dir="ltr"><<a href="mailto:Jukka.Rahkonen@mmmtike.fi" target="_blank">Jukka.Rahkonen@mmmtike.fi</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<u></u>
<div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span>Hi,</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span>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.</span></font></div>
<div dir="ltr" align="left"><font face="Arial"><span><font color="#0000ff">And I suppose <font size="3" face="Times New Roman">it would be better to remove server="</font></font><a href="http://127.0.0.1/" target="_blank"><font size="3" face="Times New Roman">http://127.0.0.1/</font></a><font color="#0000ff" size="3" face="Times New Roman">" because
it is not used any more. </font></span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span>-Jukka Rahkonen-</span></font></div>
<br>
<blockquote style="BORDER-LEFT:#0000ff 2px solid;PADDING-LEFT:5px;MARGIN-LEFT:5px;MARGIN-RIGHT:0px" dir="ltr">
<div dir="ltr" lang="fi" align="left">
<hr>
<font face="Tahoma"><b>Lähettäjä:</b> <a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>]
<b>Puolesta </b>Riccardo Gaeta<br>
<b>Lähetetty:</b> 2. toukokuuta 2012 14:28<br>
<b>Vastaanottaja:</b> <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
<b>Aihe:</b> [mapserver-users] [TinyOWS] No PostGIS available in database<br>
</font><br>
</div><div><div class="h5">
<div></div>
Hi all,
<div>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:</div>
<div>SELECT PostGIS_Lib_Version();</div>
<div>SELECT PostGIS_LibXML_Version();</div>
<div>SELECT PostGIS_GEOS_Version();</div>
<div>SELECT PostGIS_PROJ_Version();</div>
<div><br>
</div>
<div>And all seems to answer good.</div>
<div>But when I check the tinyows I get this error:</div>
<div><br>
</div>
<div>
<div>Content-Type: application/xml</div>
<div><br>
</div>
<div><?xml version='1.0' encoding='UTF-8'?></div>
<div><ows:ExceptionReport</div>
<div> xmlns='<a href="http://www.opengis.net/ows" target="_blank">http://www.opengis.net/ows</a>'</div>
<div> xmlns:ows='<a href="http://www.opengis.net/ows" target="_blank">http://www.opengis.net/ows</a>'</div>
<div> xmlns:xsi='<a href="http://www.w3.org/2001/XMLSchema-instance" target="_blank">http://www.w3.org/2001/XMLSchema-instance</a>'</div>
<div> xsi:schemaLocation='<a href="http://www.opengis.net/ows" target="_blank">http://www.opengis.net/ows</a>
<a href="http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd" target="_blank">http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd</a>'</div>
<div> version='1.1.0' language='en'></div>
<div> <ows:Exception exceptionCode='ConnectionFailed' locator='init_OWS'></div>
<div> <ows:ExceptionText>No PostGIS available in database</ows:ExceptionText></div>
<div> </ows:Exception></div>
<div></ows:ExceptionReport></div>
</div>
<div><br>
</div>
<div>I've found an old post about this, date <span style="color:rgb(136,136,136);font-size:medium;font-family:monospace">28 Mar 2012 </span>by <span style="font-size:medium">Neelima
Emmani</span>, but with no rposecution.</div>
<div><br>
</div>
<div>Anyone could help me please?</div>
<div><br>
</div>
<div>Thanks to all,</div>
<div>Riccardo</div>
<div><br>
</div>
<div>P.S.: My tinyows.xml look like this:</div>
<div><br>
</div>
<div>
<div><tinyows online_resource="<a href="http://127.0.0.1/cgi-bin/tinyows" target="_blank">http://127.0.0.1/cgi-bin/tinyows</a>" schema_dir="/usr/local/share/tinyows/schema/" log="/tmp/tinyows.log" log_level="1" ></div>
<div><br>
</div>
<div> <pg host="localhost" user="user" password="pwd" dbname="dbname" port="5432"/></div>
<div><br>
</div>
<div> <metadata name="TinyOWS Server" title="TinyOWS Server - Demo Service" /></div>
<div><br>
</div>
<div> <layer retrievable="1"</div>
<div> queryable="1"</div>
<div> writable="0"</div>
<div> ns_prefix="tows"</div>
<div> ns_uri="<a href="http://127.0.0.1/" target="_blank">http://127.0.0.1/</a>"</div>
<div> server="<a href="http://127.0.0.1/" target="_blank">http://127.0.0.1/</a>"</div>
<div> name="mytable"</div>
<div> schema="myschema"</div>
<div> srid="900913,3785"</div>
<div> title="mylayer_tiny"</div>
<div> abstract="test"</div>
<div> /></div>
<div><br>
</div>
<div></tinyows></div>
</div>
<div><br>
</div>
</div></div></blockquote>
</div>
</blockquote></div><br></div>