[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