Hi fellows.
I'm banging my head on this problem for a month, and posted on London
PM without a good clue. Maybe you folks can help me a little bit more.
I need to connect Best Pratical's RT 3.4.4 to an Oracle 10g Database
running on the same box. I'm using the mod_perl 1.29 and apache 1.3.34,
and running perl 5.8.5.
The RT configuration was easy, and I generated the database structure
using user root (with the proper environment variables set) without a
single annormal incident.
Now, trying to start apache web server, I only get errors like this
one:
-----------------------------------------------------------------------
$VAR1 = {
'NLS_LANG' => 'AMERICAN_AMERICA.AL32UTF8',
'SCRIPT_NAME' => '',
'SERVER_NAME' => 'suporte.farmasa.local',
'ORACLE_HOME' => '/opt/oracle/software/10.2.0.1',
'NLS_NCHAR' => 'AL32UTF8',
'SERVER_ADMIN' => '[EMAIL PROTECTED]',
'HTTP_ACCEPT_ENCODING' => 'gzip, deflate',
'PATH_INFO' => '/',
'HTTP_CONNECTION' => 'Keep-Alive',
'REQUEST_METHOD' => 'GET',
'HTTP_ACCEPT' => '*/*',
'SCRIPT_FILENAME' => '/usr/local/rt/share/html',
'SERVER_SOFTWARE' => 'Apache/1.3.34 (Unix) mod_perl/1.29',
'QUERY_STRING' => '',
'REMOTE_PORT' => '2045',
'HTTP_USER_AGENT' => 'Mozilla/4.0 (compatible; MSIE 6.0;
Windows NT 5.1; SV1; .NET CLR 1.1.4322)',
'SERVER_SIGNATURE' => '<ADDRESS>Apache/1.3.34 Server at
suporte.farmasa.local Port 80</ADDRESS>
',
'SERVER_PORT' => '80',
'ORACLE_SID' => 'DEVEL',
'HTTP_ACCEPT_LANGUAGE' => 'pt-br',
'REMOTE_ADDR' => '192.168.87.175',
'SERVER_PROTOCOL' => 'HTTP/1.1',
'PATH' => '/bin:/usr/bin',
'REQUEST_URI' => '/',
'GATEWAY_INTERFACE' => 'CGI-Perl/1.1',
'SERVER_ADDR' => '192.168.87.20',
'DOCUMENT_ROOT' => '/usr/local/rt/share/html',
'PATH_TRANSLATED' => '/usr/local/rt/share/html/',
'HTTP_HOST' => 'suporte',
'MOD_PERL' => 'mod_perl/1.29'
};
DBI connect('DEVEL','rt',...) failed: ERROR OCIEnvNlsCreate (check
ORACLE_HOME and NLS settings etc.) at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 108
[Fri Dec 9 16:27:29 2005] [error] Connect Failed ERROR OCIEnvNlsCreate
(check ORACLE_HOME and NLS settings etc.)\n at /usr/local/rt/lib/RT.pm
line 176\n
-----------------------------------------------------------------------
I've arranged so the env variables get Data::Dump()'ed to the STDERR,
so I can register them on logs just before trying to stablish a
connection.
Please help me. I don't know what to try next.
Thanks
--
Luis Campos de Carvalho
DBA Oracle - FARMASA
Esta mensagem tem como destinatario exclusivo a pessoa ou organizacao a que
esta dirigida e pode conter informacoes confidenciais que nao podem ser
divulgadas. Se voce recebeu esta mensagem por engano, lhe e vetado divulgar,
distribuir ou copiar a informacao aqui contida. Ficaremos gratos se voce
notificar o erro imediatamente por e-mail ao remetente e apagar esta mensagem
de seu sistema. Obrigado pela sua cooperacao.
This e-mail is meant only for the intended recipient of the transmission, and
may be a communication privileged by law. If you received this e-mail in error,
any review, use, dissemination, distribution or copying of this e-mail is
strictly prohibited. Please notify us immediately of the error by return e-mail
and please delete this message from your system. Thank you in advance for your
cooperation.
