Milti has asked for the wisdom of the Perl Monks concerning the following question:
Apache running on Windows Server2012 suddenly crashed and had to be reinstalled. All my perl scripts ran perfectly previously. Now I have two major problems. First, none of the scripts that previously connected to my MySql database will connect. They all fail. I get an error message like this: Fri Feb 01 10:00:32 2019 error client 97.124.80.68 E:/Pinnacle/DiversityLink/cgi-bin/member_search_htm.pl is not executable; ensure interpreted scripts have "#!" first line, referer: http://www.diversitylink.com/cgi-bin/showmenu2.pl Fri Feb 01 10:00:32 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_search_htm.pl, referer: http://www.diversitylink.com/cgi-bin/showmenu2.pl
Here are the first few lines of one script:The MySql database is active and can be queried via remote access.#!C:/Perl/bin/perl 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 AccountID,PW FROM memberid WHERE AccountI +D=? and PW =?");$sth->execute ($AccountID,$PW);
The second problem relates to calling PW protected files. None of the scripts are successful whereas they all worked previously. I get this error message: Fri Feb 01 11:46:03 2019 error client 97.124.80.68 user Milt not found: /diversitylink/_private/Global/USA/jobs-htm/createjobpostform_new.htm. Milt is definitely within the PW file for the _private folder that was called as well as the subsequent Accounts folder that is called.
I think the problems lie within the Apache httpd config but everything seems to be OK. Obviously I'm missing something. I'm pretty much a novice and would sincerely appreciate any assistance provided. I need to get these issues resolved as quickly as possible. Thanks!
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Cannot Connect To MySql db following reinstall of Apache2.2.11
by shadowsong (Pilgrim) on Feb 04, 2019 at 09:41 UTC |