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
_______________________________________________ MapServer-dev mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/mapserver-dev
