[TinyOWS-users] RV: TinyOWS Problems Database

Gema Palomo gema.palomo at gpex.es
Tue Nov 15 02:08:43 EST 2011


 Hola Carlos, muchas gracias por tu ayuda. Pero he instalado tinyows en windows con la versión de Mapserver para windows (MS4W).
 He ejecutado el comando tinyows dentro de c:\ms4W\Apache\cgi-bin\tinyows.exe --check
y me devuelve el siguiente mensaje: Unable to open config file !
El archivo config.xml lo tengo colocado en la siguiente ruta C:\ms4w\apps\tinyows que es accesible y con permisos. No se si es que tiene que estar situado en otra ubicación o necesita algún permiso que no le tenga asignado, no lo se la verdad.
 Una cosa curiosa que me pasa es que cuando en el archivo de configuración, es decir en el config.xml no le pongo la contraseña correcta de la base de datos al ejecutar esto  <http://127.0.0.1:8081/cgi-bin/tinyows.exe?SERVICE=WFS&REQUEST=GetCapabilities&VERSION=1.1.0> http://127.0.0.1:8081/cgi-bin/tinyows.exe?SERVICE=WFS&REQUEST=GetCapabilities&VERSION=1.1.0
me devuelve :
 
<ows:ExceptionReport xsi:schemaLocation=" <http://www.opengis.net/ows> http://www.opengis.net/ows  <http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd> 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>Connection to database failed</ows:ExceptionText>
</ows:Exception>
</ows:ExceptionReport>
 
Mientras que si yo pongo la contraseña correcta de la base de datos en el archivo config.xml y vuelvo a ejecutar  <http://127.0.0.1:8081/cgi-bin/tinyows.exe?SERVICE=WFS&REQUEST=GetCapabilities&VERSION=1.1.0> http://127.0.0.1:8081/cgi-bin/tinyows.exe?SERVICE=WFS&REQUEST=GetCapabilities&VERSION=1.1.0 el resultado que obtengo es:
   
−
<WFS_Capabilities version="1.1.0" updateSequence="0" xsi:schemaLocation=" <http://www.opengis.net/wfs> http://www.opengis.net/wfs    <http://schemas.opengis.net/wfs/1.1.0/wfs.xsd> http://schemas.opengis.net/wfs/1.1.0/wfs.xsd">
−
<ows:ServiceIdentification>
<ows:Title>TinyOWS Server - WFS-T Frida Service</ows:Title>
<ows:ServiceType>WFS</ows:ServiceType>
<ows:ServiceTypeVersion>1.0.0,1.1.0</ows:ServiceTypeVersion>
</ows:ServiceIdentification>
−
<ows:ServiceProvider>
<ows:ProviderName>TinyOWS Server</ows:ProviderName>
<ows:ProviderSite xlink:href=" <http://www.tinyows.org/> http://www.tinyows.org/"/>
−
<ows:ServiceContact>
−
<ows:ContactInfo>
−
<ows:Address>
<ows:ElectronicMailAddress>tinyows-users at lists.maptools.org</ows:ElectronicMailAddress>
</ows:Address>
</ows:ContactInfo>
</ows:ServiceContact>
</ows:ServiceProvider>
−
<ows:OperationsMetadata>
−
<ows:Operation name="GetCapabilities">
−
<ows:DCP>
−
<ows:HTTP>
<ows:Get xlink:href=" <http://127.0.0.1:8081/cgi-bin/tinyows.exe?> http://127.0.0.1:8081/cgi-bin/tinyows.exe?"/>
</ows:HTTP>
</ows:DCP>
−
<ows:DCP>
−
<ows:HTTP>
<ows:Post xlink:href=" <http://127.0.0.1:8081/cgi-bin/tinyows.exe> http://127.0.0.1:8081/cgi-bin/tinyows.exe"/>
</ows:HTTP>
</ows:DCP>
−
<ows:Parameter name="AcceptVersions">
<ows:Value>1.1.0</ows:Value>
<ows:Value>1.0.0</ows:Value>
</ows:Parameter>
−
<ows:Parameter name="AcceptFormats">
<ows:Value>text/xml</ows:Value>
</ows:Parameter>
−
<ows:Parameter name="Sections">
<ows:Value>ServiceIdentification</ows:Value>
<ows:Value>ServiceProvider</ows:Value>
<ows:Value>OperationsMetadata</ows:Value>
<ows:Value>FeatureTypeList</ows:Value>
<ows:Value>ServesGMLObjectTypeList</ows:Value>
<ows:Value>SupportsGMLObjectTypeList</ows:Value>
</ows:Parameter>
</ows:Operation>
−
<ows:Operation name="DescribeFeatureType">
−
<ows:DCP>
−
<ows:HTTP>
<ows:Get xlink:href=" <http://127.0.0.1:8081/cgi-bin/tinyows.exe?> http://127.0.0.1:8081/cgi-bin/tinyows.exe?"/>
</ows:HTTP>
</ows:DCP>
−
<ows:DCP>
−
<ows:HTTP>
<ows:Post xlink:href=" <http://127.0.0.1:8081/cgi-bin/tinyows.exe> http://127.0.0.1:8081/cgi-bin/tinyows.exe"/>
</ows:HTTP>
</ows:DCP>
−
<ows:Parameter name="outputFormat">
<ows:Value>text/xml; subtype=gml/3.1.1</ows:Value>
<ows:Value>text/xml; subtype=gml/2.1.2</ows:Value>
</ows:Parameter>
</ows:Operation>
−
<ows:Operation name="GetFeature">
−
<ows:DCP>
−
<ows:HTTP>
<ows:Get xlink:href=" <http://127.0.0.1:8081/cgi-bin/tinyows.exe?> http://127.0.0.1:8081/cgi-bin/tinyows.exe?"/>
</ows:HTTP>
</ows:DCP>
−
<ows:DCP>
−
<ows:HTTP>
<ows:Post xlink:href=" <http://127.0.0.1:8081/cgi-bin/tinyows.exe> http://127.0.0.1:8081/cgi-bin/tinyows.exe"/>
</ows:HTTP>
</ows:DCP>
−
<ows:Parameter name="resultType">
<ows:Value>results</ows:Value>
<ows:Value>hits</ows:Value>
</ows:Parameter>
−
<ows:Parameter name="outputFormat">
<ows:Value>text/xml; subtype=gml/3.1.1</ows:Value>
<ows:Value>text/xml; subtype=gml/2.1.2</ows:Value>
<ows:Value>application/json</ows:Value>
</ows:Parameter>
</ows:Operation>
−
<ows:Operation name="Transaction">
−
<ows:DCP>
−
<ows:HTTP>
<ows:Get xlink:href=" <http://127.0.0.1:8081/cgi-bin/tinyows.exe?> http://127.0.0.1:8081/cgi-bin/tinyows.exe?"/>
</ows:HTTP>
</ows:DCP>
−
<ows:DCP>
−
<ows:HTTP>
<ows:Post xlink:href=" <http://127.0.0.1:8081/cgi-bin/tinyows.exe> http://127.0.0.1:8081/cgi-bin/tinyows.exe"/>
</ows:HTTP>
</ows:DCP>
−
<ows:Parameter name="inputFormat">
<ows:Value>text/xml; subtype=gml/3.1.1</ows:Value>
</ows:Parameter>
−
<ows:Parameter name="idgen">
<ows:Value>GenerateNew</ows:Value>
<ows:Value>UseExisting</ows:Value>
</ows:Parameter>
</ows:Operation>
</ows:OperationsMetadata>
−
<FeatureTypeList>
−
<Operations>
<Operation>Query</Operation>
<Operation>Insert</Operation>
<Operation>Update</Operation>
<Operation>Delete</Operation>
</Operations>
</FeatureTypeList>
−
<SupportsGMLObjectTypeList>
−
<GMLObjectType>
<Name>gml:AbstractGMLFeatureType</Name>
−
<OutputFormats>
<Format>text/xml; subtype=gml/2.1.2</Format>
<Format>text/xml; subtype=gml/3.1.1</Format>
</OutputFormats>
</GMLObjectType>
−
<GMLObjectType>
<Name>gml:PointType</Name>
−
<OutputFormats>
<Format>text/xml; subtype=gml/2.1.2</Format>
<Format>text/xml; subtype=gml/3.1.1</Format>
</OutputFormats>
</GMLObjectType>
−
<GMLObjectType>
<Name>gml:LineStringType</Name>
−
<OutputFormats>
<Format>text/xml; subtype=gml/2.1.2</Format>
<Format>text/xml; subtype=gml/3.1.1</Format>
</OutputFormats>
</GMLObjectType>
−
<GMLObjectType>
<Name>gml:PolygonType</Name>
−
<OutputFormats>
<Format>text/xml; subtype=gml/2.1.2</Format>
<Format>text/xml; subtype=gml/3.1.1</Format>
</OutputFormats>
</GMLObjectType>
−
<GMLObjectType>
<Name>gml:MultiPointType</Name>
−
<OutputFormats>
<Format>text/xml; subtype=gml/2.1.2</Format>
<Format>text/xml; subtype=gml/3.1.1</Format>
</OutputFormats>
</GMLObjectType>
−
<GMLObjectType>
<Name>gml:MultiLineStringType</Name>
−
<OutputFormats>
<Format>text/xml; subtype=gml/2.1.2</Format>
<Format>text/xml; subtype=gml/3.1.1</Format>
</OutputFormats>
</GMLObjectType>
−
<GMLObjectType>
<Name>gml:MultiPolygonType</Name>
−
<OutputFormats>
<Format>text/xml; subtype=gml/2.1.2</Format>
<Format>text/xml; subtype=gml/3.1.1</Format>
</OutputFormats>
</GMLObjectType>
</SupportsGMLObjectTypeList>
−
<ogc:Filter_Capabilities>
−
<ogc:Spatial_Capabilities>
−
<ogc:GeometryOperands>
<ogc:GeometryOperand>gml:Envelope</ogc:GeometryOperand>
<ogc:GeometryOperand>gml:Point</ogc:GeometryOperand>
<ogc:GeometryOperand>gml:LineString</ogc:GeometryOperand>
<ogc:GeometryOperand>gml:Polygon</ogc:GeometryOperand>
</ogc:GeometryOperands>
−
<ogc:SpatialOperators>
<ogc:SpatialOperator name="Disjoint"/>
<ogc:SpatialOperator name="Equals"/>
<ogc:SpatialOperator name="DWithin"/>
<ogc:SpatialOperator name="Beyond"/>
<ogc:SpatialOperator name="Intersects"/>
<ogc:SpatialOperator name="Touches"/>
<ogc:SpatialOperator name="Crosses"/>
<ogc:SpatialOperator name="Within"/>
<ogc:SpatialOperator name="Contains"/>
<ogc:SpatialOperator name="Overlaps"/>
<ogc:SpatialOperator name="BBOX"/>
</ogc:SpatialOperators>
</ogc:Spatial_Capabilities>
−
<ogc:Scalar_Capabilities>
<ogc:LogicalOperators/>
−
<ogc:ComparisonOperators>
<ogc:ComparisonOperator>EqualTo</ogc:ComparisonOperator>
<ogc:ComparisonOperator>NotEqualTo</ogc:ComparisonOperator>
<ogc:ComparisonOperator>LessThan</ogc:ComparisonOperator>
<ogc:ComparisonOperator>GreaterThan</ogc:ComparisonOperator>
<ogc:ComparisonOperator>LessThanEqualTo</ogc:ComparisonOperator>
<ogc:ComparisonOperator>GreaterThanEqualTo</ogc:ComparisonOperator>
<ogc:ComparisonOperator>Between</ogc:ComparisonOperator>
<ogc:ComparisonOperator>Like</ogc:ComparisonOperator>
<ogc:ComparisonOperator>NullCheck</ogc:ComparisonOperator>
</ogc:ComparisonOperators>
−
<ogc:ArithmeticOperators>
<ogc:SimpleArithmetic/>
−
<ogc:Functions>
−
<ogc:FunctionNames>
<ogc:FunctionName nArgs="1">abs</ogc:FunctionName>
<ogc:FunctionName nArgs="1">acos</ogc:FunctionName>
<ogc:FunctionName nArgs="1">asin</ogc:FunctionName>
<ogc:FunctionName nArgs="1">atan</ogc:FunctionName>
<ogc:FunctionName nArgs="1">avg</ogc:FunctionName>
<ogc:FunctionName nArgs="1">cbrt</ogc:FunctionName>
<ogc:FunctionName nArgs="1">ceil</ogc:FunctionName>
<ogc:FunctionName nArgs="1">ceiling</ogc:FunctionName>
<ogc:FunctionName nArgs="1">cos</ogc:FunctionName>
<ogc:FunctionName nArgs="1">cot</ogc:FunctionName>
<ogc:FunctionName nArgs="1">count</ogc:FunctionName>
<ogc:FunctionName nArgs="1">degrees</ogc:FunctionName>
<ogc:FunctionName nArgs="1">exp</ogc:FunctionName>
<ogc:FunctionName nArgs="1">floor</ogc:FunctionName>
<ogc:FunctionName nArgs="1">length</ogc:FunctionName>
<ogc:FunctionName nArgs="1">ln</ogc:FunctionName>
<ogc:FunctionName nArgs="1">log</ogc:FunctionName>
<ogc:FunctionName nArgs="1">min</ogc:FunctionName>
<ogc:FunctionName nArgs="1">max</ogc:FunctionName>
<ogc:FunctionName nArgs="1">radians</ogc:FunctionName>
<ogc:FunctionName nArgs="1">round</ogc:FunctionName>
<ogc:FunctionName nArgs="1">sin</ogc:FunctionName>
<ogc:FunctionName nArgs="1">sqrt</ogc:FunctionName>
<ogc:FunctionName nArgs="1">tan</ogc:FunctionName>
<ogc:FunctionName nArgs="1">trunc</ogc:FunctionName>
</ogc:FunctionNames>
</ogc:Functions>
</ogc:ArithmeticOperators>
</ogc:Scalar_Capabilities>
−
<ogc:Id_Capabilities>
<ogc:EID/>
<ogc:FID/>
</ogc:Id_Capabilities>
</ogc:Filter_Capabilities>
</WFS_Capabilities>
 
Por eso estoy un poco despistada, mi fichero config.xml es el siguiente:
 
<tinyows online_resource=" <http://127.0.0.1:8081/cgi-bin/tinyows.exe> http://127.0.0.1:8081/cgi-bin/tinyows.exe"
         schema_dir="C:/ms4w/apps/tinyows/schema/" log="C:/ms4w/apps/tinyows/tinyows.log">
 
  <pg host="127.0.0.1" user="postgres" password="****" dbname="tinyows" port="5432"/>
 
  <metadata name="TinyOWS Server"
            title="TinyOWS Server - WFS-T Frida Service" />
 
  <contact name="TinyOWS Server"
           site=" <http://www.tinyows.org/> http://www.tinyows.org/"
           email=" <mailto:tinyows-users at lists.maptools.org> tinyows-users at lists.maptools.org" />
<!--         server=" <http://www.tinyows.org/> http://www.tinyows.org/"-->
  <layer retrievable="1"
         writable="1"
         prefix="frida"
   server=" <http://127.0.0.1:8081/> http://127.0.0.1:8081/"
         name="frida"
         title="Frida Parks" />
 
</tinyows>

Muchas gracias por tu ayuda, 
 
 
Saludos Gema.
 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/tinyows-users/attachments/20111115/e11f9950/attachment-0001.htm 


More information about the TinyOWS-users mailing list