[thelist] CGI script causes secondary process lock-up in Apache

Joel Lieberman joel_lieberman at yahoo.com
Fri Dec 14 16:07:58 CST 2001


Greetings -

I have a Perl script that makes a system call to
execute an Oracle schema export.  The script runs well
when called from a DOS command prompt.  

When the script is run as a CGI executable by
reference to its URL (in the browser) with a single
argument passed in as .../cgi-bin/script.pl?arg   it
executes the Oracle system call and the export dmp
file is produced, but the processes then dead-lock
each other and cannot be killed (Win2000 platform).

I also tried the same idea with a DOS batch file and
got the same lock-up when it executes in the Apache
cgi environment.

The last experiment was to try calling the DOS bat
file from the Perl script.  This combination worked
fine if executed from a command prompt, but once
again, it locked itself and the files up when executed
as a cgi call.  I also tried placing explicit "exit"
calls into the scripts but no change in behaviour.

Any ideas why the scripts execute correctly but then
lock up their files and co-processes when called as
cgi?

I can help people with Oracle if needed.

<tip>

You do not need any third party utilities like DBI or
others to work with native Oracle or SQL Server from
within an Apache/Perl/SQL interface.  The web enabled
database interface can be constructed using only the
web server, Perl,SQL scripts and PL/SQL or OSQL as the
native run-time engines.   This gives unlimited
flexibility with the full power of the native
programming environment for each platform.

</tip> 

Joel

__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com




More information about the thelist mailing list