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
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
Thanks LQ, the problems seems to be the about permission on the perl module DBD Oracle. I got it to work by changing the group in httpd.conf to wheel. Since I am new to perl, how can grant permission to that libray to the www group? The mysql driver works, I think that s because the appropriate permission have been granted by the installation package Gianni _____ Da: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Per conto di LQ Marshall Inviato: mercoledì 11 febbraio 2009 18.59 A: 'User questions and discussions about OTRS.' Oggetto: Re: [otrs] Problem with Otrs and Oracle 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 Im 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
participants (2)
-
Gianni Bracali -
LQ Marshall