[mapguide-users] trouble connecting mapguide maestro postgis
Remco Houtkamp
r.houtkamp at burohoutkamp.nl
Mon Sep 21 06:36:51 EDT 2009
Been away for the weekend, so I couldn't continue. This morning I made a newe setup.
Winxp
Mapguide 2.1
Mapguide Maestro
Postgresql 8.4
Postgis 1.4
Same trouble as before with missing libpq.ddl, so I copied this file from the postgresql tot the mapguide FDO folde. Depend.exe showed me that there were some other files missing in the FDO folder so I copied them as wel. After this maestro returen no errors after adding a new connection>postgis>test connection. So I'm as far as I got before.
When I add a layer and try to connect it, I get an error. The error log shows me:
<2009-09-21T05:20:54> 2200 127.0.0.1 Administrator
Error: Cannot establish connection.
StackTrace:
- MgFeatureServiceHandler.ProcessOperation line 83 file c:\osgeo\mapguide_21\mgdev\server\src\services\feature\FeatureServiceHandler.cpp
- MgOpDescribeSchemaAsXml.Execute line 110 file c:\osgeo\mapguide_21\mgdev\server\src\services\feature\OpDescribeSchemaAsXml.cpp
- MgServerFeatureService.DescribeSchemaAsXml line 333 file c:\osgeo\mapguide_21\mgdev\server\src\services\feature\ServerFeatureService.cpp
- MgServerDescribeSchema.DescribeSchemaAsXml line 628 file c:\osgeo\mapguide_21\mgdev\server\src\services\feature\ServerDescribeSchema.cpp
- MgServerDescribeSchema.DescribeSchema line 564 file c:\osgeo\mapguide_21\mgdev\server\src\services\feature\ServerDescribeSchema.cpp
- MgServerDescribeSchema.DescribeFdoSchema line 196 file c:\osgeo\mapguide_21\mgdev\server\src\services\feature\ServerDescribeSchema.cpp
Looking forward to reponds.
-----Oorspronkelijk bericht-----
Van: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] Namens Zac Spitzer
Verzonden: vrijdag 18 september 2009 11:11
Aan: MapGuide Users Mail List
Onderwerp: Re: [mapguide-users] trouble connecting mapguide maestro postgis
maybe adding the bin dir for your postgres client to your path,
rather than adding just the dll to fdo?
z
On Fri, Sep 18, 2009 at 7:01 PM, Remco Houtkamp
<r.houtkamp at burohoutkamp.nl> wrote:
> Message is the same as yesterday when things did work. The lbpq.ddl is still marked when running depend.exe. ieframe.ddl is also marked and has a hourglass at the beginning of the line.
> The meesage is as follows:
> Error: At least one module has an unresolved import due to a missing export function in an implicitly dependent module.
> Warning: At least one module has an unresolved import due to a missing export function in a delay-load dependent module.
>
>
>
> Met vriendelijk groet,
>
>
> Remco Houtkamp
>
> BURO HOUTKAMP
> |T: 06 14 390 205 |E: r.houtkamp at burohoutkamp.nl |P: Kweldergras 21, 1441 WP, Purmerend |
>
> -----Oorspronkelijk bericht-----
> Van: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] Namens Zac Spitzer
> Verzonden: vrijdag 18 september 2009 10:56
> Aan: MapGuide Users Mail List
> Onderwerp: Re: [mapguide-users] trouble connecting mapguide maestro postgis
>
> try depends on libpq.dll
>
> On Fri, Sep 18, 2009 at 6:46 PM, Remco Houtkamp
> <r.houtkamp at burohoutkamp.nl> wrote:
>> You guys respond faster than I can check it! Great list!
>>
>>
>>
>> But... for some reason Test connection does not work anymore only difference
>> is a restart of my laptop.
>>
>>
>>
>> Logfile 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\FeatureServiceHandler.cpp
>>
>> - MgOpTestFeatureSourceConnection.Execute line 100 file
>> c:\osgeo\mapguide_21\mgdev\server\src\services\feature\OpTestFeatureSourceConnection.cpp
>>
>> - MgFdoConnectionManager.Open line 262 file
>> c:\osgeo\mapguide_21\mgdev\server\src\common\manager\FdoConnectionManager.cpp
>>
>>
>>
>> Maestro gives the following error:
>>
>> De externe server heeft een fout geretourneerd: (559) MgFdoException.:
>>
>> An exception occurred in FDO component.
>>
>> Unable to load the FDO Provider: (null)
>>
>>
>>
>> Since installing/registering libpq.dll worked yesterday, I've redone that
>> step... but no cigar... I'm trying to learn GIS for some months now, but the
>> assumingly last obstacles are very hard to pass....
>>
>>
>>
>>
>>
>> Met vriendelijk groet,
>>
>>
>> Remco Houtkamp
>>
>> BURO HOUTKAMP
>> |T: 06 14 390 205 |E: r.houtkamp at burohoutkamp.nl |P: Kweldergras 21, 1441
>> WP, Purmerend |
>>
>>
>>
>> Van: mapguide-users-bounces at lists.osgeo.org
>> [mailto:mapguide-users-bounces at lists.osgeo.org] Namens Kenneth Skovhede,
>> GEOGRAF A/S
>> Verzonden: donderdag 17 september 2009 14:22
>> Aan: MapGuide Users Mail List
>> Onderwerp: Re: [mapguide-users] trouble connecting mapguide maestro postgis
>>
>>
>>
>> ieshims.dll and ieframe.dll can be ignored.
>> There should be no harm in copying the files, but it's not required.
>>
>> Now that you get that error, it is likely that the error.log contains extra
>> information:
>> 2.0.2: C:\Program Files\MapGuideOpenSource\Server\Logs\Error.log
>> 2.1: C:\Program Files\OSGeo\MapGuide\Server\Logs\Error.log
>>
>> The MgConnectionFailedException usually means that the MapGuide service has
>> stopped.
>>
>> Regards,. Kenneth Skovhede, GEOGRAF A/S
>>
>> Remco Houtkamp skrev:
>>
>> Been strugling along. Depend.exe told libpq.dll could not be opened. I
>> googled for it, followed instructions and installed it. Now when I press
>> test connections, it will not give me errors...seems like progress!
>>
>>
>>
>> I saved the data connection and tried to connect a layer. Maestro tells me:
>>
>> Failed to read schema from data source.
>>
>> The operation gave the error message: De externe server heeft een fout
>> geretourneerd (Dutch for the external server returned an error): (559)
>> MgConnectionFailedException.: Cannot establish connection.
>>
>>
>>
>> Depend.exe also says it cannot open ieshims.dll so I just copied it (is that
>> ok) to the FDO folder.
>>
>> Now it only says Warning: At least one module has an unresolved import due
>> to a missing export function in a delay-load dependent module.
>>
>> It also shows a hourglass and some kind of red grid on an icon for the file
>> ieframe.dll
>>
>>
>>
>>
>>
>>
>>
>> -----Oorspronkelijk bericht-----
>>
>> Van: mapguide-users-bounces at lists.osgeo.org
>> [mailto:mapguide-users-bounces at lists.osgeo.org] Namens Zac Spitzer
>>
>> Verzonden: woensdag 16 september 2009 16:08
>>
>> Aan: MapGuide Users Mail List
>>
>> Onderwerp: Re: [mapguide-users] trouble connecting mapguide maestro postgis
>>
>>
>>
>> try running depends.exe (google it) on the postgis fdo provider dll
>>
>>
>>
>> sounds like the required postgres dll's are being found
>>
>>
>>
>> z
>>
>>
>>
>> On Thu, Sep 17, 2009 at 12:04 AM, Remco Houtkamp
>>
>> <r.houtkamp at burohoutkamp.nl> wrote:
>>
>>
>>
>> Hi all, this is my first post, still a newbie.
>>
>>
>>
>> I think I managed to import data from openstreetmap.org to postgis. But now
>>
>> I cannot connect. I guess things are working since I can connect from a
>>
>> program called Udig.
>>
>>
>>
>> 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/ 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...)
>>
>>
>>
>> My setup contains postgresql 8.4 and postgis 1.4.
>>
>>
>>
>> Can anybody tell me where I'm going wrong... struggling for days and days...
>> and
>>
>> days...
>>
>>
>>
>> _______________________________________________
>>
>> mapguide-users mailing list
>>
>> mapguide-users at lists.osgeo.org
>>
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>
>
>
> --
> Zac Spitzer -
> http://zacster.blogspot.com
> +61 405 847 168
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
--
Zac Spitzer -
http://zacster.blogspot.com
+61 405 847 168
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
More information about the mapguide-users
mailing list