Issues starting RT

RT Users
1

Hi Guys,

I have a setup RHEL 4.5 ES/ Oracle XE/RT 3.6.4 … I am getting this
error starting the httpd daemon.

Any ideas would be great…

Thanks

Tamer

[warn] FastCGI: server “/opt/rt3/bin/mason_handler.fcgi” has failed to
remain running for 30 second

s given 3 attempts, its restart interval has been backed off to 600
seconds

[Wed Sep 12 15:13:51 2007] [warn] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" restarted

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

2

I looked at /usr/lib/perl5 , all folders/subfolders are owned by root. Permission 755From: Ham MI-ID, Torsten Brumm [mailto:torsten.brumm@Kuehne-Nagel.com]
Sent: Wednesday, September 12, 2007 4:31 PM
To: Tamer Tayea; rt-users@lists.bestpractical.com
Subject: AW: RE: [rt-users] issues starting RT

Hi tamer
Check the permissions of the installed perl modules i bet the have 770 onwed by root.

Apache can’t access them.

Torsten

3

[…]

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@stillsecure.com
303-381-3802 main support line
303-381-3824 my voicemail
303-381-3880 fax

www.stillsecure.com

4

I checked most of the files under /usr/lib/perl5 and they seems to be fine…

The system was working fine with MySql , I installed Oracle XE , recompiled RT with Oracle support … Then, I started getting these errors…

First error message appears once in the error.log

[warn] FastCGI: server “/opt/rt3/bin/mason_handler.fcgi” has failed to remain running for 30 second

s given 3 attempts, its restart interval has been backed off to 600 seconds

[Wed Sep 12 15:13:51 2007] [warn] FastCGI: server “/opt/rt3/bin/mason_handler.fcgi” restarted

Then I get several error like the following :

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 220From: Ham MI-ID, Torsten Brumm [mailto:torsten.brumm@Kuehne-Nagel.com]
Sent: Wednesday, September 12, 2007 5:46 PM
To: Tamer Tayea; rt-users@lists.bestpractical.com
Subject: AW: RE: RE: [rt-users] issues starting RT

And files? Btw, if you restart, whats the first entry at the log?

Torsten

5

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@stillsecure.com]
Sent: Wednesday, September 12, 2007 6:49 PM
To: Tamer Tayea
Cc: rt-users@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@stillsecure.com
303-381-3802 main support line
303-381-3824 my voicemail
303-381-3880 fax

www.stillsecure.com

6

Hi Guyes ,

To resolve issues I had earlier with RT/Oracle installation, I had to go
over the installation guide from scratch … May be I overlooked
something in my fist installation…

Issue is resolved now.,…

Thanks

TamerFrom: Ole Craig [mailto:ocraig@stillsecure.com]
Sent: Thursday, September 13, 2007 1:51 PM
To: Tamer Tayea; RT-Users
Subject: RE: [rt-users] issues starting RT

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. :slight_smile: