Re: I have a weird issue with a script running under cron

2014-02-20 Thread Peter J. Holzer
On 2014-02-19 11:14:30 -0800, Bill Ward wrote: Remember that use is a kind of BEGIN block. You have to set the ENV variables in a BEGIN block before the use line. Also, on several Unix-like systems (including Solaris and Linux/x86_64), changing LD_LIBRARY_PATH while a process is running has no

Re: I have a weird issue with a script running under cron

2014-02-20 Thread John D Groenveld
In message 20140220115644.gj10...@wsr.ac.at, Peter J. Holzer writes: You have to set LD_LIBRARY_PATH in a wrapper script. The OP should link his Oracle.so with the correct rpath so LD_LIBRARY_PATH is not required. I prefer to put ORACLE_HOME in a wrapper so I don't have to adjust every DBI

Re: I have a weird issue with a script running under cron

2014-02-20 Thread Bruce Johnson
On Feb 20, 2014, at 4:56 AM, Peter J. Holzer h...@wsr.ac.at wrote: On 2014-02-19 11:14:30 -0800, Bill Ward wrote: Remember that use is a kind of BEGIN block. You have to set the ENV variables in a BEGIN block before the use line. Also, on several Unix-like systems (including Solaris and

Re: I have a weird issue with a script running under cron

2014-02-19 Thread Bruce Johnson
Well, I’ve identified my solution, but I’m not entirely certain why it’s working. Setting the environment variables in a shell script wrapper around my perl script works. Despite %ENV being identical, when set within the perl script, I get the error, when set in the .sh wrapper it works. It

Re: I have a weird issue with a script running under cron

2014-02-19 Thread John D Groenveld
In message f661b815-79d0-4e56-af60-1cbe006c0...@pharmacy.arizona.edu, Bruce J ohnson writes: It appears to be that called modules via ‘use MODULE;’ do NOT share the environm ent of the calling perl script? No, it appears from this experiment as well as your experiment with modperl last fall that

Re: I have a weird issue with a script running under cron

2014-02-19 Thread Bill Ward
Remember that use is a kind of BEGIN block. You have to set the ENV variables in a BEGIN block before the use line. Sent from my phone (sorry if my reply is brief, ask me again when I'm at a real keyboard) On Feb 19, 2014 9:23 AM, Bruce Johnson john...@pharmacy.arizona.edu wrote: Well, I've

Re: I have a weird issue with a script running under cron

2014-02-18 Thread Jens Rehsack
Am 17.02.2014 um 23:43 schrieb Bruce Johnson john...@pharmacy.arizona.edu: On Feb 17, 2014, at 2:48 PM, John D Groenveld jdg...@elvis.arl.psu.edu wrote: In message 5302803c.4080...@triad.rr.com, Richie writes: Is LD_LIBRARY_PATH exported? It's hard to see whats going on without a

Re: I have a weird issue with a script running under cron

2014-02-18 Thread Martin J. Evans
On 17/02/14 18:50, Bruce Johnson wrote: On Feb 17, 2014, at 11:41 AM, Bruce Ferrell bferr...@baywinds.org wrote: Bruce, The error says your script is attempting to load /usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so for DBD::Oracle. is that the correct path for that library? it looks

Re: I have a weird issue with a script running under cron

2014-02-18 Thread Peter J. Holzer
On 2014-02-17 22:43:58 +, Bruce Johnson wrote: On Feb 17, 2014, at 2:48 PM, John D Groenveld jdg...@elvis.arl.psu.edu wrote: The OP shouldn't need to set a LD_LIBRARY_PATH so long as he built DBD::Oracle with the correct runtime link path, but a simple shell script to see which

Re: I have a weird issue with a script running under cron

2014-02-18 Thread John D Groenveld
In message 20140218110257.ga10...@wsr.ac.at, Peter J. Holzer writes: Yes, so obviously you should run John's little script via cron, too. What is the result? My guess is the OP still hasn't realized that his interactive shell environment is different then his cron and Apache's.

Re: I have a weird issue with a script running under cron

2014-02-18 Thread Bruce Johnson
On Feb 18, 2014, at 4:02 AM, Peter J. Holzer h...@wsr.ac.at wrote: On 2014-02-17 22:43:58 +, Bruce Johnson wrote: On Feb 17, 2014, at 2:48 PM, John D Groenveld jdg...@elvis.arl.psu.edu wrote: The OP shouldn't need to set a LD_LIBRARY_PATH so long as he built DBD::Oracle with the

Re: I have a weird issue with a script running under cron

2014-02-18 Thread John D Groenveld
In message 2076ef99-9f11-4eda-846a-f0a946e85...@pharmacy.arizona.edu, Bruce J ohnson writes: Via cron (with the Oracle environment variables set as in the script in questi on, please read the OP!): SHELL=/bin/sh USER=root LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_SID=PHMWEB

Re: I have a weird issue with a script running under cron

2014-02-18 Thread Bruce Johnson
On Feb 18, 2014, at 10:47 AM, John D Groenveld jdg...@elvis.arl.psu.edu wrote: In message 2076ef99-9f11-4eda-846a-f0a946e85...@pharmacy.arizona.edu, Bruce J ohnson writes: Via cron (with the Oracle environment variables set as in the script in questi on, please read the OP!):

Re: I have a weird issue with a script running under cron

2014-02-17 Thread Bruce Ferrell
Bruce, The error says your script is attempting to load /usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so for DBD::Oracle. is that the correct path for that library? it looks like you built DBD::Oracle against the Oracle occi libraries and those are often in different locations than the

Re: I have a weird issue with a script running under cron

2014-02-17 Thread Jens Rehsack
Hi Bruce, Am 17.02.2014 um 19:30 schrieb Bruce Johnson john...@pharmacy.arizona.edu: I get the following error: install_driver(Oracle) failed: Can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libocci.so.11.1: cannot open shared object file: No such

Re: I have a weird issue with a script running under cron

2014-02-17 Thread Richie
Is LD_LIBRARY_PATH exported? It's hard to see whats going on without a full test case. On 2/17/2014 1:50 PM, Bruce Johnson wrote: On Feb 17, 2014, at 11:41 AM, Bruce Ferrell bferr...@baywinds.org wrote: Bruce, The error says your script is attempting to load

Re: I have a weird issue with a script running under cron

2014-02-17 Thread John D Groenveld
In message 5302803c.4080...@triad.rr.com, Richie writes: Is LD_LIBRARY_PATH exported? It's hard to see whats going on without a full test case. The OP shouldn't need to set a LD_LIBRARY_PATH so long as he built DBD::Oracle with the correct runtime link path, but a simple shell script to see

Re: I have a weird issue with a script running under cron

2014-02-17 Thread Bruce Johnson
On Feb 17, 2014, at 2:48 PM, John D Groenveld jdg...@elvis.arl.psu.edu wrote: In message 5302803c.4080...@triad.rr.com, Richie writes: Is LD_LIBRARY_PATH exported? It's hard to see whats going on without a full test case. The OP shouldn't need to set a LD_LIBRARY_PATH so long as he

RE: I have a weird issue with a script running under cron

2014-02-17 Thread L Y Lam
: dbi-users@perl.org (dbi-users@perl.org) Subject: Re: I have a weird issue with a script running under cron On Feb 17, 2014, at 2:48 PM, John D Groenveld jdg...@elvis.arl.psu.edu wrote: In message 5302803c.4080...@triad.rr.com, Richie writes: Is LD_LIBRARY_PATH exported? It's hard to see whats