[mapguide-users] trouble connecting mapguide maestro postgis

Kenneth Skovhede, GEOGRAF A/S ks at geograf.dk
Thu Sep 24 02:10:23 EDT 2009


The OGR provider also supports PostGIS.
If you have given up on the PostGIS provider, you can try the OGR provider.

I belive Traian maintains a few updated OGR builds here:
http://13-9.com/

Regards, Kenneth Skovhede, GEOGRAF A/S



Pedro Venâncio skrev:
>
> Hello,
>
> I've got a similar problem.
>
> Starting at the beginning, I installed PostgreSQL 8.4 and PostGIS 1.4, 
> MapGuide OS 2.1 beta1 and Maestro r4082 on Windows XP Pro with SP2 
> (IIS 5.1).
>
> By adding a datasource with the FDO Provider for PostGIS, the test 
> connection fails. After, I added the bin folder of PostgreSQL (which 
> contains the libpq.dll) to the environment variable - system path. 
> From here, the test connection passed: "Provider reported no errors".
>
> However, when I try to save the dataconnection (FeatureSource), 
> appears this error message I send attached. Answering yes, when I try 
> to create a layer, it shows the error in the second image.
>
> I've made the attempt with PostgreSQL 8.3.3-1 and PostGIS 1.3.3-1, but 
> with the same results.
>
>
> Thank you!
>
> Regards,
> Pedro
>
>
>
>
>
>
> --- On *Tue, 9/22/09, Remco Houtkamp /<r.houtkamp at burohoutkamp.nl>/* 
> wrote:
>
>
>
>     I wrote an email for the fdo mailinglist with contains the
>     information on this problem in an easy to read way (according to
>     me). Maybe a summary is useful for this list as well, so here it is:
>
>      
>
>     Hi list,
>
>      
>
>     Somebody from the mapguide lijst told me about this list so I just
>     subscribed. I 'm new to this game and an newbie, but learned a lot
>     the last couple of months.
>
>      
>
>     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/ 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\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
>
>      
>
>     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)
>
>      
>
>      
>
>      
>
>      
>
>     *Van:* mapguide-users-bounces at lists.osgeo.org
>     [mailto:mapguide-users-bounces at lists.osgeo.org] *Namens *Remco
>     Houtkamp
>     *Verzonden:* dinsdag 22 september 2009 8:26
>     *Aan:* MapGuide Users Mail List
>     *Onderwerp:* RE: [mapguide-users] trouble connecting mapguide
>     maestro postgis
>
>      
>
>     Jason, did not know of such list. I subscribed and off course will
>     share when something comes out. I 'm pretty sure it is a Mapguide
>     FDO problem. After I've update Quantum Gis to v 1.3 (not included
>     within the ever so useful osgeo4w) I'm able to connect to postgis
>     from Quantum Gis as well besides Udig.
>
>      
>
>     If somebody here knows a solution please let me know. Do others
>     experience the same trouble?
>
>      
>
>      
>
>     Met vriendelijke 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 *Jason Birch
>     *Verzonden:* maandag 21 september 2009 22:29
>     *Aan:* MapGuide Users Mail List
>     *Onderwerp:* Re: [mapguide-users] trouble connecting mapguide
>     maestro postgis
>
>      
>
>     I haven't played with the PostGIS provider for a long time, but it
>     would be key to ensure that you are using the same version of
>     libpq (and the other postgresql client libraries) as the provider
>     was compiled with.  I'm not entirely sure what version that is,
>     but someone on the fdo-users mailing list should be able to help.
>
>      
>
>     Jason
>
>     2009/9/21 Remco Houtkamp <r.houtkamp at burohoutkamp.nl
>     </mc/compose?to=r.houtkamp at burohoutkamp.nl>>
>
>     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
>     </mc/compose?to=mapguide-users-bounces at lists.osgeo.org>
>     [mailto:mapguide-users-bounces at lists.osgeo.org
>     </mc/compose?to=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
>     </mc/compose?to=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
>     </mc/compose?to=r.houtkamp at burohoutkamp.nl> |P:  Kweldergras 21,
>     1441 WP, Purmerend |
>     >
>     > -----Oorspronkelijk bericht-----
>     > Van: mapguide-users-bounces at lists.osgeo.org
>     </mc/compose?to=mapguide-users-bounces at lists.osgeo.org>
>     [mailto:mapguide-users-bounces at lists.osgeo.org
>     </mc/compose?to=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
>     </mc/compose?to=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
>     </mc/compose?to=r.houtkamp at burohoutkamp.nl> |P:  Kweldergras 21, 1441
>     >> WP, Purmerend |
>     >>
>     >>
>     >>
>     >> Van: mapguide-users-bounces at lists.osgeo.org
>     </mc/compose?to=mapguide-users-bounces at lists.osgeo.org>
>     >> [mailto:mapguide-users-bounces at lists.osgeo.org
>     </mc/compose?to=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
>     </mc/compose?to=mapguide-users-bounces at lists.osgeo.org>
>     >> [mailto:mapguide-users-bounces at lists.osgeo.org
>     </mc/compose?to=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
>     </mc/compose?to=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
>     <http://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/ <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
>     </mc/compose?to=mapguide-users at lists.osgeo.org>
>     >>
>     >> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>     >>
>     >>
>     >>
>     >>
>     >>
>     >>
>     >>
>     >>
>     >>
>     >>
>     >>
>     >>
>     >>
>     >>
>     >>
>     >> _______________________________________________
>     >> mapguide-users mailing list
>     >> mapguide-users at lists.osgeo.org
>     </mc/compose?to=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
>     </mc/compose?to=mapguide-users at lists.osgeo.org>
>     > http://lists.osgeo.org/mailman/listinfo/mapguide-users
>     > _______________________________________________
>     > mapguide-users mailing list
>     > mapguide-users at lists.osgeo.org
>     </mc/compose?to=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
>     </mc/compose?to=mapguide-users at lists.osgeo.org>
>     http://lists.osgeo.org/mailman/listinfo/mapguide-users
>     _______________________________________________
>     mapguide-users mailing list
>     mapguide-users at lists.osgeo.org
>     </mc/compose?to=mapguide-users at lists.osgeo.org>
>     http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>      
>
>
>     -----Inline Attachment Follows-----
>
>     _______________________________________________
>     mapguide-users mailing list
>     mapguide-users at lists.osgeo.org
>     </mc/compose?to=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
>   
-------------- next part --------------
Skipped content of type multipart/related


More information about the mapguide-users mailing list