hello
> When I run a below perl script from the command line, it works, but,
> when I run it under the Apache web server, it fails!'' Why keep in
> mind that i'm using Linux Red Had 6.5 with oracle 8.i and perl 5.6.0
> with DBI version1.13, and DBD version 1.08
> #!/usr/bin/perl -I /usr/local/lib/perl5/
> use FCGI;
> use DBI;
> use DBD::Oracle qw(:ora_types);
> my $counter;
> REQUEST: while (FCGI::accept() >=0) {
> print "Content-type: text/html\r\n\r\n";
> print '<html> <body>';
> print '<br><h2>'. $counter++ . '</h2><br>';
> print '</body></html>';
> print "\n";
> }
>
> when i remove # use DBD::Oracle qw(:ora_types); it work fine but
> i need it in my code i but this as a sample code could u please help
> me in this
> and please keep in u'r mind that i but this line in httpd.config for
> the apache web server :
> SetEnv LD_LIBRARY_PATH "/opt/oracle/product/8.1.6/lib"
> SetEnv LD_RUN_PATH "/opt/oracle/product/8.1.6/lib"
> SetEnv NLS_LANG "AMERICAN_AMERICA.UTF8"
> SetEnv NLS_DATE_FPRMAT "YYYY-MM-DD HH24:MI:SS"
> SetEnv ORACLE_HOME "/opt/oracle/product/8.1.6"
> SetEnv ORACLE_SID "amm"
> ############################### FastCGI Start ####################
> FastCgiIpcDir /home/tmp
> AddHandler fastcgi-script fcgi
> <Directory "/home/hussam/SmsWapChat/wap/">
> SetHandler fastcgi-script
> </Directory>
> FastCGIConfig -restart -restart-delay 10 -maxclassprocesses 1
> -listen-queue-depth 10
> FastCGIServer /home/hussam/SmsWapChat/wap/test/hello.fcgi
> -processes 1 -listen-queue-depth 10
>
>
> thanx for u'r help
