[mapguide-users] Can't create layer using MySQL feature source
Manel Gimeno
manelgimeno at gmail.com
Fri Apr 10 12:08:36 EDT 2009
Thanks Stefan.
I copy and paste directly your XML (changing name, password,...) in Mapguide Maestro XML editor and it works fine.
But as you said the server name appears under "Database" while "server" and "port" fields remain empty in Mapguide Maestro.
Using directly Mapguide Maestro the XML generated is:
<?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>root</Value>
</Parameter>
<Parameter>
<Name>Password</Name>
<Value>password</Value>
</Parameter>
<Parameter>
<Name>Service</Name>
<Value>database at localhost:3306</Value>
</Parameter>
<Parameter>
<Name>DataStore</Name>
<Value />
</Parameter>
</FeatureSource>
It is quite different as your and it doesn't work. Maybe there is a bug in Maestro or I need to upgrade my version, I'm using Mapguide Maestro version 1.0.9.15919
Regards
Manel Gimeno
----- Original Message -----
From: Stefan Dalakov
To: MapGuide Users Mail List
Sent: Monday, April 06, 2009 8:03 PM
Subject: Re: [mapguide-users] Can't create layer using MySQL feature source
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
>
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20090410/59c8fd9f/attachment.html
More information about the mapguide-users
mailing list