[mapserver-users] ORACLE_HOME problem when using spawn-fcgi + mapserver
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' txtUnable 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
Re: [mapserver-users] ORACLE_HOME problem when using spawn-fcgi + mapserver
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.commailto: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.comhttp://55.gz.rd.mapking.com' host_addr='127.0.0.1' txtUnable 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.orgmailto: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
Re: [mapserver-users] ORACLE_HOME problem when using spawn-fcgi + mapserver
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' txtUnable 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