http://www.perlmonks.org?node_id=848019


in reply to Connecting to Oracle DB using DBI from CGI script

Tell us how it fails. Compare environment variables, and adapt them.
  • Comment on Re: Connecting to Oracle DB using DBI from CGI script

Replies are listed 'Best First'.
Re^2: Connecting to Oracle DB using DBI from CGI script
by netcooluser (Initiate) on Jul 05, 2010 at 09:52 UTC
    https://servername.com:16316/ibm/console/webtop/cgi-bin/oracle_reporter2.cgi I am getting the blank page after this i.e Netcool : Historical Report Version 2.0 I am setting the environment like the one explained below $ENV{'ORACLE_HOME'}="/u01/app/oracle/product/10.2.0/client_1"; $ENV{ORACLE_SID}=$ORACLE_SID; $ENV{'LANG'}="C"; $ENV{'LD_LIBRARY_PATH'}="/u01/app/oracle/product/10.2.0/client_1/lib"; Please guide on this
[reply]
[reply]
[d/l]

      If you set up Oracle environment variables inside a script that loads the Oracle client libraries, you have to set up the variables before the libraries are loaded:

      • You can set up %ENV in a BEGIN block, at least before loading DBD::Oracle implicitly via DBI->connect() or explicitly, better even before loading DBI.
      • You can wrap your script in a shell script that sets the variables before passing control to your script via exec.
      • You can add PassEnv or SetEnv directives to the Apache configuration.

      I prefer the last way, so no script has to be modified and all scripts automatically get the right Oracle configuration.

      Alexander

      --
      Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)
[reply]
[d/l]
[select]
      The first thing I always check when CLI works but web doesn't, is that I have my Content-Type line correct.
      You need two newlines after it: 
      print "Content-Type: text/html\n\n";

      [download]
      At least about 60% of the time for me, that fixes my main issue of not seeing anything, or rendering the page as text rather than html.
      Definitely check out marto's links, those are nice tutorials.
[reply]
[d/l]
        The below is a piece of code what we have in the environment 
        #!/usr/bin/perl
use DBI;
use Date::Manip;
#use String::Substrings;
use Fcntl; #The Module


$ENV{'ORACLE_HOME'}="/u01/app/oracle/product/10.2.0/client_1";
$ENV{'LD_LIBRARY_PATH'}="/u01/app/oracle/product/10.2.0/client_1/lib";
print "content-type: text/html \n\n";
print "<font face=verdana size=3><b>Netcool : Historical Report Versio
+n 2.0</b></font><hr size=1 noshade color=white>";
##-----------database connection ####################
$dbh = DBI->connect('dbi:Oracle:orcl','username','password', { RaiseEr
+ror => 1, AutoCommit => 0 }) or die "\n----------Unable for connect t
+o server $DBI::errstr\n";

        [download]
        I am using https protocol for accessing the url https://servername.com:16316/ibm/console/webtop/cgi-bin/oracle_reporter2.cgi. Please suggest any modification to be done.

        20100706 Janitored by Corion: Added formatting, code tags, as per Writeup Formatting Tips

[reply]
[d/l]

In Section Seekers of Perl Wisdom