[mapserver-users] ORACLE_HOME problem when using spawn-fcgi + mapserver

2013-05-21 Thread Jackey Cheung
Hi,

I'm setting up a nginx + spawn-fcgi + mapserver centos box.I've installed
everything. The web site (nginx) is working, Oracle is working fine and
returning spatial data, shp2img generates pictures from Oracle data well,
and everything just seem working well. Unless I put them all together.

Requesting map image from the box in browser and I get this:
msDrawMap(): Image handling error. Failed to draw layer named 'BLD_BLDG'.
msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI
Handlers. Connection failure. Check the connection string. Error: .

I've tried strace and checked the oracle trace log, and found this in the
oracle log:

 Unable to find environment variable: ORACLE_HOME
 


I've change the mapserver process to use oracle user, and I've then checked
the spawn-fcgi process environment at /proc/ directory and see that there
are variables in it. I've even tried adding ORACLE_HOME variable to
/etc/profile, but still can't get it working.

What is wrong? Or what have I missed?

P.S. I could have post the whole strace log here, but it's too long so if
anyone really need it to get a clue, just give a mail to me.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


Re: [mapserver-users] FOSS4G NA

2013-05-21 Thread Daniel Morissette

Hi Rich

We' re a small group upstairs at Brit's Pub on Nicolet Mall ( between 11th 
and 12th strert )


Daniel



Le 21 mai 2013 16:24:49 Richard Greenwood  a 
écrit :

Anyone drinking a beer tonight? Where?

Sent from my mobile
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


[mapserver-users] FOSS4G NA

2013-05-21 Thread Richard Greenwood
Anyone drinking a beer tonight? Where?

Sent from my mobile
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users