[SOLVED] OTRS With Oracle DB

[skullz]

Hi all..Good Evening

Im trying to use otrs with oracle db

Ver: OTRS v3.1.11
Database: Oracle 11gR2
OS : Centos 32
DBD::Oracle installed via cpan

1. Connect to Database via perl script..OK


2. This is what happen when i open web browser to launch otrs


ANY IDEA??
Thanks in Advance

[reneeb]

You run the commandline tool as root user. I assume this is not the webserver user The webserver user has less privileges and not all environment variables set.

You can check it with

Code: Select all

[root@localhost]# perl -le 'print $_, " -> ", $ENV{$_} for sort keys %ENV'
[root@localhost]# sudo -u www-data perl -le 'print $_, " -> ", $ENV{$_} for sort keys %ENV'

replace www-data with the username that runs the webserver.

[skullz]

You run the commandline tool as root user. I assume this is not the webserver user The webserver user has less privileges and not all environment variables set.

You can check it with

Code: Select all

[root@localhost]# perl -le 'print $_, " -> ", $ENV{$_} for sort keys %ENV'
[root@localhost]# sudo -u www-data perl -le 'print $_, " -> ", $ENV{$_} for sort keys %ENV'

replace www-data with the username that runs the webserver.

thanks for your suggestion..Is there any way i can solve my problem above..

[reneeb]

Have you checked the environment variables? Are there any differences?

[crythias]

Look at Defaults.pm and copy edit to Config.pm

[skullz]

Look at Defaults.pm and copy edit to Config.pm

Have you checked the environment variables? Are there any differences?

Problem solved..
Look like my httpd sysconfig do not have oracle environment..
i added oracle environment and its working well..
thanks again..