<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style></head><body lang=EN-US link=blue vlink=purple style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal>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. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’m using cmake with -DWITH_ORACLE_PLUGIN=1 and then<o:p></o:p></p><p class=MsoNormal>make msplugin_oracle<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>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. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>If I set an incorrect path to the plugin, I see an error<o:p></o:p></p><p class=MsoNormal>[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<o:p></o:p></p><p class=MsoNormal>[Sat Apr 9 13:33:11 2022].731455 loadCustomLayerDLL: General error message. Failed to load dynamic Layer LIB: /opt2/conda/lib/libmsplugin_oracle.so<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>When the plugin is set I get<br><br>[Sat Apr 9 13:35:15 2022].17089 msDrawMap(): rendering using outputformat named png (AGG/PNG).<o:p></o:p></p><p class=MsoNormal>[Sat Apr 9 13:35:15 2022].17135 msDrawMap(): WMS/WFS set-up and query, 0.000s<o:p></o:p></p><p class=MsoNormal>[Sat Apr 9 13:35:15 2022].55543 msOracleSpatialLayerOpen(): OracleSpatial error. OracleSpatial is not supported<o:p></o:p></p><p class=MsoNormal>[Sat Apr 9 13:35:15 2022].56576 msDrawMap(): Layer 1 (basins), 0.039s<o:p></o:p></p><p class=MsoNormal>[Sat Apr 9 13:35:15 2022].56614 msDrawMap(): Drawing Label Cache, 0.000s<o:p></o:p></p><p class=MsoNormal>[Sat Apr 9 13:35:15 2022].56623 msDrawMap() total time: 0.041s<o:p></o:p></p><p class=MsoNormal>[Sat Apr 9 13:35:15 2022].70250 msSaveImage(stdout) total time: 0.014s<o:p></o:p></p><p class=MsoNormal>[Sat Apr 9 13:35:15 2022].70413 mapserv request processing time (msLoadMap not incl.): 0.054s<o:p></o:p></p><p class=MsoNormal>[Sat Apr 9 13:35:15 2022].70426 msFreeMap(): freeing map at 0x5604a1a50be0.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Layer is defined as:<br><br> LAYER<o:p></o:p></p><p class=MsoNormal> NAME basins<o:p></o:p></p><p class=MsoNormal> DEBUG 5<o:p></o:p></p><p class=MsoNormal> CONNECTIONTYPE plugin<o:p></o:p></p><p class=MsoNormal> PLUGIN "/opt/conda lib/libmsplugin_oracle.so"<o:p></o:p></p><p class=MsoNormal> INCLUDE "include/connection.inc"<o:p></o:p></p><p class=MsoNormal> DATA "shape from WORLD_BASINS using srid 4326"<o:p></o:p></p><p class=MsoNormal> PROCESSING "CLOSE_CONNECTION=DEFER"<o:p></o:p></p><p class=MsoNormal> PROJECTION<o:p></o:p></p><p class=MsoNormal> "init=epsg:4326"<o:p></o:p></p><p class=MsoNormal> END<o:p></o:p></p><p class=MsoNormal>…<o:p></o:p></p><p class=MsoNormal>END<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>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. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>If I get this working, I’ll certainly be adding some doc tickets about this.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Mike<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>-- <o:p></o:p></p></div><div><p class=MsoNormal>Michael Smith<o:p></o:p></p><p class=MsoNormal>US Army Corps / Remote Sensing GIS Center<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>