[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