[rt-users] Cron Issues....

[Jeff Stark]

Thanks, yes, actually I am expecting it to run as root. (I know bad
karma to follow) 

But I am just trying to get it working.  I have tried forcing the
loading of .bash_profile and have also tried adding the following to the
script:
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/client_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

But I still get this error:

Unable to load DBIx::SearchBuilder database handle for 'Oracle'.
Perhaps you've picked an invalid database type or spelled it
incorrectly.
Can't load
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/
Oracle.so' for module DBD::Oracle: libclntsh.so.10.1: cannot open shared
object file: No such file or directory at
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
 at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm
line 6
Compilation failed in require at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm line
6.
BEGIN failed--compilation aborted at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm line
6.
Compilation failed in require at (eval 207) line 1.
BEGIN failed--compilation aborted at (eval 207) line 1.
Compilation failed in require at /opt/rt3/lib/RT.pm line 201.


 
-  Stark



-----Original Message-----
From: John BORIS [mailto:jboris at adphila.org] 
Sent: Wednesday, July 11, 2007 3:43 PM
To: RT-Users at lists.bestpractical.com; sturner at MIT.EDU; Jeff Stark
Subject: Re: RE: [rt-users] Cron Issues....

This might be trivial but make sure the job is running the job as the
user you expect.  If cron.hourly is being executed as root then it may
be reading the wrong files to setup the environment.  

John J. Boris, Sr.
JEN-A-SyS Administrator
Archdiocese of Philadelphia
222 North 17th Street
Philadelphia, Pa. 19103
Tel: 215-965-1714
Fax: 215-587-3525
"Remember! That light at the end of the tunnel Just might be the
headlight of an oncoming train!"