[rt-users] issues starting RT

[Ole Craig]

Tamer -
    I don't actually use Oracle as my RT backend, I just have scars from
working with Oracle in a previous lifetime. There are several people on
the list who do use it, so one of them may have more useful
suggestions... But since you're asking me: 

    I'd put the variables into the daemon startup sequence. If you're
using a RedHat (or CentOS) system, you could just shove the variable
declarations into /etc/sysconfig/httpd since that will be dot-included
by the init script.

	Cheers,
		Ole

PS. Please try to keep the list CC'd, since my suggestions may be way
off-base and if we keep the conversation public that gives the rest of
the listmembers the chance to call shenanigans on me, which benefits
both of us. :-)

On Thu, 2007-09-13 at 10:01 -0400, Tamer Tayea wrote:
> Hi ,
> 
> The apache user has no login in /etc/passwd .. Where do I need to put
> all oracle ENV Variables..
> 
> Thanks
> 
> Tamer
> 
> -----Original Message-----
> From: Ole Craig [mailto:ocraig at stillsecure.com] 
> Sent: Wednesday, September 12, 2007 6:49 PM
> To: Tamer Tayea
> Cc: rt-users at lists.bestpractical.com
> Subject: RE: [rt-users] issues starting RT
> 
> On Wed, 2007-09-12 at 16:18 -0400, Tamer Tayea wrote:
> [...]
> > DBI connect('rt3','root',...) failed: ERROR OCIEnvNlsCreate. Check
> > ORACLE_HOME env var, NLS settings, permissions, etc.
> > at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line
> > 106
> > 
> > Connect Failed ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS
> > settings, permissions, etc.
> > 
> >  at /opt/rt3/lib/RT.pm line 220
> 
> Tamer -
>     IIRC, Oracle requires a bunch of environment variables before you
> can connect successfully. Did you make sure that those environment
> variables are set for the apache process that runs RT?
> 
-- 
/Ole Craig
Security Engineer
Team lead, customer support

ocraig at stillsecure.com
303-381-3802 main support line
303-381-3824 my voicemail
303-381-3880 fax

www.stillsecure.com