Re: [otrs] Problem with Otrs and Oracle

11 Feb 2009

      Just knee-jerk responses/guesses...

* Check that otrs user/apache has perms to the lib
* verify that the otrs (database) user has appropriate permissions to
database
* verify that the perl oracle module is installed (DBD::Oracle)
* did u restart otrs (yeah I know)

I would think that check modules will verify most of this? but that is an
assumption.

Figure you'll see this but you defined the ORACLE_HOME var twice.

LQ

  _____  

From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of
Gianni Bracali
Sent: Wednesday, February 11, 2009 12:25 PM
To: otrs@otrs.org
Subject: [otrs] Problem with Otrs and Oracle

Hi to all.

I successfully installed OTRS 2.1.7 on openSUSE 10.3 and MySql. (Linux svrhd
2.6.22.19-0.2-default #1 SMP 2008-12-18 10:17:03 +0100 i686 i686 i386
GNU/Linux)

Now I'm trying to make Otrs work with Oracle, for database consolidation
purpouse.

I installed Oracle client and DBD::Oracle. Running bin/CheckDB.pl says "It
looks Ok!".

When I try to open the application from the web browser (index.pl) I get
this error:

ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Wed Feb 11 18:02:40 2009

Message: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var  or PATH
(Windows) and or NLS settings, permissions, etc.

Traceback (3105):

   Module: Kernel::System::DB::new (v1.57) Line: 172

   Module: Kernel::System::Web::InterfaceAgent::Run (v1.17.2.1) Line: 145

   Module:
ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler
(v) Line: 47

   Module: (eval) (v1.81) Line: 204

   Module: ModPerl::RegistryCooker::run (v1.81) Line: 204

   Module: ModPerl::RegistryCooker::default_handler (v1.81) Line: 170

   Module: ModPerl::Registry::handler (v1.99) Line: 31

This is the content of Config.pl

    # ---------------------------------------------------- #

    # ---------------------------------------------------- #

    #                                                      #

    #         Start of your own config options!!!          #

    #                                                      #

    # ---------------------------------------------------- #

    # ---------------------------------------------------- #

    $ENV{ORACLE_HOME} = '/opt/oracle/product/10.2.0/client_1';

    $ENV{NLS_DATE_FORMAT} = 'YYYY-MM-DD HH24:MI:SS';

    $ENV{NLS_LANG} = 'GERMAN_GERMANY.UTF8';

    $ENV{ORACLE_BASE}='/opt/oracle/product';

    $ENV{ORACLE_HOME}='/opt/oracle/product/10.2.0/client_1';

    $ENV{LD_LIBRARY_PATH}='/opt/oracle/product/10.2.0/client_1/lib';

    $ENV{ORACLE_SID}='REDB';

    # ---------------------------------------------------- #

    # database settings                                    #

    # ---------------------------------------------------- #

    # DatabaseHost

    # (The database host.)

    $Self->{'DatabaseHost'} = '172.25.43.11';

    # Database

    # (The database name.)

    $Self->{'Database'} = 'REDB';

    # DatabaseUser

    # (The database user.)

    $Self->{'DatabaseUser'} = 'otrs';

    # DatabasePw

    # (The password of database user. You also can use bin/CryptPassword.pl

    # for crypted passwords.)

    $Self->{'DatabasePw'} = 'otrs1234';

    # DatabaseDSN

    # (The database DSN for MySQL ==> more: "man DBD::mysql")

    #$Self->{DatabaseDSN} =
"DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};";

    # (The database DSN for Oracle ==> more: "man DBD::oracle")

     $Self->{DatabaseDSN} =
"DBI:Oracle:sid=$Self->{Database};host=$Self->{DatabaseHost};port=1521;";

I tought about an environment problem, so I added the following lines in
/etc/environment, but nothing changed:

ORACLE_BASE=/opt/oracle/product

ORACLE_HOME=/opt/oracle/product/10.2.0/client_1

LD_LIBRARY_PATH=/opt/oracle/product/10.2.0/client_1/lib

ORACLE_SID=REDB

NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'

NLS_LANG="GERMAN_GERMANY.UTF8"

Any suggestions?

Thanks

Gianni

Re: [otrs] Problem with Otrs and Oracle

LQ Marshall