Trouble connecting Mapguide to Postgis.
|
|
Remco Houtkamp
|
Some javascript/style in this post has been disabled (why?)
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 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: 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) The errorlog tells me: <2009-09-18T10:40:23>
3508 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) _______________________________________________ fdo-users mailing list [hidden email] http://lists.osgeo.org/mailman/listinfo/fdo-users |
||||||||||||||||
Orest Halustchak
|
Some javascript/style in this post has been disabled (why?)
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: [hidden email]
[mailto:[hidden email]] On Behalf Of Remco Houtkamp 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 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: 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) The errorlog tells me: <2009-09-18T10:40:23>
3508 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) _______________________________________________ fdo-users mailing list [hidden email] http://lists.osgeo.org/mailman/listinfo/fdo-users |
||||||||||||||||
|
Remco Houtkamp
|
Some javascript/style in this post has been disabled (why?)
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:
[hidden email] [mailto:[hidden email]] Namens
Orest Halustchak 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: [hidden email]
[mailto:[hidden email]] On Behalf Of Remco Houtkamp 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 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: 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) The errorlog tells me: <2009-09-18T10:40:23>
3508 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) _______________________________________________ fdo-users mailing list [hidden email] http://lists.osgeo.org/mailman/listinfo/fdo-users |
||||||||||||||||
zspitzer
|
maybe a version mismatch, try using the dll's from 8.3.7.?
On Thu, Sep 24, 2009 at 2:04 AM, Remco Houtkamp <[hidden email]> wrote: > 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: [hidden email] > [mailto:[hidden email]] 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: [hidden email] > [mailto:[hidden email]] On Behalf Of Remco Houtkamp > Sent: Tuesday, September 22, 2009 2:46 AM > To: [hidden email] > 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/ 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) > > > > > > _______________________________________________ > fdo-users mailing list > [hidden email] > http://lists.osgeo.org/mailman/listinfo/fdo-users > > -- Zac Spitzer - http://zacster.blogspot.com +61 405 847 168 _______________________________________________ fdo-users mailing list [hidden email] http://lists.osgeo.org/mailman/listinfo/fdo-users |
||||||||||||||||
|
Remco Houtkamp
|
I'm behind another machine now on which I installed postgresql 8.3 still no luck.
Does anybody know a setup at winxp that does work. Maybe I can check out the versions that person is running. -----Oorspronkelijk bericht----- Van: [hidden email] [mailto:[hidden email]] Namens Zac Spitzer Verzonden: woensdag 23 september 2009 18:08 Aan: FDO Users Mail List Onderwerp: Re: [fdo-users] RE: Trouble connecting Mapguide to Postgis. maybe a version mismatch, try using the dll's from 8.3.7.? On Thu, Sep 24, 2009 at 2:04 AM, Remco Houtkamp <[hidden email]> wrote: > 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: [hidden email] > [mailto:[hidden email]] 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: [hidden email] > [mailto:[hidden email]] On Behalf Of Remco Houtkamp > Sent: Tuesday, September 22, 2009 2:46 AM > To: [hidden email] > 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/ 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) > > > > > > _______________________________________________ > fdo-users mailing list > [hidden email] > http://lists.osgeo.org/mailman/listinfo/fdo-users > > -- Zac Spitzer - http://zacster.blogspot.com +61 405 847 168 _______________________________________________ fdo-users mailing list [hidden email] http://lists.osgeo.org/mailman/listinfo/fdo-users _______________________________________________ fdo-users mailing list [hidden email] http://lists.osgeo.org/mailman/listinfo/fdo-users |
||||||||||||||||
Dejan Gregor
|
Dear colleagues,
I am disappointed that no solution has been provided for similar errors in Windows environments for the FDO provider for PostGIS ('crawling' through different forums). I have also tried installing different versions of FDO providers (from the OSGEO as well as from other creators of 3.3 and 3.4 versions), different MGOS (2.0.2, 2.1), PostGIS 1.4 on Windows and it simply did not go through at the Layer creation in MapGuide Studio 2010 or MapGuide Maestro. Can someone please check on this that had positive experience in the installation on Windows XP or 2003 (32-bit)? Kind regards, Dejan Gregor
|
||||||||||||||||
| Free Embeddable Forum Powered by Nabble | Help |
