[mapguide-users] FDO - MySQL issues/questions

[Brent Robinson]

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 <mailto:brent.robinson at autodesk.com>  

	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/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/20061018/cc69a94d/attachment.html