How to correct a Perl configuration error for Power Plan

Avatar
  • Answered
As a Power Plan customer, it appears that I cannot make changes to the system like reconfiguring Perl or changing environment variables. I have a bare-bones Perl script that only invokes DBI via the line "use DBI;". It does not connect or interact with any of my databases. The error log indicates (last line of this post) that this line tries to run a program (to launch DBI) but the system cannot find the executable. Is there any way for me to correct this with the hosting plan that I have? The following are additional details that I included in a support ticket. Support says that the problem is with my script; I know where the problem occurs, in the "use DBI;" line, but I cannot correct it because of my hosting plan. I would REALLY appreciate any real help in resolving this problem. Load these in a browser: http://www.chinesetoolbox.com/cgi-bin/bcs/TestingWithDBI.pl http://www.chinesetoolbox.com/cgi-bin/bcs/TestingWithoutDBI.pl Except for names and text displayed, these two scripts differ only in one line: the first includes the line use DBI and the second does not. When TestingWithDBI.pl is invoked, the following is returned to the browser: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. Here is the content of the two scripts: TestingWithDBI.pl: #!/usr/bin/perl use cPanelUserConfig; use DBI; print "Content-type: text/html\n\n"; print < Testing DBI

Testing DBI

EOF TestingWithoutDBI.pl: #!/usr/bin/perl use cPanelUserConfig; # use DBI; print "Content-type: text/html\n\n"; print < Testing without DBI

Testing without DBI

EOF In cPanel, the stats column on the left states that my path to Perl is /usr/bin/perl. Just off my account home there is a perl directory and a perl5 directory. Finally, this latest error log entry should help to clarify the problem: Can't locate DBI.pm in @INC at TestingWithDBI.pl line 4. (detailed content of @INC removed for readability)
Avatar
Arn
Hello, Sorry for the difficulties with connecting to the database in your PERL script. You unfortunately cannot typically change many of the server environmental values on a shared server account. However, you should be able to connect to the MySQL database. Keep in mind that the database is local (localhost). We unfortunately cannot provide coding support, but you may want to reference this article for more info. I hope that helps to answer your question! If you require further assistance, please let us know! Regards, Arnel C.