Hey…
Toolic and Davido: I’ve included the entire test below (its short :D) I have tried caps and non-caps and both, I think DBD::mysql is non-caps on the “M” whereas Mysql.pm is caps. I’ve tried (I think) all iterations…but I’ll try them all again.

My other scripts (the ones written against Perl 5.8 use the Mysql.pm module – so maybe the focus should be on trying to get it to load properly through MCPAN. I do want to have the other scripts working with Perl 5.14 (see below).

@Onelesd: I DO in fact have two versions installed in the same system. One in /usr/bin and one in /usr/local/bin. The perl 5.14 install went there by default. I wasn;t sure if this was the issue since …

A) The OTHER MCPAN installs went in fine (except for Mysql) and B) The paths in the @INC statement (error message) all seem to be pointing to the 5.14 paths (although I could be wrong).

----> I updated Perl by doing a fresh config and install from the tar.gz. Is there a way to actuall “update” 5.8?

Thanks for the help!!

SNIPPET #!/usr/local/bin/perl -l

use DBD::Mysql;
use Date::Manip;
use Date::Manip::Date;

# CONFIG VARIABLES
$database = "tapestorage";
$host = "localhost";
$tablename = "tapes";
$user = "root";
$pw = "";

$connect = Mysql->connect($host, $database, $user, $pw);
$connect->selectdb($database);
$mysqlquery = "SELECT * FROM tapes WHERE expdate > '$startdate' AND expdate <= '$enddate';";
$execute = $connect->query($mysqlquery);
while (@results = $execute->fetchrow()) {
print fh "$results[0]|$results1|$results2";
}

$data = qx{rsh
master /usr/openv/netbackup/bin/admincmd/bpmedialist -m SJ9063 -mlist -l};
@bpmedialist = split(/ /,$data);

$test=ParseDateString("epoch $bpmedialist6");
print "Test = $test";
END SNIPPET