Did you see that someone on the FDO-users list (Beppe?) came up with a solution in a thread something like "Mapguide OS and FDO"? It turned out to be a matter of using the correct postgres library version...
Jason On 2009-10-09, Remco Houtkamp <[email protected]> wrote: > Hi All, > > > > Below you can read the last thing I posted on my problem with mapguide > maestro. Unfortunately people stopped responding when the problem was > not solved after a suggestion or two. Clearly the downside of Open > Source. Don't get me wron, not blaming anybody, maybe it is my lack of > knowledge on this subject. Anyways, I had fun trying the software and it > is great! Too bad I cannot manage to connect to postgis, because a > shapefile of the Netherlands with open street map data is just too big. > So after investing way over a 100 hours into this I'm giving up and I > will try mapserver. > > > > Thanks to the people that thought along and I will keep following the > project, still think it rocks! I suppose not, but if somebody does know > a solution... A summary of the problem can be found below. > > > > Cheers, Remco > > > > > > Van: [email protected] > [mailto:[email protected]] Namens Remco Houtkamp > Verzonden: woensdag 7 oktober 2009 13:01 > Aan: MapGuide Users Mail List > Onderwerp: RE: [mapguide-users] trouble connecting mapguide maestro > postgis > > I finally managed to build the following setup: > > Winxp > Mapguide 2.1 > Mapguide Maestro > Postgresql 8.4 > Postgis 1.4 > > > > I've filled the database (postgresql) with data from open street map > with osm2pgsql. I can connect from Udig to postgis and from Quantum Gis > (1.3 !!! 1.0 included with osgeo4w is not working). So my postgis setups > works. > > > > In mapguide maestro I go through the following steps: > Create a new resource>data connection > OSGEO FDO Provider for Postgis > Database: osm (is visible in Udig) > server: I tried localhost http://localhost/ <http://localhost/> > 127.0.0.1 http:// 127.0.0.1/ <http://127.0.0.1/> > Port: 5432 > Tried all three credentials but think it must be Specified Credentials > with user postgres and my secret password ;) > Press test connection and then the following error appears: > De externe server heeft een fout geretourneerd: (559) MgFdoException.: > An exception occurred in FDO component. Unable to load the FDO Provider: > Kan opgegeven module niet vinden. (some of this is Dutch... for cannot > find the module) > > > > Somebody told me to test the fdo with depends.exe. This way we found out > that libpq.dll is missing. After installing " a version of libpq.dll" I > was able to run the the test connection. It returned no errors and I > save the connection. After this I need a layer to connect to the data. > Unfortunately I ge the following error: > > De externe server heeft een fout geretourneerd: (559) MgFdoException.: > (dutch for the external server returned an error) > An exception occurred in FDO component. > Unable to load the FDO Provider: (null) > > > > The errorlog tells me: > > <2009-09-18T10:40:23> 3508 > 127.0.0.1 Administrator > Error: An exception occurred in FDO component. > Unable to load the FDO Provider: (null) > StackTrace: > - MgFeatureServiceHandler.ProcessOperation line 83 file > c:\osgeo\mapguide_21\mgdev\server\src\services\feature\FeatureServiceHan > dler.cpp > - MgOpTestFeatureSourceConnection.Execute line 100 file > c:\osgeo\mapguide_21\mgdev\server\src\services\feature\OpTestFeatureSour > ceConnection.cpp > - MgFdoConnectionManager.Open line 262 file > c:\osgeo\mapguide_21\mgdev\server\src\common\manager\FdoConnectionManage > r.cpp > > > > It looks like the problem lies within the libpq.dll file. Anybody a > thought on how to solve this problem... > > > > Thanks in advance, Remco (The Netherlands) > > > > > > > > Took a brake for two weeks and retried today. But I still can 't connect > a layer to a postgis dataconnection. Tried different versions etc. One > thing caught my eye today. The errorlog tells me: > > <2009-10-07T12:52:31> 2824 127.0.0.1 > Administrator > > Error: Cannot establish connection. > > StackTrace: > > - MgFeatureServiceHandler.ProcessOperation line 83 file > c:\osgeo\mapguide_21\mgdev\server\src\services\feature\FeatureServiceHan > dler.cpp > > - MgOpGetSpatialContexts.Execute line 105 file > c:\osgeo\mapguide_21\mgdev\server\src\services\feature\OpGetSpatialConte > xts.cpp > > - MgServerFeatureService.GetSpatialContexts line 703 file > c:\osgeo\mapguide_21\mgdev\server\src\services\feature\ServerFeatureServ > ice.cpp > > - MgServerGetSpatialContexts.GetSpatialContexts line 100 file > c:\osgeo\mapguide_21\mgdev\server\src\services\feature\ServerGetSpatialC > ontexts.cpp > > - MgServerGetSpatialContexts.GetSpatialContexts() line 92 file > c:\osgeo\mapguide_21\mgdev\server\src\services\feature\ServerGetSpatialC > ontexts.cpp > > > > Mapguide Maestro tells me: > > > > The thing is... I do not even have an directory called d:\build...etc. > and I use mapguide 2.1 > > Can this be the problem > > _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
