[mapguide-users] No Feature Providers in Studio Preview

Greg Boone greg.boone at autodesk.com
Wed Aug 2 15:01:58 EDT 2006


The quick answer is that the MySQL provider code base is located in
https://fdordbms.osgeo.org/. MySQL is packaged within a GenericRdbms
framework that allows RDBMS providers to share code. The two RDBMS
providers that have been open sourced are MySQL and ODBC. Other
proprietary providers developed using this architecture include the
Autodesk Oracle provider and Autodesk SQLServer provider.

The version of the FDO provider in the Subversion is 3.2. 3.2 can only
be run with MapGuide code contained in their Subversion. No official
MapGuide tar file posting exists at this time that uses 3.2. 

Run the build_linux.sh script located under:
https://fdordbms.osgeo.org/source/browse/fdordbms/trunk/Providers/Generi
cRdbms/ in order to build the MySQL provider. 

NOTE: running the above script will also build the ODBC provider. 

Greg

-----Original Message-----
From: Marcus Spurkel [mailto:mspurkel at pacbell.net] 
Sent: Wednesday, August 02, 2006 2:44 PM
To: users at mapguide.osgeo.org
Subject: Re: [mapguide-users] No Feature Providers in Studio Preview

Makes sense, but now the big question is: where/what subversion tree??  
I have looked at  fdo.osgeo.org  backwards and forwards and can't find 
anything concrete relating to a MySQL provider.  The main project's SVN 
trunk contains /www/docs and that's about it.  All documents -- no 
actual provider code.  Many of the docs mention the MySQL provider, but 
nowhere does it tell me where to actually go to get it.  FDO's 
subprojects consist of:
fdoarcsde, fdocore, fdogdal, fdoogr, fdordbms, fdosdf, fdoshp, fdowfs, 
fdowms.  I checked out fdordbms but no luck there either.

Sorry to be burning so much email on this but I'm starting to feel like 
an idiot for not being able to find it...

-Marcus

P.S.  Yes, originally I downloaded the tarball and that was it.  No svn.

Traian Stanev wrote:

>>>What am I missing here?
>>>      
>>>
>
>You are missing the code for the MySQL FDO provider. :)
>I would guess that the tar you used to compile FDO only contained the
>SDF and SHP providers. That's why I asked about the version of FDO you
>are using and how you got it -- did you download a tar.gz file and does
>it contain 3.1 or 3.0 in the file name? Neither of the posted tars
>contain providers other than SHP and SDF. You will need to get source
>from subversion for the other providers.
>
>
> 
>
>-----Original Message-----
>From: Marcus Spurkel [mailto:mspurkel at pacbell.net] 
>Sent: Wednesday, August 02, 2006 1:22 PM
>To: users at mapguide.osgeo.org
>Subject: Re: [mapguide-users] No Feature Providers in Studio Preview
>
>The rpm is for the MySQL database (as well ad the devel & client
>modules).  I definitely do not have a libFdoMySQL.so file (or anything
>close to it) in my fdo directory.  I checked the /providers directory
in
>the fdo source and there is nothing there that looks like it could be
>related either.  Originally, I simply ran build_linux.sh from fdo
source
>and everything got built automatically.
>
>Hmmm, I did just come across this in the online version of the
>OpenSourceBuild_README file which, for some reason, was not in the
>tarball:
>*****
>NOTE: Choosing the RPM install of the MySQL components is *strongly*
>recommended. However, if a non-RPM installation of MySQL is chosen,
>following the installation, set the following FDO environment variable:

>FDOMYSQL=[MySQL developer components path]
>*****
>I never set an FDO environment variable, though judging by the text I
>shouldn't have to since I did use RPMs.  Still...
>
>I also did a grep scan of all Makefile and configure files and found no
>references to MySQL whatsoever.  What am I missing here?
>
>-Marcus
>
>
>Traian Stanev wrote:
>
>  
>
>>An rpm of the provider or the MySQL database? Do you have libFdoMySQL 
>>in the directory where FDO is?
>>There is an install script for FDO providers that also adds to the xml

>>file automatically, but since I don't know what exactly you did, it
was
>>    
>>
>
>  
>
>>easiest to go for the manual way.
>>
>>
>>
>>-----Original Message-----
>>From: Marcus Spurkel [mailto:mspurkel at pacbell.net]
>>Sent: Tuesday, August 01, 2006 10:00 PM
>>To: users at mapguide.osgeo.org
>>Subject: Re: [mapguide-users] No Feature Providers in Studio Preview
>>
>>Well it's Fedora, so I installed an rpm.  Version is 5.0.18.  I'll 
>>check
>>
>>the dependencies, but is it really necessary to get so low-level that
I
>>    
>>
>
>  
>
>>have to edit the providers.xml file by hand?  Not that I mind (I'm a 
>>programmer after all) but I would have thought that MapGuide would
have
>>    
>>
>
>  
>
>>some sort of higher level and/or GUI-based interface for setting up 
>>data
>>
>>connections.  Or at the very least, shouldn't the fdo make process
have
>>    
>>
>
>  
>
>>detected my MySQL installation and taken care of it?
>>
>>Traian Stanev wrote:
>>
>> 
>>
>>    
>>
>>>I think those two are special cased to not show up in that list, but
>>>   
>>>
>>>      
>>>
>>I'm not sure. I'd start by adding MySQL to providers.xml on the
server.
>>Then make sure the MySQL provider .so is not missing any dependencies 
>>(use ldd or something) and restart the server process. Did you compile

>>the MySQL provider yourself, and if yes, what source code are you 
>>working with (what date?)
>> 
>>
>>    
>>
>>>	-----Original Message----- 
>>>	From: Marcus Spurkel [mailto:mspurkel at pacbell.net] 
>>>	Sent: Tue 8/1/2006 9:25 PM 
>>>	To: users at mapguide.osgeo.org 
>>>	Cc: 
>>>	Subject: Re: [mapguide-users] No Feature Providers in Studio
>>>   
>>>
>>>      
>>>
>>Preview
>> 
>>
>>    
>>
>>>	
>>>	
>>>
>>>	Yeah, that works.  And you're right: my providers.xml file only
>>>   
>>>
>>>      
>>>
>>mentions
>> 
>>
>>    
>>
>>>	SDF and SHP.  So:
>>>	
>>>	1. Why don't those two show up on the Data Connection popup
>>>   
>>>
>>>      
>>>
>>winodow as
>> 
>>
>>    
>>
>>>	feature providers?
>>>	2. How can I get MySQL (which I do have on the server) to show?
>>>   
>>>
>>>      
>>>
>>Do need
>> 
>>
>>    
>>
>>>	to go back and recompile fdo with a certain switch?
>>>	
>>>	Remember I'm on FC5, not Windows.  I found some references to
>>>   
>>>
>>>      
>>>
>>API
>> 
>>
>>    
>>
>>>	discussions but I'm not sure that's what I need.  I just want to
>>>   
>>>
>>>      
>>>
>>start
>> 
>>
>>    
>>
>>>	by setting up a connection path.
>>>	
>>>	-Marcus
>>>	
>>>	Traian Stanev wrote:
>>>	
>>>	>You probably have only the SHP and SDF providers on your Liunx
>>>   
>>>
>>>      
>>>
>>box, so you see nothing on that list in Studio. Simply drag an SHP or 
>>SDF file into Studio (into the tree view on the left) and see what 
>>happens.
>> 
>>
>>    
>>
>>>	>
>>>	>Traian
>>>	>
>>>	>
>>>	>       -----Original Message-----
>>>	>       From: Marcus Spurkel [mailto:mspurkel at pacbell.net]
>>>	>       Sent: Tue 8/1/2006 7:17 PM
>>>	>       To: users at mapguide.osgeo.org
>>>	>       Cc:
>>>	>       Subject: [mapguide-users] No Feature Providers in Studio
>>>   
>>>
>>>      
>>>
>>Preview
>> 
>>
>>    
>>
>>>	>      
>>>	>      
>>>	>
>>>	>       I just tried clicking on New|Data Connection... in
>>>   
>>>
>>>      
>>>
>>Studio 2007 Preview
>> 
>>
>>    
>>
>>>	>       and got an empty popup, i.e. no feature providers
>>>   
>>>
>>>      
>>>
>>listed.  I do have a
>> 
>>
>>    
>>
>>>	>       providers.xml file in my FDO install directory (and the
>>>   
>>>
>>>      
>>>
>>server admin
>> 
>>
>>    
>>
>>>	>       does point to the correct place) but for some reason
>>>   
>>>
>>>      
>>>
>>it's not seeing
>> 
>>
>>    
>>
>>>	>       it.  Does anyone know what's wrong?  I'm running on a
>>>   
>>>
>>>      
>>>
>>Linux box (FC5).
>> 
>>
>>    
>>
>>>	>      
>>>	>       -Marcus
>>>	>      
>>>	>
>>>   
>>>
>>>      
>>>
>>---------------------------------------------------------------------
>> 
>>
>>    
>>
>>>	>       To unsubscribe, e-mail:
>>>   
>>>
>>>      
>>>
>>users-unsubscribe at mapguide.osgeo.org
>> 
>>
>>    
>>
>>>	>       For additional commands, e-mail:
>>>   
>>>
>>>      
>>>
>>users-help at mapguide.osgeo.org
>> 
>>
>>    
>>
>>>	>      
>>>	>      
>>>	>
>>>	> 
>>>	>
>>>
>>>---------------------------------------------------------------------
-
>>>-
>>>   
>>>
>>>      
>>>
>>-
>> 
>>
>>    
>>
>>>	>
>>>
>>>---------------------------------------------------------------------
>>>	>To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
>>>	>For additional commands, e-mail: users-help at mapguide.osgeo.org
>>>	>
>>>
>>>---------------------------------------------------------------------
-
>>>-
>>>   
>>>
>>>      
>>>
>>-
>> 
>>
>>    
>>
>>>	>
>>>	>No virus found in this incoming message.
>>>	>Checked by AVG Free Edition.
>>>	>Version: 7.1.394 / Virus Database: 268.10.5/404 - Release Date:
>>>   
>>>
>>>      
>>>
>>7/31/2006
>> 
>>
>>    
>>
>>>	> 
>>>	>
>>>	
>>>
>>>   
>>>
>>>      
>>>
>>---------------------------------------------------------------------
>> 
>>
>>    
>>
>>>	To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
>>>	For additional commands, e-mail: users-help at mapguide.osgeo.org
>>>	
>>>	
>>>
>>>
>>>
>>>---------------------------------------------------------------------
-
>>>-
>>>   
>>>
>>>      
>>>
>>-
>> 
>>
>>    
>>
>>>---------------------------------------------------------------------
>>>To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
>>>For additional commands, e-mail: users-help at mapguide.osgeo.org
>>>
>>>---------------------------------------------------------------------
-
>>>-
>>>   
>>>
>>>      
>>>
>>-
>> 
>>
>>    
>>
>>>No virus found in this incoming message.
>>>Checked by AVG Free Edition.
>>>Version: 7.1.394 / Virus Database: 268.10.5/404 - Release Date:
>>>   
>>>
>>>      
>>>
>>7/31/2006
>> 
>>
>>    
>>
>>>   
>>>
>>>      
>>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
>>For additional commands, e-mail: users-help at mapguide.osgeo.org
>>
>>
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
>>For additional commands, e-mail: users-help at mapguide.osgeo.org
>>
>>
>> 
>>
>>    
>>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
>For additional commands, e-mail: users-help at mapguide.osgeo.org
>
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
>For additional commands, e-mail: users-help at mapguide.osgeo.org
>
>
>  
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
For additional commands, e-mail: users-help at mapguide.osgeo.org






More information about the Mapguide-users mailing list