Error installing OTRS with Oracle 11g

Moderator: crythias

Locked
josotr
Znuny newbie
Posts: 6
Joined: 30 Jun 2015, 00:48
Znuny Version: OTRS 6
Real Name: Jose Chinchilla
Company: GBSYS

Error installing OTRS with Oracle 11g

Post by josotr »

Hi, I am trying to connect OTRS 4 with Oracle Database version 11.2.0.4.

So after installation, via console I can connect to database, but when I try to configure the database using OTRS Webpage, its says:

"Can't connect to database, Perl module DBD::Oracle not installed!"

So, I don't know why is this error because I have installed DBD::Oracle via cpan, and as I say if I do:

export ORACLE_HOME=/usr/lib/oracle/11.2/client64
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

I can connect via terminal.

Any help would be appreciated. Thanks for your help.
You do not have the required permissions to view the files attached to this post.
root
Administrator
Posts: 4253
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: Error installing OTRS with Oracle 11g

Post by root »

The webserver also needs the ORACLE_HOME and other relevent environment variables. Check the apache config, there must be placeholders for them.
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
josotr
Znuny newbie
Posts: 6
Joined: 30 Jun 2015, 00:48
Znuny Version: OTRS 6
Real Name: Jose Chinchilla
Company: GBSYS

Re: Error installing OTRS with Oracle 11g

Post by josotr »

Hi, thank you very much for your answer, I have exported variables in httpd.conf file and OTRS configuration web page still not working.

I have exported ORACLE_HOME and LD_LIBRARY_PATH as the attached image. Also they are in /opt/otrs/Kernel/Config.pm

Thanks
You do not have the required permissions to view the files attached to this post.
josotr
Znuny newbie
Posts: 6
Joined: 30 Jun 2015, 00:48
Znuny Version: OTRS 6
Real Name: Jose Chinchilla
Company: GBSYS

Re: Error installing OTRS with Oracle 11g

Post by josotr »

Ok, for the moment I've solved the problem I exported variables in /etc/sysconfig/httpd now OTRS is connected to database.

Thanks all.
Locked