[mapguide-trac] #1369: Problem with MapGuide and Oracle Spatial (FDOKingOracle) in linux

MapGuide Open Source trac_mapguide at osgeo.org
Fri Jun 4 11:28:06 EDT 2010


#1369: Problem with MapGuide and Oracle Spatial (FDOKingOracle) in linux
------------------------------+---------------------------------------------
 Reporter:  rafael            |         Owner:       
     Type:  defect            |        Status:  new  
 Priority:  high              |     Milestone:  2.2  
Component:  General           |       Version:  2.2.0
 Severity:  critical          |    Resolution:       
 Keywords:  FDO Oracle linux  |   External_id:       
------------------------------+---------------------------------------------
Comment (by rafael):

 Can you describe
  1. the version of oracle you are using
 Oracle client 11.2
 Oracle Server 10.2
 I changed the providers.xml and add:
  <FeatureProvider>
     <Name>OSGeo.KingOracle.3.5</Name>
     <DisplayName>OSGeo FDO Provider for Oracle</DisplayName>
     <Description>Read/write access to spatial and attribute data in an
 Oracle.</Description>
     <IsManaged>False</IsManaged>
     <Version>3.5.0.0</Version>
     <FeatureDataObjectsVersion>3.5.0.0</FeatureDataObjectsVersion>
     <LibraryPath>libKingOracleProvider.so</LibraryPath>
   </FeatureProvider>

  2. the dataset you testing against,
 Oracle Spatial tables. (SDO)


  3. How far you got, ie some data displayed or it crashed trying to author
 a layer? The first problem I found. It was missing the lib libaio.so. Now
 LDD is OK rafael at ubuntu:/usr/local/fdo-3.5.0/lib$ ldd -r
 libKingOracleOverrides-3.5.0.so
         linux-gate.so.1 =>  (0x00aa5000)
         libFDO-3.5.0.so => /usr/local/fdo-3.5.0/lib/libFDO-3.5.0.so
 (0x00110000)
         libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x00484000)
         libm.so.6 => /lib/tls/i686/cmov/libm.so.6 (0x0097f000)
         libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0x00576000)
         libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x006ba000)
         libxalan-c.so => /usr/local/fdo-3.5.0/lib/libxalan-c.so
 (0xb73e7000)
         libxalanMsg.so.17 => /usr/local/fdo-3.5.0/lib/libxalanMsg.so.17
 (0x009b4000)
         libxerces-c.so.25 => /usr/local/fdo-3.5.0/lib/libxerces-c.so.25
 (0xb702f000)
         libpthread.so.0 => /lib/tls/i686/cmov/libpthread.so.0 (0x007cc000)
         libdl.so.2 => /lib/tls/i686/cmov/libdl.so.2 (0x00e5e000)
         /lib/ld-linux.so.2 (0x00891000)
 rafael at ubuntu:/usr/local/fdo-3.5.0/lib$ ldd -r
 libKingOracleProvider-3.5.0.so
         linux-gate.so.1 =>  (0x00889000)
         libKingOracleOverrides-3.5.0.so =>
 /usr/local/fdo-3.5.0/lib/libKingOracleOverrides-3.5.0.so (0x00be3000)
         libFDO-3.5.0.so => /usr/local/fdo-3.5.0/lib/libFDO-3.5.0.so
 (0x00110000)
         libocci.so.11.1 =>
 /usr/local/oracle/instantclient_11_2/libocci.so.11.1 (0x00a4b000)
         libclntsh.so.11.1 =>
 /usr/local/oracle/instantclient_11_2/libclntsh.so.11.1 (0xb5bf1000)
         libociei.so => /usr/local/oracle/instantclient_11_2/libociei.so
 (0xb06b4000)
         libnnz11.so => /usr/local/oracle/instantclient_11_2/libnnz11.so
 (0x005c5000)
         libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x00484000)
         libm.so.6 => /lib/tls/i686/cmov/libm.so.6 (0x00e9c000)
         libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0x0088a000)
         libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00576000)
         libxalan-c.so => /usr/local/fdo-3.5.0/lib/libxalan-c.so
 (0x00ec2000)
         libxalanMsg.so.17 => /usr/local/fdo-3.5.0/lib/libxalanMsg.so.17
 (0x00594000)
         libxerces-c.so.25 => /usr/local/fdo-3.5.0/lib/libxerces-c.so.25
 (0xb02ed000)
         libpthread.so.0 => /lib/tls/i686/cmov/libpthread.so.0 (0x00812000)
         libdl.so.2 => /lib/tls/i686/cmov/libdl.so.2 (0x0059c000)
         libnsl.so.1 => /lib/tls/i686/cmov/libnsl.so.1 (0x0082b000)
         libaio.so.1 => /lib/libaio.so.1 (0x005a0000)
         /lib/ld-linux.so.2 (0x005a8000)

 Now when I try to connect this was showed in error file:
 <2010-06-02T14:05:34>   -1395135632     MapGuide Maestro v2.0.0.4650
 127.0.0.1
  Error: Session has expired or is invalid. Please log in again.
  StackTrace:
   - MgSiteServiceHandler.ProcessOperation() line 83 file
 SiteServiceHandler.cpp
   - MgOpAuthenticate.Execute() line 107 file OpAuthenticate.cpp
   - MgServerSiteService.Authenticate() line 709 file ServerSiteService.cpp
   - MgSecurityManager.Authenticate() line 224 file SecurityManager.cpp
   - MgSessionCache.GetSessionInfo() line 175 file SessionCache.cpp
 <2010-06-02T14:07:07>   -1366713488     MapGuide Maestro v2.0.0.4650
 127.0.0.1       Administrator
  Error: An exception occurred in FDO component.
         CLNT_8_UNABLE_TO_LOAD_LIBRARY
  StackTrace:
   - MgFeatureServiceHandler.ProcessOperation() line 83 file
 FeatureServiceHandler.cpp
   - MgOpTestFeatureSourceConnection.Execute() line 100 file
 OpTestFeatureSourceConnection.cpp
   - MgServerFeatureService.TestConnection() line 233 file
 ServerFeatureService.cpp
   - MgFdoConnectionManager.Open() line 308 file FdoConnectionManager.cpp
 <2010-06-02T14:07:28>   -1375134864     MapGuide Maestro v2.0.0.4650
 127.0.0.1       Administrator
  Error: An exception occurred in FDO component.
         CLNT_8_UNABLE_TO_LOAD_LIBRARY
  StackTrace:
   - MgFeatureServiceHandler.ProcessOperation() line 83 file
 FeatureServiceHandler.cpp
   - MgOpTestFeatureSourceConnection.Execute() line 100 file
 OpTestFeatureSourceConnection.cpp
   - MgServerFeatureService.TestConnection() line 233 file
 ServerFeatureService.cpp
   - MgFdoConnectionManager.Open() line 308 file FdoConnectionManager.cpp
 <2010-06-02T14:15:27>   -1217176736
  Success: Server stopped.

-- 
Ticket URL: <http://trac.osgeo.org/mapguide/ticket/1369#comment:2>
MapGuide Open Source <http://mapguide.osgeo.org/>
MapGuide Open Source Internals


More information about the mapguide-trac mailing list