Re: [mapguide-users] MGOS 3.1.2 and MySQL 8.0 - unable to display spatial objects

Nice job, it is possible to see the geometry (points) now -- Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html___ mapguide-users mailing list

Re: [mapguide-users] MGOS 3.1.2 and MySQL 8.0 - unable to display spatial objects

Could you give this patched MySQL provider a go? https://download.osgeo.org/mapguide/patches/MySQLProvider_MGOS312/MySQLProvider_983.zip This fixes spatial filter generation on MySQL 8.0 by forcing long/lat ordering regardless of srid of the geometry column https://trac.osgeo.org/fdo/ticket/983

Re: [mapguide-users] MGOS 3.1.2 and MySQL 8.0 - unable to display spatial objects

On my mapguide server (windows server 2019 datacenter) I had to use the dll from the mysql-5.7.29-winx64 client to get it work with MapGuide 3.1.2 -- Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html ___ mapguide-users

Re: [mapguide-users] MGOS 3.1.2 and MySQL 8.0 - unable to display spatial objects

And which correct libmysql.dll is that? That's what I need to know right now in order to investigate this further. - Jackie -- Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html ___ mapguide-users mailing list

Re: [mapguide-users] MGOS 3.1.2 and MySQL 8.0 - unable to display spatial objects

Yes, I had the same issue with MySQL (installed on linux). MapGuide 3.1.2 (on windows) could not connect until I found the correct the libmysql.dll... -- Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html ___ mapguide-users

Re: [mapguide-users] MGOS 3.1.2 and MySQL 8.0 - unable to display spatial objects

*No chances at all* -- Sent from:

Re: [mapguide-users] MGOS 3.1.2 and MySQL 8.0 - unable to display spatial objects

no chances at all -- Sent from:

Re: [mapguide-users] MGOS 3.1.2 and MySQL 8.0 - unable to display spatial objects

You need to try with a spatial filter specified like I suggested. I'm not disputing the FDO provider's ability to read geometry data out of MySQL (as your screenshots have proven), I'm disputing the FDO provider's ability to properly translate a FDO spatial filter to a SQL WHERE clause in MySQL

Re: [mapguide-users] MGOS 3.1.2 and MySQL 8.0 - unable to display spatial objects

I am sorry Jackie but the rendering problem seems to be with MGOS because I have no such problem with FDO Toolbox 1.4.0I have no problem to display 70 points from MySQL 8.0 (point epsg 3857) in the map of FDO Toolbox. There is no reversal of x and y (area 40 km by 25 km)

Re: [mapguide-users] MGOS 3.1.2 and MySQL 8.0 - unable to display spatial objects

I am using EPSG 3857 (cartographic projection Pseudo Mercator for Google and others). The problem must be the reversal between lat and long? MySQL is really not build for spatial has I see and that is why QGIS and ARCGIS do not support it out of the box. (what a pain). I will try to reverse

Re: [mapguide-users] MGOS 3.1.2 and MySQL 8.0 - unable to display spatial objects

Just to add to this, is your MySQL 8 table using srid 4326? If so then they've made a breaking change in MySQL 8 in how geographic coordinates are meant to be interpreted (as lat/long instead of long/lat). Ref:

Re: [mapguide-users] MGOS 3.1.2 and MySQL 8.0 - unable to display spatial objects

For the FDO Toolbox test, try putting in a spatial filter. This is generally of the form GeometryProperty INTERSECTS GeomFromText('The polygon WKT of your view box') If this fails, this is probably what MapGuide is experiencing also when trying to render the features. - Jackie -- Sent from: