[Mapserver-users] msOCIConnect() in msOracleSpatialLayerOpen(): OracleSpatial error.

[nakts at latnet.lv]

I don't have this  "PassEnv ORACLE_SID TWO_TASK....." line,-this don't want to 
work correctly - Apache2 says ".. [warn] PassEnv variable 
ORACLE_SID was undefined ..". This PassEnv line comes after SetEnv and 
LoadModule lines in my http.conf.
 
But i found that i can see these environment variables working correctly. From 
MapsServer application - if i write [ORACLE_HOME] in 
demo.html file it shows right C:\oracle\ora81 value. Also phpinfo(); shows those 
variables.
Maybe i have wrong values ? What values do you have ?
What problem could be else ?
Is somewhere some documentation about these variable things, which ones is 
needed. Where do you get from this info that variables must be 
set such way.... don't understand quite that all... :(
 
Thank you,
Ima
 
 
On Thu, 17 Apr 2003 10:39:35 +1000, <Timothy.Mackey at ga.gov.au> wrote:
 
Hi,
 
I also got this error, and traced it back to environment settings in Apache, for 
ORACLE_SID TWO_TASK TNS_ADMIN ORACLE_HOME.
 
Do you have this line in your httpd.conf?
PassEnv ORACLE_SID TWO_TASK TNS_ADMIN ORACLE_HOME
 
Also, you can look at the "printenv" CGI program that comes with Apache, to see 
if the variables your are setting in httpd.conf are getting 
to the shell Apache creates to run the CGI programs.
 
regards,
 
Tim Mackey
Webmaster
Geoscience Australia
timothy.mackey at ga.gov.au
http://www.ga.gov.au
 
 
 
-----Original Message-----
From: nakts at latnet.lv [mailto:nakts at latnet.lv]
Sent: Wednesday, 16 April 2003 7:49 PM
To: mapserver-users at lists.gis.umn.edu
Subject: [Mapserver-users] msOCIConnect() in msOracleSpatialLayerOpen():
OracleSpatial error.
 
 
Hello
 
msOCIConnect() in msOracleSpatialLayerOpen(): OracleSpatial error.
on Windows XP with
Oracle Client 8.1.7.
MapServer version 3.6.1  ..INPUT=ORACLESPATIAL ..
MapServer is on my local PC, Oracle DB - on other linux server.
Mapserver works fine with .shp files.
 
I can connect through SQPLUS, bu not this way:
LAYER
NAME "ielaaas"
STATUS DEFAULT
CONNECTIONTYPE oraclespatial
CONNECTION 'username.../pwd... at po1'
TYPE POLYGON
DATA "GEOM FROM SHP_CLIP96 USING SRID 82305"
CLASS
NAME "ielaaas"
COLOR 220 220 220
OUTLINECOLOR 0 0 0
END
END
 
I tried a lot of combinations in httpd.conf like:
LoadModule env_module modules/mod_env.so
...
<IfModule mod_env.c>
SetEnv ORACLE_SID po1
SetEnv ORACLE_HOME "C:\oracle\ora81"
SetEnv ORA_NLS33 "C:\oracle\ora81\ocommon\nls\ADMIN\DATA"
SetEnv LD_LIBRARY_PATH "C:\oracle\ora81\lib"
SetEnv TNS_ADMIN "C:\oracle\ora81\network\ADMIN"
</IfModule>
 
Where could be the problem, how to test what Mapserver is doing, how it tries to 
connect to DB ?
 
Thanks,
Ima
_______________________________________________
Mapserver-users mailing list
Mapserver-users at lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
 
_______________________________________________
Mapserver-users mailing list
Mapserver-users at lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users