Your problem appears to be one with the
she-bang (
#!) line of your script. I can tell this
because apache's claiming the exec
is failing with "No such file or directory", which
is a sign that the kernel is not finding the program
specified on the she-bang line of the script.
(An error
exec'ing means that the perl interperator
couldn't be run, so the problem can't be anything in the
actual perl code.)
I can see two scenerios:
- /usr/bin/perl is not the perl interperator.
- You have a stray \x0D (AKA carriage return AKA \r) at the end of each line of
the script, so the OS is trying to run the file
named /usr/bin/perl\x0D to run your script,
which doesn't exsit. This would probably be caused
by uploading your file without translating newlines from
Windows. It can fixed on the (UNIX) command line with the
one-liner perl -pi -e'tr/\r//d' file.
To test if your problem is one of these see if your script
executes on the command line with ./perl_select_gebr.pl. If this returns
an error, then you probably have one of those problems.
Similarly you can test if you have
fixed one of these problems from
the command line by seeing if the same works.
(update: previous sentence
re-worked to actually mention testing fixes, as I meant
to say originally.)
A side note: It's a good idea to use strict and warnings. And -T.