nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Connecting database from a wft file.

phanee

I am using Teamsite 6.7.1.Sp1 on Solaris 10 and oracle 10g database.

I am having trouble connecting to the oracle 10 g DB.

I face a issue stating.

install_driver(Oracle) failed: Can't load '/app/iw-home/iw-perl/site/lib/auto/DBD/Oracle/Oracle.so' for module DBD: Smiley Surprised

racle: ld.so.1: perl: fatal: /app/oracle/product/10gcli/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64 at /app/iw-home/iw-perl/lib/DynaLoader.pm line 229.
at (eval 55) line 3
Compilation failed in require at (eval 55) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /app/iw-home/custom/entitlement/pm/entitlement_modules.pm line 104

from the earlier threads I could find out that this was an environment variable related issue, so as advised I had set the oracle environment variable

ORA_NLS
ORACLE_HOME
NLS_LANG
LD_LIBRARY_PATH

in my perl files Begin{..} block.


BEGIN
{
    my %ora_config = IcmsCommon::ICMScfgreader('Oracle_Env',undef,'entitlement');
 $ENV{ORA_NLS}=$ora_config{ORA_NLS};
 $ENV{ORACLE_HOME}=$ora_config{ORACLE_HOME};
 $ENV{NLS_LANG}=$ora_config{NLS_LANG};

    my $need=$ora_config{LD_LIBRARY_PATH};
    my $ld= $ENV{LD_LIBRARY_PATH};
    if(  ! $ld  ) {
        $ENV{LD_LIBRARY_PATH}= $need;
    } elsif(  $ld !~ m#(^|\Q$need\E($)#  ) {
        $ENV{LD_LIBRARY_PATH} .= ':' . $need;
    } else {
        $need= "";
    }

    if(  $need  ) {
        exec '/usr/bin/env', $^X, $0, @ARGV;
    }
}

This worked well for inline and call server related ipl files.
But when I try to connect to the DB after setting these variable through wft files in template_script part I face an error stating

"ERROR: you must specify a template"

I debuged and found out that this is because of the "exec '/usr/bin/env', $^X, $0, @ARGV;" code in the Begin block which i need in order to programaticaly set the LD_LIBRARY_PATH env variable.

Anybody could suggest an alternative solution for this issue,
I am struggling with this for 2 days.

Find more posts tagged with

Comments

ISCBorisB

I [...] found out that this is because of the "exec '/usr/bin/env', $^X, $0, @ARGV;"...

Of course it is! You absolutely can not run this hack within WFT Code to reload cached LD_LIBRARY_PATH.

$0 in your case is iwwft_instantiator, it tries to obtain request information from non-existing CGI's STDIN and complains,
sure enough. Remove "Talk to DB" code from the WFT altogether, make it a dedicated script that prints what you need into STDOUT.
Execute from WFT and go from there

Adam Stoller

You seem to have a significant amount of custom code intermixed with "standard" code in your BEGIN block.
Without seeing all the code and being able to run it in an environment in which it is supposed to work - it's kind of difficult to tell what might be going wrong here.
Are you sure you need all of that stuff in your BEGIN block? Have you tried something like:

BEGIN {
    my %ora_config = IcmsCommon::ICMScfgreader('Oracle_Env', undef, 'entitlement');

    $ENV{ORA_NLS}         ||= $ora_config{ORA_NLS};
    $ENV{ORACLE_HOME}     ||= $ora_config{ORACLE_HOME};
    $ENV{NLS_LANG}        ||= $ora_config{NLS_LANG};
    $ENV{LD_LIBRARY_PATH} ||= $ora_config{LD_LIBRARY_PATH};
};
use DBD:racle;
...

This assumes the problem is not in this IcmsCommon library.

Valentine

You are calling /usr/bin/env from Perl,
- which will create a new shell
- modify the environment
- close the shell

All you need is to set

$ENV{'LD_LIBRARY_PATH'} to the appropriate balue

ISCBorisB

All you need is to set

$ENV{'LD_LIBRARY_PATH'} to the appropriate value

Nope, won't work. At this point 'LD_LIBRARY_PATH' is already cached by the Loader. You'll change it, sure enough - but that's too late.
It is actually why phanee used this "run it again!" hack in the first place

phanee

Hi guys thanks for the reply
Ghoti IcmsCommon module does not cause any issue.
I have even tried hard coding the env path in the BEGIN{..} block.

For now I am forced to use ISCBorisB solution to call a separate ipl from the WFT to connect to DB.

Thanks for the solution.