[mapguide-users] trouble connecting mapguide maestro postgis

[Jason Birch]

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 <r.houtkamp at burohoutkamp.nl> 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: mapguide-users-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at lists.osgeo.org] 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
>
>