[mapguide-users] Can't create layer using MySQL feature source
Kenneth Skovhede, GEOGRAF A/S
ks at geograf.dk
Tue Apr 14 02:45:41 EDT 2009
Yes, that is a bug Maestro.
I will fix it, thanks for finding it.
Regards, Kenneth Skovhede, GEOGRAF A/S
Stefan Dalakov skrev:
> Manel,
> I have used MapGuide Studio 2008 to create this feature source.
> Perhaps Kenneth can answer if this is a bug, or there is something
> extra to be done in setting the feature source.
> I have the same version of Maestro as yours.
>
> Stefan Dalakov
>
> Manel Gimeno wrote:
>> 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 <mailto:s.dalakov at mapware.net>
>> *To:* MapGuide Users Mail List
>> <mailto:mapguide-users at lists.osgeo.org>
>> *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
>> <mailto:mapguide-users at lists.osgeo.org>
>> >> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>> >>
>> >
>> >
>> ------------------------------------------------------------------------
>> > _______________________________________________
>> > mapguide-users mailing list
>> > mapguide-users at lists.osgeo.org
>> <mailto:mapguide-users at lists.osgeo.org>
>> > http://lists.osgeo.org/mailman/listinfo/mapguide-users
>> >
>> >
>> ------------------------------------------------------------------------
>> >
>> > _______________________________________________
>> > mapguide-users mailing list
>> > mapguide-users at lists.osgeo.org
>> <mailto:mapguide-users at lists.osgeo.org>
>> > http://lists.osgeo.org/mailman/listinfo/mapguide-users
>> >
>>
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> <mailto: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/20090414/8acfb676/attachment.html
More information about the mapguide-users
mailing list