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

[Jackey Cheung]

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.suematsu at syncadd.com <
richard.suematsu at 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.jackey at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20130523/8cfcff60/attachment.html>