Topic: Cannot connect to MySql db After Apache 2.2 Reinstall

[MiltSpain1]

My Apache2.2.11 was running perfectly on Windows Server 2012 for 3 years when it suddenly crashed and had to be reloaded. I have a website (virtual host) on Apache and a Mysql database on the same drive. After reloading the Apache with what I thought was the exact Httpd config I am unable to get my PERL cgi programs to connect to the database even though the PERL and Mysql files appear to be exactly as they were previously. The Mysql database is live and can be accessed remotely and inquiries made at the command prompt. Consequently I think something is amiss in the Apache Httpd config file. Any suggestions as to where my problem lies will be sincerely appreciated. Thanks!

Milt Spain

[James Blond]

You should upgrade to Apache 2.4. The 2.2 version is no longer supported.

Anything in the apache error log? Windows event log? PHP error log?

[MiltSpain1]

Just got these. First time I've seen them.

[Fri Feb 01 06:40:59 2019] [error] [client 97.124.80.68] E:/Pinnacle/DiversityLink/cgi-bin/member_selections_htm.pl is not executable; ensure interpreted scripts have "#!" first line, referer: http://www.diversitylink.com/cgi-bin/showmenu2.pl
[Fri Feb 01 06:40:59 2019] [error] [client 97.124.80.68] (9)Bad file descriptor: don't know how to spawn child process: E:/Pinnacle/DiversityLink/cgi-bin/member_selections_htm.pl, referer: http://www.diversitylink.com/cgi-bin/showmenu2.pl

[James Blond]

If you open one of those files with for example Notepad++ do you see the correct line ending for Windows?

[MiltSpain1]

Not sure what you mean by "correct line ending for Windows" but the programs all ran perfectly previously. Here is the begining lines of one program:

##memberselections.pl
#!C:/Perl/bin/perl -w
use strict;
use CGI qw(:standard);
###print "content-type: text/html\n\n";
use DBI;
my ($dbh, $sth);

my $AccountID=param('AccountID');
my $PW=param('Password');

$dbh = DBI->connect('dbi:mysql:membersdb','member','memberpasswd') || die "cannot open";
$sth = $dbh->prepare("SELECT PW FROM memberid WHERE AccountID=? ");
$sth->execute ($AccountID);

An example of a cgi file that does work is:
http://www.diversitylink.com/cgi-bin/Global/USA/USA_statetoc.pl

The only programs that I cannot get to work are those that connect to the database or those that are protected by htaccess. All worked previously.

[glsmith]

#!C:/Perl/bin/perl -w

That (shebang) needs to be the first line of a perl script.

However you were probably using ScriptInterpreterSource in your prior config which removes that requirement.

[MiltSpain1]

You are 100% correct!! Thanks!