FW: [mapguide-users] FDO - MySQL issues/questions

[Brent Robinson]

MySQL 4.1.20 would be older than the minimum version supported by the
MySQL provider. I'm not exactly sure what the minimum is (does anyone
else know off-hand?). However, upgrading to 5.0.15 or later would get
rid of the error. 

 

The MySQL provider relies on some information_schema tables (which were
introduced in version 5) to get information on tables, columns, etc.

 

-----Original Message-----
From: Jason Birch [mailto:Jason.Birch at nanaimo.ca] 
Sent: Tuesday, October 17, 2006 3:35 PM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] FDO - MySQL issues/questions

 

I believe that the MySQL provider requires that a schema be defined,
though I haven't tried it myself.

 

Currently, the only way that I know of for doing this is via Autodesk's
Map 3D.  The scripts for creating the schema tables are in FDO
repository I think, so you might be able to reverse engineer the process
and create your own.

 

https://fdordbms.osgeo.org/source/browse/fdordbms/branches/3.2.x/Provide
rs/GenericRdbms/com/

 

Jason

 

  _____  

From: Kerndata.com [@kerndata.com] 
Sent: Tuesday, October 17, 2006 10:18
To: users at mapguide.osgeo.org
Subject: [mapguide-users] FDO - MySQL issues/questions

I'm attempting to configure a MySQL connection in MapGuide Studio 2007
using the MySQL FDO I downloaded and installed from osgeo.org.

 

It appears that the "Test Connection" functions properly (I think) but
the little box that shows whatever message it's supposed to show doesn't
show a message - just a little yield sign with no message in the box (on
user permissions errors I receive an actual message). 

 

At any rate, when I ultimately enter the correct connection information
and attempt to browse for a Data store - I receive the following
message:

 

"An exception occurred in FDO component.

RDBMS: Table 'information_schema.schemata' doesn't exist"

 

And then - 

 

"No data stores found"

 

Any insight into this error - or how to actually connect to my MySQL db
would be greatly appreciated.

 

DB = MySQL 4.1.20

 

Please advise,

 

Eric Brown
Kerndata.com
5500 Ming Avenue
Suite 160
Bakersfield, CA 93309
888.871.7205
888.603.6279 fax
support at kerndata.com
http://www.kerndata.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide_users/attachments/20061017/879f170d/attachment.html