Unable to load postgis feature source

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Unable to load postgis feature source

Smith Roman
Hi,

I am unable to access postgis database using map maestro 5. I am using postgres 8.4 and postgis 1.5.2. Map guide 2.4.

Cheers,

Smith.


Here is the log:



The remote server returned an error: (559) MgFdoException.: 
An exception occurred in FDO component.
Unable to load the FDO Provider library '.\PostgreSQLProvider.dll': The specified module could not be found.
  (Cause: , Root Cause: Unable to load the FDO Provider library '.\PostgreSQLProvider.dll': The specified module could not be found.
 )






System.Exception: The remote server returned an error: (559) MgFdoException.: 
An exception occurred in FDO component.
Unable to load the FDO Provider library '.\PostgreSQLProvider.dll': The specified module could not be found.
  (Cause: , Root Cause: Unable to load the FDO Provider library '.\PostgreSQLProvider.dll': The specified module could not be found.
 )



 ---> System.Net.WebException: The remote server returned an error: (559) MgFdoException.
   at System.Net.HttpWebRequest.GetResponse()
   at OSGeo.MapGuide.MaestroAPI.HttpServerConnection.OpenRead(String req) in c:\Program Files (x86)\Jenkins\jobs\Maestro trunk\workspace\OSGeo.MapGuide.MaestroAPI.Http\HttpServerConnection.cs:line 1310
   --- End of inner exception stack trace ---
   at OSGeo.MapGuide.MaestroAPI.HttpServerConnection.OpenRead(String req) in c:\Program Files (x86)\Jenkins\jobs\Maestro trunk\workspace\OSGeo.MapGuide.MaestroAPI.Http\HttpServerConnection.cs:line 1326
   at OSGeo.MapGuide.MaestroAPI.HttpServerConnection.GetProviderCapabilities(String provider) in c:\Program Files (x86)\Jenkins\jobs\Maestro trunk\workspace\OSGeo.MapGuide.MaestroAPI.Http\HttpServerConnection.cs:line 1751
   at Maestro.Base.Editor.FsEditorOptionPanel.Bind(IEditorService service) in c:\Program Files (x86)\Jenkins\jobs\Maestro trunk\workspace\Maestro.Base\Editor\FsEditorOptionPanel.cs:line 60
   at Maestro.Base.Editor.FeatureSourceEditor.Bind(IEditorService service) in c:\Program Files (x86)\Jenkins\jobs\Maestro trunk\workspace\Maestro.Base\Editor\FeatureSourceEditor.cs:line 63
   at Maestro.Base.Editor.EditorContentBase.set_EditorService(IEditorService value) in c:\Program Files (x86)\Jenkins\jobs\Maestro trunk\workspace\Maestro.Base\Editor\EditorContentBase.cs:line 110
   at Maestro.Base.Services.OpenResourceManager.Open(IResource res, IServerConnection conn, Boolean useXmlEditor, ISiteExplorer siteExp) in c:\Program Files (x86)\Jenkins\jobs\Maestro trunk\workspace\Maestro.Base\Services\OpenResourceManager.cs:line 191
   at Maestro.Base.Services.OpenResourceManager.Open(String resourceId, IServerConnection conn, Boolean useXmlEditor, ISiteExplorer siteExp) in c:\Program Files (x86)\Jenkins\jobs\Maestro trunk\workspace\Maestro.Base\Services\OpenResourceManager.cs:line 259

_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
Reply | Threaded
Open this post in threaded view
|

Re: Unable to load postgis feature source

Steve Golden
Perhaps a few things to check:

1.  Check out the FDO folder where the dll's are installed (typically folder location, C:\Program Files\OSGeo\MapGuide\Server\Fdo).  Is the PostgreSQLProvider.dll file there?  Also check providers.xml to see that the provider is listed.  You should find the following:

<FeatureProvider>
    <Name>OSGeo.PostgreSQL.3.7</Name>
    <DisplayName>PostgreSQL/PostGIS Provider</DisplayName>
    <Description>Read/write access to PostgreSQL/PostGIS-based data store. Supports spatial data types and spatial query operations.</Description>
    <IsManaged>False</IsManaged>
    <Version>3.7.0.0</Version>
    <FeatureDataObjectsVersion>3.7.0.0</FeatureDataObjectsVersion>
    <LibraryPath>.\PostgreSQLProvider.dll</LibraryPath>
  </FeatureProvider>

2.  Check out these notes:

http://trac.osgeo.org/fdo/wiki/FdoPostgreSQLNotes

3.  Your problem may also be the bit-ness of your install (64 bit vs. 32).  See the following thread for info.

http://osgeo-org.1560.n6.nabble.com/FDO-PostgreSQL-PostGIS-provider-on-64bit-td4183551.html#a4183555

Reply | Threaded
Open this post in threaded view
|

Re: Unable to load postgis feature source

Smith Roman

Hi Steve,

I have verified the 3 points you listed and all seems to be okay. Still yet to figure out where the problem is coming from.

Regards,




From: Steve G <[hidden email]>
To: [hidden email]
Sent: Monday, January 28, 2013 10:37 PM
Subject: Re: [mapguide-users] Unable to load postgis feature source

Perhaps a few things to check:

1.  Check out the FDO folder where the dll's are installed (typically folder
location, C:\Program Files\OSGeo\MapGuide\Server\Fdo).  Is the
PostgreSQLProvider.dll file there?  Also check providers.xml to see that the
provider is listed.  You should find the following:

<FeatureProvider>
    <Name>OSGeo.PostgreSQL.3.7</Name>
    <DisplayName>PostgreSQL/PostGIS Provider</DisplayName>
    <Description>Read/write access to PostgreSQL/PostGIS-based data store.
Supports spatial data types and spatial query operations.</Description>
    <IsManaged>False</IsManaged>
    <Version>3.7.0.0</Version>
    <FeatureDataObjectsVersion>3.7.0.0</FeatureDataObjectsVersion>
    <LibraryPath>.\PostgreSQLProvider.dll</LibraryPath>
  </FeatureProvider>

2.  Check out these notes:

http://trac.osgeo.org/fdo/wiki/FdoPostgreSQLNotes

3.  Your problem may also be the bit-ness of your install (64 bit vs. 32).
See the following thread for info.

http://osgeo-org.1560.n6.nabble.com/FDO-PostgreSQL-PostGIS-provider-on-64bit-td4183551.html#a4183555





--
View this message in context: http://osgeo-org.1560.n6.nabble.com/Unable-to-load-postgis-feature-source-tp5030025p5030340.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
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
Reply | Threaded
Open this post in threaded view
|

Re: Unable to load postgis feature source

Steve Golden
I would recommend doing a dependency walker on PostgreSQLProvider.dll to see if you have all of the dependent dll's.  I seem to think that I was missing some of the dll's when I first tried connecting to a postgis database.  This thread identifies some of the files that you may need, but do the dependency walker yourself.

http://osgeo-org.1560.n6.nabble.com/PostGIS-postgreSQL-problem-td4185840.html#a4185843

I would assume that all of your connection properties are ok, but you could post your xml for readers to review it to see if you have any missing properties.