[mapserver-users] Fwd: no oracle access with ogr

[Jeff McKenna]

Did you set those as System Environment Variables (not only at the
commandline)?.  I usually set my environment variables and give the
machine a reboot.

-jeff

-- 
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/


On 2014-07-24, 3:03 AM, Dietmar Stolz wrote:
> No one with an idea?
> Authorization trouble in iis?
> Why it works in command line but not via http in my iis?
> 
> 
> -------- Original-Nachricht --------
> 
> I have a problem with the oracle access via ogr.
> Beforehand: with orginfo and shp2img everthing works fine. I get my
> geometries as well as images. Examples:
> 
>     /orginfo --formats shows -> "OCI" (read/write)/
>     /ogrinfo -al oci:usr/pwd at gspp:table -geom=SUMMARY/
>     /shp2img -m test.map -o output.png -all_debug 5 -e 523600 5549800
>     581900 5639700 -l strom/
> 
> With mapserver via getmap request i get the following error:
> 
>     /[Fri Jul 18 10:21:13 2014].50000
>     msOGRFileOpen(OCI:xxx/xxx at GSPP:TAALBF_NETZGEBIET).../
>     /[Fri Jul 18 10:21:13 2014].50000
>     OGROPen(OCI:xxx/xxx at GSPP:TAALBF_NETZGEBIET)/
>     /[Fri Jul 18 10:21:13 2014].51000 msOGRFileOpen(): OGR error. Open
>     failed for OGR connection in layer `strom'.  File not found or
>     unsupported format./
>     /[Fri Jul 18 10:21:13 2014].55000 msDrawMap(): Image handling error.
>     Failed to draw layer named 'strom'./
> 
> My mapfile (partial):
> 
>     / LAYER/
>     / DEBUG 5/
>     /  NAME "strom"/
>     /  TYPE POLYGON/
>     /  CONNECTIONTYPE OGR/
>     /  CONNECTION "OCI:///:usr/pwd/@GSPP"/
>     /  DATA "TAALBF_NETZGEBIET"/
>     /  METADATA/
>     /   "ows_title" "xxx"/
>     /   "ows_abstract" "xxx"/
>     /   "ows_extent"   "523600 5549800 581900 5639700"/
>     /  END/
>     /  CLASS/
>     /   STYLE/
>     /    OUTLINECOLOR 0 0 0/
>     /    COLOR 255 0 0/
>     /    WIDTH 2/
>     /   END/
>     /  END/
>     / END/
> 
> I work on Windows Server 2012 Datacenter with Mapserver 6.4.1 and GDAL
> 1.11.0 (from release-1600-x64-gdal-1-11-mapserver-6-4).
> I have also tested older versions. without success.
> 
> I set a lot of system variables:
> set path=C:\Apps\Oracle.112.x64\bin;
> set ORACLE_HOME=C:\Apps\Oracle.112.x64
> set GDAL_DRIVER_PATH=D:\webgis\mapserver-6-4-1\bin\gdal\plugins
> set GDAL_DATA=D:\Temp\mapserver-6-4-1\bin\gdal-data
> set LD_LIBRARY_PATH=C:\Apps\Oracle.112.x64\lib;
> set TNS_ADMIN=C:\Apps\Oracle.112.x64\network\ADMIN
> set ORACLE_SID=GSPP
> set ORACLE_BASE=C:\Apps\Oracle.112.x64
> 
> Why the mapserver gives me no bitmap?
> 
> Thanks a lot
> 
> Dietmar
> 
> 
>