[mapguide-users] FDO - MySQL issues/questions
Kerndata.com
support at kerndata.com
Wed Oct 18 17:51:55 EDT 2006
Unexpected Error in contacting site URLBrent,
Here's a Dump of the SCHEMATA table
--
-- Table: SCHEMATA
--
CREATE TABLE `SCHEMATA`
(
`CATALOG_NAME` varchar (512),
`SCHEMA_NAME` varchar (64) NOT NULL,
`DEFAULT_CHARACTER_SET_NAME` varchar (64) NOT NULL,
`DEFAULT_COLLATION_NAME` varchar (64) NOT NULL,
`SQL_PATH` varchar (512)
) CHARACTER SET utf8 COLLATE utf8_general_ci;
-- GO
BEGIN;
-- GO
--
-- Dumping Triggers
--
SET FOREIGN_KEY_CHECKS=1;
-- GO
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
----- Original Message -----
From: Brent Robinson
To: users at mapguide.osgeo.org
Sent: Wednesday, October 18, 2006 12:46 PM
Subject: RE: [mapguide-users] FDO - MySQL issues/questions
Hi Eric,
Could you do a describe on the information_schema.schemata table and send me the results?
Unfortunately, I don't yet have MapGuide on my machine but I tried installing 5.0.26 and accessing it with an FDO test program. I just tried a few simple things ( listing datatores, opening a connection, describing schemas ) but it worked ok.
The main difference is that mine was a fresh install while yours would have been an upgrade from 4. I'm wondering if the information_schema ends up a bit different in either case.
Brent.
-----Original Message-----
From: Kerndata.com [mailto:support at kerndata.com]
Sent: Tuesday, October 17, 2006 7:59 PM
To: users at mapguide.osgeo.org
Subject: Re: [mapguide-users] FDO - MySQL issues/questions
Brent,
I upgraded to 5.0.26-max and now I receive:
"An exception occured in FDO component.
RDBMS:"
and then:
"No data stores found."
Is there some other item I'm not understanding here?
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
----- Original Message -----
From: Brent Robinson
To: users at mapguide.osgeo.org
Sent: Tuesday, October 17, 2006 3:01 PM
Subject: FW: [mapguide-users] FDO - MySQL issues/questions
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/Providers/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/20061018/2657b6e3/attachment.html
More information about the Mapguide-users
mailing list