<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="GENERATOR" content="MSHTML 8.00.6001.19190">
</head>
<body>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="749241213-02052012">Hi,</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="749241213-02052012"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="749241213-02052012">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 size="2" face="Arial"><span class="749241213-02052012"><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/"><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" size="2" face="Arial"><span class="749241213-02052012"></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" size="2" face="Arial"><span class="749241213-02052012">-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" class="OutlookMessageHeader" align="left">
<hr tabindex="-1">
<font size="2" face="Tahoma"><b>Lähettäjä:</b> mapserver-users-bounces@lists.osgeo.org [mailto:mapserver-users-bounces@lists.osgeo.org]
<b>Puolesta </b>Riccardo Gaeta<br>
<b>Lähetetty:</b> 2. toukokuuta 2012 14:28<br>
<b>Vastaanottaja:</b> mapserver-users@lists.osgeo.org<br>
<b>Aihe:</b> [mapserver-users] [TinyOWS] No PostGIS available in database<br>
</font><br>
</div>
<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">http://www.opengis.net/ows</a>'</div>
<div> xmlns:ows='<a href="http://www.opengis.net/ows">http://www.opengis.net/ows</a>'</div>
<div> xmlns:xsi='<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>'</div>
<div> xsi:schemaLocation='<a href="http://www.opengis.net/ows">http://www.opengis.net/ows</a>
<a href="http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd">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="BACKGROUND-COLOR: rgb(255,255,255); FONT-FAMILY: monospace; COLOR: rgb(136,136,136); FONT-SIZE: medium">28 Mar 2012 </span>by <span style="BACKGROUND-COLOR: rgb(255,255,255); 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">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/">http://127.0.0.1/</a>"</div>
<div> server="<a href="http://127.0.0.1/">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>
</blockquote>
</body>
</html>