trouble connecting mapguide maestro postgis

[stijlie]

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…

[Remco Houtkamp]

Some javascript/style in this post has been disabled (why?)

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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[zspitzer]

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
<[hidden email]> 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
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>

--
Zac Spitzer -
http://zacster.blogspot.com
[phone]
_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[Remco Houtkamp]

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: [hidden email] [mailto:[hidden email]] 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
<[hidden email]> 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
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>

--
Zac Spitzer -
http://zacster.blogspot.com
[phone]
_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[Kenneth Skovhede, GEOGRAF A/S]

Some javascript/style in this post has been disabled (why?)

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.


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: [hidden email] [[hidden email]] 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
[hidden email] 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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users


    

_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[Remco Houtkamp]

Some javascript/style in this post has been disabled (why?)

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: [hidden email] |P:  Kweldergras 21, 1441 WP, Purmerend |

 

Van: [hidden email] [mailto:[hidden email]] 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: [hidden email] [[hidden email]] 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

[hidden email] 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

[hidden email]

http://lists.osgeo.org/mailman/listinfo/mapguide-users

_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[zspitzer]

try depends on  libpq.dll

On Fri, Sep 18, 2009 at 6:46 PM, Remco Houtkamp
<[hidden email]> 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: [hidden email] |P:  Kweldergras 21, 1441
> WP, Purmerend |
>
>
>
> Van: [hidden email]
> [mailto:[hidden email]] 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: [hidden email]
> [mailto:[hidden email]] 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
>
> <[hidden email]> 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
>
> [hidden email]
>
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> _______________________________________________
> mapguide-users mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>

--
Zac Spitzer -
http://zacster.blogspot.com
[phone]
_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[Remco Houtkamp]

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: [hidden email] |P:  Kweldergras 21, 1441 WP, Purmerend |

-----Oorspronkelijk bericht-----
Van: [hidden email] [mailto:[hidden email]] 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
<[hidden email]> 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: [hidden email] |P:  Kweldergras 21, 1441
> WP, Purmerend |
>
>
>
> Van: [hidden email]
> [mailto:[hidden email]] 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: [hidden email]
> [mailto:[hidden email]] 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
>
> <[hidden email]> 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
>
> [hidden email]
>
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> _______________________________________________
> mapguide-users mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>

--
Zac Spitzer -
http://zacster.blogspot.com
[phone]
_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[zspitzer]

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
<[hidden email]> 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: [hidden email] |P:  Kweldergras 21, 1441 WP, Purmerend |
>
> -----Oorspronkelijk bericht-----
> Van: [hidden email] [mailto:[hidden email]] 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
> <[hidden email]> 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: [hidden email] |P:  Kweldergras 21, 1441
>> WP, Purmerend |
>>
>>
>>
>> Van: [hidden email]
>> [mailto:[hidden email]] 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: [hidden email]
>> [mailto:[hidden email]] 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
>>
>> <[hidden email]> 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
>>
>> [hidden email]
>>
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> mapguide-users mailing list
>> [hidden email]
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>
>
>
> --
> Zac Spitzer -
> http://zacster.blogspot.com
> [phone]
> _______________________________________________
> mapguide-users mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>

--
Zac Spitzer -
http://zacster.blogspot.com
[phone]
_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[Remco Houtkamp]

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: [hidden email] [mailto:[hidden email]] 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
<[hidden email]> 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: [hidden email] |P:  Kweldergras 21, 1441 WP, Purmerend |
>
> -----Oorspronkelijk bericht-----
> Van: [hidden email] [mailto:[hidden email]] 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
> <[hidden email]> 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: [hidden email] |P:  Kweldergras 21, 1441
>> WP, Purmerend |
>>
>>
>>
>> Van: [hidden email]
>> [mailto:[hidden email]] 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: [hidden email]
>> [mailto:[hidden email]] 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
>>
>> <[hidden email]> 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
>>
>> [hidden email]
>>
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> mapguide-users mailing list
>> [hidden email]
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>
>
>
> --
> Zac Spitzer -
> http://zacster.blogspot.com
> [phone]
> _______________________________________________
> mapguide-users mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>

--
Zac Spitzer -
http://zacster.blogspot.com
[phone]
_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[Jason Birch]

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 <[hidden email]>

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: [hidden email] [mailto:[hidden email]] 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
<[hidden email]> 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: [hidden email] |P:  Kweldergras 21, 1441 WP, Purmerend |
>
> -----Oorspronkelijk bericht-----
> Van: [hidden email] [mailto:[hidden email]] 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
> <[hidden email]> 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: [hidden email] |P:  Kweldergras 21, 1441
>> WP, Purmerend |
>>
>>
>>
>> Van: [hidden email]
>> [mailto:[hidden email]] 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: [hidden email]
>> [mailto:[hidden email]] 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
>>
>> <[hidden email]> 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
>>
>> [hidden email]
>>
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> mapguide-users mailing list
>> [hidden email]
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>
>
>
> --
> Zac Spitzer -
> http://zacster.blogspot.com
> [phone]
> _______________________________________________
> mapguide-users mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>



--
Zac Spitzer -
http://zacster.blogspot.com
[phone]
_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[Remco Houtkamp]

Some javascript/style in this post has been disabled (why?)

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: [hidden email] |P:  Kweldergras 21, 1441 WP, Purmerend |

 

Van: [hidden email] [mailto:[hidden email]] 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 <[hidden email]>

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: [hidden email] [mailto:[hidden email]] 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
<[hidden email]> 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: [hidden email] |P:  Kweldergras 21, 1441 WP, Purmerend |
>
> -----Oorspronkelijk bericht-----
> Van: [hidden email] [mailto:[hidden email]] 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
> <[hidden email]> 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: [hidden email] |P:  Kweldergras 21, 1441
>> WP, Purmerend |
>>
>>
>>
>> Van: [hidden email]
>> [mailto:[hidden email]] 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: [hidden email]
>> [mailto:[hidden email]] 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
>>
>> <[hidden email]> 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
>>
>> [hidden email]
>>
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> mapguide-users mailing list
>> [hidden email]
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>
>
>
> --
> Zac Spitzer -
> http://zacster.blogspot.com
> [phone]
> _______________________________________________
> mapguide-users mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>



--
Zac Spitzer -
http://zacster.blogspot.com
[phone]
_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

 

_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[Remco Houtkamp]

Some javascript/style in this post has been disabled (why?)

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/
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: [hidden email] [mailto:[hidden email]] 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: [hidden email] |P:  Kweldergras 21, 1441 WP, Purmerend |

 

Van: [hidden email] [mailto:[hidden email]] 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 <[hidden email]>

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: [hidden email] [mailto:[hidden email]] 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
<[hidden email]> 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: [hidden email] |P:  Kweldergras 21, 1441 WP, Purmerend |
>
> -----Oorspronkelijk bericht-----
> Van: [hidden email] [mailto:[hidden email]] 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
> <[hidden email]> 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: [hidden email] |P:  Kweldergras 21, 1441
>> WP, Purmerend |
>>
>>
>>
>> Van: [hidden email]
>> [mailto:[hidden email]] 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: [hidden email]
>> [mailto:[hidden email]] 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
>>
>> <[hidden email]> 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
>>
>> [hidden email]
>>
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> mapguide-users mailing list
>> [hidden email]
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>
>
>
> --
> Zac Spitzer -
> http://zacster.blogspot.com
> [phone]
> _______________________________________________
> mapguide-users mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>



--
Zac Spitzer -
http://zacster.blogspot.com
[phone]
_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

 

_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[Pedro Venâncio]

Some javascript/style in this post has been disabled (why?)

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 <[hidden email]> 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/
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: [hidden email] [mailto:[hidden email]] 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: [hidden email] |P:  Kweldergras 21, 1441 WP, Purmerend |

 

Van: [hidden email] [mailto:[hidden email]] 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@...>

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@... [mailto:mapguide-users-bounces@...] 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@...> 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@... |P:  Kweldergras 21, 1441 WP, Purmerend |
>
> -----Oorspronkelijk bericht-----
> Van: mapguide-users-bounces@... [mailto:mapguide-users-bounces@...] 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@...> 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@... |P:  Kweldergras 21, 1441
>> WP, Purmerend |
>>
>>
>>
>> Van: mapguide-users-bounces@...
>> [mailto:mapguide-users-bounces@...] 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@...
>> [mailto:mapguide-users-bounces@...] 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@...> 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@...
>>
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users@...
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>
>
>
> --
> Zac Spitzer -
> http://zacster.blogspot.com
> [phone]
> _______________________________________________
> mapguide-users mailing list
> mapguide-users@...
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> mapguide-users@...
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>



--
Zac Spitzer -
http://zacster.blogspot.com
[phone]
_______________________________________________
mapguide-users mailing list
mapguide-users@...
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
mapguide-users@...
http://lists.osgeo.org/mailman/listinfo/mapguide-users

 

-----Inline Attachment Follows-----

_______________________________________________
mapguide-users mailing list
mapguide-users@...
http://lists.osgeo.org/mailman/listinfo/mapguide-users

_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[Kenneth Skovhede, GEOGRAF A/S]

Some javascript/style in this post has been disabled (why?)

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/


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 [hidden email] 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/
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: [hidden email] [[hidden email]] 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: [hidden email] |P:  Kweldergras 21, 1441 WP, Purmerend |

 

Van: [hidden email] [[hidden email]] 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@...>

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@... [mailto:mapguide-users-bounces@...] 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@...> 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@... |P:  Kweldergras 21, 1441 WP, Purmerend |
>
> -----Oorspronkelijk bericht-----
> Van: mapguide-users-bounces@... [mailto:mapguide-users-bounces@...] 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@...> 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@... |P:  Kweldergras 21, 1441
>> WP, Purmerend |
>>
>>
>>
>> Van: mapguide-users-bounces@...
>> [mailto:mapguide-users-bounces@...] 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@...
>> [mailto:mapguide-users-bounces@...] 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@...> 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@...
>>
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users@...
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>
>
>
> --
> Zac Spitzer -
> http://zacster.blogspot.com
> [phone]
> _______________________________________________
> mapguide-users mailing list
> mapguide-users@...
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> mapguide-users@...
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>



--
Zac Spitzer -
http://zacster.blogspot.com
[phone]
_______________________________________________
mapguide-users mailing list
mapguide-users@...
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
mapguide-users@...
http://lists.osgeo.org/mailman/listinfo/mapguide-users

 

-----Inline Attachment Follows-----

_______________________________________________
mapguide-users mailing list
mapguide-users@...
http://lists.osgeo.org/mailman/listinfo/mapguide-users

---

---

_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
  

_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[Remco Houtkamp]

Some javascript/style in this post has been disabled (why?)

OGR did not work either… I wanted to test if the same thing happens with mapguide 2.0.2, unfortunately it does not contain the postgis fdo. So still no luck. I’m starting to worry that nobody will help me out. Can somebody answer my other question? Does anybody have a similar windows xp setup running and what versions do you use (postgresql, mapguide, postgis).

 

 

 

Van: [hidden email] [mailto:[hidden email]] Namens Kenneth Skovhede, GEOGRAF A/S
Verzonden: donderdag 24 september 2009 8:10
Aan: MapGuide Users Mail List
Onderwerp: Re: [mapguide-users] trouble connecting mapguide maestro postgis

 

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 [hidden email] 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/
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: [hidden email] [[hidden email]] 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: [hidden email] |P:  Kweldergras 21, 1441 WP, Purmerend |

 

Van: [hidden email] [[hidden email]] 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@...>

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@... [mailto:mapguide-users-bounces@...] 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@...> 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@... |P:  Kweldergras 21, 1441 WP, Purmerend |
>
> -----Oorspronkelijk bericht-----
> Van: mapguide-users-bounces@... [mailto:mapguide-users-bounces@...] 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@...> 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@... |P:  Kweldergras 21, 1441
>> WP, Purmerend |
>>
>>
>>
>> Van: mapguide-users-bounces@...
>> [mailto:mapguide-users-bounces@...] 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@...
>> [mailto:mapguide-users-bounces@...] 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@...> 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@...
>>
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users@...
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>
>
>
> --
> Zac Spitzer -
> http://zacster.blogspot.com
> [phone]
> _______________________________________________
> mapguide-users mailing list
> mapguide-users@...
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> mapguide-users@...
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>



--
Zac Spitzer -
http://zacster.blogspot.com
[phone]
_______________________________________________
mapguide-users mailing list
mapguide-users@...
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
mapguide-users@...
http://lists.osgeo.org/mailman/listinfo/mapguide-users

 

-----Inline Attachment Follows-----

_______________________________________________
mapguide-users mailing list
mapguide-users@...
http://lists.osgeo.org/mailman/listinfo/mapguide-users

 

---

 

 

---

 

_______________________________________________

mapguide-users mailing list

[hidden email]

http://lists.osgeo.org/mailman/listinfo/mapguide-users

_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[Pedro Venâncio]

Some javascript/style in this post has been disabled (why?)

I also get the same error with the OGR Provider...



--- On Fri, 9/25/09, Remco Houtkamp <[hidden email]> wrote:

OGR did not work either… I wanted to test if the same thing happens with mapguide 2.0.2, unfortunately it does not contain the postgis fdo. So still no luck. I’m starting to worry that nobody will help me out. Can somebody answer my other question? Does anybody have a similar windows xp setup running and what versions do you use (postgresql, mapguide, postgis).

 

 

 

Van: [hidden email] [mailto:[hidden email]] Namens Kenneth Skovhede, GEOGRAF A/S
Verzonden: donderdag 24 september 2009 8:10
Aan: MapGuide Users Mail List
Onderwerp: Re: [mapguide-users] trouble connecting mapguide maestro postgis

 

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@...> 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/
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@... [mailto:mapguide-users-bounces@...] 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@... |P:  Kweldergras 21, 1441 WP, Purmerend |

 

Van: mapguide-users-bounces@... [mailto:mapguide-users-bounces@...] 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 <[hidden email]>

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: [hidden email] [mailto:[hidden email]] 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
<[hidden email]> 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: [hidden email] |P:  Kweldergras 21, 1441 WP, Purmerend |
>
> -----Oorspronkelijk bericht-----
> Van: [hidden email] [mailto:[hidden email]] 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
> <[hidden email]> 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: [hidden email] |P:  Kweldergras 21, 1441
>> WP, Purmerend |
>>
>>
>>
>> Van: [hidden email]
>> [mailto:[hidden email]] 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: [hidden email]
>> [mailto:[hidden email]] 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
>>
>> <[hidden email]> 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
>>
>> [hidden email]
>>
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> mapguide-users mailing list
>> [hidden email]
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>
>
>
> --
> Zac Spitzer -
> http://zacster.blogspot.com
> [phone]
> _______________________________________________
> mapguide-users mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>



--
Zac Spitzer -
http://zacster.blogspot.com
[phone]
_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

 

-----Inline Attachment Follows-----

_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

 

---

 

 

---

 

_______________________________________________

mapguide-users mailing list

mapguide-users@...

http://lists.osgeo.org/mailman/listinfo/mapguide-users

-----Inline Attachment Follows-----

_______________________________________________
mapguide-users mailing list
mapguide-users@...
http://lists.osgeo.org/mailman/listinfo/mapguide-users

_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[Remco Houtkamp]

Some javascript/style in this post has been disabled (why?)

Still have no solution. Could somebody please tell with which setup they do have a good result (windows xp). Which combination and versions do you use (postgresql postgis mapguide FDO). The only next thing for me to do is to drop out and that would be a shame of all the effort….

 

 

Van: [hidden email] [mailto:[hidden email]] Namens Kenneth Skovhede, GEOGRAF A/S
Verzonden: donderdag 24 september 2009 8:10
Aan: MapGuide Users Mail List
Onderwerp: Re: [mapguide-users] trouble connecting mapguide maestro postgis

 

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 [hidden email] 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/
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: [hidden email] [[hidden email]] 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: [hidden email] |P:  Kweldergras 21, 1441 WP, Purmerend |

 

Van: [hidden email] [[hidden email]] 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@...>

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@... [mailto:mapguide-users-bounces@...] 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@...> 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@... |P:  Kweldergras 21, 1441 WP, Purmerend |
>
> -----Oorspronkelijk bericht-----
> Van: mapguide-users-bounces@... [mailto:mapguide-users-bounces@...] 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@...> 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@... |P:  Kweldergras 21, 1441
>> WP, Purmerend |
>>
>>
>>
>> Van: mapguide-users-bounces@...
>> [mailto:mapguide-users-bounces@...] 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@...
>> [mailto:mapguide-users-bounces@...] 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@...> 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@...
>>
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users@...
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>
>
>
> --
> Zac Spitzer -
> http://zacster.blogspot.com
> [phone]
> _______________________________________________
> mapguide-users mailing list
> mapguide-users@...
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> mapguide-users@...
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>



--
Zac Spitzer -
http://zacster.blogspot.com
[phone]
_______________________________________________
mapguide-users mailing list
mapguide-users@...
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
mapguide-users@...
http://lists.osgeo.org/mailman/listinfo/mapguide-users

 

-----Inline Attachment Follows-----

_______________________________________________
mapguide-users mailing list
mapguide-users@...
http://lists.osgeo.org/mailman/listinfo/mapguide-users

 

---

 

 

---

 

_______________________________________________

mapguide-users mailing list

[hidden email]

http://lists.osgeo.org/mailman/listinfo/mapguide-users

_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[Remco Houtkamp]

Some javascript/style in this post has been disabled (why?)

Still no answer, so I guess there are not many of you running a winxp setup. So can a few of you tell me which combination does work for you including mapguide postgresql postgis and mapguide maestro. I already played around with Debian and Ubuntu, but had some trouble to setup postgresql (userrights). Maybe I’ve to reconsider them… let me know.

 

 

Van: [hidden email] [mailto:[hidden email]] Namens Remco Houtkamp
Verzonden: zondag 27 september 2009 11:18
Aan: MapGuide Users Mail List
Onderwerp: RE: [mapguide-users] trouble connecting mapguide maestro postgis

 

Still have no solution. Could somebody please tell with which setup they do have a good result (windows xp). Which combination and versions do you use (postgresql postgis mapguide FDO). The only next thing for me to do is to drop out and that would be a shame of all the effort….

 

 

Van: [hidden email] [mailto:[hidden email]] Namens Kenneth Skovhede, GEOGRAF A/S
Verzonden: donderdag 24 september 2009 8:10
Aan: MapGuide Users Mail List
Onderwerp: Re: [mapguide-users] trouble connecting mapguide maestro postgis

 

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 [hidden email] 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/
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: [hidden email] [[hidden email]] 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: [hidden email] |P:  Kweldergras 21, 1441 WP, Purmerend |

 

Van: [hidden email] [[hidden email]] 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@...>

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@... [mailto:mapguide-users-bounces@...] 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@...> 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@... |P:  Kweldergras 21, 1441 WP, Purmerend |
>
> -----Oorspronkelijk bericht-----
> Van: mapguide-users-bounces@... [mailto:mapguide-users-bounces@...] 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@...> 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@... |P:  Kweldergras 21, 1441
>> WP, Purmerend |
>>
>>
>>
>> Van: mapguide-users-bounces@...
>> [mailto:mapguide-users-bounces@...] 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@...
>> [mailto:mapguide-users-bounces@...] 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@...> 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@...
>>
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users@...
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>
>
>
> --
> Zac Spitzer -
> http://zacster.blogspot.com
> [phone]
> _______________________________________________
> mapguide-users mailing list
> mapguide-users@...
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> mapguide-users@...
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>



--
Zac Spitzer -
http://zacster.blogspot.com
[phone]
_______________________________________________
mapguide-users mailing list
mapguide-users@...
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
mapguide-users@...
http://lists.osgeo.org/mailman/listinfo/mapguide-users

 

-----Inline Attachment Follows-----

_______________________________________________
mapguide-users mailing list
mapguide-users@...
http://lists.osgeo.org/mailman/listinfo/mapguide-users

 

---

 

 

---

 

_______________________________________________

mapguide-users mailing list

[hidden email]

http://lists.osgeo.org/mailman/listinfo/mapguide-users

_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[Ben Schalley]

Remco Houtkamp wrote:

>> My setup contains postgresql 8.4 and postgis 1.4.

Just a thought, maybe your problem is related to the following ticket with the FDO Postgis provider http://trac.osgeo.org/fdo/ticket/530

Try using Postgis 1.3.3 or 1.3.4.

I use a winxp machine with mapguide 2.0.x, postgresql 8.2.9 and postgis 1.3.3 as a development environment and it works pretty well.