[mapguide-users] FDO - MySQL issues/questions

[Kerndata.com]

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