[mapguide-users] trouble connecting mapguide maestro postgis

Sun Oct 18 07:09:13 EDT 2009

Tried swapping all kind off files. Without the wanted result though. I
assume I've to accept that this does not work (for whatever reason). Is
this something that keeps developing in future releases? Just have to
wait maybe. Does anybody know if the compatibility within linux is
better than with windows xp.

-----Oorspronkelijk bericht-----
Van: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] Namens Jason Birch
Verzonden: zaterdag 10 oktober 2009 3:01
Aan: MapGuide Users Mail List
Onderwerp: Re: [mapguide-users] trouble connecting mapguide maestro
postgis

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
>
>
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users