Installing OTRS with Oracle 11g Server Linux

[dushyantmdave]

Hello I am trying to install OTRS with oracle 10g on Linux but I am not able to connect with oracle please guide...

o CGI..............................ok (v3.63)
o Crypt::PasswdMD5.................ok (v1.3)
o Crypt::SSLeay....................ok (v0.64)
o CSS::Minifier....................ok (v0.01)
o Date::Format.....................ok (v2.24)
o Date::Pcalc......................ok (v1.2)
o DBI..............................ok (v1.618)
o DBD::mysql.......................ok (v4.020)
o DBD::ODBC........................ok (v1.41)
o DBD::Oracle......................ok (v1.56)
o DBD::Pg..........................Not installed! (optional - Required to connect to a PostgreSQL database.)
o Digest::MD5......................ok (v2.51)
o Digest::SHA::PurePerl............ok (v5.81)
o Digest::SHA......................ok (v5.62)
o Encode::HanExtra.................ok (v0.23)
o Encode::Locale...................ok (v1.03)
o GD...............................ok (v2.46)
o GD::Text.......................ok (v0.86)
o GD::Graph......................ok (v1.44)
o GD::Graph::lines...............ok (v1.15)
o GD::Text::Align................ok (v1.18)
o IO::Scalar.......................ok (v2.110)
o IO::Wrap.........................ok (v2.110)
o JavaScript::Minifier.............ok (v1.05)
o JSON.............................ok (v2.53)
o JSON::PP.......................ok (v2.27200)
o JSON::XS.......................ok (v2.32)
o Locale::Codes....................ok (v3.24)
o LWP::UserAgent...................ok (v6.04)
o Mail::Internet...................ok (v2.12)
o Mail::POP3Client.................ok (v2.18)
o IO::Socket::SSL................ok (v1.82)
o Mail::IMAPClient.................ok (v3.32)
o IO::Socket::SSL................ok (v1.82)
o MIME::Base64.....................ok (v3.13)
o MIME::Tools......................ok (v5.428)
o ModPerl::Util....................ok (v2.000007)
o Apache::DBI....................ok (v1.11)
o Apache2::Reload................ok (v0.12)
o Net::DNS.........................ok (v0.72)
o Net::POP3........................ok (v2.29)
o Net::IMAP::Simple................ok (v1.2034)
o IO::Socket::SSL................ok (v1.82)
o Net::SMTP........................ok (v2.31)
o Authen::SASL...................ok (v2.16)
o Net::SMTP::SSL.................ok (v1.01)
o Net::SMTP::TLS::ButMaintained..ok (v0.20)
o Net::LDAP........................ok (v0.53)
o Net::SSL.........................ok (v2.85)
o PDF::API2........................ok (v2.020)
o Compress::Zlib.................ok (v2.037)
o Storable.........................ok (v2.32)
o SOAP::Lite.......................ok (v0.715)
o version........................ok (v0.93)
o Class::Inspector...............ok (v1.28)
o Text::CSV........................ok (v1.21)
o Text::CSV_PP...................ok (v1.29)
o Text::CSV_XS...................ok (v0.95)
o Time::HiRes......................ok (v1.9724)
o XML::Parser......................ok (v2.41)
o HTTP::Message....................ok (v6.06)
o HTTP::Headers..................ok (v6.05)
o URI..............................ok (v1.60)
o URI::Escape....................ok (v3.31)
o Scalar::Util.....................ok (v1.23)
o YAML::XS.........................ok (v0.38)

Oracle files:
----------------
@$HOME_OTRS/scripts/database/otrs-schema.oracle.sql
$HOME_OTRS/scripts/database/otrs-initial_insert.oracle.sql
$HOME_OTRS/scripts/database/otrs-schema-post.oracle.sql

=======================================================
Please find the error logs as following :

/opt/otrs/bin/otrs.CheckDB.pl
Can't locate object method "new" via package "Kernel::System::DB::Oracle" (perhaps you forgot to load "Kernel::System::DB::Oracle"?) at /opt/otrs/Kernel/System/DB.pm line 169.
=============================================================
/opt/otrs/scripts/redhat-rcotrs start
Starting OTRS..
Checking httpd ... done.
Checking database connection... Can't locate object method "new" via package "Kernel::System::DB::Oracle" (perhaps you forgot to load "Kernel::System::DB::Oracle"?) at /opt/otrs/Kernel/System/DB.pm line 169.
Error!
Maybe your database isn't configured yet?

Thanks ,
Dushyant

[jojo]

show your Config.pm part for the database connection

[dushyantmdave]

Please find the Config.pm file :

# --
# Kernel/Config.pm - Config file for OTRS kernel
# Copyright (C) 2001-2012 xxx, http://otrs.org/
# --
# $Id: Config.pm.dist,v 1.27 2012/11/20 14:26:12 mh Exp $
# --
# This software comes with ABSOLUTELY NO WARRANTY. For details, see
# the enclosed file COPYING for license information (AGPL). If you
# did not receive this file, see http://www.gnu.org/licenses/agpl.txt.
# --
# Note:
#
# -->> OTRS does have a lot of config settings. For more settings
# (Notifications, Ticket::ViewAccelerator, Ticket::NumberGenerator,
# LDAP, PostMaster, Session, Preferences, ...) see
# Kernel/Config/Defaults.pm and copy your wanted lines into "this"
# config file. This file will not be changed on update!
#
# --

package Kernel::Config;

use utf8;

sub Load {
my $Self = shift;
# ---------------------------------------------------- #
# ---------------------------------------------------- #
# #
# Start of your own config options!!! #
# #
# ---------------------------------------------------- #
# ---------------------------------------------------- #

# ---------------------------------------------------- #
# database settings #
# ---------------------------------------------------- #
# DatabaseHost
# (The database host.)
$Self->{'SecureMode'} = '0';
$Self->{'DatabaseHost'} = 'localhost';
# Database
# (The database name.)
$Self->{'Database'} = 'otrs1';
# DatabaseUser
# (The database user.)
$Self->{'DatabaseUser'} = 'system';
# DatabasePw
# (The password of database user. You also can use bin/otrs.CryptPassword.pl
# for crypted passwords.)
$Self->{'DatabasePw'} = 'otra007';
# DatabaseDSN
# (The database DSN for MySQL ==> more: "man DBD::mysql")
# $Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};";
$Self->{DatabaseDSN} = "DBI:Oracle:sid=otrs1;host=localhost;port=1522;";

# (The database DSN for PostgreSQL ==> more: "man DBD::Pg")
# if you want to use a local socket connection
# $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};";
# if you want to use a tcpip connection
# $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};host=$Self->{DatabaseHost};";
# if you have PostgresSQL 8.1 or earlier, activate the legacy driver with this line:
# $Self->{DatabasePostgresqlBefore82} = 1;

# ---------------------------------------------------- #
# fs root directory
# ---------------------------------------------------- #
$Self->{Home} = '/opt/otrs';

# ---------------------------------------------------- #
# insert your own config settings "here" #
# config settings taken from Kernel/Config/Defaults.pm #
# ---------------------------------------------------- #
# $Self->{SessionUseCookie} = 0;
# $Self->{CheckMXRecord} = 0;

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

# ---------------------------------------------------- #
# data inserted by installer #
# ---------------------------------------------------- #
# $DIBI$

# ---------------------------------------------------- #
# ---------------------------------------------------- #
# #
# End of your own config options!!! #
# #
# ---------------------------------------------------- #
# ---------------------------------------------------- #
}

# ---------------------------------------------------- #
# needed system stuff (don't edit this) #
# ---------------------------------------------------- #
use strict;
use warnings;

use vars qw(@ISA $VERSION);
$VERSION = qw($Revision: 1.27 $)[1];

use Kernel::Config::Defaults;
push (@ISA, 'Kernel::Config::Defaults');

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

1;

[jojo]

does the otrs and webserver user have read permissions on the Oracle client?

[dushyantmdave]

I have installed Oracle 10g Server .....you mean to say I have to change the ownership?

[dushyantmdave]

I have set the follwoing parameters :
export PERL5LIB="/u01/oracle/product/10.2.0/perl/lib/site_perl/5.8.3/i686-linux-thread-multi/auto/DBD"
export ORACLE_HOME=/u01/oracle/product/10.2.0/

[jojo]

can the webserver user and the otrs user use the Oracle client? (Unix Permissions)

[dushyantmdave]

I am able to login sqlplus from root and also able to run OTRS from root
once I got success with opt/otrs/bin/otrs.CheckDB.pl but that time I am not able to do the WEB GUI because there is only one option MYSQL in GUI,
thats why I have reinstalled mysql and then starts making changes.

[jojo]

thats not an answer to my question.

Do you have any need to run OTRS on oracle? If no, use MySQL
Do you have any experience in running Webservers using Oracle DB via Perl? If no, use MySQL

[dushyantmdave]

I will connect the Oracle database connection....just want to know the GUI Connectivity.

[jojo]

does the otrs and webserver user have read permissions on the Oracle client?

[dushyantmdave]

OK let me know I am using ORACLE_HOME=/u01/instantclient_10_2....
is any documentation is there for the connectivity ?

[dushyantmdave]

Instant clinet has root:root permission
any need to change in DB.pm?

Can't locate object method "new" via package "Kernel::System::DB::Oracle" (perhaps you forgot to load "Kernel::System::DB::Oracle"?) at /opt/otrs/Kernel/System/DB.pm line 169.

[skullz]

Im using oracle 11 with otrs 3.11 on SLES..Here my some configuration..

1. Config.pm

Code: Select all

    
    $Self->{'DatabaseHost'} = 'localhost';
     $Self->{'Database'} = 'otrs';
    $Self->{'DatabaseUser'} = 'otrs';
     $Self->{'DatabasePw'} = 'otrs';
     $Self->{DatabaseDSN} = "DBI:Oracle:sid=$Self->{Database};host=$Self->{DatabaseHost};port=1521;"; 

   $ENV{ORACLE_HOME} = '/opt/oracle/product/11gR1/db';
    $ENV{NLS_DATE_FORMAT} = 'YYYY-MM-DD HH24:MI:SS';
    $ENV{NLS_LANG} = 'AMERICAN_AMERICA.utf8';

2. enable oracle path in /etc/apache2/conf.d/otrs.conf

3. Check DB Connection by terminal command perl /opt/otrs/bin/otrs.CheckDB.pl

4. enable oracle path or config in /opt/otrs/scripts/apache2-perl-startup.pl

Code: Select all

use DBD::Oracle ();
use Kernel::System::DB::oracle;

good luck..

[dushyantmdave]

OK..but how I can get GUI because there is only MYSQL option...?

[jojo]

don't use installer.pl if you don't want to use MySQL

[dushyantmdave]

Hi,

I got error:

Error Message: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH (Windows) and [..]

how to solve it ?

[jojo]

Set Oracle env for Apache and OTRS. Your DBA should be able to provide the needed data

[dushyantmdave]

I have update vi /etc/sysconfig/httpd
export ORACLE_BASE=/u01/app/oracle/
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=otrs
export LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/dbhome_1/lib
export ORACLE_USERID="otrs/otrs@otrs"

and the problem is solved !

Thanks a lot for Help !

[dushyantmdave]

A big thank you to skullz and jojo !!