Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: Connecting to Oracle DB using DBI from CGI script

by moritz (Cardinal)
on Jul 05, 2010 at 06:24 UTC ( #848019=note: print w/ replies, xml ) Need Help??


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
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
      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";
      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.
        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";
        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

      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". ;-)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://848019]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (6)
As of 2014-07-31 00:05 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (241 votes), past polls