[mapserver-dev] Oracle Plugin - Does it work (linux)?

[Michael Smith]

In changing over our build configs to conda, I want to start using the very nice mapserver packages at conda-forge. However to do that, I need to build the mapserver oracle plugin. 

 

I’m using cmake with    -DWITH_ORACLE_PLUGIN=1 and then

make  msplugin_oracle

 

I’ve been able to do this successfully in gdal and building an oracle plugin for gdal but, while the mapserver oracle plugin builds, and using ldd I can see that the plugin is properly linked, I cannot get the plugin to work in a mapfile. 

 

If I set an incorrect path to the plugin, I see an error

[Sat Apr  9 13:33:11 2022].731407 msGetSymbol(): General error message. Dynamic loading failed: /opt2/conda/lib/libmsplugin_oracle.so: cannot open shared object file: No such file or directory

[Sat Apr  9 13:33:11 2022].731455 loadCustomLayerDLL: General error message. Failed to load dynamic Layer LIB: /opt2/conda/lib/libmsplugin_oracle.so

 

When the plugin is set I get

[Sat Apr  9 13:35:15 2022].17089 msDrawMap(): rendering using outputformat named png (AGG/PNG).

[Sat Apr  9 13:35:15 2022].17135 msDrawMap(): WMS/WFS set-up and query, 0.000s

[Sat Apr  9 13:35:15 2022].55543 msOracleSpatialLayerOpen(): OracleSpatial error. OracleSpatial is not supported

[Sat Apr  9 13:35:15 2022].56576 msDrawMap(): Layer 1 (basins), 0.039s

[Sat Apr  9 13:35:15 2022].56614 msDrawMap(): Drawing Label Cache, 0.000s

[Sat Apr  9 13:35:15 2022].56623 msDrawMap() total time: 0.041s

[Sat Apr  9 13:35:15 2022].70250 msSaveImage(stdout) total time: 0.014s

[Sat Apr  9 13:35:15 2022].70413 mapserv request processing time (msLoadMap not incl.): 0.054s

[Sat Apr  9 13:35:15 2022].70426 msFreeMap(): freeing map at 0x5604a1a50be0.

 

 

Layer is defined as:

  LAYER

      NAME basins

      DEBUG 5

      CONNECTIONTYPE plugin

      PLUGIN "/opt/conda lib/libmsplugin_oracle.so"

      INCLUDE "include/connection.inc"

      DATA "shape from WORLD_BASINS using srid 4326"

      PROCESSING "CLOSE_CONNECTION=DEFER"

      PROJECTION

        "init=epsg:4326"

      END

…

END

 

Any idea anyone? I may have to do this via OGR connection but I have had faster performance in the past with the native oracle spatial driver. So I would prefer to use that, just as a plugin. 

 

If I get this working, I’ll certainly be adding some doc tickets about this.

 

Mike

 

 

-- 

Michael Smith

US Army Corps / Remote Sensing GIS Center

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-dev/attachments/20220409/3fdd4b4e/attachment.html>