<div dir="ltr">from CMake<div><br></div><div>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica">[ 98%] Linking CXX shared library libmapserver.so</p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica">[ 98%] Built target mapserver</p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica">[100%] Building C object CMakeFiles/msplugin_oracle.dir/maporaclespatial.c.o</p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica">/home/ec2-user/miniconda3/conda-bld/mapserverplugins_1649503981733/work/maporaclespatial.c: In function 'msOracleSpatialLayerWhichShapes':</p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica">/home/ec2-user/miniconda3/conda-bld/mapserverplugins_1649503981733/work/maporaclespatial.c:2141:18: warning: assignment discards 'const' qualifier from pointer target type [-Wdiscarded-qualifiers]</p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica"><span class="gmail-Apple-converted-space"> </span>2141 | <span class="gmail-Apple-converted-space"> </span>bind_value = msLookupHashTable(&layer->bindvals, bind_key);</p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica"><span class="gmail-Apple-converted-space"> </span>|<span class="gmail-Apple-converted-space"> </span>^</p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica">/home/ec2-user/miniconda3/conda-bld/mapserverplugins_1649503981733/work/maporaclespatial.c: In function 'msOracleSpatialLayerGetAutoProjection':</p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica">/home/ec2-user/miniconda3/conda-bld/mapserverplugins_1649503981733/work/maporaclespatial.c:2766:31: warning: variable 'dthand' set but not used [-Wunused-but-set-variable]</p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica"><span class="gmail-Apple-converted-space"> </span>2766 | <span class="gmail-Apple-converted-space"> </span>msOracleSpatialDataHandler *dthand = NULL;</p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica"><span class="gmail-Apple-converted-space"> </span>| <span class="gmail-Apple-converted-space"> </span>^~~~~~</p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica">/home/ec2-user/miniconda3/conda-bld/mapserverplugins_1649503981733/work/maporaclespatial.c: In function 'msOracleSpatialLayerGetItems':</p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica">/home/ec2-user/miniconda3/conda-bld/mapserverplugins_1649503981733/work/maporaclespatial.c:2983:31: warning: variable 'dthand' set but not used [-Wunused-but-set-variable]</p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica"><span class="gmail-Apple-converted-space"> </span>2983 | <span class="gmail-Apple-converted-space"> </span>msOracleSpatialDataHandler *dthand = NULL;</p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica"><span class="gmail-Apple-converted-space"> </span>| <span class="gmail-Apple-converted-space"> </span>^~~~~~</p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica">At top level:</p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica">/home/ec2-user/miniconda3/conda-bld/mapserverplugins_1649503981733/work/maporaclespatial.c:1078:13: warning: 'osConvexHullGetExtent' defined but not used [-Wunused-function]</p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica"><span class="gmail-Apple-converted-space"> </span>1078 | static void osConvexHullGetExtent(layerObj *layer, char *query_str, size_t size, char *geom_column_name, char *table_name)</p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica"><span class="gmail-Apple-converted-space"> </span>| <span class="gmail-Apple-converted-space"> </span>^~~~~~~~~~~~~~~~~~~~~</p>
<p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica">[100%] Linking C shared module libmsplugin_oracle.so</p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica"><br></p><p class="gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:12px;line-height:normal;font-family:Helvetica">In case this helps</p></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, Apr 9, 2022 at 9:42 AM Michael Smith <<a href="mailto:michael.smith.erdc@gmail.com">michael.smith.erdc@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang="EN-US" style="overflow-wrap: break-word;"><div class="gmail-m_-3077804146836654923WordSection1"><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. <u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">I’m using cmake with -DWITH_ORACLE_PLUGIN=1 and then<u></u><u></u></p><p class="MsoNormal">make msplugin_oracle<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></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. <u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">If I set an incorrect path to the plugin, I see an error<u></u><u></u></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<u></u><u></u></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<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></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).<u></u><u></u></p><p class="MsoNormal">[Sat Apr 9 13:35:15 2022].17135 msDrawMap(): WMS/WFS set-up and query, 0.000s<u></u><u></u></p><p class="MsoNormal">[Sat Apr 9 13:35:15 2022].55543 msOracleSpatialLayerOpen(): OracleSpatial error. OracleSpatial is not supported<u></u><u></u></p><p class="MsoNormal">[Sat Apr 9 13:35:15 2022].56576 msDrawMap(): Layer 1 (basins), 0.039s<u></u><u></u></p><p class="MsoNormal">[Sat Apr 9 13:35:15 2022].56614 msDrawMap(): Drawing Label Cache, 0.000s<u></u><u></u></p><p class="MsoNormal">[Sat Apr 9 13:35:15 2022].56623 msDrawMap() total time: 0.041s<u></u><u></u></p><p class="MsoNormal">[Sat Apr 9 13:35:15 2022].70250 msSaveImage(stdout) total time: 0.014s<u></u><u></u></p><p class="MsoNormal">[Sat Apr 9 13:35:15 2022].70413 mapserv request processing time (msLoadMap not incl.): 0.054s<u></u><u></u></p><p class="MsoNormal">[Sat Apr 9 13:35:15 2022].70426 msFreeMap(): freeing map at 0x5604a1a50be0.<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Layer is defined as:<br><br> LAYER<u></u><u></u></p><p class="MsoNormal"> NAME basins<u></u><u></u></p><p class="MsoNormal"> DEBUG 5<u></u><u></u></p><p class="MsoNormal"> CONNECTIONTYPE plugin<u></u><u></u></p><p class="MsoNormal"> PLUGIN "/opt/conda lib/libmsplugin_oracle.so"<u></u><u></u></p><p class="MsoNormal"> INCLUDE "include/connection.inc"<u></u><u></u></p><p class="MsoNormal"> DATA "shape from WORLD_BASINS using srid 4326"<u></u><u></u></p><p class="MsoNormal"> PROCESSING "CLOSE_CONNECTION=DEFER"<u></u><u></u></p><p class="MsoNormal"> PROJECTION<u></u><u></u></p><p class="MsoNormal"> "init=epsg:4326"<u></u><u></u></p><p class="MsoNormal"> END<u></u><u></u></p><p class="MsoNormal">…<u></u><u></u></p><p class="MsoNormal">END<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></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. <u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">If I get this working, I’ll certainly be adding some doc tickets about this.<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Mike<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal">-- <u></u><u></u></p></div><div><p class="MsoNormal">Michael Smith<u></u><u></u></p><p class="MsoNormal">US Army Corps / Remote Sensing GIS Center<u></u><u></u></p></div></div><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><u></u> <u></u></p></div></div>
</blockquote></div>