[fdo-users] RE: Trouble connecting Mapguide to Postgis.

[Remco Houtkamp]

All the dll 's are present within C:\Program
Files\OSGeo\MapGuide\Server\Fdo unfortunately that does not help.  I'm
out off clues so I hope somebody can help...

 

 Remco

 

Van: fdo-users-bounces at lists.osgeo.org
[mailto:fdo-users-bounces at lists.osgeo.org] Namens Orest Halustchak
Verzonden: dinsdag 22 september 2009 15:08
Aan: FDO Users Mail List
Onderwerp: [fdo-users] RE: Trouble connecting Mapguide to Postgis.

 

Hi Remco,

 

In addition to libq.dll, there are a number of other dll's from the
postgresql bin that you can try to copy into the fdo bin directory.

 

-          comerr32.dll

-          gssapi32.dll

-          k5sprt32.dll

-          krb5_32.dll

-          libeay32.dll

-          libiconv-2.dll

-          libintl-8.dll

-          libpq.dll

 

I have not tried postgres 8.4 yet, but I have used postgis 1.3.6 /
postgres 8.3.7.

 

Thanks,

Orest.

 

From: fdo-users-bounces at lists.osgeo.org
[mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Remco Houtkamp
Sent: Tuesday, September 22, 2009 2:46 AM
To: fdo-users at lists.osgeo.org
Subject: [fdo-users] Trouble connecting Mapguide to Postgis.

 

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/ <http://localhost/>
127.0.0.1 http:// 127.0.0.1/ <http://127.0.0.1/> 
Port: 5432
Tried all three credentials but think it must be Specified Credentials
with user postgres and my secret password ;)
Press test connection and then the following error appears:
De externe server heeft een fout geretourneerd: (559) MgFdoException.:
An exception occurred in FDO component. Unable to load the FDO Provider:
Kan opgegeven module niet vinden. (some of this is Dutch... for cannot
find the module)

 

Somebody told me to test the fdo with depends.exe. This way we found out
that libpq.dll is missing. After installing " a version of libpq.dll" I
was able to run the the test connection. It returned no errors and I
save the connection. After this I need a layer to connect to the data.
Unfortunately I ge the following error:

De externe server heeft een fout geretourneerd: (559) MgFdoException.:
(dutch for the external server returned an error)
An exception occurred in FDO component.
Unable to load the FDO Provider: (null)

 

The errorlog tells me:

<2009-09-18T10:40:23>                3508
127.0.0.1             Administrator
Error: An exception occurred in FDO component.
Unable to load the FDO Provider: (null)
StackTrace:
- MgFeatureServiceHandler.ProcessOperation line 83 file
c:\osgeo\mapguide_21\mgdev\server\src\services\feature\FeatureServiceHan
dler.cpp
- MgOpTestFeatureSourceConnection.Execute line 100 file
c:\osgeo\mapguide_21\mgdev\server\src\services\feature\OpTestFeatureSour
ceConnection.cpp
- MgFdoConnectionManager.Open line 262 file
c:\osgeo\mapguide_21\mgdev\server\src\common\manager\FdoConnectionManage
r.cpp

 

It looks like the problem lies within the libpq.dll file. Anybody a
thought on how to solve this problem...

 

Thanks in advance, Remco  (The Netherlands)

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20090923/26fb7554/attachment.html