[FASTCGI] FastCGI with Oracle

A. M. ArunKumar arun at eagle-india.com
Fri Dec 4 06:12:33 EST 2009

Thank you libo (I am not sure about the name, since it shows in chinese

The solution which you gave has helped me.  But its not after accept its
before that. we need to set it back in the C++ program.  I used the setenv
function in c++ and now its connecting to oracle.

Thanks for the timely reply.



From: 李波 [mailto:libo.868 at gmail.com]
Sent: Thursday, December 03, 2009 7:37 AM
To: A. M. ArunKumar
Subject: Re: [FASTCGI] FastCGI with Oracle

ha ha , i know the answer, ^_^

you should set oracle env at c++ source code after Accept() .because all env
will be cleared after Accept()

2009/12/2 A. M. ArunKumar <arun at eagle-india.com>


I am new to this FastCGI.  I have an issue in connecting to Oracle database
through fast CGI using my C++ program.  I get the error as “Cannot Create
OCI Environment”  The same program works fine without fast CGI.  The issue
happens to be only in FastCGI.

I defined the following SetEnvs to work in cgi-bin

<Location "/cgi-bin/">

  SetEnv ORACLE_BASE "/app/oracle"

  SetEnv ORACLE_HOME "/app/oracle/product/10.2.0/db_1"


  SetEnv OCILIB_INC "/usr/local/include"

  SetEnv OCILIB_LIB "/usr/local/lib"

  SetEnv LD_LIBRARY_PATH "/app/oracle/product/10.2.0/db_1"


If I do the same thing for fcgi-bin its not working.



FastCGI-developers mailing list
FastCGI-developers at mailman.fastcgi.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.pins.net/mailman/private.cgi/fastcgi-developers/attachments/20091204/cfcfc8ef/attachment.html>

More information about the FastCGI-developers mailing list