[mapguide-users] Can't create layer using MySQL feature source
Stefan Dalakov
s.dalakov at mapware.net
Mon Apr 6 14:03:06 EDT 2009
Here is the FeatureSource
I find interesting thing here.
When I open this FeatureSource in MG Studio I see
my server name appearing under "Service"
In Maestro the same server name appears under "Database", while "server"
and "port" fields remain empty.
Do you have MG Studio ?
How did your data get in MySQL format ?
If you don't manage, mail me directly, not thru the list and I will send
you the pwd.
Stefan Dalakov
<?xml version="1.0" encoding="utf-8"?>
<FeatureSource xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xsi:noNamespaceSchemaLocation="FeatureSource-1.0.0.xsd">
<Provider>OSGeo.MySQL</Provider>
<Parameter>
<Name>Username</Name>
<Value>%MG_USERNAME%</Value>
</Parameter>
<Parameter>
<Name>Password</Name>
<Value>%MG_PASSWORD%</Value>
</Parameter>
<Parameter>
<Name>Service</Name>
<Value>mysql2.winhostingcenter.com</Value>
</Parameter>
<Parameter>
<Name>DataStore</Name>
<Value>technop_mg</Value>
</Parameter>
<SupplementalSpatialContextInfo>
<Name>Default</Name>
<CoordinateSystem>LOCAL_CS["Non-Earth (Meter)",LOCAL_DATUM["Local
Datum",0],UNIT["Meter",
1],AXIS["X",EAST],AXIS["Y",NORTH]]</CoordinateSystem>
</SupplementalSpatialContextInfo>
<ConfigurationDocument>config.xml</ConfigurationDocument>
</FeatureSource>
Manel Gimeno wrote:
> Thanks Stefan.
>
> I think the main problem is in the connection to MySQL. Even Mapguide
> Maestro says that there is no error reported I've tried to use the
> FeatureSource to connect using MapAgent/Test connection and the test
> doesn't work (it return false).
>
> Could you send me your FeatureSource XML to try to find where the
> problem is?
>
> Thanks in advance
> Manel Gimeno
>
> ----- Original Message -----
>
> *From:* Stefan Dalakov <mailto:s.dalakov at mapware.net>
> *To:* MapGuide Users Mail List
> <mailto:mapguide-users at lists.osgeo.org>
> *Sent:* Monday, April 06, 2009 4:48 PM
> *Subject:* Re: [mapguide-users] Can't create layer using MySQL
> feature source
>
> Hi Manel,
> Here is a layerDefinition that works for me.
> Have you specified Coordinate-System-Overrides ?
>
> Stefan Dalakov
>
> <?xml version="1.0" encoding="UTF-8" ?>
> - <#> <LayerDefinition
> xmlns:xsi="*http://www.w3.org/2001/XMLSchema-instance*"
> xsi:noNamespaceSchemaLocation="*LayerDefinition-1.1.0.xsd*"
> version="*1.1.0*">
> - <#> <VectorLayerDefinition>
> <ResourceId>Library://mysql_ds.FeatureSource</ResourceId>
> <FeatureName>Fdotechnop_mg:links</FeatureName>
> <FeatureNameType>FeatureClass</FeatureNameType>
> - <#> <PropertyMapping>
> <Name>LAYER</Name>
> <Value>LAYER</Value>
> </PropertyMapping>
> - <#> <PropertyMapping>
> <Name>LENGTH</Name>
> <Value>LENGTH</Value>
> </PropertyMapping>
> <Geometry>ogc_geom</Geometry>
> - <#> <VectorScaleRange>
> - <#> <PointTypeStyle>
> <DisplayAsText>false</DisplayAsText>
> <AllowOverpost>false</AllowOverpost>
> - <#> <PointRule>
> <LegendLabel />
> </PointRule>
> </PointTypeStyle>
> - <#> <LineTypeStyle>
> - <#> <LineRule>
> <LegendLabel>'Main Pipe'</LegendLabel>
> <Filter>"LAYER" = 'Main Pipe'</Filter>
> - <#> <LineSymbolization2D>
> <LineStyle>Solid</LineStyle>
> <Thickness>2</Thickness>
> <Color>FF000000</Color>
> <Unit>Points</Unit>
> <SizeContext>DeviceUnits</SizeContext>
> </LineSymbolization2D>
> </LineRule>
> - <#> <LineRule>
> <LegendLabel>'Pipeline'</LegendLabel>
> <Filter>"LAYER" = 'Pipeline'</Filter>
> - <#> <LineSymbolization2D>
> <LineStyle>Solid</LineStyle>
> <Thickness>2</Thickness>
> <Color>FF000080</Color>
> <Unit>Points</Unit>
> <SizeContext>DeviceUnits</SizeContext>
> </LineSymbolization2D>
> </LineRule>
> - <#> <LineRule>
> <LegendLabel />
> - <#> <LineSymbolization2D>
> <LineStyle>Solid</LineStyle>
> <Thickness>0.0</Thickness>
> <Color>ff000000</Color>
> <Unit>Centimeters</Unit>
> <SizeContext>DeviceUnits</SizeContext>
> </LineSymbolization2D>
> </LineRule>
> </LineTypeStyle>
> - <#> <AreaTypeStyle>
> - <#> <AreaRule>
> <LegendLabel />
> - <#> <AreaSymbolization2D>
> - <#> <Fill>
> <FillPattern>Solid</FillPattern>
> <ForegroundColor>ffffffff</ForegroundColor>
> <BackgroundColor>ff000000</BackgroundColor>
> </Fill>
> - <#> <Stroke>
> <LineStyle>Solid</LineStyle>
> <Thickness>0.0</Thickness>
> <Color>ff000000</Color>
> <Unit>Centimeters</Unit>
> <SizeContext>DeviceUnits</SizeContext>
> </Stroke>
> </AreaSymbolization2D>
> </AreaRule>
> </AreaTypeStyle>
> </VectorScaleRange>
> </VectorLayerDefinition>
> </LayerDefinition>
>
>
> Manel Gimeno wrote:
>> Hi all,
>>
>> I've created a MySQL FeatureSource in Mapguide 2.0 using Mapguide
>> Maestro 1.0.9.15910. When I click in the test connection button
>> no error is reported, so it seems the connection to MySQL works fine.
>>
>> When I try to create a FeatureLayer using the MySQL FeatureSource
>> previously defined the following error happens after selecting
>> the FeatureSource as resource:
>>
>> "Failed to read schema from data source.
>> The operation gave the error message: Error en el servidor
>> remoto: (559) MgConnectionFailedException.:
>> Cannot establish connection.
>> Exception occurred in method
>> MgServerDescribeSchema::ExecuteDescribeSchema() at line 173 in
>> file
>> d:\buildforgeprojects\mapguide_open_source_v2.0\build_23.8\mgdev\server\src\services\feature\ServerDescribeSchema.cpp"
>>
>> Can anyone help me to solve this problem? (Maybe if you have an
>> example of XML LayerDefinition using a MySQL FeatureSource...)
>>
>> Thanks in advance
>> Manel Gimeno
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>
> ------------------------------------------------------------------------
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
More information about the mapguide-users
mailing list