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 <[email protected]> > ** > 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
