Thanks for your reply. Nginx doesn't have control on that. I've set the environment variable in spawn-fcgi (mapserver) startup script right from the beginning, and it's always there. As I said, I've checked spawn-fcgi's process environment, and can see the ORACLE_HOME is there.
On Wed, May 22, 2013 at 8:14 PM, richard.suema...@syncadd.com < richard.suema...@syncadd.com> wrote: > I could be wrong but I believe /etc/profile is only loaded when you > spawn a shell. You can try force the issue and set the oracle home in your > startup script for nginx and work backwards from there. > > Sent from my iPhone > > On May 22, 2013, at 1:38 AM, "Jackey Cheung" <cheung.jac...@gmail.com> > wrote: > > 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: > <msg time='2013-05-22T14:15:00.181+08:00' org_id='oracle' > comp_id='clients' > type='UNKNOWN' level='16' host_id='55.gz.rd.mapking.com' > host_addr='127.0.0.1'> > <txt>Unable to find environment variable: ORACLE_HOME > </txt> > </msg> > > 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 > >
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users