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ä: [email protected] [mailto:[email protected]] Puolesta Riccardo Gaeta Lähetetty: 2. toukokuuta 2012 14:28 Vastaanottaja: [email protected] 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>
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
