in reply to Perl, DBI, Oracle, Apache

In the readme for the DBD::Oracle module, it describes three or four environment variables that are necessary for the module to run properly (well, at least compile). Along with this, I am fairly certain that $ENV{LD_LIBRARY_PATH} needs to include the directory to the libclntsh.so file as listed. You may also be able to get away with running ldconfig.

Anyway, you may want to check on the actual existence of the above shared library, as you may have libclntsh.so.X.0 where X may not be 8.

I can't help you with Carp, but it seems like you should review the readme for DBD::Oracle to ensure all the proper environment variables are set. (Edit /etc/profile in RH7 to make them automatically available at every login). Carp may be dying on the error since the DBI generally sends out errors via $dbh->errstr.

ALL HAIL BRAK!!!

Replies are listed 'Best First'.
Re: Re: Perl, DBI, Oracle, Apache
by BigJoe (Curate) on Apr 24, 2001 at 23:26 UTC
    I do have the path set in the /etc/profile and in the httpd.conf file to allow the webserver to be able to access it. And the file is still there. If I run the standard script servername/printenv It does show the LD_LIBRARY_PATH still there. The file is also there and available to all users.

    --BigJoe

    Learn patience, you must.
    Young PerlMonk, craves Not these things.
    Use the source Luke.
[reply]
[d/l]
      This is the print out of the /cgi-bin/printenv on the machine
      DOCUMENT_ROOT="/var/www/html" GATEWAY_INTERFACE="CGI/1.1" 
HTTP_ACCEPT="image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, appl
+ication/vnd.ms-powerpoint, application/vnd.ms-excel, application/mswo
+rd, */*" 
HTTP_ACCEPT_ENCODING="gzip, deflate" 
HTTP_ACCEPT_LANGUAGE="en-us" 
HTTP_CONNECTION="Keep-Alive" 
HTTP_HOST="172.16.8.19" 
HTTP_USER_AGENT="Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)" 
LD_LIBRARY_PATH="/usr/local/OraHome/lib" 
ORACLE_HOME="/usr/local/OraHome" 
PATH="/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin" 
QUERY_STRING="" 
REMOTE_ADDR="172.16.X.XX" 
REMOTE_PORT="4978" 
REQUEST_METHOD="GET" 
REQUEST_URI="/cgi-bin/printenv" 
SCRIPT_FILENAME="/var/www/cgi-bin/printenv" 
SCRIPT_NAME="/cgi-bin/printenv" 
SERVER_ADDR="172.16.8.19" 
SERVER_ADMIN="root@localhost" 
SERVER_NAME="havoc" SERVER_PORT="80" 
SERVER_PROTOCOL="HTTP/1.1" 
SERVER_SIGNATURE="Apache/1.3.12 Server at havoc Port 80
\n" 
SERVER_SOFTWARE="Apache/1.3.12 (Unix) (Red Hat/Linux) mod_ssl/2.6.6 Op
+enSSL/0.9.5a mod_perl/1.24"

      [download]


      --BigJoe

      Learn patience, you must.
      Young PerlMonk, craves Not these things.
      Use the source Luke.
[reply]
[d/l]

In Section Seekers of Perl Wisdom