I'm trying to run ogr2ogr from a PHP script. This runs fine, if the script is
run from the command line. It does not work if run through the web server.
The scripts basically runs:
/usr/local/bin/ogr2ogr -f 'ESRI Shapefile'
'/tmp/tmp_plant_cfa4f818c6c5c1e7881b' 'OCI:plantmap/plantm...@plantmap' -sql
'SELECT * FROM tmp_plant_cfa4f818c6c5c1e7881b' -nln plant
and returns the error:
ERROR 1: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
in <unnamed>
ORACLE_HOME, ORACLE_SID, ORACLE_HOME are set in the web server init script (the
whole application runs with Oracle).
I tried to enforce the variables in the virtual host fragment in httpd.conf:
SetEnv ORACLE_HOME /u01/app/oracle/product/11.1.0/db_1
SetEnv ORACLE_SID plantmap
SetEnv ORACLE_OWNER oracle
If I run a little test script, like:
#!/bin/sh
echo $ORACLE_HOME
echo $ORACLE_SID
echo $LD_LIBRARY_PATH
the environment variables are set correctly.
So why can't ogr2ogr find the correct Oracle instance?
Platform: RHEL 5, 64 bit, Oracle 11.1
Regards,
Peter Hopfgartner
R3 GIS Srl - GmbH
http://www.r3-gis.com
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev
